Y

Power BI · Beginner · 6 h

Data model and first report

Load data, build a star schema, and create a one-page report that answers a real question.

Why employers care: Power BI was the most named BI tool in our Data Analyst research, ahead of Tableau. Junior roles expect a clean model and a readable report.

In the roadmaps for: Data Analyst

Lessons, in order

  1. Power BI Desktop tutorial for beginnersInstall Power BI Desktop, learn the four views and the panes, load half a million real retail transactions from a URL and build your first three visuals, then spot the numbers that are wrong before your manager does.14 min
  2. Power BI get data and Power Query transformationsLoad the eight Olist e-commerce files from one folder with a parameter and a reusable function, fix types and locales, translate Portuguese categories, and keep staging queries out of the model.16 min
  3. Power BI star schema and your first reportTurn 541,909 raw retail lines into a Sales fact table with Customer, Product and Date dimensions, write your first measures, and prove the report total of 8,911,407.90 against an independent check.13 min

Next shelf: DAX measures and time intelligence