This project involves analyzing coffee shop sales data using SQL and Power BI. The analysis provides insights into sales trends, product performance, and customer preferences, helping optimize business decisions.
- Coffee Shop Sales Dataset.csv: The dataset containing sales data, including details on products, sales, and customers.
- Coffee Shop Sales Analysis.sql: SQL queries used to analyze the sales data and uncover key patterns and trends.
- Coffee Shop Sales Power BI Dashboard.pbix: The Power BI dashboard used to visualize the analysis results, including charts and graphs showing sales trends and product performance.
- SQL Analysis: Open the
Coffee Shop Sales Analysis.sqlfile in any SQL editor (e.g., MySQL Workbench) and run the queries to analyze the dataset. - Power BI Dashboard: Open the
Coffee Shop Sales Power BI Dashboard.pbixfile in Power BI Desktop to explore the visualizations and insights.