This GitHub repository holds my solutions for the #8WeekSQLChallenge using PostgreSQL 16.
Big thanks to @DataWithDanny for the fun SQL case studies! 🙇
- 🍜 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
- 🤝 Contribution
- 👐 Support
Danny's passion for Japanese cuisine led him to open Danny's Diner in 2021, specializing in sushi, curry, and ramen. With basic operational data in hand, the diner seeks assistance in leveraging data to optimize business performance.
Check out my solution here.
Inspired by a vision of retro styling and pizza, Danny launches Pizza Runner, combining pizza delivery with an innovative mobile app. Seeking expansion beyond traditional pizza outlets, he ventures into an Uberized pizza delivery model, initiating a journey into the world of digital entrepreneurship.
Check out my solution here.
Identifying a niche market for food-related content, Danny co-founds Foodie-Fi, a subscription-based streaming service. Anchored in data-driven decision-making, the platform offers exclusive culinary content globally, highlighting Danny's entrepreneurial drive and commitment to innovation.
Check out my solution here.
Danny pioneers Data Bank, integrating banking services with secure data storage, tapping into the emerging landscape of digital finance and cryptocurrency. Tasked with increasing customer base and optimizing data management, Data Bank seeks strategic insights for future growth.
Check out my solution here.
Danny's venture, Data Mart, undergoes a sustainability overhaul in June 2020, prompting a need to assess its impact on sales and customer segments. Seeking guidance on minimizing sales disruption from future sustainability updates, Data Mart turns to data analysis for solutions.
Check out my solution here.
Danny expands his entrepreneurial endeavors to seafood with Clique Bait, aiming to apply data analytics to optimize online sales funnel performance. Tasked with analyzing dataset dynamics, the project seeks innovative solutions for calculating funnel fallout rates in the seafood industry.
Check out my solution here.
Danny ventures into fashion retail with Balanced Tree Clothing, entrusting data analysis to optimize sales and financial reporting. Aligning with the brand's ethos of providing quality lifestyle wear, the project seeks to enhance sales performance through strategic insights.
Check out my solution here.
Fresh Segments, Danny's digital marketing agency, specializes in analyzing online ad click behavior for diverse clientele. Focused on aggregating and interpreting interest metrics, the project aims to provide actionable insights for clients, showcasing Danny's expertise in digital analytics.
Check out my solution here.
We ❤️ your input!
Want to help make this project even better? We'd love your contributions, bug reports, and ideas for new features!
To contribute to this project, see the GitHub documentation on creating a pull request.
Love this project? Show it some love with a ⭐️!
© 2024 Shiv Katira