Total Sales

$742,000

Total Profit

$18,451

Profit Margin

2.5%

Total Discount

$369

Avg. Sales per Order

$421

Avg. Sales per Customer

$1,050

Avg. Sales per Product

$1,953

Customer.Name Customer.ID Segment TotalSales
Seth Vernon SV-20365 Consumer $8,332
Joe Elijah JE-15715 Consumer $6,920
Peter Fuller PF-19120 Consumer $6,837
Caroline Jumper CJ-12010 Consumer $6,267
Greg Tran GT-14710 Consumer $6,219
Laura Armstrong LA-16780 Corporate $5,387
Tom Prescott TP-21415 Consumer $4,899
Nora Preis NP-18700 Consumer $4,840
Brenda Bowman BB-11545 Corporate $4,768
Bill Donatelli BD-11320 Consumer $4,513
Product.Name Sub.Category TotalSales
HON 5400 Series Task Chairs for Big and Tall Chairs $21,871
Riverside Palais Royal Lawyers Bookcase, Royale Cherry Finish Bookcases $15,611
Bretford Rectangular Conference Table Tops Tables $12,995
Global Troy Executive Leather Low-Back Tilter Chairs $12,975
SAFCO Arco Folding Chair Chairs $11,573
DMI Eclipse Executive Suite Bookcases Bookcases $11,047
Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back Chairs $10,638
Chromcraft Bull-Nose Wood Oval Conference Tables & Bases Tables $9,918
Bush Advantage Collection Racetrack Conference Table Tables $9,545
GuestStacker Chair with Chrome Finish Legs Chairs $9,071

Store Start Date

2014-01-06

Days of Operation

1,454

Total Orders

1,764

Avg. Orders /Year

441

Avg. Orders /Month

37

Avg. Orders /Day

2

Avg. Shipping Days

4

Shipping Modes by Number of Orders
Year over Year Orders Trend

Total Customers

707

Locations: City

371

Locations: State

48

Avg. Orders per Customer

2

Avg. Product Qty /Customer

11

Year over Year Customer Growth Trend
Customer Segment by Number of Customer
Quantity Sold, Discount, Profit, and Sales by Customer Segment
Top Locations (zipcode) by Number of Customers

Number of Products

380

Quantity Sold

8,028

Avg Qty Sold /Product

21

Avg. Yearly Qty Sold

2,007

Avg. Monthly Qty Sold

167

Avg. Daily Qty Sold

9

Quantity Sold by Product Category
Product.Name Quantity
KI Adjustable-Height Table 74
Situations Contoured Folding Chairs, 4/Set 64
Staple-based wall hangings 62
Chromcraft Round Conference Tables 61
Eldon Wave Desk Accessories 61
Global Wood Trimmed Manager’s Task Chair, Khaki 59
Global High-Back Leather Tilter, Burgundy 54
SAFCO Arco Folding Chair 53
Flat Face Poster Frame 51
Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back 51
Product.Name Quantity
Bush Saratoga Collection 5-Shelf Bookcase, Hanover Cherry, *Special Order 1
Global Enterprise Series Seating Low-Back Swivel/Tilt Chairs 1
Barricks Non-Folding Utility Table with Steel Legs, Laminate Tops 2
Ultra Commercial Grade Dual Valve Door Closer 2
Atlantic Metals Mobile 2-Shelf Bookcases, Custom Colors 3
Bush Westfield Collection Bookcases, Dark Cherry Finish, Fully Assembled 3
Executive Impressions 13-1/2” Indoor/Outdoor Wall Clock 3
Linden 12” Wall Clock With Oak Frame 3
Bevis Round Conference Room Tables and Bases 4
Bush Cubix Collection Bookcases, Fully Assembled 4
Sales, Profit, and Discount by Product Category
Year over Year Quantity of Product Sold

Products:

  • The store had 380 furniture products (by Product Name) for sale during the period. (Note: 375 product count by Product ID. There are 16 products that shared the same ID and 3 products that have two different IDs each).

  • The products are categorized into 4 types: 1) Bookcases 2) Chairs 3) Tables and 4) Furnishings.

  • The total quantity of product sold was 8,028 items. Average quantity sold per product is 21 items. Average quantity sold per year is 2,007 items, 167 items /month, and 9 items /day.

  • Number of quantities sold shows an increasing trend over years from 1,623 items in 2014 items to 2,437 in 2017. Monthly trend also appears similarly each year with increasing trend starting lowest products sold at the beginning of the year and highest at the end of the year with a couple of drops around August and October month.

year Total.Qty pct_change
2014 1,623 NA
2015 1,775 9
2016 2,193 24
2017 2,437 11
  • Furnishing products were the most sold in quantity (3,563 /44%); bookcases were the least sold in quantity (868 /11%).
