This post is a part of the DP-900: Microsoft Azure Data Fundamentals Exam Prep Hub.
This topic falls under these sections:
Describe an analytics workload (25–30%)
--> Describe data visualization in Microsoft Power BI
--> Identify appropriate visualizations for data
Note that there are 10 practice questions (with answers and explanations) for each section to help you solidify your knowledge of the material. Also, there are 2 practice tests with 60 questions each available on the hub below the exam topics section.
Data visualization is the process of representing data graphically so users can quickly understand patterns, trends, relationships, and insights. In Microsoft Power BI, choosing the correct visualization is important for effective reporting and decision-making.
For the DP-900 exam, you should understand:
- Common visualization types
- When each visualization should be used
- The strengths and limitations of different visuals
Why Visualization Selection Matters
The correct visualization helps users:
- Understand data quickly
- Identify trends and anomalies
- Compare values
- Monitor performance
- Make informed decisions
Using the wrong visualization can make data confusing or misleading.
Common Visualization Types in Power BI
1. Bar Charts and Column Charts
Purpose
Used to compare values across categories.
Best Used For
- Comparing sales by region
- Comparing revenue by product
- Ranking categories
Difference
- Bar chart → horizontal bars
- Column chart → vertical bars
Advantages
✔ Easy to read
✔ Good for comparisons
✔ Works well with categorical data
Example
Sales by product category
2. Line Charts
Purpose
Used to show trends over time.
Best Used For
- Monthly sales trends
- Website traffic over time
- Stock price movement
Advantages
✔ Excellent for time-series data
✔ Clearly shows increases/decreases
Example
Revenue by month
3. Pie Charts and Donut Charts
Purpose
Show proportions or percentages of a whole.
Best Used For
- Market share
- Percentage of sales by region
Limitations
❌ Difficult with many categories
❌ Hard to compare similar values
Best Practice
Use only with a small number of categories
4. Tables and Matrices
Tables
Purpose
Display detailed data in rows and columns.
Best Used For
- Exact values
- Detailed records
Matrices
Purpose
Similar to pivot tables with grouped summaries.
Best Used For
- Aggregated business reporting
- Cross-tab analysis
Advantages
✔ Good for detailed analysis
✔ Supports drill-down
5. Maps
Purpose
Visualize geographic data.
Best Used For
- Sales by country
- Store locations
- Regional performance
Requirements
Data should contain:
- Country
- City
- Coordinates
6. KPI Visuals
Purpose
Display performance against goals.
Best Used For
- Revenue targets
- Operational metrics
- Performance monitoring
Advantages
✔ Easy to monitor status
✔ Quickly highlights success/failure
7. Gauge Charts
Purpose
Show progress toward a target value.
Best Used For
- Budget usage
- Performance thresholds
Example
Current sales vs sales target
8. Scatter Charts
Purpose
Show relationships between two numeric variables.
Best Used For
- Correlation analysis
- Identifying outliers
Example
Advertising spend vs revenue
9. Cards
Purpose
Display a single key metric.
Best Used For
- Total revenue
- Customer count
- Profit margin
Advantages
✔ Simple and clear
✔ Common in dashboards
10. Slicers
Purpose
Provide interactive filtering.
Best Used For
- Filtering by date
- Selecting regions or categories
Advantages
✔ Enhances report interactivity
Choosing the Right Visualization
| Goal | Recommended Visualization |
|---|---|
| Compare categories | Bar/Column Chart |
| Show trends over time | Line Chart |
| Show proportions | Pie/Donut Chart |
| Display exact values | Table |
| Summarize grouped data | Matrix |
| Show geographic data | Map |
| Track KPIs | KPI/Gauge |
| Show correlations | Scatter Chart |
| Show a single metric | Card |
Visualization Best Practices
Keep Visuals Simple
Avoid clutter and unnecessary complexity.
Use Appropriate Colors
Colors should improve readability, not distract.
Limit Pie Chart Categories
Too many slices reduce readability.
Use Consistent Formatting
Helps users interpret reports more easily.
Focus on Business Questions
Choose visuals that answer specific questions.
Interactive Features in Power BI
Power BI visuals support:
- Filtering
- Drill-down
- Cross-highlighting
- Tooltips
These features make reports interactive and user-friendly.
Why This Matters for DP-900
On the exam, you may be asked to:
- Identify the best visualization for a scenario
- Match visualization types to business requirements
- Understand the strengths and weaknesses of visuals
Summary — Exam-Relevant Takeaways
✔ Common visuals:
- Bar/Column → comparisons
- Line → trends over time
- Pie/Donut → proportions
- Map → geographic data
- Scatter → relationships
- Card → single metric
✔ Tables show detailed data
✔ KPIs and gauges track performance
✔ Slicers provide interactivity
✔ Exam tips:
👉 Line chart = trends over time
👉 Bar chart = category comparison
👉 Pie chart = parts of a whole
👉 Scatter chart = relationships/correlation
👉 Card = single value
Go to the Practice Exam Questions for this topic.
Go to the DP-900 Exam Prep Hub main page.
The Data Community 