Sales Insights Data Analysis Project

Problem Statement

A Computer Hardware Company supply equipments and computer Peripherals across India and having lot of regional offices across India .As sales Director is facing lot of issues and challenges as the market is growing dynamically becoming difficult to track .so the Director wants Insights of Business from all Regional Managers.But they are sending all excel files with numbers and figures which is difficult for humans to gain all insights from that numbers and cannot be get complete picture

Sales Director wants:-

• where are the sales declining in which region?
• what is the profit according to region?
• where to focus in which region more?

Solution

To solve the Sales insights problem Data Analytics team is required and IT team managing Database So entire team come up with a solution solving Using

AIMS Grid

1. Purpose
2. StakeHolders
3. End Result
4. Success Criteria

Requirements

• Build a Dashoard showing all insights and complete picture of sales Clearly
• Profit By Region
• Performance Insights according to Region

Tech Stack

• MySql
• Microsoft PowerBI
• Tableau

WorkFlow

1. Importing All Excel Files to MySql and Analyzing columns and joining the tables according to Requirements
2. Connecting PowerBI to MySql Server for retrieving data
3. Using DAX in PowerBI cleaning the data
4. Building a Interactive Dashboard using the cleaned data

Some Pictures of PowerBI

Key Insights

Performance Insights

Profit Analysis

Tableau Dashboard