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

Dashboard Creation and Tiles

Power BI dashboards provide a compact view of important business information. They help users monitor key performance indicators, compare results, and identify areas that may require attention. In the Power BI service, dashboards can combine tiles pinned from different reports and semantic models.

This lesson explains the difference between reports and dashboards, how to create a dashboard in the Power BI service, how to pin tiles, how to organize dashboard content, and how to test the finished dashboard for usability.

Learning Objectives

  • Understand Power BI dashboards and tiles.
  • Differentiate dashboards from reports.
  • Identify the role of Power BI Desktop and the Power BI service.
  • Create a dashboard in the Power BI service.
  • Pin report visuals to a dashboard.
  • Arrange and resize dashboard tiles.
  • Configure useful dashboard interactions and links.
  • Apply dashboard design and testing best practices.

1. What Is a Power BI Dashboard?

A Power BI dashboard is a single-page canvas in the Power BI service that presents important information using tiles. A tile can display content pinned from a report or other supported sources. Dashboards are useful when users need a quick overview rather than a detailed, multi-page investigation.

For example, a sales manager might use a dashboard to monitor total sales, order count, monthly performance, regional results, and progress against business targets.

Example Dashboard Layout

Sales Management Dashboard Total Sales $125K Orders 2,450 Customers 980 Average Order Value $51 Monthly Sales Trend Sales by Region North South West

A dashboard places important indicators and selected visuals on one page so users can review the overall situation quickly.

2. Dashboard vs. Report

Reports and dashboards serve related but different purposes. Reports are commonly used for detailed analysis across one or more pages. Dashboards provide a single-page monitoring view in the Power BI service.

Feature Report Dashboard
Typical location Power BI Desktop and the Power BI service Power BI service
Page structure Can contain multiple report pages Single dashboard canvas
Main purpose Detailed exploration and analysis Monitoring important information at a glance
Content Visuals built on the report's data model Tiles pinned from reports and other supported sources
Filtering Includes report filters and slicers Dashboard tiles generally link users to more detailed content for exploration
Creation workflow Build and format in Power BI Desktop or the service Create and arrange in the Power BI service
Remember: Power BI dashboards are created in the Power BI service, not in Power BI Desktop. Build your report in Desktop, publish it to the service, and then pin relevant content to a dashboard.

3. What Is a Dashboard Tile?

A tile is an individual item displayed on a Power BI dashboard. Tiles can contain pinned report visuals, text, images, video, web content, or other supported dashboard content, depending on the available Power BI features and tenant settings.

Tile Type Purpose Example
KPI tile Highlights a key measure. Total Sales
Chart tile Displays a trend or comparison. Monthly Sales
Table tile Shows selected detailed information. Top Products
Text tile Provides a title, explanation, or note. Quarterly Review
Image tile Displays an image where supported. Organization logo

4. Understand the Dashboard Creation Workflow

From Data to Dashboard

Prepare Data Model Build Report Visuals Publish To Service Pin Report Tiles Dashboard Arrange Share Validate each stage before sharing the final dashboard.

5. Prepare a Report for Dashboard Use

A useful dashboard begins with a well-designed report. Select visuals that answer important business questions and display them in a clear, readable format before pinning them.

Preparation Checklist

  1. Load and clean the required data.
  2. Build the necessary relationships and measures.
  3. Create report visuals for the main business metrics.
  4. Use descriptive titles and suitable number formats.
  5. Check that the measures return correct results.
  6. Save the report and publish it to the Power BI service.
  7. Confirm that the published report is available in the intended workspace.
Important: A dashboard does not replace the report's data model or validation work. Incorrect measures or misleading visual titles can lead to incorrect decisions even when the dashboard looks professional.

6. Create a Dashboard in the Power BI Service

After publishing a report, use the Power BI service to create a dashboard in a workspace where you have the required permissions. The exact interface labels can vary as Power BI evolves.

Step-by-Step Instructions

  1. Sign in to the Power BI service.
  2. Open the workspace containing your published report.
  3. Locate the dashboard creation option, such as New dashboard, where available.
  4. Enter a descriptive dashboard name.
  5. Create the dashboard.
  6. Open the report you want to use as the content source.
  7. Choose a visual to pin, using its pin option where available.
  8. Select the target dashboard and confirm the pin action.
  9. Repeat for other visuals that are important to the dashboard.
Tip: Use a name that describes the dashboard's purpose, such as Sales Executive Dashboard, Regional Performance Dashboard, or Monthly Operations Dashboard.

7. Pin a Report Visual to a Dashboard

Pinning places a selected report visual onto a dashboard as a tile. This allows users to see important information on the dashboard and open the underlying report for further analysis when appropriate.

Pinning Workflow

  1. Open the published report in the Power BI service.
  2. Identify the visual you want to add to the dashboard.
  3. Open the visual's available options.
  4. Select the pin option if it is available for that visual.
  5. Choose an existing dashboard or create a new one.
  6. Confirm the action.
  7. Open the dashboard and verify that the tile appears.

Report Visual to Dashboard Tile

Published Report Monthly Sales Pin Dashboard Monthly Sales Tile Pinning adds a dashboard tile; the report remains available for deeper analysis.

8. Arrange and Resize Dashboard Tiles

After adding tiles, arrange them so the most important information appears first. Dashboard tiles can generally be moved and resized in the Power BI service, subject to the current interface and permissions.

