Project 2 - Supply and Demand Gap Analysis

AIM:

The aim of this analysis is to provide supermarket sales management the overview of the product total sale, product sale by branch, customer type by branch, payment type, cogs, and rating to the product.

INTRODUCTION:

The growth of supermarkets in most populated cities are increasing and market competitions are also high. The dataset is one of the historical sales of supermarket company which has recorded in 3 different branches. Data analytics methods are easy to apply with this dataset. The analysis will help management to improve and to take appropriate decision regarding choosing products by location of the store.

PROBLEM STATEMET:

• To find out city by product line.
• To find out customer type by branch.
• To find out quantity by product line.
• To find number of product sale by branch and total sales.
• To find out invoice ID by payment.
• To find out cogs by city and product line.
• To find out the rating by product.

METHODOLOGY:

Step 1. Data Importing:

In power Bi Desktop with the help of the get data option imported CSV data which is named as SUPPERMARKETING SALES and clicked load option.

Step 2: Data Cleaning:

After loading the data and after analysing the data I understood that there are rows 1002 and 17 columns is a significant step to process and prepare the data for analysis.

Step 3: 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.

ANALYSIS:

In observation found some interesting points that are mentioned below.

• The sales data in city by product line. Product line: General item categorization groups - Electronic accessories, Fashion accessories, Food and beverages, Health and beauty, Home and lifestyle, Sports, and travel.
• A Market Segmentation of 1000 Supermarket Customers Using Data on Sales, Income and Demographics.
• We can see that the sum sales of different lines of products. Electronic accessories making the highest sales whereas Health and beauty making the lowest sales.
• The customer type, rating, invoice ID, date of payment, type of payment, city of purchase and product purchased per branch
• Businesses must track all the costs that are directly and indirectly involved in producing and distributing their products for sale.
• Most of the customers gave the product fair rating.

Insights:

This project contains a detailed report and dashboard of supermarket sales for the supermarket branches, sales to get data insights.

Recommendations:

As for analysis it our recommended management is to improve the sale of health and beauty product by providing additional offers and promotion.

Conclusion:

The growth of supermarkets in most populated cities are increasing and market competitions are also high.