392K Sales & Profit Analysis Dashboard

Desciption

392K
Dashboard Title:
Sales & Profit Analysis Dashboard

Overall Summary:
This dashboard provides a comprehensive overview of sales and profit data for a given year. It provides insights into the performance of different regions, segments, categories, and subcategories. It also provides a comparison of sales and profit percentages over time to identify growth opportunities.

What Insights Can Be Gained:
Understand the performance of different regions, segments, categories, and subcategories
Identify growth opportunities by comparing sales and profit percentages over time
Analyze the median sales and profit percentages
Identify the most profitable categories and subcategories

Who Can Benefit From Using The Dashboard:
Business owners, marketing professionals, and data analysts can all benefit from using this dashboard. It provides insights into the performance of different regions, segments, categories, and subcategories, enabling them to identify growth opportunities and make informed decisions.

How It Would Benefit Them:
Business owners can use the dashboard to understand the performance of different regions, segments, categories, and subcategories.
Marketing professionals can use the dashboard to identify growth opportunities and make informed decisions.
Data analysts can use the dashboard to analyze the median sales and profit percentages.

Data

Selection Parameters
Year of Order Date
(All)
Grouping
Regionwise
Segmentwise
Catagorywise
Sub Catagorywise
● Productwise
Selected Grouping
So
34.43%
East
23.98%
South
40.50%
West
% of Total
Profit
2014
21.44%
Central
28.57%
East
21.44%
South
West
% of Total
Sales
Profit
SUK
Central
34.23%
East
South
33.20%
West
% of Total
Profit
Median
Sales profit Percentge Comparision
2015
2016
21.30%
33.22%
East
15.17%
South
29.75%
West
Growth & Opportunity Quadrant Analysis
o
% of Total
Sales
100K
24.33
Central
24.62%
East
21.44%
South
Sale w/ Profit Analysis
29.40%
West
% of Total
Profit
200K
Central
29.60%
East
15.37%
South
30.77%
West
% of Total
Sales
35.56%
East
46.88%
West
300K
2017
% of Total
29.06%
East
16.76%
South
34.11%
West
% of Total
Sales
Quadrants
Qdt1
Qdt2
Qdt3
Qdt4
400K
Median
Selected Grouping
Catagoty & Sub Catagorywise
Category Sub-Cat.. 2
Furniture Bookcases
Office
Supplies
Chairs
Furnishings
Tables
Appliances
Art
Binders
Envelopes
Fasteners
Labels
Paper
Storage
Supplies
Technolo.. Accessories
Copiers
Machines
Phones
Profit
-18K 56K 0
27K
92K
16K
фак
115K
12K
108K
78K
47K
207K
Sales
203K
224K
167K
150K
189K
330K
328K
330K