Skip to content

Faasos (now Rebel Foods) is a popular Indian food delivery company. It started as a restaurant chain, then shifted online. They offer affordable meals, diverse cuisines, and efficient delivery. Rebel Foods operates multiple brands, using technology to enhance the food delivery experience.

Notifications You must be signed in to change notification settings

shivanidashore777/FAASOS_SQL_ANALYSIS_PROJECT

Repository files navigation

FASSOS_SQL_ANALYSIS_PROJECT

Faasos is a popular food delivery company that operates primarily in India. Founded in 2011, Faasos started as a quick-service restaurant chain offering a variety of wraps and other fast-food items. Over time, it transitioned into an online food delivery platform, catering to the increasing demand for convenient food options.

Faasos gained prominence by introducing a unique concept of "wraps on wheels" and rapidly expanded its menu to include a diverse range of Indian and international cuisines. The company focused on providing tasty and affordable meals with efficient delivery services.

In addition to its own kitchens and delivery fleet, Faasos also collaborated with local restaurants to offer a wider selection of dishes. It utilized technology to streamline the ordering process, allowing customers to conveniently place their orders through a user-friendly mobile app or website.

Faasos experienced significant growth and secured funding from various investors, enabling it to expand its operations across multiple cities in India. It later rebranded itself as Rebel Foods to reflect its broader vision of becoming a global cloud kitchen network.

Today, Rebel Foods operates numerous brands, including Faasos, Behrouz Biryani, Oven Story, and Mandarin Oak, among others. These brands cater to different culinary preferences, offering a variety of cuisines and food options to customers. Rebel Foods has revolutionized the food delivery industry in India, leveraging technology, innovation, and a vast network of cloud kitchens to provide a seamless and enjoyable dining experience for its customers

In this Fassos Analysis Project I have solved Business Problems --

** ROLL_METRICS **

  1. HOW MANY ROLLS WERE ORDERED?
  2. HOW MANY UNIQUE CUSTOMER ORDERS WERE MADE?
  3. HOW MANY SUCCESSFULL ORDERS WERE DELIVERED BY EACH DRIVER?
  4. HOW MANY OF EACH TYPE OF ROLL WAS DELIVERED?
  5. HOW MANY VEG AND NON VEG ROLLS WERE ORDERED BY EACH CUSTOMER?
  6. WHAT WAS THE MAXIMUM NUMBERS OF ROLLS DELIVERED IN A SINGLE ORDER?
  7. FOR EACH CUSTOMER HOW MANY DELIVERED ROLLS HAD ATLEAST ONE CHANGE AND HOW MANY HAD NO CHANGE?
  8. HOW MANY ROLES WERE DELIVERED THAT HAD BOTH EXCLUSIONS AND EXTRAS?
  9. WHAT WAS THE TOTAL NUMBER OF ROLLS ORDERED FOR EACH HOURS OF THE DAY?
  10. WHAT WAS THE NUMBER OF ORDER FOR EACH DAY OF THE WEEK?

** DRIVER AND CUSTOMER EXPERIENCE **

  1. WHAT WAS THE AVERAGE TIME AVERAGE TIME IN MINUTE IT TOOK FOR EACH DRIVER TO ARRIVE AT THE FASSOS HEADQUATER TO PICK THE ORDER?
  2. IS THERE ANY RELATIONSHIP BETWEEN THE NUMBER OF ROLLS AND HOW LONG THE ORDER TAKES TO PREPARE?
  3. WHAT WAS THE AVERAGE DISTANCE TRAVEL FOR EACH CUSTOMER?
  4. What was the longest and shortest deilivery times for all orders?
  5. WHAT WAS THE AVERAGE SPEED FOR EACH DRIVER FOR EACH DEILIVERY AND DO YOU NOTICE ANY TREND FOR THIS VALUES?
  6. WHAT IS THE SUCCESSFUL PERCENTAGE FOR EACH DRIVER?

About

Faasos (now Rebel Foods) is a popular Indian food delivery company. It started as a restaurant chain, then shifted online. They offer affordable meals, diverse cuisines, and efficient delivery. Rebel Foods operates multiple brands, using technology to enhance the food delivery experience.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published