Coffee Shop Sales Analysis Practice Project
Performed data cleaning and preprocessing by correcting price formatting and converting date/time fields to enable accurate reporting and business analysis. Analyzed sales and customer purchasing trends to identify top-performing products, store locations, peak business hours, and weekday versus weekend performance. Designed SQL reports and KPIs to measure revenue, sales volume, average daily performance, and product demand for business decision-making. Applied MySQL analytical techniques including aggregate functions, CASE expressions, subqueries, window functions, and date/time functions to answer business questions from transactional sales data.

.png)
