Decathlon Sales & Customer Analytics Dashboard (Excel)
Built an end-to-end sales and customer analytics dashboard in Excel using Power Pivot, Data Model, PivotTables, and advanced DAX measures on 29,000+ transaction records.
Key highlights:
Designed a Power Pivot data model with proper relationships between fact and dimension (calendar) tables
Built multiple interlinked PivotTables as the backend engine for all dashboard visuals and KPIs
Created dynamic, slicer-linked images using Camera Tool combined with dynamic Named Ranges (OFFSET/MATCH) to auto-update sport visuals based on filter selection
Built custom DAX time-intelligence measures (YoY growth, previous year comparisons) using FILTER-based patterns for accurate, slicer-safe calculations
Created dynamic KPI cards for Total Sales, Orders, Customers, and Average Order Value with trend sparklines
Developed interactive slicers for payment mode, gender, year, and month with consistent custom styling
Visualized top-performing sports categories, sales trends over time, product category distribution, and customer retention rate (64.58%)
Delivered a clean, recruiter-ready visual layout with a cohesive blue-white color palette
Tools used: Microsoft Excel, Power Pivot, PivotTables, Power Query, DAX, Data Modeling, Camera Tool
Good choice putting the motion in the footer. By the time someone scrolls that far they're already interested, so it rewards them without slowing down the first impression. For a health records app it also helps that the motion stays calm and doesn't feel flashy.