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.