Domain 4: Analytics on Azure Free ⏱ ~10 min read
Choosing the Right Visualization
The wrong chart misleads. The right chart tells a story instantly. Learn which Power BI visual suits each type of data.
Why visualisation choice matters
Simple explanation
The right chart is like the right map for a journey.
Show change over time? Line chart. Compare categories? Bar chart. Single number? Card. Picking right means your audience gets the point instantly.
Visualisation guide
Comparison visuals
| Visual | Best For | Example |
|---|---|---|
| Bar chart | Comparing categories | Revenue by product |
| Column chart | Comparing groups | Sales by store |
| Clustered bar | Sub-groups within categories | Sales by store, split by type |
Trend visuals
| Visual | Best For | Example |
|---|---|---|
| Line chart | Change over time | Monthly revenue over 2 years |
| Area chart | Trends with volume | Cumulative sales |
Part-of-whole visuals
| Visual | Best For | Example |
|---|---|---|
| Pie chart | Simple proportion (max 5-6 slices) | Market share |
| Treemap | Hierarchical breakdown | Sales by category |
Other visuals
| Visual | Best For | Example |
|---|---|---|
| Scatter plot | Relationship between two measures | Price vs demand |
| Map | Geographic data | Sales by city |
| Card | Single KPI | Total revenue: $2.3M |
| KPI | Target vs actual | Revenue vs target |
| Table/Matrix | Detailed drill-down | Store-by-store monthly data |
| Question | Best Visual |
|---|---|
| How does X compare to Y? | Bar or column chart |
| How has X changed over time? | Line chart |
| What proportion is X? | Pie or treemap |
| Relationship between X and Y? | Scatter plot |
| Where is X happening? | Map |
| What is the current value? | Card or KPI |
Common mistakes
- Pie charts with 6+ slices — use bar charts instead
- 3D charts — distort data. Always 2D
- Line charts for categories — lines imply continuous trends
Exam tip: visual matching
- “Sales trend over months” → Line chart
- “Compare 5 stores” → Bar chart
- “Market share” → Pie chart
- “Price vs demand” → Scatter plot
- “Sales by city” → Map
- “Single KPI number” → Card
Flashcards
Knowledge check
Knowledge Check
Priya wants to show monthly revenue over 2 years. Which visual?
Knowledge Check
Tom needs to compare completed vs late deliveries across 5 depots. Which visual?
Knowledge Check
The CEO wants one number: this month's total revenue. Which visual?
You’ve completed the entire DP-900 course! 🎉
You’ve covered core data concepts, relational and non-relational databases on Azure, and the full analytics stack from ingestion to Power BI.
What’s next?
- Review tricky modules
- Practice questions (coming soon)
- Book your exam at Microsoft Learn