Project: Building Your First Sales Dashboard

Goal: To build a functional, interactive Power BI dashboard using a standard Excel sales dataset. This project follows the complete "End-to-End" workflow—from raw data import to cloud-based sharing.

Outcome: By the end of this project, you will understand how data flows through the four main stages of Power BI: Connectivity, Transformation, Modeling, and Visualization.

Project Phase 1: Data Preparation

• Step 1 (Ingestion): Open Power BI Desktop and use Get Data to import your Excel file. Select the tables for Sales, Products, and Customers.
• Step 2 (Transformation): Click Transform Data to enter the Power Query Editor. Ensure the Date column is set to the "Date" data type and rename short headers (e.g., change "Qty" to "Quantity Ordered").

Project Phase 2: Data Modeling

• Step 3 (Relationships): Navigate to the Model View. Connect your tables by dragging ProductID from the Products table to the Sales table. Do the same for Date and CustomerID to create a Star Schema.
• Step 4 (Calculations): In the Report View, create the following core measures using DAX:
  • Total Sales = SUM(Sales[SalesAmount])
  • Total Profit = SUM(Sales[Profit])
  • Average Sales = AVERAGE(Sales[SalesAmount])

Project Phase 3: Visual Design

Build your interactive canvas by adding the following elements to the report page:

Project Phase 4: Publishing & Monitoring

• Step 5 (Publishing): Click the Publish button and upload your report to "My Workspace" in the Power BI Service.
• Step 6 (Dashboarding): Open the report in your browser. Hover over your most important visuals (the Card and the Line Chart) and click the Pin icon to add them to a new Management Dashboard.

Final Project Output Sample

Below is an example of what your finished Sales Dashboard should look like. Notice the clean layout, with "KPI Cards" at the top for quick reading and interactive charts below for deeper analysis.