Data Analysis with Power BI

Business Intelligence

Capacitación: Alta Dirección   Duracion: 16 Hrs.

THIS COURSE IS MEANT FOR

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

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

SUBJECT

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.

Temarios Cursos- Español

Recibe una Pre-Cotización por Correo
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.