First report
Load a sample sales spreadsheet and build a one-page report with three visuals.
Turn raw data into interactive reports and dashboards that people use to make decisions.
You have reached the end of the beginner stages. Prove what you learned with a project.
You have reached the end of the intermediate stages. Prove what you learned with a project.
You have reached the end of the advanced stages. Prove what you learned with a project.
Load a sample sales spreadsheet and build a one-page report with three visuals.
Clean an untidy dataset in Power Query and document each step.
Build a model with a fact table, three dimensions and a date table.
Write measures for revenue, margin, year to date and growth versus last year.
Design a clear dashboard for a manager with drill-down and slicers.
Publish a report with scheduled refresh and row-level security for two regions.
The same roadmap as a reading list: every stage, what each topic covers, and which ones are optional.
Desktop for building, the service for sharing, and how they fit together.
The free Windows app where you build reports.
Load data from Excel, CSV files, databases and the web.
Step-by-step learning paths with exercises.
Clean and reshape data with repeatable steps.
Remove columns, fix types, split, merge and append tables.
Correct types and checks for blanks and errors before you build anything.
Pull exactly the rows you need from a database.
Fact and dimension tables: the shape Power BI works best with.
Connect tables so filters flow the right way.
A proper calendar table makes time comparisons easy.
The ideas behind good analytical models.
The formula language for calculations in your model.
Calculations that respond to filters and slicers.
The most important DAX idea: changing what a measure is calculated over.
Year to date, previous year and growth calculations.
Layout, hierarchy and the few visuals that answer the question.
Choose the right chart and remove clutter.
Let people filter, drill down and explore on their own.
Readable colours, alt text and keyboard navigation.
Share reports online with the right people.
Keep reports up to date automatically.
Show each person only the data they are allowed to see.
The Power BI Data Analyst Associate exam (PL-300).
Building interactive reports and dashboards from business data, so managers can track performance and spot problems without asking for new spreadsheets.
Both are leading tools. Power BI is common in organisations using Microsoft 365 and has a free desktop app. Check which one job posts near you ask for.
It helps. Many Power BI ideas, such as Power Query and PivotTable thinking, start in Excel.
© 2026 KamerLink. All rights reserved.