Back

Back

Back

[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:

https://www.youtube.com/watch?v=RXef0BoxkyE

[Industry]

Excel

[My Role]

Project Lead

[Platforms]

Excel

[Timeline]

Sep 2024 - Oct 2024

View Project Report

View Project Report

View Project Report

[My Contributions]
[01] Data Preparation

Structured and cleaned raw sales data for accuracy and consistency.

[01] Data Preparation

Structured and cleaned raw sales data for accuracy and consistency.

[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. |

[02] Visualization Development

Created key Pivot Tables and dynamic charts to highlight performance metrics. |

[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.

[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.

[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.

[04] Analytical Insights

Interpreted customer behavior and sales trends to support decision-making.

[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.

Data Transformation Skills

Gained hands-on experience in cleaning and structuring real-world datasets.

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.

Dashboard Design Thinking

Learned how to create intuitive and interactive dashboards tailored for business needs.

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.

Insight Communication

Developed the ability to interpret data and communicate insights effectively through visuals.

Insight Communication

Developed the ability to interpret data and communicate insights effectively through visuals.

Select this text to see the highlight effect

Create a free website with Framer, the website builder loved by startups, designers and agencies.