Dashboards vs reports in Power BI - Business Scenario Comparison

Scenario Mode

👤 Your Role: You are a business analyst at a retail company.

📋 Request: Your manager wants you to explain the difference between dashboards and reports using Power BI. They also want you to create a simple example of each to show how they look and work.

📊 Data: You have sales data for different products, regions, and months. The data includes Product Name, Region, Month, Sales Amount, and Quantity Sold.

🎯 Deliverable: Create one Power BI report page showing detailed sales data with tables and charts. Then create a dashboard that summarizes key sales metrics with tiles linking to the report.

Sample Data

Product Name	Region	Month	Sales Amount	Quantity Sold
Widget A	North	January	1000	50
Widget B	South	January	1500	75
Widget A	North	February	1200	60
Widget B	South	February	1300	65
Widget C	East	January	900	45
Widget C	East	February	1100	55
Widget A	West	January	800	40
Widget B	West	February	1400	70

1

Step 1: Import the sales data into Power BI Desktop.

Use 'Get Data' > 'Excel' or 'CSV' depending on your file format. Load the table with columns: Product Name, Region, Month, Sales Amount, Quantity Sold.

Expected Result

Sales data is loaded into Power BI with all columns visible.

2

Step 2: Create a report page showing detailed sales data.

Add a table visual with fields: Product Name, Region, Month, Sales Amount, Quantity Sold. Add a clustered column chart showing Sales Amount by Month and Region.

Expected Result

Report page displays a detailed table and a chart showing sales trends by month and region.

3

Step 3: Create calculated measures for total sales and total quantity.

Total Sales = SUM('Sales'[Sales Amount]) Total Quantity = SUM('Sales'[Quantity Sold])

Expected Result

Measures Total Sales and Total Quantity are available for use in visuals.

4

Step 4: Create a dashboard in Power BI Service.

Publish the report to Power BI Service. Pin the Total Sales and Total Quantity cards, and the sales trend chart from the report to a new dashboard.

Expected Result

Dashboard shows key metrics as cards and a chart summarizing sales data.

5

Step 5: Explain the difference between dashboards and reports.

Dashboard: A single page with key metrics and visuals from one or more reports, designed for quick insights. Report: One or more pages with detailed data visuals and tables, allowing deep analysis.

Expected Result

Manager understands that reports provide detailed data exploration, while dashboards give a quick overview.

Final Result

Power BI Report Page:
+------------------------------------------------+
| Table: Product, Region, Month, Sales, Quantity |
|                                                |
| Chart: Sales Amount by Month and Region        |
+------------------------------------------------+

Power BI Dashboard:
+-------------------+-------------------+
| Total Sales Card  | Total Quantity Card|
+-------------------+-------------------+
| Sales Trend Chart (Pinned from report)       |
+----------------------------------------------+

✓Reports show detailed sales data and trends for deep analysis.

✓Dashboards summarize key metrics for quick decision making.

✓Dashboards can combine visuals from multiple reports.

✓Reports allow filtering and exploring data in detail.

Bonus Challenge

Create a dashboard that updates automatically when new sales data is added to the report.

Show Hint

Use Power BI data refresh settings and pin live report pages or visuals to the dashboard.

Practice

1. What is the main difference between a dashboard and a report in Power BI?

easy

A. Dashboards show key info on one page; reports have multiple pages with details.

B. Dashboards have multiple pages; reports show info on one page only.

C. Dashboards are only for printing; reports are interactive.

D. Dashboards contain raw data; reports contain only charts.

Solution

1. Step 1: Understand dashboard purpose

   Dashboards provide a quick view of key information on a single page for fast understanding.

2. Step 2: Understand report purpose

   Reports contain multiple pages with detailed data and filters for deeper exploration.

3. Final Answer:

   Dashboards show key info on one page; reports have multiple pages with details. -> Option A

4. Quick Check:

   Dashboard = summary, Report = detailed [OK]

Hint: Dashboards = one page summary, reports = detailed multi-page [OK]

