Microsoft
Power BI.

— Data 01 / 05

01day

Power Query & preparation

• The Power BI Desktop interface
• Connecting to Excel, CSV, SQL, SharePoint
• Cleaning and transforming in Power Query
• Data types and merging queries

— Model 02 / 05

02day

Data modelling

• Star schema: facts and dimensions
• Relationships and cardinality
• Date table and hierarchies
• Performance best practices

— Calculations 03 / 05

03day

The DAX language

• Measures and calculated columns
• CALCULATE and filter context
• Time intelligence: running totals, prior year, growth
• Variables and readable formulas

— Reporting 04 / 05

04day

Dashboards & storytelling

• Choosing the right visual
• Slicers, drill-down and tooltips
• Conditional formatting and themes
• Mobile version of the report

— Sharing 05 / 05

05day

Publishing & final project

• Power BI Service and workspaces
• Scheduled refresh and gateway
• Row-level security (RLS)
• A complete dashboard and certificate