Project Overview

The Aroma Blend Sales Dashboard is a robust tool designed to provide insights into the sales performance of a mock coffee shop, seamlessly integrating data-driven analysis with brand identity. Key features of the dashboard include:

Sales Over Time Graphic

This graphic displays sales trends over four years, offering a historical perspective on the coffee shop's performance. It helps identify seasonal patterns and guides marketing and inventory decisions.

Sales by Country Graphic

A visual representation of sales by country offers insights into the shop's international reach. It aids in understanding regional variations and tailoring marketing efforts accordingly.

Sales by Customer Graphic

Highlighting the top 5 clients who have made the most purchases, this graphic aids in recognizing and rewarding loyal customers. It provides opportunities for targeted customer engagement and loyalty program management.

Flexible Filtering

The dashboard's filtering options based on order date, coffee type, size, roast type, and customer loyalty card status make it a versatile tool. Users can dissect the data to reveal specific insights and adapt strategies accordingly.

The process of merging the order, customer, and product tables to create the Data Table showcases my data manipulation skills using Excel functions such as XLOOKUP, IF, INDEX, and MATCH. The approach to pivot tables and dashboard design reflects my ability to translate complex data into a user-friendly interface aligned with the envisioned brand identity.

In conclusion, the Aroma Blend Sales Dashboard is a valuable asset for making informed decisions, enhancing customer engagement, and optimizing sales strategies for the mock coffee shop. It seamlessly blends data analytics with brand identity, creating a rich and visually appealing tool for business success.