The 8 week SQL challenge was created by Danny Ma. It contains business problems and questions from 8 different businesses to be solved using SQL. The case studies can be accessed at 8 week SQL Challenge
The topics covered in the case studies include;
- Health analytics
- Marketing analytics
- People analytics
- Financial markets
- Fast moving consumer goods
- Digital marketing
Brief description of each case study:
| Case Study | Description | Status |
|---|---|---|
| #1 Danny's Diner | The owner of a Japanese restaurant wants to analyze the visiting patterns of his customers,how much they spent and their favorite items on the menu so he can deliver a better and more personalized experience for his loyal customers. He has asked a few business questions which can be answered by analyzing the data he has collected. | Completed |
| #2 Pizza Runner | Pizza Runner is an uberized pizza restaurant that has runners who deliver pizza from the headquarters to customers.The owner has collected some data which he wants analyzed so he can optimize his business operations and better direct his runners. He has prepared some business questions to guide the analysis. However, the data is messy and will need some cleaning. | Completed |
| #3 Foodie-Fi | Foodie-Fi is a subscription based streaming service that offers trial and sells monthly and annual subscriptions. The owner wants to understand the journey of some select customers and also wants the data analyzed to answer the business questions he has provided. Also, he wants a payment table created using specific conditions. The owner has also asked for a few business recommendations | Completed |
| #4 Data Bank | Data Bank is a digital bank that also has a secure distributed data platform.Customers are allocated cloud data storage limits which are directly linked to how much money they have in their accounts. 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. | Part Completed |
| #5 Data Mart | The owner of Data Mart introduced large scale supply changes in June 2020. The task is to quantify the impact of this change on sales performance by analyzing sales before the change and after the change. The owner would also like to know how this change affected the different categories of customers. | Completed |
| #6 Clique Bait | Tasks include analyzing product performance in terms of views, cart adds, purchases and desertions. Tasks also include creating new table to match users and visits to various marketing campaigns and devising metrics to comapare marketing campaigns | Completed |
| #7 Balanced Tree | Analyzing the sales performance of Balanced Tree Clothing Company | Part Completed |
| #8 Fresh Segments | In progress |
I used PostgreSQL to solve the case studies