Sales

Sell smarter, faster and the way you want, with the power of Reliant Global Technology. Build deeper customer connections and loyalty by making every customer interaction count. In a fast moving world, we provides the ability to manage sales processes.

Client Background:

Supermarket Stores
All over USA

Project Title

Supermarket Sales Analysis

Project Objective

Objective of this analysis are as follow:
To Analyse the total sales.
To Analyse the total profit.
To analyse sales by state of USA.
Total quantity to be sold.
Sales/ Profit by segment (Consumer, Corporate, Home Office)
Sales/Profit by category of product.
Top selling products of supermarket.

Project Description

Client wanted to analyse the data of Supermarket. Data was provided thorough API . Using that, we have to deliver the supermarket sales insights. Using that analysis client wanted to take major decisions and modification in their stores.

Our Solution

Data which was provided to us we performed EDA on it and then integrate it with Power BI

Why Power BI ?

Power BI is a new cloud-based Business Intelligence service from Microsoft that builds on the company’s years of experience with relational databases such as Access, SQL Server, and others. It is a business intelligence platform that enables organisations to clean and completely transform raw data into meaningful data. It thoroughly analyses data and provides insightful results.

A quick start.
Streamlined publication and distribution.
Real-time information.
Ability to customize Power BI app navigation.
Ability to customize security features.
Cortana integration
Artificial Intelligence.

Tools used

Databases , Power BI

Language/techniques used

Python , DAX

What are the technical Challenges Faced during Project Execution

Technical challenges during this project:
First challenge in this project was to fetch data from API to Power BI.
Data which was provided to us was uncleaned.
Missing values in data.
Perform calculation on data to find insights.

How the Technical Challenges were Solved

First we store data in csv file using connector from and API.
Cleaned data by performing data analysis using python.
Performed statistical analysis to fill up missing values of data.
Performed calculation to get sales and generated profit from that data

Business Impact

Client now can visualize following information from dashboard:

Using this map view they can visualize the sales according to the location of their stores in every state of USA. Which will help them to focus on less sales generating stores. It will also help them to see most sales generating stores.

By Visualizing this client can see most sales and profit by category of product.

By seeing this visualization client can analyse the trend in sales over the period of time in all three segments. They can also visualize the sales and profit on basis of region of there stores. Client also have flexibility of filtering out the dashboard using Date filter and State selection filter.