fbpx

Superstore Sample Data Analytics Dashboard

Desciption

2015
$4,458,741
$4,474,577
65,535
46,645
45,215
28,749
26,411
24,674
24,085
23,625
21,773
21,176
0,160
793
Superstore Sample Data Analytics Dashboard
This dashboard provides an overview of the total revenue, number of customers, sales, profit and quantity trends of the Superstore Sample Data. It also provides insights into the sales by segment, region and category, as well as the profit KPI by segment across regions.

Summary:
This dashboard provides a comprehensive overview of the Superstore Sample Data, giving insights into total revenue, number of customers, sales, profit and quantity trends. It also provides insights into the sales by segment, region and category, as well as the profit KPI by segment across regions.

Benefits:
This dashboard is beneficial to anyone who wants to gain insights into their business operations. It can provide valuable information to help make informed decisions on how to optimize sales and profits.

Who Can Benefit:
Business owners, managers, and analysts can all benefit from using this dashboard. It can help them to better understand their business operations and make informed decisions on how to optimize sales and profits.

How it Benefits Them:
This dashboard provides a comprehensive overview of the Superstore Sample Data, giving insights into total revenue, number of customers, sales, profit and quantity trends. It also provides insights into the sales by segment, region and category, as well as the profit KPI by segment across regions. This can help business owners, managers, and analysts to better understand their business operations and make informed decisions on how to optimize sales and profits.

Data

TOTAL REVENUE
$15,040,855
Region
✔Central
✔East
✔South
Category
(All)
Sales
Furniture
Office Supplies
ales
$91,476
4M
Segment
✔Technology
TOP 3 CUSTOMERS BY REVENUE
Customer Name
$174,454
(All)
Consumer
✔Corporate
Home Office
Year of Ship Date
$3,209,625
(A)
✓2011
2012
2015
Raymond Sean Miller Tamara
Buch
Chand
$114,421
$3,076,637
SUPERSTORE SAMPLE DATA ANALYTICS DASHBOARD
TOTAL PROFIT
NO. OF CUSTOMERS
Forecast indicator
Actual
$1,860,501
Estimate
SALES BY SEGMENT
Consumer
$7,604,933
Product N… F
Canon imageCL..
Fellowes PBSO..
TOP 10 PRODUCTS BY PROFIT
Hewlett Packar..
Canon PC1060..
Ativa V4110MD..
3D Systems Cu…
Plantronics Sav..
SALES FORECAST FOR 2015 & 2016
Order Date
$4,458,741
$3.945,544
HP Designjet T..
Ibico EPK-21 El..
Zebra ZM400 T..
Corporate
$4,602,477
$4,474,577
46,645
45,215
28,749
26,411
24,674
24,085
23,625
21,773
21,176
TOTAL QUANTITY SOLD
65,535
State
Arizona
Colorado
Florida
0,160
793
% SALES BY CATEGORY
Illinois
$2955 746 North Carolina
Office Supplies
31.285%
Furniture
32.224%
SALES BY REGION
Central
$3,289,180
NON-PROFIT GENERATING CITIES
West
$4,740,244
($22,477)
($44,200)
($22,952)
($84,679)
($50,295)
Technology
36.491%
South
$2.583,411
300K
200K
East
$4,428,019
First Class
PROFIT KPI BY SEGMENT ACROSS REGIONS
Region
Segment Central East
Consumer
Corporate
Home Office
Total Qty. Total Profit Total Sales
PROFIT KPI
✓ ABOVE TARGET
X BELOW TARGET
SALES, PROFIT AND QUANITY TREND
Order Date
$3,209,625
325,605
49,894
2011
$3,076,637
400,853
South
52,364
$3,945,544
529,952
64,163
2012
PROFIT TREND (IN YEARS) BY SHIP MODE
Ship Mode / Year of Ship Date
Same Day
Second Class
2013
West
09.048
604,091
81,910
2014
Standard Class