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
Menterns at work
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
Learn more about our Menternship Principle
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
Learn more about our Menternship Principle
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
Learn more about our Menternship Principle
What you’ll need before starting
Access to a Power BI account
Why Do Menternships?
Each Menternship experience is powered by the MentorMind experiential learning model. We empower you as a Mentern to produce your own unique real work output through mentoring, deep-learning & applying your learnings to work.
All our Menternships are co-created with companies. They are designed for real-time work in the corporate function which allows all levers of a work experience to flourish in your Menternship experience.
You get access to a guild of industry mentors with remarkably diverse experience in their fields. Mentors help you with expert advice, domain guidance or to understand a specific task better. Moreover, you can always depend on our community of menterns, MentorMind Garage, to seek assistance from your co-menterns, guides & mentors!
Successfully completing a Menternship is no less that having practical, hands-on work experience. You earn a Certificate of Recognition from the Menternship partner company which can be showcased on your CV or your LinkedIn as a proof of your real skills!
As a Certified Mentern you earn a spot in the exclusive Mentern Perks Club, a MentorMind community that opens up networking amongst menterns from across the globe. MentorMind empowers the community with our amazing Perks Club guides, Do-With-Us workshops & access to work opportunities with our Corporate Partners!
Meet Our Certified Menterns
It was amazing! I learnt so many things like creating engagement on social media platforms. The 1:1 with mentors were super helpful. I learnt how to create Instagram ads, identify goals & do competitor analysis- so many things.
Ria Bothra
Menternship taken up by this mentern
Create an Effective Strategy to Increase Brand Online Presence & Engagement on Social Media
There was a lot of interactive sessions with Mentors. The Menternship I completed gave me a new perspective to how work has to be done. I truly enjoyed working with real figures & actual industry case studies.
Tejaswini Kapade
Menternship taken up by this mentern
Improve customer experience by analyzing product reviews of e-commerce website
John Sunith
Menternship taken up by this mentern
Analyse User Behaviour & Optimise the User Workflow Using a Machine Learning Algorithm
My experience was great as I got a chance to explore subjects like Analytics which are difficult to look for. The Menternship allowed to get subject knowledge and see what goes behind the making and delivering of a product.
Harsha Diwan
Menternship taken up by this mentern
Observe Consumer Behaviour at a Local Point of Sale, and Develop a Marketing Strategy for a Niche Health Beverage
My experience was very useful as I learnt so much about Fleet Management & Digital Marketing connected to the real-world scenario. I learnt how to actually work with social media channels like IG & Facebook.
Lova Kumar Uggina
Menternship taken up by this mentern
Create a B2B Digital Marketing Strategy for a Fleet Management Company to Expand to Other Countries
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.
Explore our curated Resource Hub
Get Guidance in One-on-One Mentor Hours
Ask Questions in our Biweekly AMA
Resolve all doubts on Mentor Support Chatbox
Get Actionable Mentor Feedback on your work
Learn & Network at the exclusive Mentern Perks Club
