Business Analytics
Create an interactive Excel dashboard to manage orders in a cloud kitchen
How do online kitchens manage orders and their successful delivery? 
Certified by
Role
Business Analyst
Industry
Food & Beverage
No. of Subscribers
30
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
Ram ki Bandi is a famous fast casual dosa restaurant chain in Hyderabad! It has been around since 1989 as a food cart frequented by clubbers in the wee hours of morning! Since then Ram ki Bandi has grown to be a large food chain with over six separate outlets in Hyderabad. The restaurant is famous for having no fixed menu - the food is customized as per the customer's desire. In the past few years, Ram ki Bandi has established a solid social media presence with over 5 million viewers on its content on various channels like Instagram and YouTube.
Explore
the following work techniques
Advanced Analytics
MS Excel (Pivot VLookup IF condition)
Dashboard building
VBA (Visual Basic for Applications)
Bridging the gap
Cloud kitchens can receive subscription based orders as well as day-to-day orders etc. In this menternship, you will be challenged to picture excel dashboard needs to track sales, pending payments if any, quality of order processing and customer feedback. An excel dashboard is a low-tech, low-cost solution used by small businesses that want to leverage technology for tracking operations and sales data, but do not have the resources to invest in paid softwares or technically trained database management staff. An excel-based database management system is typically run by managers who are trained in basic Excel and then trained further, specially on the use of Excel database by the business analyst who designed the dashboard - in this menternship, that’s you!
Apply
the following skills
Dashboard designing
Data Analysis
Data preparation
Hypothesis testing
Expected output
Design an excel-based data management system for tracking key sales and service metrics in a small cloud kitchen
Create
the following deliverables
Needs assessment report for restaruant database model
An excel-based database management system for a restaurant
What you’ll need before starting
MS Excel, Visual Basics, Macros