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
Total Customers
707
Locations: City
371
Locations: State
48
Avg. Orders per Customer
2
Avg. Product Qty /Customer
11
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
| 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 |
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 |
| Sub.Category | Quantity | Percent |
|---|---|---|
| Furnishings | 3,563 | 44 |
| Chairs | 2,356 | 29 |
| Tables | 1,241 | 16 |
| Bookcases | 868 | 11 |
| Total | 8,028 | 100 |
| 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 |
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 |
| 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 |
| year | NumOrders | pct_change |
|---|---|---|
| 2014 | 353 | NA |
| 2015 | 371 | 5 |
| 2016 | 476 | 28 |
| 2017 | 564 | 18 |
Customer & Locations:
| Segment | n | percent |
|---|---|---|
| Consumer | 368 | 52 |
| Home Office | 128 | 18 |
| Corporate | 211 | 30 |
| Total | 707 | 100 |
| 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 |
| 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 |
| 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 |
| 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 |
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.
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,…