Business Intelligence
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!
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.
SYLLABUS
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.
