This repository presents the 8 Week SQL Challenge, created by Danny Ma. It includes eight case studies that simulate real-world business scenarios where SQL queries were applied to analyze datasets and provide insights.
If you're interested in further details or would like to visit the original challenge page, please click here.
The 8 Week SQL Challenge addresses various business challenges across different case studies, each requiring data-driven solutions. My goal was to gain insights into business problems, improve my SQL skills, and understand how data analytics supports decision-making in various industries. Throughout this challenge, business problems were analyzed using PostgreSQL, and key insights were derived from the datasets to inform data-driven decisions and recommendations.
Each folder includes:
- PostgreSQL queries files 🗃️
- Case study questions and detailed explanations 📑
You can find the case studies and solutions below:
- Case Study #1 - Danny's Diner 🍽️
- Case Study #2: Pizza Runner 🍕
- Case Study #3: Foodie-Fi 🎬
- Case Study #4: Data Bank 🏦
- Case Study #5: Data Mart 🛒
- Case Study #6: Clique Bait 📱
- Case Study #7: Balanced Tree Clothing Co. 👗
- Case Study #8: Fresh Segments 🍉
- Introduction: Overview of the business and its objectives.
- Problem Statement: Key business problems analyzed through data.
- Data Overview: Summary of the dataset and significant variables.
- Solutions: SQL queries addressing the business questions, with detailed explanations.
As I continue to develop my skills in data analysis, this challenge has provided me with valuable experience in solving real-world business problems using PostgreSQL. Each case study has contributed to my understanding of how data analysis can be applied to make informed business decisions.
If you find this repository helpful or have any feedback, feel free to give it a ⭐ or reach out. Thank you for checking out my work!