MOC 20778
ANALYZING DATA WITH POWER BI
Duración:
15 horas lectivas.
5 Horas / Día
Detalles
Requisitos previos MOC 20778:
Before attending this course, students must have:
- Excellent knowledge of relational databases and reporting.
- Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
- Familiarity with Microsoft Office applications – particularly Excel
Ubicación
- Presencial en Madrid y Barcelona
- En oficina de cliente
- Online Direct
Objetivos MOC 20778:
El objetivo de este curso es proporcionar a los estudiantes una buena comprensión del análisis de datos con Power BI, incluyendo visualizaciones, servicio y Mobile App.
Temario MOC 20778:
Module 1: Introduction to Self-Service BI Solutions
- Introduction to business intelligence
- Introduction to data analysis & data visualization
- Overview of self-service BI
- Considerations & Microsoft Tools for self-service BI
Lab : Exploring an Enterprise BI solution
Module 2: Introducing Power BI
- Power BI
- The Power BI service
Lab : Creating a Power BI dashboard
Module 3: Power BI
- Using Excel as a data source for Power BI
- The Power BI data model
- Using databases as a data source for Power BI
- The Power BI service
Lab : Importing data into Power BI
Module 4: Shaping and Combining Data
- Power BI desktop queries
- Shaping data
- Combining data
Lab : Shaping and combining data
Module 5: Modeling data
- Relationships
- DAX queries
- Calculations and measures
Lab : Modeling Data
Module 6: Interactive Data Visualizations
- Creating Power BI reports
- Managing a Power BI solution
Lab : Creating a Power BI report
Module 7: Direct Connectivity
- Cloud data
- Connecting to analysis services
Lab : Direct Connectivity
Module 8: The Developer API
- The developer API
- Custom visuals
Lab : Using the developer API
Module 9: Power BI mobile app
- Power BI mobile apps
- Using the Power BI mobile app
- Power BI embedded