Welcome to the SQL Challenge Case Studies repository! This repository is your gateway to enhancing your SQL skills through real-world data analysis scenarios.
About In this repository, you'll find a collection of SQL case studies inspired by real-world scenarios. Dive into these challenges to analyze data, extract insights, and generate actionable recommendations using SQL.
Resources 8 Week SQL Challenge Website: Link to 8 Week SQL Challenge [https://8weeksqlchallenge.com/case-study-1/] Case Study 1: Danny's Diner Introduction: Danny's Diner is a fictional restaurant facing data challenges. In this case study, you'll dive into Danny's Diner's data to answer key questions about customer behavior, spending patterns, and menu preferences.
Key Questions:
1️⃣ Total Customer Spending: Calculate the total amount spent by each customer, offering insights into spending patterns.
2️⃣ Customer Visit Frequency: Analyze the frequency of customer visits, providing a glimpse into customer engagement.
3️⃣ Initial Menu Choices: Identify the first menu item purchased by each customer, crucial for personalizing customer experiences.
4️⃣ Popular Menu Items: Unveil the most popular menu items and their purchase frequencies, aiding menu optimization strategies.
5️⃣ Individual Customer Preferences: Discover individual customer preferences to enable tailored recommendations.
6️⃣ Post-Membership Purchasing Behaviors: Track purchasing behaviors of customers after joining the membership program, enhancing loyalty program strategies.
7️⃣ Pre-Membership Buying Trends: Investigate buying trends of customers just before joining the membership program, offering insights into customer journeys.
8️⃣ Pre-Membership Spending Analysis: Calculate the total spending and number of items purchased by each member before joining, aiding in segmentation strategies.
9️⃣ Loyalty Points System: Implement a loyalty points system based on customer spending, with a bonus for sushi purchases! 🍣
🔟 Bonus: Points Calculation for First Week Post-Joining: Calculate the points earned by customers in the first week after joining the program, incentivizing program participation.