The Coffee Sales Dashboard is an Excel project that visualizes and analyzes sales data for four different types of coffee over a specific time frame. The dashboard provides insights into top customers, expenses, and country-wise sales using interactive charts. Built with advanced Excel functions and Data Analysis Expressions (DAX), the project showcases a robust understanding of data manipulation and visualization.

• Total Sales Visualization: Track the total sales for each coffee type, allowing for a quick overview of performance over time.

• Top 5 Customers: Identify the top 5 customers based on their expenses, aiding in customer relationship management.

• Country-wise Sales Charts: View sales distribution across different countries, providing geographical insights into market performance.

• Dynamic Slicers: Utilize slicers for Country, Package Size, Roast Type, and Loyalty Card to dynamically filter and analyze data.

• Advanced Functions: Leverage powerful Excel functions like XLOOKUP(), INDEX(), MATCH(), PROPER(), and UPPER() for efficient data manipulation.

• Data Analysis Expressions (DAX): Employ DAX for enhanced data modeling and calculation, contributing to a more robust analytical framework.

1. Download the Excel File: Clone or download the repository to access the Excel file. (coffeeOrdersData.xlsx - contains only data)(coffeeOrdersProject.xlsx - contains the interactive dashboard)

2. Open in Microsoft Excel: Open the Coffee Sales Dashboard in Microsoft Excel to explore the features (Remember - XLOOKUP feature can be used in paid version or Microsoft 365 only).

3. Interactive Analysis: Utilize slicers to dynamically filter data based on specific criteria. Explore charts and graphs for a deeper understanding of coffee sales trends.

If you find any issues or have suggestions for improvements, feel free to open an issue or create a pull request. Contributions are welcome!

This project is licensed under the MIT License.