Why data transformation ensures quality in Power BI - Dashboard Impact

Dashboard Mode - Why data transformation ensures quality

Business Question

How does transforming raw sales data improve its quality for better decision-making?

Sample Data (Raw Sales Data)

Order ID	Product	Quantity	Price	Order Date	Region
1001	Widget A	10	20	2024-01-05	East
1002	Widget B		15	2024-01-07	West
1003	Widget A	5	20	2024-01-08	East
1004	Widget C	8		2024-01-10	North
1005	Widget B	12	15	2024-01-12	West
1006	Widget A	7	20	2024-01-15	East
1007	Widget C	3	25	2024-01-18	North

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUMX(FILTER(Sales, NOT(ISBLANK(Sales[Quantity])) && NOT(ISBLANK(Sales[Price]))), Sales[Quantity] * Sales[Price])
  Result: 10*20 + 5*20 + 12*15 + 7*20 + 3*25 = 200 + 100 + 180 + 140 + 75 = 695
• Table: Cleaned Sales Data
  Shows only rows where Quantity and Price are not blank (transformed data)
  Rows: Order IDs 1001, 1003, 1005, 1006, 1007
• Bar Chart: Sales by Region
  Formula: Sales by Region = SUMX(FILTER(Sales, NOT(ISBLANK(Sales[Quantity])) && NOT(ISBLANK(Sales[Price]))), Sales[Quantity] * Sales[Price]) grouped by Region
  Results:
  East: (10*20)+(5*20)+(7*20)=200+100+140=440
  West: 12*15=180
  North: 3*25=75
• Card: Number of Invalid Rows
  Formula: Invalid Rows = COUNTROWS(FILTER(Sales, ISBLANK(Sales[Quantity]) || ISBLANK(Sales[Price])))
  Result: 2 (Order IDs 1002 and 1004)

Layout

+-------------------+-----------------------+
|   Total Sales     |  Number of Invalid    |
|      (KPI)        |       Rows (KPI)      |
+-------------------+-----------------------+
|                                       |
|          Sales by Region (Bar Chart)  |
|                                       |
+---------------------------------------+
|                                       |
|         Cleaned Sales Data Table      |
|                                       |
+---------------------------------------+

Interactivity

A slicer for Region filters the bar chart and cleaned sales data table. Selecting a region updates total sales and invalid rows count accordingly, showing only data for that region.

Self Check

If you add a filter for Region = East, which components update?

• Total Sales KPI updates to 440
• Sales by Region bar chart shows only East region bar
• Cleaned Sales Data Table shows only rows with Region East (Order IDs 1001, 1003, 1006)
• Number of Invalid Rows updates to 0 (no invalid rows in East)

Key Result

Dashboard shows how cleaning data by removing blanks improves sales analysis quality.