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

Maps and Geographic Visuals

Maps and geographic visuals help users understand business performance across locations. In Power BI, geographic information can be used to compare regional sales, analyze customer distribution, identify location-based patterns, and support decisions involving territories.

Learning Objectives

  • Understand the purpose of geographic visuals.
  • Prepare location fields for map visualizations.
  • Understand bubble maps, filled maps, and Azure Maps.
  • Configure location, size, color, and tooltip fields.
  • Recognize common geographic data quality problems.
  • Choose appropriate map visuals for business analysis.

1. What Are Geographic Visuals?

Geographic visuals display data using location information such as country, state, city, postal code, latitude, and longitude. These visuals allow users to explore where business activities occur.

Example: Regional Business Analysis

West Central East Illustrative locations, not a geographic map

Markers can represent locations, while their sizes or colors can represent measures such as sales, orders, or customer counts.

2. Common Map Visual Types

Visual Type Purpose Example
Bubble Map Shows locations with markers Sales by city
Filled Map Colors geographic regions Sales by state
Azure Maps Supports geographic layers and location analysis Store distribution
Shape Map Displays values using supported geographic shapes Regional performance comparison
Availability note: Map visual availability and configuration can depend on the Power BI version, tenant settings, organizational policies, and the visual's current support status. Check your environment before designing a report that depends on a particular map visual.

3. Bubble Maps

A bubble map places markers at geographic locations. Marker size, color, and tooltips can communicate additional business information. Bubble maps are useful for comparing measures across cities, stores, branches, and other point locations.

Illustration: Sales by City

City A City B City C City D City E Bubble size represents a measure such as sales

How to Build a Bubble Map

  1. Select a supported map visual in Power BI Desktop.
  2. Add a geographic field such as City or State to the location field.
  3. Add a measure such as Total Sales to the size field, if supported by the selected visual.
  4. Optionally add a category field to the legend.
  5. Add useful fields to tooltips.
  6. Verify that each marker appears at the correct location.
Tip: Use a measure for marker size when the map should respond to filters and slicers in your report.

4. Filled Maps

Filled maps color geographic regions according to a measure or category. They are useful when the business question concerns differences between countries, states, provinces, or other supported geographic areas.

Illustration: Regional Sales Intensity

Region A Region B Region C Region D Region E Illustrative regions; color intensity represents relative values

How to Create a Filled Map

  1. Choose a supported filled-map visual.
  2. Add a geographic region field to the location field well.
  3. Add a numeric measure to the color or value field, where supported.
  4. Configure the color scale and legend.
  5. Review the region boundaries and verify that locations are matched correctly.
Important: A city name or region name can be ambiguous. Include additional geographic context, such as country or state, when necessary to help Power BI identify the intended location.

5. Azure Maps and Geographic Layers

Azure Maps is a mapping visual available in supported Power BI environments. Depending on the current implementation and available settings, it can support different ways to represent geographic data, including point layers and other location-focused visualizations.

Geographic Layer Concept

Store A Store B Store C Store D Conceptual illustration of location data on a map

Typical Business Uses

  • Visualizing store and branch locations.
  • Exploring customer distribution by geography.
  • Comparing sales performance across territories.
  • Displaying delivery or service coverage.
  • Supporting location-based operational planning.

6. Prepare Geographic Data Correctly

Geographic visuals depend on accurate location fields. Incorrect spellings, inconsistent labels, missing values, and ambiguous names can cause locations to appear incorrectly or remain unmatched.

Field Example Purpose
Country India Provides country context
State Maharashtra Identifies a state or province
City Pune Identifies a city or locality
Latitude 18.5204 Specifies north-south position
Longitude 73.8567 Specifies east-west position
Tip: Latitude and longitude fields should contain valid numeric coordinates. Verify their order and ensure they refer to the intended location before building the visual.

7. Assign Geographic Data Categories

Power BI can use data categories to interpret certain fields as geographic information. Where appropriate, select the relevant column and assign a category such as Country/Region, State or Province, City, Postal Code, Latitude, or Longitude.

  1. Open Data view or Model view.
  2. Select the geographic column.
  3. Locate the data category setting in the column properties.
  4. Choose the category that matches the actual contents of the column.
  5. Return to the report and verify the map's location matching.
Data quality check: Do not assign a geographic category solely because a column name sounds geographic. Confirm that its values really contain the corresponding type of information.

8. Map Formatting and Tooltips

Map formatting helps users interpret geographic patterns without creating unnecessary visual clutter.

  • Use a descriptive title that states the measure and geography.
  • Choose marker sizes that keep nearby locations distinguishable.
  • Use a clear color scale with an understandable legend.
  • Add useful tooltip fields such as region, sales, and order count.
  • Keep labels readable and avoid overlapping information.
  • Check the visual at different zoom levels.

Example Tooltip Design

Pune Branch Total Sales 125,000 Total Orders 320 Region West

Tooltips provide additional information when users hover over supported map elements. Use fields that help explain the location's business performance.

9. Common Map Problems

Problem Possible Cause Recommended Check
Location appears in the wrong place Ambiguous place name Add country or state context
Some locations are missing Blank or invalid location values Inspect and clean the source data
Markers have unexpected sizes Incorrect aggregation or measure Verify the field and aggregation
Map is difficult to read Overlapping markers or excessive labels Adjust zoom, sizing, and labels
Map visual is unavailable Visual or tenant restrictions Check Power BI environment settings

10. Practice Activity

Scenario: Regional Store Performance

Imagine that a retail company operates branches in several cities. The dataset contains the following fields:

City State Country Total Sales Total Orders
Pune Maharashtra India 125,000 320
Mumbai Maharashtra India 180,000 450
Nashik Maharashtra India 85,000 210
Nagpur Maharashtra India 95,000 240

Tasks

  1. Create a map that displays each city as a location.
  2. Use Total Sales to represent the value of each location where supported.
  3. Add Total Orders and State to the tooltips.
  4. Verify that all cities are placed correctly.
  5. Compare a point-based map with a suitable regional map.
  6. Write two observations about the sales distribution.

11. Knowledge Check

Question 1: Which fields can help identify a geographic location?

A. City, State, and Country

B. Font Size and Border Color

C. Page Title and Theme Name

Question 2: What does a filled map typically emphasize?

A. Geographic regions colored by values or categories

B. Individual text paragraphs

C. DAX formula syntax

Question 3: What should you do when a city name is ambiguous?

A. Add geographic context such as country or state

B. Remove all location fields

C. Change the report font

Show Answers
  1. Question 1: A — City, State, and Country.
  2. Question 2: A — Geographic regions colored by values or categories.
  3. Question 3: A — Add geographic context such as country or state.

Summary

In this lesson, you learned how geographic visuals represent business information by location. You explored bubble maps, filled maps, and Azure Maps, and practised assigning location fields, configuring measures, and adding useful tooltips.

Accurate geographic data, suitable visual selection, and clear formatting are essential for reliable map analysis. Validate location matching and measure aggregation before using geographic visuals to support business decisions.