Contact us by Telephone: Monterrey: (81) 80.04.54.94      México City: (55) 36.22.07.38     Jalisco: 33.36.66.05.29 and Lada toll free: 800.552.9951

Business Intelligence

Catalog Area: Alta Dirección
Duration: 8
Modality: online and Face-to-face modality

Receive a Course Pre-Quote by Email

Let a Sales Advisor Contact You by Email

Temarios Cursos- Inglés

Receive complete information in your email!

  • Consultek uses the information you provide us to contact you about our relevant content, products and services. You will be able to unsuscribe from these communications at any time. For more information, see our privacy policy.

OBJECTIVE:

By the end of the course, the participant will apply the concepts of Business Intelligence in the design of interactive reports that may include performance indicators, graphs or process traffic signaling

BASIC COURSE INFORMATION:

ADDRESSED TO:

To all those people who manage databases of companies or institutions that need to analyze information and create reports for effective decision-making.

AGENDA

UNIT 1. INTRODUCTION TO POWER BI
1.1. What is Power BI?

1.2. Use of Power BI

1.3. Creation blocks of Power BI.

1.4. A review to the Power BI service.

UNIT 2. HOW TO OBTAIN DATA IN POWER BI?
2.1. Obtaining data with Power BI.

2.2. Connection to data origins in Power BI Desktop.

2.3. Cleaning and transforming data with the Query Editor.

2.4. More advanced data sources and transformations.

2.5. Cleaning irregularly formatted data.

UNIT 3. DATA MODELING WITH POWER BI
3.1. Introduction to data modeling.

3.2. Data relationship management.

3.3. Creation of calculated columns.

3.4. Creation of calculated columns.

UNIT 4. POWER BI DATA VISUALIZATIONS
4.1. Creation and customization of simple visualizations.

4.2. Use of combo charts.

UNIT 5. DATA EXPLORATION WITH POWER BI
5.1. Using Quick Info in the Power BI service.

5.2. Creation and configuration of a panel.

5.3. Viewing visuals and icons in full screen

UNIT 6. POWER BI AND EXCEL
6.1. Importing an Excel table to Power BI.

6.2 Updating of information.

UNIT 7. PUBLISH AND SHARE
7.1. Publishing Power BI Desktop reports to Power BI service.

7.2. Printing and exporting Power BI dashboards.

UNIT 8. LANGUAGE OF DAX FORMULAS WITH POWER BI
8.1. Introduction to DAX.

8.2. Types of DAX calculations.

8.3. Main DAX functions.

BENEFITS

  • By taking this course, you will be able to structure data tables that, when analyzed, allow you to make more accurate and reliable decision-making.
  • You will know the use of DAX functions that allow you to collect data from different origins to enhance the use of formulas.

FIND OUT MORE COURSES THAT MIGHT INTEREST YOU