📈 Painting with Data: Core Visualizations

Once your data is cleaned and your relationships are established, you move to the Report View (the top canvas icon on the left sidebar). This is where the magic happens.

Data visualization is not just about making things look pretty; it is about Data Storytelling. A poor chart choice can confuse or mislead a user, while the perfect chart choice makes the insight instantly obvious. Always focus on Avoiding misleading visuals (e.g., don't manipulate axis scales to exaggerate differences).

🎯 Selecting the Correct Chart

Before you click a chart icon, ask yourself: What is the goal of this visual?

📊 Deep Dive: The Core Charts

1. Comparison: Bar & Column Charts

The most universally understood charts in the world.

• Column Charts (Vertical): Great for comparing a small number of categories (e.g., Sales by Region).
• Bar Charts (Horizontal): Better when you have a lot of categories, or categories with very long text names, because the text is easier to read horizontally.
• Clustered vs Stacked: Clustered places bars side-by-side (easier to compare individual pieces). Stacked places them on top of each other (easier to see the grand total). Disadvantages of Stacked: It is very difficult to read when there are too many bars, confusing if a stack has 4-5 layers, and errors in estimation of the middle pieces can cause false interpretations.

2. Trends: Line & Area Charts

• Line Chart: The absolute best choice for showing trends over time (e.g., Dates, Months, Years on the X-axis).
• Area Chart: A line chart with the area underneath filled in. Use a Stacked Area Chart if you want to show how different categories contribute to a total trend over time (e.g., Stock prices of 3 different companies combining into a total portfolio value).
• Ribbon Chart: A special Power BI chart that looks like flowing ribbons. It automatically ranks categories. The highest value is always pushed to the top of the ribbon, making it easy to see if a category dropped in rank over time.

3. Composition: Pies, Donuts & Waterfalls

• Pie / Donut Charts: Use these sparingly! They are only good if you have 2 to 4 categories (e.g., Male vs Female). If you have 20 categories, a pie chart becomes an unreadable mess of tiny slices.
• Tree Map: Displays hierarchical data as colored rectangles. The size of the rectangle represents the value. Great for fitting a massive amount of categories into a small square of screen space.
• Waterfall Chart: The best chart for showing a running total as values are added or subtracted.
• Funnel Chart: Used for tracking process workflows and sequential stages. It is the best chart for analyzing conversion rates and finding bottlenecks in a pipeline (e.g., Website Visitors -> Cart -> Purchase).
• Funnel Chart: Used for tracking process workflows and sequential stages. It is the best chart for analyzing conversion rates and finding bottlenecks in a pipeline (e.g., Website Visitors -> Cart -> Purchase).
  • Use Case: Visualizing Cashflow. You start with January Revenue (Green Bar). Then you subtract Taxes (Red Bar), subtract Payroll (Red Bar), and the final bar lands on your Net Profit.

4. Relationships & Distribution

• Scatter Chart & Bubble Chart: Plots data points on an X and Y axis to find correlations. A Bubble Chart is a scatter chart where the size of the bubble represents a third metric.
• Correlation Matrix: A visual table that shows correlation coefficients between multiple variables.
• Heat Map: Uses color intensity in a matrix grid to show the magnitude of a phenomenon.
• Box Plot & Density Plot: Used for tracking the statistical distribution, median, and outliers of your data.

5. Geographic: Maps

• Map (Bubble Map): Plots a circle over a city or country. The bigger the circle, the larger the value.
• Filled Map (Choropleth): Colors the entire physical boundary of a state or country based on a value (e.g., Dark blue for high sales, light blue for low sales).

🏋️ Practice Drill

Let's build your first chart!

Task:

// Try answering these:
1. In the **Report View**, look at the **Visualizations Pane** on the right side.
2. Click the icon for the **Stacked Column Chart** (it looks like a vertical bar chart). A blank gray square will appear on your canvas.
3. In your **Data Pane** on the far right, find a text column (like Category or Name) and check the box.
4. Find a number column (like Sales or Amount) and check the box.

← 🔗 Relationships and Filter Flow | Next Topic → 🎛️ Advanced Visuals and Interactivity