Req : Postgresql
- 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
In early 2021, Danny opened a little Japanese restaurant selling food: sushi, curry, and ramen.
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 also which menu items are their favourite. He plans on using these insights to help him decide whether he should expand the existing customer loyalty program.
📌 Check out the full case study here!
Danny launched Pizza Runner, the new Pizza Empire that combines with to Uberize it.
He 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. Danny requires assistance to optimize Pizza Runner’s operations.
📌 Check out the full case study here!
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!
This case study focuses on using subscription style digital data to answer important business questions.
📌 Check out the full case study here!
Danny launched Data Bank, that's a digital bank that has 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.
This case study is all about calculating metrics, growth and helping the business analyze their data in a smart way to better forecast and plan for their future developments!
📌 Check out the full case study here!
Data Mart is Danny’s latest venture and after running international operations for his online supermarket that specialises in fresh produce. In June 2020 - All Data Mart products now use sustainable packaging methods in every single step from the farm all the way to the customer.
Danny needs your help to quantify the impact of this change on the sales performance for Data Mart and it’s separate business areas.
📌 Check out the full case study here!
Clique Bait is an online seafood store - the founder and CEO Danny wanted to expand his knowledge into the seafood industry.
You are required to support Danny’s vision and analyze his dataset and come up with creative solutions to calculate funnel fallout rates for the Clique Bait online store.
📌 Check out the full case study here!
Balanced Tree Clothing Company prides themselves on providing an optimised range of clothing and lifestyle wear for the modern adventurer!
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.
📌 Check out the full case study here!
Danny created Fresh Segments, a digital marketing agency that helps other businesses analyse trends in online ad click behaviour for their unique customer base.
Clients share their customer lists with the Fresh Segments team who then aggregate interest metrics and generate a single dataset worth of metrics for further analysis.
In particular - the composition and rankings for different interests are provided for each client showing the proportion of their customer list who interacted with online assets related to each interest for each month.
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.
📌 Check out the full case study here!