[Project 04]
Interactive Sales Dasboard in Excel
Excel
Sales Dashboard Project
[Project Overview]
Analysis and design of an interactive dashboard for a sales dataset exported from Kaggle.
[Details]
As part of my Data Analysis and Modelling: Excel course (DSA-401) at Thai-Nichi International College, I led the and designed an interactive Excel dashboard to visualize key sales metrics across multiple branches, enabling clear insights into revenue trends, product performance, and customer behavior.
We also recorded a full dashboard walkthrough to explain the process and design choices in YouTube:
[Industry]
Excel
[My Role]
Project Lead
[Platforms]
Excel
[Timeline]
Sep 2024 - Oct 2024
[My Contributions]
[01] Data Preparation
Structured and cleaned raw sales data for accuracy and consistency.
[02] Visualization Development
Created key Pivot Tables and dynamic charts to highlight performance metrics. |
[03] Interactivity Features
Integrated slicers, VLOOKUP, RANK, and Conditional Formatting for user-friendly interaction.
Added features like autofill suggestions and real-time error.
Added features like autofill suggestions and real-time error.
[04] Analytical Insights
Interpreted customer behavior and sales trends to support decision-making.
[Key Learnings]
Data Transformation Skills
Gained hands-on experience in cleaning and structuring real-world datasets.
Dashboard Design Thinking
Learned how to create intuitive and interactive dashboards tailored for business needs.
Insight Communication
Developed the ability to interpret data and communicate insights effectively through visuals.