Business Analytics
Use Power BI to design a best-selling menu for a restaurant
Ever wondered how McDonald's decides its combo meals? It isn't common sense, it is data science! This menternship shows how.
Certified by
Role
Business Analyst
Industry
Food & Beverage
No. of Subscribers
62
Level
Advanced
Time Commitment
Submit First Draft in 30 days
Duration
60 days
Tools you’ll learn
Here’s What You Work On
About the Company
Thickshake Factory is a specialty restaurant that has its stores across India and the US. The restaurant opened its door for the first time in the year 2013 in Hyderabad and has since then become a household name for fans of ‘milkshakes’ across the country. The restaurant has also recently launched its own e-commerce website styled after Dominos Pizza. Interestingly, one of the food chain’s investors and partners includes the famous Indian actor - Tiger Shroff.
Explore
the following work techniques
Advanced Analytics
Power BI
Bridging the gap
Power BI is an open-source data analytics and visualization tool that can be used by business teams across the world to gain real-time insights into their business. Power BI dashboards present complex data analysis in an easy-to-understand format that can be shared across multiple devices and platforms. In this menternship, you will be challenged to undertake the tasks that precede dashboard preparation - tasks like data wrangling, and data warehousing. Once you have made the required connections between various datasets, you will be able to create a dashboard that help a restaurant identify its top selling products and create meal combos that customers will love.
Apply
the following skills
Data Analysis
Data preparation
Hypothesis testing
Model formulation
Expected output
Use Power BI to help a restaurant revamp its menu and create profitable meal combos
Create
the following deliverables
Data warehousing plan for given datasets
Power BI dashboard to generate insights about the best-selling items on a restaurant menu
What you’ll need before starting
Access to a Power BI account