Food Circles is a restaurant marketplace. Its core business is to facilitate the connection and negotiations between customers and restaurants. Restaurants register on the Food Circles platform, providing information such as address, cuisine type, reservation availability, delivery options, and a rating for their services and products, among other details.
The CEO needs to make informed strategic decisions, and to do so, an analysis of the company's data is required along with the creation of dashboards within a unified tool. These dashboards will allow the CEO to quickly access information and make swift decisions. The CEO is interested in the following growth insights:
- How many unique restaurants are registered?
- How many unique countries are registered?
- How many unique cities are registered?
- What is the total number of reviews?
- How many distinct cuisine types are registered?
- Which country has the most registered cities?
- Which country has the most registered restaurants?
- Which country has the most restaurants with a price level of 4?
- Which country has the highest number of distinct cuisine types?
- Which country has the most reviews?
- Which country has the most restaurants offering delivery?
- Which country has the most restaurants accepting reservations?
- Which country has the highest average number of reviews?
- Which country has the highest average rating?
- Which country has the lowest average rating?
- What is the average price for a meal for two, per country?
- Which city has the most registered restaurants?
- Which city has the most restaurants with an average rating above 4?
- Which city has the most restaurants with an average rating below 2.5?
- Which city has the highest average price for a meal for two?
- Which city has the most distinct cuisine types?
- Which city has the most restaurants accepting reservations?
- Which city has the most restaurants offering delivery?
- Which city has the most restaurants accepting online orders?
- Which restaurant has the most reviews?
- Which restaurant has the highest average rating?
- Which restaurant has the highest average price for a meal for two?
- Among Brazilian cuisine restaurants, which has the lowest average rating?
- Among Brazilian cuisine restaurants in Brazil, which has the highest average rating?
- Are restaurants that accept online orders also the ones with the highest average number of reviews?
- Are restaurants that accept reservations also the ones with the highest average price for a meal for two?
- Do Japanese cuisine restaurants in the United States have a higher average price for a meal for two compared to American BBQ restaurants?
- Among Italian cuisine restaurants, which has the highest average rating?
- Among Italian cuisine restaurants, which has the lowest average rating?
- Among American cuisine restaurants, which has the highest average rating?
- Among American cuisine restaurants, which has the lowest average rating?
- Among Arabian cuisine restaurants, which has the highest average rating?
- Among Arabian cuisine restaurants, which has the lowest average rating?
- Among Japanese cuisine restaurants, which has the highest average rating?
- Among Japanese cuisine restaurants, which has the lowest average rating?
- Among homemade cuisine restaurants, which has the highest average rating?
- Among homemade cuisine restaurants, which has the lowest average rating?
- Which cuisine type has the highest average price for a meal for two?
- Which cuisine type has the highest average rating?
- Which cuisine type has the most restaurants accepting online orders and offering delivery?
- Marketplace model was assumed for the business.
- Assumed views for the business are: Overview, Country, Cuisine, and City.
-
Dashboards were built based on key metrics from the main business views:
- Overview
- Country
- City
- Cuisine
-
Each view is represented by the following sets of metrics:
- Registered restaurants
- Distinct registered countries
- Distinct registered cities
- Offered cuisines
- Total reviews on the platform
- Map showing restaurant locations
- Number of restaurants per country
- Price for Two People by country
- Distinct cuisine types per country
- Average rating by country
- Restaurant with the most reviews
- Best-rated restaurant
- Restaurant with highest price for Two People
- Best-rated cuisine
- Number of restaurants per city
- Cities with the best and worst ratings
- Cities with the highest price for Two People
- Cities with the highest number of restaurants accepting online orders.
- Restaurants that accept online orders are not necessarily the ones with the most reviews on the platform.
- Restaurants that accept reservations tend to have higher average prices for a meal for two.
- Despite having the highest number of restaurants with the highest price level, the United States does not have the highest average price for a meal for two.
An online dashboard hosted in the cloud, accessible from any internet-connected device.
The dashboard can be accessed through this link: https://projects-foodcircle.streamlit.app/
The aim of this project is to create dashboards with charts and tables that present business metrics in the best possible way for the CEO to make decisions.
We can conclude that the dashboard fulfills the CEO's requirements, allowing them to select desired metrics in the preferred way, covering the main views of the Food Circles marketplace.
- It's evident that a significant portion of the business is concentrated in the United States and India, where established restaurants with numerous reviews are located. The CEO should focus efforts on countries with lower platform adoption and lower ratings, such as Brazil.
- Streamline the number of metrics in each view to focus on asking the right questions.