Common Mistakes:

• Confusing dashboards as multi-page
• Thinking reports are only for printing
• Believing dashboards contain raw data

2. Which of the following is the correct way to create a dashboard in Power BI?

easy

A. Write DAX formulas to build a dashboard page.

B. Create a dashboard first, then add reports inside it.

C. Create a report and pin visuals to a dashboard.

D. Use Power Query to design the dashboard layout.

Solution

1. Step 1: Understand dashboard creation process

   Dashboards are created by pinning visuals from reports to a single page.

2. Step 2: Eliminate incorrect options

   Dashboards are not created first, nor built with DAX or Power Query layouts.

3. Final Answer:

   Create a report and pin visuals to a dashboard. -> Option C

4. Quick Check:

   Pin visuals from reports = dashboard creation [OK]

Hint: Pin report visuals to dashboard to create it [OK]

Common Mistakes:

• Trying to create dashboard before reports
• Using DAX or Power Query to build dashboard layout
• Confusing dashboard and report creation steps

3. You have a Power BI report with 5 pages and many filters. You pin 3 visuals from different pages to a dashboard. What will the dashboard show?

medium

A. Only the 3 pinned visuals on one page without filters.

B. All 5 pages with filters applied.

C. The entire report with interactive filters.

D. A summary table of all report data.

Solution

1. Step 1: Understand dashboard content

   Dashboards show only pinned visuals on a single page, not full report pages or filters.

2. Step 2: Analyze filter behavior

   Filters on report pages do not carry over to dashboard visuals; dashboard visuals are snapshots.

3. Final Answer:

   Only the 3 pinned visuals on one page without filters. -> Option A

4. Quick Check:

   Dashboard = pinned visuals only [OK]

Hint: Dashboard shows only pinned visuals, no full pages [OK]

Common Mistakes:

• Assuming dashboard shows all report pages
• Expecting filters to apply on dashboard visuals
• Thinking dashboard is interactive like report

4. You created a dashboard but notice some visuals do not update when report data changes. What is the likely cause?

medium

A. The report is not connected to any data source.

B. You forgot to refresh the Power BI Desktop file.

C. Dashboard visuals are snapshots and need to be repinned to update.

D. Dashboards cannot show visuals from reports.

Solution

1. Step 1: Understand dashboard refresh behavior

   Dashboard visuals update automatically when the underlying report dataset refreshes in Power BI service.

2. Step 2: Identify likely cause

   If report data changed externally, you must refresh queries in Power BI Desktop before republishing to update the service dataset.

3. Final Answer:

   You forgot to refresh the Power BI Desktop file. -> Option B

4. Quick Check:

   Refresh Desktop queries + republish [OK]

Hint: Refresh Power BI Desktop file and republish after data changes [OK]

Common Mistakes:

• Believing dashboard visuals need repinning for data updates
• Assuming report is disconnected from data source
• Believing dashboards cannot show report visuals

5. You want to share a summary of sales performance with executives who need quick insights, but also provide detailed data for analysts. How should you use dashboards and reports in Power BI?

hard

A. Create separate dashboards for executives and analysts with same visuals.

B. Create only a detailed report with all data for everyone.

C. Create only a dashboard with all data and filters for analysts.

D. Create a dashboard with key sales visuals for executives and a detailed report for analysts.

Solution

1. Step 1: Identify needs of executives

   Executives need quick insights, best served by a dashboard with key visuals on one page.

2. Step 2: Identify needs of analysts

   Analysts require detailed data and filters, best provided by a multi-page report.

3. Step 3: Combine solution

   Create a dashboard for executives and a detailed report for analysts to meet both needs.

4. Final Answer:

   Create a dashboard with key sales visuals for executives and a detailed report for analysts. -> Option D

5. Quick Check:

   Dashboard = summary, Report = detailed [OK]

Hint: Dashboard for quick view, report for deep dive [OK]

Common Mistakes:

• Using only reports for all users
• Using dashboards for detailed data
• Creating duplicate dashboards for different roles