Power BI: a dashboard needs a decision
Connect to a small CSV in Power BI Desktop. Profile missing values and set correct types before loading. Write down the business question the report will answer.
Power BI: a dashboard needs a decision
Connect and prepare
Connect to a small CSV in Power BI Desktop. Profile missing values and set correct types before loading. Write down the business question the report will answer.
Model relationships
Separate facts, such as sales transactions, from dimensions, such as dates and products. Use one-to-many relationships and a date table. Reconcile row counts after loading.
Build a useful report
Create a measure for Total Revenue using SUM. Use a bar chart to compare regions and a line chart for change over time. Add readable labels and test keyboard navigation.
Your next step
Try the exercises with a small dataset. Write down your assumptions, check the results against the source, and explain one thing you would improve.