Power BI Coffee Sales Analysis Project
The goal of this project is to provide insights into coffee sales trends across multiple countries and multiple coffee blends
This Power BI project analyzes coffee sales data sourced from and inspired by Mo Chen's Project Excel file
Project Overview -
Analysis of coffee sales by type, blend, and weight. Visualization of sales trends over time using line charts. Examination of customer loyalty card usage and its impact on sales. Identification of top 5 customers by sales amount.
Data Source The data used in this project is sourced from the following GitHub repository:
Coffee Sales Data Repository The dataset includes raw data that has been processed using various Excel techniques such as XLOOKUP and INDEX(MATCH) to ensure accuracy and consistency.
Key Visualizations Sales by Coffee Type and Blend:
Visualizes sales performance by different types of coffee and blends using bar charts. Sales Trends Over Time:
Displays line charts illustrating sales trends over the entire period from 2019 to 2022, allowing for the identification of seasonal patterns or fluctuations. Impact of Loyalty Card:
Analyzes the effect of customer loyalty card usage on sales volume and revenue through comparative analysis and visualization. Top 5 Customers by Sales:
Identifies and highlights the top 5 customers based on sales amount, providing insights into customer behavior and preferences.