Business Intelligence & Power BI Desktop
Transforming raw organizational records into high-impact executive dashboards. A practical tour of modern BI architectures, Desktop UI navigation, data ingestion, and introductory visual reporting.
Platform: Microsoft Power BI Desktop
Dataset: Superstore_Sales.csv
Outputs: Multi-Field Table & KPI CardsFrom Raw Data to Actionable Decisions
Five Key Executive Inquiries
Product Demand: Which individual product generates the highest gross sales volume?
Temporal Patterns: Which calendar month recorded peak performance, and what is the velocity?
Geographic Footprint: Which regional territory outperforms other customer markets?
Cumulative Total: What is the overarching financial baseline across all business units?
Repeat Retention: How many unique individual customers placed orders this quarter?
Key Enterprise Capabilities
Mathematical Foundations
Raw Data (Millions of Rows)
↓ Power BI Engine (ETL + DAX)
Actionable Business Decisions in SecondsThe Three Complementary Pillars
Power BI Desktop (Authoring): The primary workstation tool where BI developers connect to sources, clean data with Power Query, model relationships, and craft reports.
Power BI Service (Publish & Share): Cloud portal used to host published reports, schedule automated data pipeline refreshes, collaborate with peers, and set up governance.
Power BI Mobile (Monitor on the Go): Mobile interface allowing executives to review KPI scorecards, inspect dashboards, and receive push notifications on threshold alerts.
Enterprise Lifecycle Flow
Our primary laboratory focus is Power BI Desktop.
Everything begins with robust data modeling and local visual authoring.The Three Primary Views
Report View: The visual design canvas where charts, KPI cards, tables, and slicers are arranged. Pages are managed at the bottom edge (Page 1, +).
Table / Data View: Inspects raw underlying records, validates ingested columns, previews values, and reviews applied data formatting.
Model View: Displays the Entity-Relationship Diagram (ERD). Shows relationships, primary/foreign keys, and data cardinality across multiple tables.
The Right-Hand Tool Panes
Always verify column data types in Table View before constructing complex calculations on the Report Canvas.Connecting to Source Data
Click Get Data → Select Text/CSV (or use the shortcut icon directly on the blank canvas).
Locate and select your laboratory dataset: Superstore_Sales.csv.
Inspect the 200-row preview dialog and review detected column headers.
Load vs. Transform Data
Building the Table Visual
Click the Table icon in the visual catalog to add an empty grid to the canvas.
From the Superstore_Sales table, select three fields into the Columns well: Product (Dimension), Country (Dimension), and Sales (Numerical Metric).
Power BI groups identical product/country pairs and automatically sums numerical Sales.
Tabular Breakdown
Tables provide precise, high-granularity records suitable for detailed operational reviews.Building the KPI Card
Executives require instantaneous clarity on overarching figures without scanning granular tables.
Deselect the table by clicking on empty canvas. Click the Card visual icon (123).
Drag Sales into the Fields well. Confirm the aggregation is set to SUM.
The Card displays the high-level formatted gross revenue figure (e.g., $2.30M).
Executive KPI Display
========================================
TOTAL GROSS REVENUE
$2.30M
========================================Calculate Unique Customers
Challenge: Display the total count of active individual customers on a dedicated KPI Card.
Insert a second Card visual on the canvas next to Total Sales.
Drag Customer ID into the Fields well of the new Card.
Click the field dropdown arrow → select Distinct Count (not standard Count!).
Preview of Lab 02
Save your progress as: Lab01_Introduction.pbix
Review documentation for practice questions.