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

Cards, Tables and Matrices

Cards, tables, and matrix visuals are essential Power BI components for presenting business information. Cards highlight important numbers, tables display detailed records, and matrices organize information into grouped rows and columns.

Learning Objectives

  • Understand the purpose of card visuals.
  • Create single-value and multi-value card displays.
  • Build tables for detailed business records.
  • Use matrices to summarize data by rows and columns.
  • Apply formatting to improve readability.
  • Choose the right visual for a reporting requirement.

1. Understanding Cards, Tables and Matrices

Each visual serves a different reporting purpose. A card provides a quick summary, a table presents individual records, and a matrix summarizes information using a row-and-column structure.

Visual Comparison

Card Total Sales 125K One key metric Table Product Sales Laptop 50K Phone 35K Tablet 40K Matrix Region Q1 Q2 North 20 25 South 18 22 West 15 19 Summary metric, detailed records, and grouped analysis

2. Card Visuals

A card displays a prominent value such as total sales, profit, order count, or customer count. Cards are commonly placed at the top of a report page to communicate important performance indicators.

Examples of Card Metrics

Total Sales 125,000 Sales value Total Orders 860 Order count Profit Margin 22% Profit percentage

How to Create a Card

  1. Select an empty area on the report canvas.
  2. Choose the Card visual from the Visualizations pane.
  3. Drag a measure or suitable numeric field into the visual's data field well.
  4. Verify that the value is summarized correctly.
  5. Open the formatting options to configure the title, callout value, labels, and background.
  6. Resize and position the card to fit the report layout.
Tip: Prefer measures for important business KPIs. Measures let you define the calculation explicitly and reuse it consistently across report visuals.

3. Creating a Sales Measure for a Card

Suppose your model contains a table named Sales with a numeric column named SalesAmount. You can create a measure to calculate total sales.

DAX Measure

Total Sales = SUM(Sales[SalesAmount])

Add the Total Sales measure to a card. The card displays the total for the current filter context, so its value can change when users interact with report filters and slicers.

Important: The table and column names in the formula must match your model. Replace Sales and SalesAmount if your model uses different names.

4. Table Visuals

A table displays data in rows and columns. It is useful when users need to inspect individual records, compare several fields, or verify the detail behind a summary value.

Example: Product Sales Table

Product Category Units Sold Sales Amount
Laptop Electronics 25 50,000
Phone Electronics 35 35,000
Desk Furniture 12 24,000
Chair Furniture 20 16,000

How to Create a Table

  1. Select the Table visual.
  2. Add the required columns or measures to the visual.
  3. Arrange the fields in the desired order.
  4. Check numeric aggregation and column formatting.
  5. Apply sorting and conditional formatting if required.
  6. Adjust column widths so the information is easy to read.

When to Use a Table

  • When users need to see individual records.
  • When several attributes must be displayed together.
  • When users need to inspect the detail behind a summary.
  • When exact values are more important than visual patterns.

5. Matrix Visuals

A matrix summarizes data across row groups and column groups. It is similar to a pivot table and can support hierarchical grouping, subtotals, and drill-down interactions.

Example: Sales by Region and Quarter

Region Q1 Sales Q2 Sales Total Sales
North 20,000 25,000 45,000
South 18,000 22,000 40,000
West 15,000 19,000 34,000
Grand Total 53,000 66,000 119,000

How to Create a Matrix

  1. Select the Matrix visual.
  2. Place a grouping field, such as Region, in Rows.
  3. Place a time period, such as Quarter, in Columns.
  4. Place a measure, such as Total Sales, in Values.
  5. Configure subtotals, grand totals, and row or column formatting.
  6. Test expand and collapse options if the matrix contains a hierarchy.
Tip: A matrix is especially useful for comparing multiple groups across the same set of time periods or categories.

6. Table vs. Matrix

Feature Table Matrix
Structure Flat rows and columns Grouped rows and columns
Hierarchy Limited hierarchical presentation Supports expandable row hierarchies
Subtotals Not the main grouping feature Supports grouped subtotals and grand totals
Best use Detailed record inspection Cross-group summaries and comparisons

7. Formatting and Conditional Formatting

Formatting helps users identify important values and read data efficiently. Power BI provides formatting controls for titles, labels, borders, gridlines, backgrounds, and numeric display.

  • Use descriptive titles for cards, tables, and matrices.
  • Format currency values consistently.
  • Use appropriate decimal places and percentage formats.
  • Keep column headers concise.
  • Apply conditional formatting to highlight meaningful differences.
  • Use restrained colors to preserve readability.

Illustration: Conditional Formatting

Product Sales Performance Laptop 50,000 High Phone 35,000 Medium Tablet 12,000 Low

Conditional formatting can highlight values according to rules, thresholds, or data-driven color scales. The rules should have a clear business meaning.

8. Practice Activity

Scenario: Retail Performance Report

Create a report page that helps a manager understand overall performance and inspect product-level details.

Tasks

  1. Create a card for Total Sales.
  2. Create another card for Total Orders.
  3. Build a table containing Product, Category, Units Sold, and Sales Amount.
  4. Build a matrix showing Region in Rows, Quarter in Columns, and Total Sales in Values.
  5. Format sales amounts as currency or an appropriate numeric format.
  6. Apply conditional formatting to highlight high and low sales values.
  7. Compare the table and matrix and explain when each is more useful.

9. Knowledge Check

Question 1: Which visual is most suitable for highlighting one important KPI?

A. Card

B. Matrix

C. Detailed table only

Question 2: Which visual supports grouped row and column summaries?

A. Card

B. Matrix

C. Pie chart

Question 3: What is a common purpose of conditional formatting?

A. Highlighting meaningful values or differences

B. Creating a new data source automatically

C. Replacing all report measures

Show Answers
  1. Question 1: A — Card.
  2. Question 2: B — Matrix.
  3. Question 3: A — Highlighting meaningful values or differences.

Summary

In this lesson, you learned how to use cards to highlight key business metrics, tables to display detailed records, and matrices to summarize information across grouped rows and columns. You also practised formatting values and applying conditional formatting to make important information easier to identify.

Choose a visual according to the reporting requirement. Cards communicate key figures, tables support detailed inspection, and matrices help users compare grouped data. Consistent formatting and meaningful labels improve report readability.