Sub.Category Quantity Percent
Furnishings 3,563 44
Chairs 2,356 29
Tables 1,241 16
Bookcases 868 11
Total 8,028 100
  • Chairs product produced the highest revenue both in sales ($328,449 /44%) and profit ($26,590 /144%). Tables and bookcases made the sales however were negative in profit after the costs. Furnishing products were the highest in discount.
Sub.Category TotalSales TotalDiscount TotalProfit PctSales PctDiscount PctProfit
Bookcases 114,880 48 -3,473 15 13 -19
Chairs 328,449 105 26,590 44 29 144
Furnishings 91,705 132 13,059 12 36 71
Tables 206,966 83 -17,725 28 23 -96
  • KI Adjustable-Height Table was the most sold product in quantity (74). Bush Saratoga Collection 5-Shelf Bookcase, Hanover Cherry, Special Order and Global Enterprise Series Seating Low-Back Swivel/Tilt Chairs were the least sold in quantity (1).

Orders & Shipping:

  • The store total number is 1,764. Average order per year is 441, 37 orders per month, and 2 orders per day.

  • There were 4 shipping modes offered to customers: 1) Same Day 2) First Class 3) Second Class and 4) Standard Class. Most customers opted their order shipment using Standard Class (59%) and only 5% of the orders got shipped using the same day option.

Ship.Mode n percent
Same Day 96 5
First Class 274 16
Second Class 354 20
Standard Class 1,040 59
Total 1,764 100
  • The store could take from 0 to 7 days to ship the orders with an average of 4 days. Standard Class most likely took 4-6 days; Second Class 2 up to 5 days; First Class 1-3 days; and Same Day mostly likely within the day with small cases that would be the next day.
Days.to.Ship n percent
0 93 5
1 66 4
2 258 15
3 154 9
4 499 28
5 390 22
6 195 11
7 109 6
Total 1,764 100
  • Order numbers trend has similar increasing trend over the years as the product quantity sold and customer trend with the trend starting lowest at the beginning of the year and highest at the end of the year with a couple of drops around August and October month.
year NumOrders pct_change
2014 353 NA
2015 371 5
2016 476 28
2017 564 18

Customer & Locations:

  • The store had 707 customers in total over the years. The customers are categorized into 3 segments: 1) Consumer 2) Home office and 3) Corporate. Consumer is the largest segment having 52% of the customers in the group. The rest are 18% in home office and 30% in corporate.
Segment n percent
Consumer 368 52
Home Office 128 18
Corporate 211 30
Total 707 100
  • Consumer segment generated the highest overall in sales ($391,049 /53%), products quantity sold (4,166 /52%), and got more discount than other segments. However, the store gained slightly more in profit from the corporate segment ($7,585 /41%) comparing to the consumer segment (6,991 /38%). Home office was the smallest segment and generated the least revenues overall.
Segment QtySold TotalSales TotalDiscount TotalProfit PctQtySold PctSales PctDiscount PctProfit
Consumer 4,166 391,049 197 6,991 52 53 53 38
Home Office 1,367 121,931 60 3,875 17 16 16 21
Corporate 2,495 229,020 112 7,585 31 31 30 41
  • The customers were in different locations in the U.S. (4 regions, 48 states, 371 cities, and 454 zip codes based on the locations the products were shipped to). There were more shipments to customers in the west (31%) particularly in California (19%). New York City, however, had the highest number of customers (28%) at the city level.
Region n percent
West 423 31
East 371 27
Central 318 24
South 239 18
State n percent
California 299 19
New York 175 11
Texas 160 10
Pennsylvania 97 6
Washington 93 6
City State Count Percent
New York City New York 145 28
Los Angeles California 125 24
Philadelphia Pennsylvania 88 17
San Francisco California 88 17
Seattle Washington 79 15
  • Customer growth trend has similar increasing trend over the years as the product quantity sold trend with the trend starting lowest at the beginning of the year and highest at the end of the year with a couple of drops around August and October month.
year NumCustomer pct_change
2014 290 NA
2015 289 0
2016 355 23
2017 403 14

Sales & Profit:

  • The store total sales were $742,000, total profit was $18,451 with profit margin of 2.5%, and $369 in total discount. An average sale per order was $421, $1,050 per customer, and $1,953 per product.

  • There were higher sales ($252,613 /34%) and profit ($11,505) in the west region. South region was the lowest in sales ($117,299 /16%). Central region was negative in profit (-$2,871). At the state level, California had the highest in sales ($156,065) and profit ($9,163); there was a lost in profit in Texas (-$10,436) and Pennsylvania (-$7,197). On the city level, New York City was highest in sales ($75,691); Seattle was higher in profit ($6,209); and there was a negative in profit in Philadelphia (-$6,827) and Houston (-$3,405).

