Phone Dashboard

Step 1: Power Query Cleaning

I started with a messy CSV file full of inconsistencies. Using Power Query, I:

- Cleaned and transformed 20+ columns

- Parsed and normalized sales volume data (even those tricky “K” suffixes)

- Removed duplicates and irrelevant fields

- Extracted brand names from product titles using conditional logic

Step 2: DAX Categorization & Price Analysis

Once the data was clean, I used DAX in Power Pivot to:

- Categorize phones into Low, Mid, and High price tiers

- Create custom price interval bins for deeper segmentation

- Calculate the difference between original price and actual product price to analyze discount patterns

Step 3: Pivot Tables & Visuals

I built multiple pivot tables to explore:

- Brand sales volume — comparing performance across Samsung, iPhone, Nokia, Motorola, and others

- Price distribution — showing how many products fall into custom price intervals

- Average star rating by price category

- Key metrics — including total products, total sales volume, average price difference, and average star rating

And more...

Step 4: Final Dashboard

All wrapped into a single, interactive Excel dashboard—designed with clarity, minimalism, and decision-making in mind.