Skip to content

My Solutions to Data with Danny's #8WeekSQLChallenge Case Studies, with explanations.

Notifications You must be signed in to change notification settings

EnyaCrocock/8_Week_SQL_Challenge

Repository files navigation

8 Week SQL Challenge

The 8 Week SQL Challenge, which consists of 8 different case studies, was created by Danny Ma and the Data With Danny virtual data apprenticeship program. Each case study contains a dataset with a series of questions to practice your SQL skills.

💻 Visit Dannys website to find out all about the challenge, as well as different resources:

📌 Case Studies

🍜 Case Study #1 - Danny's Diner

Introduction

Danny seriously loves Japanese food so in the beginning of 2021, he decides to embark upon a risky venture and opens up a cute little restaurant that sells his 3 favourite foods: sushi, curry and ramen.

Danny’s Diner is in need of your assistance to help the restaurant stay afloat - the restaurant has captured some very basic data from their few months of operation but have no idea how to use their data to help them run the business.

Questions & Dataset

My Solutions:

🍕 Case Study #2 - Pizza Runner

Introduction

Danny was scrolling through his Instagram feed when something really caught his eye - “80s Retro Styling and Pizza Is The Future!”

Danny was sold on the idea, but he knew that pizza alone was not going to help him get seed funding to expand his new Pizza Empire - so he had one more genius idea to combine with it - he was going to Uberize it - and so Pizza Runner was launched!

Danny started by recruiting “runners” to deliver fresh pizza from Pizza Runner Headquarters (otherwise known as Danny’s house) and also maxed out his credit card to pay freelance developers to build a mobile app to accept orders from customers.

Questions & Dataset

My Solutions:

🥑 Case Study #3 - Foodie-Fi

Introduction

Subscription based businesses are super popular and Danny realised that there was a large gap in the market - he wanted to create a new streaming service that only had food related content - something like Netflix but with only cooking shows!

Danny finds a few smart friends to launch his new startup Foodie-Fi in 2020 and started selling monthly and annual subscriptions, giving their customers unlimited on-demand access to exclusive food videos from around the world!

Danny created Foodie-Fi with a data driven mindset and wanted to ensure all future investment decisions and new features were decided using data. This case study focuses on using subscription style digital data to answer important business questions.

Questions & Dataset

My Solutions:

About

My Solutions to Data with Danny's #8WeekSQLChallenge Case Studies, with explanations.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published