This repository contains the solution for the 8 case studies in #8WeekSQLChallenge!
Thanks @DataWithDanny for the excellent SQL case studies! 👋🏻
| Name | Description | Status |
|---|---|---|
| Case Study #1 - Danny's Diner | Danny’s Diner is in need of your assistance to help the restaurant stay afloat.Danny wants to use the data to answer a few simple questions about his customers,especially about their visiting patterns, how much money they’ve spent and alsowhich menu items are their favourite. | Completed |
| Case Study #2 - Pizza Runner | Danny requires further assistance to clean his data and apply some basic calculations so he can better direct his runners and optimise Pizza Runner’s operations. | In Progress |
| Case Study #3 - Foodie-Fi | This case study focuses on using subscription style digital data to answer important business questions. | Completed |
| Case Study #4 - Data Bank | Data Bank runs just like any other digital bank - but it isn’t only for banking activities, they also have the world’s most secure distributed data storage platform! The management team at Data Bank want to increase their total customer base - but also need some help tracking just how much data storage their customers will need. | Partially Completed |
| Case Study #5 - Data Mart | Data Mart is Danny’s latest venture and after running international operations for his online supermarket that specialises in fresh produce - Danny is asking for your support to analyse his sales performance. | Completed |
| Case Study #6 - Clique Bait | In this case study - you are required to support Danny’s vision and analyse his dataset and come up with creative solutions to calculate funnel fallout rates for the Clique Bait online store. | Completed |
| Case Study #7 - Balanced Tree Clothing Co. | Danny, the CEO of this trendy fashion company has asked you to assist the team’s merchandising teams analyse their sales performance and generate a basic financial report to share with the wider business. | Partially Completed |
| Case Study #8 - Fresh Segments | Danny created Fresh Segments, a digital marketing agency that helps other businesses analyse trends in online ad click behaviour for their unique customer base. Danny has asked for your assistance to analyse aggregated metrics for an example client and provide some high level insights about the customer list and their interests. | Partially Completed |