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

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