Project 2 - Supply and Demand Gap Analysis
Case Study on Supply and Demand of Living Food Industry
Aim:
Creating the detail review and report study for the company supply and selling of the product and check the demand based on the sales of the product how to improve the process further.
Introduction:
In this report we going to study the last month sales report and analyze the report of the Top selling product of that particular month sum of the quantity of the product Total Revenue generated and also how much discount we given for the product which mode we have sold the product most and which product is top selling and which is lowest analyzing how we can improve our demand and checking the reason for the lowest selling product.
Problem Statement:
- Analyzing the supply and demand of the recent month sales report to move further growth of the company
- Finding the Top selling product of that month and lowest
- Total Revenue generated on that month based on the discount generated.
Methodology:
Step1: Data Cleaning
In data cleaning I cleaned the data with the transform data option present in Power BI because the dataset was not cleaned and included some missing values, so with the help of the duplicates function in Power BI, I cleaned the data and replace the null values with 0 and then started working on it .Removing the unwanted columns from the table and also assigning proper data types to the table
Step2: Data Interpretation
I found some important information about the data set in this data interpretation step.
- The data set was almost clear and completed.
- Replaced the null value to 0
- Removing the error rows
- There are 541 rows 17 columns in the Raw data Table
- There are 15 rows 4 columns in the Sheet1 Table
Step3: Visualization
In visualization, I took the help of Power BI Desktop software to make graphs and charts here some relevant graphs and charts are attached in this report at the End.
Analysis (Datasheets about it):
In observation found some interesting points that are mentioned below.
- The Total Revenue generated on that month and how much discount is given
- Total selling amount and total item amount how much generated.
- Top selling product count of the month
- Top sales as per the Day in that month
- Top selling item of the month
- Creating the report of count of item, sales discount and selling price by the item name
- Item amount generated based on the how much quantity is ordered
- Creating the report for the top selling item based on the ordered type
Insights:
- In conclusion, we can look at the final Dashboard for further analysis.
- We can see the total revenue based on the item name.
Recommendations:
- We can collect a large dataset for analysis.
- We can analysis the data based on each kitchen.
- We can analysis the data into further based on the last few months comparison and checking which is continuously growing and which is lagging behind
- We can conclude our decision based on which day we are growing good.
Conclusion:
In conclusion, we can look at the final Dashboard for further analysis
https://app.powerbi.com/groups/me/reports/840dd842-9b2a-4d06-ab16-69a0f10fe19b/ReportSection
The report You can find the top selling product and also the revenue generated and also the growth rate and supply and demand of the product for the further improvement for the upcoming months