This project transforms raw sales data into an interactive dashboard that highlights key business insights. Using pivot tables and charts, I analyzed trends and performance over time. With slicers and timelines, I added smooth filtering to make the dashboard fully dynamic. KPI cards display quick, high-impact insights like total sales, profit, and top-performing countries. Conditional formatting was also applied to make key patterns stand out.
Through this project, I learned how to turn data into actionable insights, the importance of design and usability in analytics, and how to connect different Excel tools to create a seamless, interactive experience.
Tools I Used:
Excel Pivot Tables & Pivot Charts
Slicers & Timelines
KPI Cards (Total Sales, Profit, Top Country)
Conditional Formatting
Clean, professional design principles