Region TotalSales TotalProfit
West 252,613 11,505
East 208,291 3,046
Central 163,797 -2,871
South 117,299 6,771
State TotalSales TotalProfit
California 156,065 9,163
New York 93,373 5,858
Texas 60,593 -10,436
Washington 48,020 7,194
Pennsylvania 39,355 -7,197
City State TotalSales TotalProfit
New York City New York 75,691 5,307
Los Angeles California 54,000 3,072
Seattle Washington 40,996 6,209
Philadelphia Pennsylvania 36,496 -6,827
San Francisco California 36,357 1,491
Houston Texas 23,183 -3,405
  • The store sales trend has increasing trend over the years with the trend starting lowest at the beginning of the year and highest at the end of the year with a couple of drops around August and October month. The overall profit was mostly on the positive side throughout the years; however, the profit trend doesn’t appear to follow the same increasing trend as sales with major drops in profit in 2015 (-45%) and 2017 (-57%). Profit margin decreased to lowest at 1% in 2017.
Year TotalSales TotalProfit TotalDiscount Avg.Sales Avg.Profit pctChangeSales pctChangeProfit ProfMarginPct
2014 157,193 5,458 77 373 13 NA NA 3
2015 170,518 3,015 76 377 7 8 -45 2
2016 198,901 6,960 99 354 12 17 131 3
2017 215,387 3,018 117 314 4 8 -57 1
  • Seth Vernon was the store’s top customer who made the biggest purchase by total sales ($8,332). HON 5400 Series Task Chairs for Big and Tall was the top product that generated the most sales in total of $21,871.

About the data

This dashboard is based on Store Sales Forecasting Data from Kaggle https://www.kaggle.com/datasets/tanayatipre/store-sales-forecasting-dataset/data. The dataset is a collection of a retail furniture store’s historical sales data during its 4-year operating period from 2014-01-06 to 2017-12-30 containing 2,121 observations and 21 variables including the store’s orders, shipping, customers, locations, products, sales, and profit information.

The objective of this dashboard is to gain insights from the store’s historical operations and sales patterns and to report by visualizing the key information that allows the users to track and analyze for making better informed business decisions.

Data Structure
Rows: 2,121
Columns: 21
$ Row.ID        <int> 1, 2, 4, 6, 11, 24, 25, 28, 30, 37, 39, 40, 52, 53, 58, …
$ Order.ID      <chr> "CA-2016-152156", "CA-2016-152156", "US-2015-108966", "C…
$ Order.Date    <chr> "11/8/2016", "11/8/2016", "10/11/2015", "6/9/2014", "6/9…
$ Ship.Date     <chr> "11/11/2016", "11/11/2016", "10/18/2015", "6/14/2014", "…
$ Ship.Mode     <chr> "Second Class", "Second Class", "Standard Class", "Stand…
$ Customer.ID   <chr> "CG-12520", "CG-12520", "SO-20335", "BH-11710", "BH-1171…
$ Customer.Name <chr> "Claire Gute", "Claire Gute", "Sean O'Donnell", "Brosina…
$ Segment       <chr> "Consumer", "Consumer", "Consumer", "Consumer", "Consume…
$ Country       <chr> "United States", "United States", "United States", "Unit…
$ City          <chr> "Henderson", "Henderson", "Fort Lauderdale", "Los Angele…
$ State         <chr> "Kentucky", "Kentucky", "Florida", "California", "Califo…
$ Postal.Code   <int> 42420, 42420, 33311, 90032, 90032, 19140, 84057, 19140, …
$ Region        <chr> "South", "South", "South", "West", "West", "East", "West…
$ Product.ID    <chr> "FUR-BO-10001798", "FUR-CH-10000454", "FUR-TA-10000577",…
$ Category      <chr> "Furniture", "Furniture", "Furniture", "Furniture", "Fur…
$ Sub.Category  <chr> "Bookcases", "Chairs", "Tables", "Furnishings", "Tables"…
$ Product.Name  <chr> "Bush Somerset Collection Bookcase", "Hon Deluxe Fabric …
$ Sales         <dbl> 261.9600, 731.9400, 957.5775, 48.8600, 1706.1840, 71.372…
$ Quantity      <int> 2, 3, 5, 7, 9, 2, 3, 7, 3, 5, 3, 3, 2, 1, 5, 4, 5, 8, 2,…
$ Discount      <dbl> 0.00, 0.00, 0.45, 0.00, 0.20, 0.30, 0.00, 0.50, 0.20, 0.…
$ Profit        <dbl> 41.9136, 219.5820, -383.0310, 14.1694, 85.3092, -1.0196,…