Sales Data for Demo
  • Project Information
    Project Name
    How-to Blogs
    Dataframe Name
    Global_Sales
    Created By
    Kan Nishida
    Created Date
    9/26/2022 8:14:00 PM UTC
    Updated Date
    9/26/2022 8:14:00 PM UTC
    Desktop Version
    6.11.0.1
    Schedule
    Scheduling is not supported because:
    • No Data Source to Refresh
  
  
Order Date
Date
Not NA: 100.00%
NA0 (0.00%)
Min2012-01-01
Max2015-12-31
Median2014-07-08
Average2014-05-11
Ship Mode
Character
Standard Class (30,775)
Standard Class: 30,775 (60.00%)
Second Class (10,309)
Second Class: 10,309 (20.10%)
First Class (7,505)
First Class: 7,505 (14.63%)
Same Day (2,701)
Same Day: 2,701 (5.27%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values4
Min Length8
Max Length14
Customer ID
Character
SV-203651406 (26)
SV-203651406: 26 (0.05%)
WB-218501404 (24)
WB-218501404: 24 (0.05%)
AP-109151404 (23)
AP-109151404: 23 (0.04%)
EM-1396082 (21)
EM-1396082: 21 (0.04%)
CS-121757 (20)
CS-121757: 20 (0.04%)
JK-1609027 (19)
JK-1609027: 19 (0.04%)
(Others) (51,157)
(Others): 51,157 (99.74%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values17,415
Min Length7
Max Length12
Segment
Character
Consumer (26,518)
Consumer: 26,518 (51.70%)
Corporate (15,429)
Corporate: 15,429 (30.08%)
Home Office (9,343)
Home Office: 9,343 (18.22%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values3
Min Length8
Max Length11
City
Character
New York City (915)
New York City: 915 (1.78%)
Los Angeles (747)
Los Angeles: 747 (1.46%)
Philadelphia (537)
Philadelphia: 537 (1.05%)
San Francisco (510)
San Francisco: 510 (0.99%)
Santo Domingo (443)
Santo Domingo: 443 (0.86%)
Manila (432)
Manila: 432 (0.84%)
(Others) (47,706)
(Others): 47,706 (93.01%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values3,650
Min Length2
Max Length35
State
Character
California (2,001)
California: 2,001 (3.90%)
England (1,499)
England: 1,499 (2.92%)
New York (1,128)
New York: 1,128 (2.20%)
Texas (985)
Texas: 985 (1.92%)
Ile-de-France (981)
Ile-de-France: 981 (1.91%)
New South Wales (781)
New South Wales: 781 (1.52%)
(Others) (43,915)
(Others): 43,915 (85.62%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values1,102
Min Length3
Max Length36
Country
Character
United States (9,994)
United States: 9,994 (19.49%)
Australia (2,837)
Australia: 2,837 (5.53%)
France (2,827)
France: 2,827 (5.51%)
Mexico (2,635)
Mexico: 2,635 (5.14%)
Germany (2,063)
Germany: 2,063 (4.02%)
China (1,880)
China: 1,880 (3.67%)
(Others) (29,054)
(Others): 29,054 (56.65%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values165
Min Length4
Max Length32
Region
Character
Western Europe (5,883)
Western Europe: 5,883 (11.47%)
Central America (5,616)
Central America: 5,616 (10.95%)
Oceania (3,487)
Oceania: 3,487 (6.80%)
Western US (3,203)
Western US: 3,203 (6.24%)
Southeastern Asia (3,129)
Southeastern Asia: 3,129 (6.10%)
South America (2,988)
South America: 2,988 (5.83%)
(Others) (26,984)
(Others): 26,984 (52.61%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values23
Min Length6
Max Length17
Market
Character
Asia Pacific (14,302)
Asia Pacific: 14,302 (27.88%)
Europe (11,729)
Europe: 11,729 (22.87%)
USCA (10,378)
USCA: 10,378 (20.23%)
LATAM (10,294)
LATAM: 10,294 (20.07%)
Africa (4,587)
Africa: 4,587 (8.94%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values5
Min Length4
Max Length12
Category
Character
Office Supplies (31,289)
Office Supplies: 31,289 (61.00%)
Technology (10,141)
Technology: 10,141 (19.77%)
Furniture (9,860)
Furniture: 9,860 (19.22%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values3
Min Length9
Max Length15
Sub-Category
Character
Binders (6,146)
Binders: 6,146 (11.98%)
Storage (5,049)
Storage: 5,049 (9.84%)
Art (4,864)
Art: 4,864 (9.48%)
Paper (3,492)
Paper: 3,492 (6.81%)
Chairs (3,434)
Chairs: 3,434 (6.70%)
Phones (3,357)
Phones: 3,357 (6.55%)
(Others) (24,948)
(Others): 24,948 (48.64%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values17
Min Length3
Max Length11
Product Name
Character
Staples (227)
Staples: 227 (0.44%)
Cardinal Index Tab, Clear (92)
Cardinal Index Tab, Clear: 92 (0.18%)
Eldon File Cart, Single Width (90)
Eldon File Cart, Single Width: 90 (0.18%)
Rogers File Cart, Single Width (84)
Rogers File Cart, Single Width: 84 (0.16%)
Ibico Index Tab, Clear (83)
Ibico Index Tab, Clear: 83 (0.16%)
Sanford Pencil Sharpener, Water Color (80)
Sanford Pencil Sharpener, Water Color: 80 (0.16%)
(Others) (50,634)
(Others): 50,634 (98.72%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values3,788
Min Length5
Max Length127
Sales
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min0.444
Max22,638.48
Median85.053
Average246.491
Std Dev487.57
Quantity
Integer
Not NA: 100.00%
NA0 (0.00%)
Min1
Max14
Median3
Average3.477
Std Dev2.28
Discount
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min0
Max0.85
Median0
Average0.1429
Std Dev0.21
Direct Mail
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min0
Max8,399.98
Median9.24
Average46.56
Std Dev138.73
Online Advertisement
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min1.002
Max933.57
Median7.79
Average26.479
Std Dev57.25
Priority
Character
Medium (29,433)
Medium: 29,433 (57.39%)
High (15,501)
High: 15,501 (30.22%)
Critical (3,932)
Critical: 3,932 (7.67%)
Low (2,424)
Low: 2,424 (4.73%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values4
Min Length3
Max Length8
Returned
Logical
TRUE (2,220)
TRUE : 2,220 (4.33%)
FALSE (49,070)
FALSE: 49,070 (95.67%)
Not NA: 100.00%
NA0 (0.00%)
TRUE2,220 (4.33%)
FALSE49,070 (95.67%)
19 Columns   51,290 Rows
19 Columns   51,290 Rows
Description
No description.
Data Dictionary
Column Name
Description
Order Date
Ship Mode
Customer ID
Segment
City
State
Country
Region
Market
Category
Sub-Category
Product Name
Sales
Quantity
Discount
Direct Mail
Online Advertisement
Priority
Returned
Other Information
Size
10M bytes
Type
Excel - Local
Details
Parameter
Value
File
Global_Sales.xlsx
Folder
/Users/kannishida/Dropbox/Documents/Analytics/Tam/Training/Booster_June/Shared/Data
Sheet Name
Sheet1