← Back to catalogue
Enrollment openBusiness IntelligenceIntermediate
Power BI and Business Intelligence
Design professional dashboards with Power BI: data modelling, DAX, visualization and report publishing.
Objectives
- Connect and transform data with Power Query
- Build a relational data model in Power BI
- Create measures using the DAX language
- Design clear dashboards and publish reports
Target audience
Analysts, controllers and reporting professionals.
Prerequisites
Good command of Excel recommended.
Skills you will gain
Power QueryData modellingDAXDashboard design
Detailed programme
Modules 1
Data connection and preparation
Power Query: import, cleaning and transformation.
Modules 2
Data modelling
Relationships, star schema and best practices.
Modules 3
DAX language
Measures, calculated columns and filter context.
Modules 4
Report design
Visuals, layout and UX best practices.
Modules 5
Publishing and sharing
Power BI Service, refresh and report distribution.
Tools used
Power BI DesktopPower BI Service