Project 2 - Supply and Demand Gap Analysis

Used the Dataset of our own (download from kaggle), Below was the link to dwld dataset from kaggel

https://www.restaurantbusinessonline.com/future-50-2020

Created a Power BI dashboard using file taken from kaggle project-2

I have completed the projec-2 and attached the files,

Power BI Report à .pbix file

Attached the Power point file(.pptx) Presentation about project-2

Detailed Documentation of project on Food Analysis using word file is attached.

Project Report on Food Restaurant analysis

Created By:

Name: K Vamsi Krishna

E-mail: [email protected]

Table of contents:

• Aim
• Introduction
• Problem Statement
• Methodology
• Analysis
• Insights
• Recommendations
• Conclusion

Aim:-

In this project the aim is to analyse the Restaurant’s sales data by Year-over-year growth and Year-over-Year Units growth.

Introduction:-

The main objective of this project to analysis data on Food Analysis, Through this Analysis of data, we can find some important insights.

Problem Statement:-

• We can find Top 5 states based on the sales
• Overall sum of sales by segment category and that rank rank & sum units, y-o-y growth & y-o-y units growth sales.

Methodolgy:-

1. Data Cleaning: The data source was a CSV file consisting of data-set with 2 tables with 17 columns. On Power BI Desktop we click on “Get Data” from CSV file and proceed onto transforming/cleaning the data in the Query editor.
2. Data Interpretation: In this data-set I didn't see any null values so I can import the file. There is total 250 rows and 17 columns on both the tables.

• Visualization: In Visualization, I take the power BI Desktop Software to make charts, Graphs, Card numbers & some relevant images are attached below.

Analysis:-

In observation I found some interesting points mentioned below.

• According to the data based on sales and quality top 5 Restaurants and Overall sales by city's.
• The data set taken from kaggle website having 2 tables and 17 columns on both the data-set.
• Maximum Meals served by the Restaurant in stacked area chart.
• Top 5 states based on sales and year over year growth, year over year units these data we can see in the charts and cards.
• Based on segment category the rank will show above the visual chart in cards.
• Maximum meals served by state we can seen in the Funnel visual.
• Sum of sales and sum of top 10 units by segment_category we can seen in the line and stacked column chart visual.
• Sum of sales by city using bubble size shown in the map chart and sum of Average check by state.
• Sum of sales by segment_category visual in Tree map.

Insights:-

Insights feature helps to easily explore and find insights such as trends in the data we interact and consume our report. It works out of the box on any report in power BI. So automatically start getting insights from the below report. We can see in the conclusion to look final report on sales on Restaurants.

Recommendations:-

• I can collect good data from kaggel which is Restaurant Analysis and there sales based on segment.
• I can analyse the data base on city and state sales on Restaurant.
• Like in this data set I work in different columns like Restaurants sales, rank, city wise sales, state wise, yoy - growth , yoy units growth, meals served.
• Based on the data-set I can create a dashboard visual.

Conclusion:-

In Conclusion, we can look at final Report for further analysis, As we can see in this report top 5 states based on there sales in Restaurants, Based on sales and there segment_category rank will be given, sum of top 10 sales units by segment and sum of sales by city & states.