Project 2 - Supply and Demand Gap Analysis

Aim:- The Aim of this project is analysis the data collect the insight to grow the business.

Introduction:-

In this project we are finding The some meaningful Insights for the business.

What was the highest number of sales in which year?

What product sold the most? Why do you think it sold the most?

What was the average price for each product? And the overall average price of all products?

What method is most efficient for sales?

Problem statement:-For Adidas shopping which method is used. And the Highest Seller Material Finding.

Methodology:-

1) Data Collection and cleaning:-

Collected data from Kaggle side, Cleaning Remove Errors, Replace Null Value to Zero.

2) Understand the data: - In that data is Complicated 33 Columns and 9648 rows need convert in Simple format.

3) Visualization: - To make simple and easier format I Took the help of Power BI Desktop Software Which is best for the presentation.

Analysis (Data sheets pertaining to it):-

In observation found some interesting points that are mentioned below.

Insights:- The Highest no of sales in 2021 which 2021 in New York which 3,98,01,335.00

According to funnel chart Men’s street Footwear sold more. It is approximately 20,88,26,244.00

The Average price of project is 256.93.

For sale In-store method is best almost 39.63% sold.

Recommendations:-

We can collect data from kaggle side.

We can analyse large data sets.

Like this dataset we can perform operations with various categories, city-wise or region-wise.
We can work on large datasets and analyze them with the proper format of the chart.

Conclusions: -

Here we conclude that the large amount of shoes is purchased in New York.

Men Street Footwear purchased more. Increase the production of this product.

Need to increase store.