Introduction
This project showcases a comprehensive analysis of coffee sales trends using advanced Excel functionalities. The visualizations and features include:
- Interactive Timeline: Filter sales data by specific time periods with dynamic slicers.
- Total Sales Over Time: A line graph that compares sales trends across coffee types, including Arabica, Robusta, Excelsa, and Liberica.
- Sales by Country: A bar chart highlighting revenue contributions from different regions, including the United States, Ireland, and the United Kingdom.
- Top 5 Customers: A ranked chart displaying the highest-spending customers.
In this project, I utilized the following skills:
- Advanced Excel formulas, such as XLOOKUP and INDEX-MATCH, to extract and organize data efficiently.
- Sorting and filtering techniques to enable dynamic data exploration.
- Graph creation to visualize trends and patterns effectively.
- PivotTables for summarizing large datasets and deriving actionable insights.
- Customization and formatting to create an engaging and user-friendly dashboard interface.
This dashboard not only provides insights into coffee sales performance but also demonstrates my ability to turn raw data into meaningful and actionable visualizations.