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

Advanced Visuals and Custom Visuals

Advanced visuals help users analyze business performance beyond basic charts and tables. They can explain relationships, compare actual performance with targets, analyze distributions, and communicate complex information. Custom visuals can extend Power BI with additional visualization options when standard visuals do not meet a specific reporting requirement.

Learning Objectives

  • Understand common advanced Power BI visuals.
  • Identify when to use scatter charts, waterfall charts, and funnels.
  • Understand gauge and KPI visuals.
  • Explore the purpose of custom visuals.
  • Evaluate visual suitability, usability, and security considerations.
  • Build a report page that communicates advanced business insights.

1. What Are Advanced Visuals?

Advanced visuals are useful when a business question requires more than a simple comparison or trend. Different visuals reveal different types of information, so the correct choice depends on the purpose of the analysis.

Advanced Visual Selection

Business Question Relationships Scatter Chart Change Analysis Waterfall Chart Target Tracking KPI / Gauge Select a visual that answers the question clearly.

2. Scatter Charts

A scatter chart displays the relationship between two numeric variables. Each point represents an observation, such as a product, customer, or store. It can help identify clusters, unusual values, and possible relationships between measures.

Example: Advertising Spend and Sales

Advertising Spend Sales Illustrative trend line

In this illustration, higher advertising spend tends to be associated with higher sales. This pattern alone does not prove that advertising caused the increase.

How to Create a Scatter Chart

  1. Select the Scatter Chart visual.
  2. Add a numeric measure to the X-axis.
  3. Add another numeric measure to the Y-axis.
  4. Use a category or identifier to distinguish individual observations when appropriate.
  5. Optionally add a size measure or legend category if supported by the visual.
  6. Inspect clusters and outliers before drawing conclusions.
Tip: Use scatter charts to investigate relationships between numeric variables. Avoid treating correlation as proof of causation.

3. Waterfall Charts

A waterfall chart shows how a starting value changes through a sequence of positive and negative contributions until it reaches an ending value. It is useful for explaining changes in profit, revenue, expenses, and budget variance.

Example: Profit Movement

Start Sales Costs Other Tax End 100 +40 -55 +25 -35 75 Illustrative values; use a correctly ordered contribution sequence.

When to Use a Waterfall Chart

  • Explaining changes from budget to actual results.
  • Showing how revenue and costs affect profit.
  • Investigating month-to-month financial movement.
  • Explaining the contributions that produce a final total.
Important: Confirm the category order and whether each contribution is positive or negative. A waterfall chart can mislead users if the sequence or signs are incorrect.

4. Funnel Charts

A funnel chart shows values across sequential stages of a process. It is often used for sales pipelines, recruitment processes, customer journeys, and lead conversion analysis.

Example: Sales Pipeline

Leads: 1,000 Qualified: 600 Proposal: 300 Won: 120

How to Create a Funnel Chart

  1. Select the Funnel visual.
  2. Add a stage field, such as Lead Stage, to the category or group field well.
  3. Add a measure, such as Lead Count, to Values.
  4. Ensure the stages follow the correct business sequence.
  5. Format data labels and titles to make stage values easy to read.
Tip: A funnel is most useful when the stages represent a meaningful process. For unrelated categories, a bar chart may be clearer.

5. Gauge and KPI Visuals

Gauge and KPI visuals communicate progress toward a goal. A gauge typically compares a current value with a target or defined range. A KPI visual can communicate performance and, when configured, a trend against a goal.

Gauge Concept

Current Sales 75K 0 100K Illustrative target: 100K

Example DAX Measures

Total Sales

Total Sales = SUM(Sales[SalesAmount])

Sales Target

Sales Target = 100000

Target Achievement Percentage

Target Achievement % =
DIVIDE([Total Sales], [Sales Target], 0)

Format Target Achievement % as a percentage. Add the appropriate measures to a gauge or KPI visual and configure the target and trend fields according to the visual's available field wells.

Measure requirement: The Sales table and SalesAmount column must exist in your model. Use the exact names from your model or adjust the formulas accordingly.

6. Custom Visuals

Custom visuals extend the standard visualization options available in Power BI. They can provide specialized chart types, layouts, or interactions for reporting needs that standard visuals do not fully address.

Visual Category Potential Use Evaluation Question
Advanced Charts Specialized comparisons or distributions Is the visual easier to understand than a standard chart?
Process Visuals Stages, dependencies, or workflows Does it accurately represent the process?
Specialized Tables Additional layouts or conditional displays Does it improve readability?
Industry-Specific Visuals Specialized operational or analytical reporting Does it meet the reporting requirement?

7. How to Add a Custom Visual

  1. Open the report in Power BI Desktop.
  2. Locate the option for obtaining or importing additional visuals.
  3. Review the available visuals and their documentation.
  4. Check the publisher, permissions, support information, and organizational policies.
  5. Add the approved visual to the report.
  6. Assign the required fields and configure the formatting options.
  7. Test the visual in Desktop and in the intended sharing environment.
Security and governance: Use custom visuals only when they are permitted by your organization. Review data access, certification or approval status where applicable, publisher information, and any relevant privacy or security requirements.

8. Standard vs. Custom Visuals

Consideration Standard Visual Custom Visual
Availability Built into Power BI May need to be obtained or imported
Setup Usually straightforward Depends on the visual
Specialized features Depends on built-in capabilities May provide additional capabilities
Governance Follow organizational Power BI policies May require additional review and approval
Maintenance Managed as part of Power BI Can depend on the publisher and version

9. Choosing the Right Advanced Visual

Visual Selection Guide

What Must Be Explained? Relationships Scatter Chart Process Stages Funnel Chart Target Progress Gauge / KPI Validate and Communicate Check data, labels, and interpretation

10. Practice Activity

Scenario: Business Performance Dashboard

A company wants to analyze its sales pipeline, advertising performance, and progress toward its monthly sales target.

Tasks

  1. Create a scatter chart to compare advertising spend with sales.
  2. Create a funnel chart to show lead counts across sales stages.
  3. Create a waterfall chart to explain the movement from starting profit to ending profit.
  4. Create a gauge or KPI visual to compare total sales with the monthly target.
  5. Investigate one custom visual that could meet an additional reporting requirement.
  6. Document why each visual was selected and what insight it communicates.
  7. Validate the calculations and confirm that the labels explain the results.

11. Knowledge Check

Question 1: Which visual is useful for exploring the relationship between two numeric variables?

A. Scatter chart

B. Card

C. Basic text box

Question 2: Which visual commonly represents sequential process stages?

A. Funnel chart

B. Donut chart

C. Card

Question 3: What is an important consideration before adding a custom visual?

A. Review its suitability, publisher, and organizational policies.

B. Use it without checking its behavior.

C. Remove all report labels.

Question 4: What does a waterfall chart help explain?

A. Contributions that move a value from a starting point to an ending point.

B. Geographic coordinates only.

C. The structure of a report page.

Show Answers
  1. Question 1: A — Scatter chart.
  2. Question 2: A — Funnel chart.
  3. Question 3: A — Review its suitability, publisher, and organizational policies.
  4. Question 4: A — Contributions that move a value from a starting point to an ending point.

Summary

In this lesson, you learned how advanced Power BI visuals support relationship analysis, process tracking, financial movement, and target monitoring. You explored scatter charts, waterfall charts, funnel charts, gauge visuals, and KPI visuals, along with the purpose of custom visuals.

Select visuals according to the business question, validate the underlying data, and use clear formatting to communicate results. Before using custom visuals, review their functionality, publisher, and applicable organizational security requirements.