Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Pie, Donut and Treemap Charts

Pie charts, donut charts, and treemaps help users understand how categories contribute to a total. These visuals are useful for showing proportions, category shares, and the relative size of different groups in a dataset.

Learning Objectives

  • Understand the purpose of pie charts, donut charts, and treemaps.
  • Assign category and numeric fields to the correct visual roles.
  • Interpret category proportions and contribution to totals.
  • Format labels, legends, titles, and colors effectively.
  • Recognize when another chart type is a better choice.

1. Understanding Part-to-Whole Charts

A part-to-whole chart shows how individual categories contribute to a complete total. For example, a business might use one to display the percentage of sales generated by each product category.

Example: Product Sales Contribution

Electronics Clothing Other Each segment represents a category's contribution to the total. The segment sizes are illustrative, not actual business results.

2. Pie Chart

A pie chart represents a total as a circle divided into slices. Each slice corresponds to a category, and its size represents that category's share of the total.

Sales Share by Category

Electronics — 30% Clothing — 25% Food — 25% Other — 20% Illustrative category proportions

How to Create a Pie Chart

  1. Select an empty area on the report canvas.
  2. Choose the Pie Chart visual from the Visualizations pane.
  3. Add a categorical field, such as Product Category, to the Legend or category field well.
  4. Add a numeric field, such as Sales Amount, to Values.
  5. Check that the values are aggregated correctly.
  6. Format the title, legend, data labels, and colors.
Tip: Pie charts work best when there are only a few categories and the differences between their proportions are easy to see.

3. Donut Chart

A donut chart is similar to a pie chart, but it has an empty center. The center can provide visual space for a title or a separate label added to the report. The chart still represents category shares.

Donut Chart Example

Total 100% Category A Category B Category C Category D

When to Use a Donut Chart

  • When showing a small number of categories as shares of a total.
  • When a center label helps communicate a key message.
  • When the report design benefits from a compact circular visual.
Important: Avoid using many small slices. If users need to compare similar values precisely, a bar chart is often easier to interpret than a pie or donut chart.

4. Treemap Chart

A treemap represents categories as nested rectangles. The area of each rectangle corresponds to the value assigned to that category. Treemaps are useful for displaying many categories in a limited space.

Sales by Product Category

Electronics Clothing Food Other Larger rectangles represent larger values.

How to Create a Treemap

  1. Select the Treemap visual.
  2. Drag a category field, such as Product Category, into the category or Group field well.
  3. Drag a numeric field, such as Sales Amount, into Values.
  4. Optionally add a second category field to create grouped rectangles.
  5. Format data labels, colors, and titles for readability.
Tip: Use treemaps when the relative size of many categories matters more than precise comparisons between similar values.

5. Compare the Three Visuals

Visual Main Strength Potential Limitation
Pie Chart Shows proportions of a total Many slices are difficult to compare
Donut Chart Shows proportions with an open center Small differences may be hard to judge
Treemap Displays many categories in a compact area Precise comparison between similar areas can be difficult
Bar Chart Often better for precise category comparisons May need more space for many categories

6. Understand the Data Fields

These visuals generally need a categorical field to define the groups and a numeric field to calculate the size of each group. The available field wells can vary with the visual and Power BI version.

From Data to Proportion

Source Data Category Sales Amount Aggregation Group by Category Calculate Total Visual Category Share Pie / Donut / Treemap

7. Formatting and Readability

  • Use a meaningful title that explains what the chart represents.
  • Keep category names short and understandable.
  • Use consistent colors for the same categories across the report.
  • Show data labels when they improve interpretation.
  • Use percentage labels when the purpose is to show shares.
  • Do not rely on color alone; include readable category names.
  • Check that blank, negative, or unexpected values are handled appropriately.

8. Practice Activity

Scenario: Department Sales

Department Sales Amount
Electronics 45,000
Clothing 25,000
Food 20,000
Home Goods 10,000

Tasks

  1. Create a pie chart showing sales by department.
  2. Create a donut chart using the same fields.
  3. Create a treemap and compare the relative sizes of the departments.
  4. Add meaningful titles and data labels.
  5. Decide which visual is easiest to interpret and explain why.

9. Knowledge Check

Question 1: Which visual is designed to show categories as rectangles whose areas represent values?

A. Treemap

B. Line chart

C. Scatter chart

Question 2: What does a slice in a pie chart represent?

A. A category's contribution to the total

B. A report page

C. A column's data type

Question 3: What should you consider when a chart contains many categories?

A. Whether the visual remains readable

B. Whether every category has a different font

C. Whether the title is removed

Show Answers
  1. Question 1: A — Treemap.
  2. Question 2: A — A category's contribution to the total.
  3. Question 3: A — Whether the visual remains readable.

Summary

In this lesson, you learned how pie charts, donut charts, and treemaps represent category contributions to a total. You practised assigning category and numeric fields, interpreting proportions, and formatting visuals for clear communication.

Choose a part-to-whole visual when category share is the main message. When users need precise comparisons or many categories make the visual difficult to read, consider using a bar chart instead.