Data Analyst
Data Analyst — Expert
Become a Power BI expert and drive decisions with reliable business KPIs.
You build expertise in Power BI: data modeling, the DAX language and advanced KPI-oriented analysis. The course prepares for the Microsoft PL-300 certification through a decision-support dashboard project.
Objectives
- Model data in a star schema for decision analysis
- Write measures and columns in the DAX language
- Design relevant and reliable business KPIs
- Prepare for and pass the Microsoft PL-300 certification
Program
Advanced modeling
- Star schema and relationships
- Date tables and hierarchies
- Best practices for a performant model
DAX and analysis
- Measures, calculated columns and context
- Time-intelligence functions and running totals
- Comparative analysis and variances
KPIs and PL-300 certification
- Defining actionable business indicators
- Decision-support dashboards
- Review and PL-300 mock exam
Prerequisites
Strong Excel skills and initial dataviz experience.