Company Sales Performance Analysis
Originally published: 25/10/2021 13:05
Publication number: ELQ-97041-1
View all versions & Certificate
certified

Company Sales Performance Analysis

Company Sales Analysis Dashboard in Excel and pbix

Description
This is Company Sales Analysis Dashboard.t.
Pages:
In this report, we have the following 6 pages.
1. Customer History
2. Product Catalog
3. Transaction History
4.Agent Performance
5.3PL Performance
6.Warehouse

KPIs:

In this report, I have created the following KPIs.
1.Customer Served
2.Customer Transactions
3.Quantity Sold to Customer
4.Avg Quantity Per Customer
5.Total Products
6.Total Sold Products
7.Total Selling Price
8.Avg Selling Price
9.Total Transaction
10.Total Gross Income
11.Total Agents
12.Top Selling Agent Location
13.Top Agent Sold Quantity
14.Top Agent Gross Income
15.Total 3rd Party Logistic
16.Top 3rd Party Logistic
17.Top 3PL Delivery Quantity
18.Customer Satisfaction
19.Total Warehouse
20.Top Warehouse Location
21.Top Warehouse Income
22.Total Returns to Warehouse


Process:
In which the data source is an Excel file. First I have uploaded excel data into the Power BI file.
Then I did a little bit of transformation in the power query. Then created DAX measures for all above define KPIs. Then created visuals as shown in the attached images.

Modification if Needed :

If you want any modification in background images or visualization, you can connect with me through Eloquens or WhatsApp here is my WhatsApp number +92 3000945833.

Deliverable :
I will provide you Excel dataset file and a power bi file in which all KPIs and visualization are present.

Usage:
You can use this report for learning purposes or entering into a competition or commercial use or for portfolio.
if you want to create any other domain reports then you can also let me know.
God Bless you.
Thanks and Regards
Muhammad Umair Shahid

This Best Practice includes
1 Excel , pbix file

Muhammad Umair Shahid offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

You can use this report for learning purposes or entering into a competition or commercial use or for portfolio.


0.0 / 5 (0 votes)

please wait...