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.