Power Query is washing vegetables. A star schema is the solar system. A slicer is asking for only the red sweets.
If Power BI still feels heavy, read this once. Every idea is something you already know.
Then teach it to a friend.
explained to kids (1/2)
Power BI, the simple way
Get Data
Tip all your toys out of the box so you can see what you have.
Home > Get DataPower Query
Wash the muddy vegetables before Mummy cooks them.
Transform dataRelationship
Match every sock with its partner using the colour.
1 to manyStar schema
The sun sits in the middle. The planets go around it.
Fact + dimensionsMeasure
At the end of the match, count the total goals.
Total Sales = SUM(Sales[Amount])Calculated column
Write a name tag on every single crayon, one by one.
Line Total = Sales[Price] * Sales[Qty]explained to kids (2/2)
Power BI, the simple way
Slicer
Only show me the red sweets, please.
Slicer: Colour = RedCALCULATE
Same sweets, but look at them through a red window.
CALCULATE([Total Sales], Sales[Region] = "North")Visual
Draw the numbers as a picture so anyone can read it.
Bar chartDashboard
Like the car dashboard: speed and fuel, all on one screen.
One page, 4 KPIsRefresh
Get today's newspaper, not last week's.
Home > RefreshPublish
Stick your drawing on the class notice board for all to see.
Publish to ServiceReady for the real thing?
Next: 10 DAX functions you actually need and what a Power BI JD really tests.
Free PDF
How I'd explain Power BI to a 5-year-old
Download the PDFOpens in Google Drive. No sign-up.