Layout Guidelines

  • Place the most important KPIs near the top.
  • Group related tiles together.
  • Use larger tiles for important trends or comparisons.
  • Keep supporting information in secondary positions.
  • Avoid excessive empty space and unnecessary tile duplication.
  • Use consistent spacing to make the dashboard easier to scan.
Design Tip: A dashboard should communicate its main message quickly. Avoid pinning every report visual simply because it is available.

9. Understand Tile Behavior and Data Updates

Dashboard tiles and their source reports are related, but they are not identical experiences. A tile presents selected content on the dashboard, while opening the source report provides the report's full interactive analysis.

Consideration What to Understand
Source report The report provides the full page layout, visual interactions, and report navigation.
Dashboard tile The tile displays selected content on the dashboard canvas.
Data refresh Tile freshness depends on the source, refresh behavior, and Power BI service features.
Permissions Users need appropriate access to view the underlying content.
Navigation Tiles can provide a route back to the related report or source content where supported.
Important: Do not assume that every tile behaves like an interactive report page. Test the tile and its source content in the Power BI service using the intended user permissions.

10. Use Dashboard Tiles for Business Monitoring

Dashboard tiles are most useful when each tile communicates a clear business message. Select metrics that users need to monitor frequently and include enough context to interpret the values correctly.

Example: Sales Executive Dashboard

  • Total Sales: Shows sales for the reporting period.
  • Total Orders: Tracks order volume.
  • Monthly Sales Trend: Shows changes over time.
  • Regional Performance: Compares geographic areas.
  • Top Products: Highlights products with the highest sales.
  • Target Progress: Compares actual performance with targets when target data is available.

11. Common Dashboard Design Mistakes

Mistake Why It Is a Problem Recommended Solution
Too many tiles Important metrics become difficult to identify. Keep only the tiles needed for the dashboard's purpose.
Unclear titles Users cannot determine what a tile represents. Use descriptive titles and appropriate units.
Inconsistent number formats Values become harder to compare. Use consistent currency, percentage, and decimal formats.
Unrelated tile placement The dashboard lacks a logical reading order. Group related information and prioritize important metrics.
No path to details Users may struggle to investigate a result. Provide access to relevant reports where appropriate.
Unverified data freshness Users may rely on outdated information. Review refresh status and explain reporting periods clearly.

12. Dashboard Sharing and Permissions

A dashboard is useful only when its intended audience can access it. Before sharing, confirm that users have the required permissions for the dashboard and its underlying content. Sharing options and licensing requirements depend on the organization's Power BI configuration.

Sharing Checklist

  1. Confirm that the dashboard is in the correct workspace.
  2. Verify the intended audience.
  3. Check access to the dashboard and source reports.
  4. Review the organization's sharing and licensing requirements.
  5. Test access with an appropriate user account when possible.
  6. Confirm that sensitive information is not exposed to unauthorized users.

13. Hands-On Practice

Task 1: Publish a Sales Report

  1. Create a report containing Total Sales, Total Orders, Monthly Sales, and Sales by Region.
  2. Check the calculations, titles, and number formats.
  3. Publish the report to the appropriate Power BI service workspace.

Task 2: Create a Dashboard

  1. Open the Power BI service and select the appropriate workspace.
  2. Create a dashboard named Sales Executive Dashboard, where the option is available.
  3. Open the published sales report.
  4. Pin the important visuals to the dashboard.
  5. Verify that each tile appears correctly.

Task 3: Organize Dashboard Tiles

  1. Place KPI tiles near the top.
  2. Position the sales trend prominently.
  3. Place regional and product comparisons together.
  4. Resize tiles to improve readability.
  5. Remove unnecessary or duplicate tiles.

Task 4: Validate the Dashboard

  1. Confirm the reporting period shown by each metric.
  2. Check the source report for detailed analysis.
  3. Review data freshness and access permissions.
  4. Test the dashboard using the intended viewing account where possible.

14. Knowledge Check

Question 1: Where are Power BI dashboards created?

A. Only in Power BI Desktop

B. In the Power BI service

C. Only in Microsoft Word

D. Only in Excel worksheets


Question 2: What is a dashboard tile?

A. An individual item displayed on a dashboard

B. A database relationship

C. A DAX variable

D. A report page tab


Question 3: What is a common way to add a report visual to a dashboard?

A. Pin the visual from the published report when supported

B. Delete the source report

C. Rename the data model

D. Remove the visual's title only


Question 4: What is the main purpose of a dashboard?

A. To provide a concise view of important information

B. To replace every detailed report

C. To remove all data refreshes

D. To create database tables automatically


Question 5: What should be checked before sharing a dashboard?

A. Access permissions and source content availability

B. Only the dashboard background color

C. The number of fonts installed on the computer

D. Whether all tiles have identical sizes

Show Answers
  1. B — Dashboards are created in the Power BI service.
  2. A — A tile is an individual item on the dashboard canvas.
  3. A — Report visuals can be pinned to dashboards where supported.
  4. A — Dashboards provide a concise monitoring view.
  5. A — Verify permissions and access to the underlying content.

Summary

Power BI dashboards provide a single-page view of important business information through tiles. Reports support detailed, multi-page analysis, while dashboards help users monitor key metrics and identify results that need further investigation.

A typical workflow is to prepare and validate the data, build a report in Power BI Desktop, publish it to the Power BI service, create a dashboard, and pin selected report visuals as tiles. Arrange the tiles so the most important information is easy to find.

Before sharing, verify data freshness, source report access, permissions, titles, number formats, and tile behavior. A focused dashboard with clear metrics and access to detailed reports can help users monitor performance and make better business decisions.