Row ID Order ID Order Date Ship Date Ship Mode Customer ID Customer Name Segment Country City State Postal Code Region Product ID Category Sub$-$Category Product Name Sales Quantity Discount Profit

$1$ CA$-2016-1521562016-11-082016-11-11$ Second Class CG$-12520$ Claire Gute Consumer United States Henderson Kentucky $42420$ South FUR$-$BO$-10001798$ Furniture Bookcases Bush Somerset Collection Bookcase $261\mathrm{.}962041\mathrm{.}9136$

$2$ CA$-2016-1521562016-11-082016-11-11$ Second Class CG$-12520$ Claire Gute Consumer United States Henderson Kentucky $42420$ South FUR$-$CH$-10000454$ Furniture Chairs Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back $731\mathrm{.}9430219\mathrm{.}582$

$3$ CA$-2016-1386882016-06-122016-06-16$ Second Class DV$-13045$ Darrin Van Huff Corporate United States Los Angeles California $90036$ West OFF$-$LA$-10000240$ Office Supplies Labels Self$-$Adhesive Address Labels for Typewriters by Universal $14\mathrm{.}62206\mathrm{.}8714$

$4$ US$-2015-1089662015-10-112015-10-18$ Standard Class SO$-20335$ Sean O'Donnell Consumer United States Fort Lauderdale Florida $33311$ South FUR$-$TA$-10000577$ Furniture Tables Bretford CR$4500$ Series Slim Rectangular Table $957\mathrm{.}577550\mathrm{.}45-383\mathrm{.}031$

$5$ US$-2015-1089662015-10-112015-10-18$ Standard Class SO$-20335$ Sean O'Donnell Consumer United States Fort Lauderdale Florida $33311$ South OFF$-$ST$-10000760$ Office Supplies Storage Eldon Fold $\text{'}$N Roll Cart System $22\mathrm{.}36820\mathrm{.}22\mathrm{.}5164$

$6$ CA$-2014-1158122014-06-092014-06-14$ Standard Class BH$-11710$ Brosina Hoffman Consumer United States Los Angeles California $90032$ West FUR$-$FU$-10001487$ Furniture Furnishings Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood $48\mathrm{.}867014\mathrm{.}1694$

$7$ CA$-2014-1158122014-06-092014-06-14$ Standard Class BH$-11710$ Brosina Hoffman Consumer United States Los Angeles California $90032$ West OFF$-$AR$-10002833$ Office Supplies Art Newell $3227\mathrm{.}28401\mathrm{.}9656$

$8$ CA$-2014-1158122014-06-092014-06-14$ Standard Class BH$-11710$ Brosina Hoffman Consumer United States Los Angeles California $90032$ West TEC$-$PH$-10002275$ Technology Phones Mitel $5320$ IP Phone VoIP phone $907\mathrm{.}15260\mathrm{.}290\mathrm{.}7152$

$9$ CA$-2014-1158122014-06-092014-06-14$ Standard Class BH$-11710$ Brosina Hoffman Consumer United States Los Angeles California $90032$ West OFF$-$BI$-10003910$ Office Supplies Binders DXL Angle$-$View Binders with Locking Rings by Samsill $18\mathrm{.}50430\mathrm{.}25\mathrm{.}7825$

$10$ CA$-2014-1158122014-06-092014-06-14$ Standard Class BH$-11710$ Brosina Hoffman Consumer United States Los Angeles California $90032$ West OFF$-$AP$-10002892$ Office Supplies Appliances Belkin F$5$C$206$VTEL $6$ Outlet Surge $114\mathrm{.}95034\mathrm{.}47$

$11$ CA$-2014-1158122014-06-092014-06-14$ Standard Class BH$-11710$ Brosina Hoffman Consumer United States Los Angeles California $90032$ West FUR$-$TA$-10001539$ Furniture Tables Chromcraft Rectangular Conference Tables $1706\mathrm{.}18490\mathrm{.}285\mathrm{.}3092$

$12$ CA$-2014-1158122014-06-092014-06-14$ Standard Class BH$-11710$ Brosina Hoffman Consumer United States Los Angeles California $90032$ West TEC$-$PH$-10002033$ Technology Phones Konftel $250$ Conference$$phone$-$ Charcoal black $911\mathrm{.}42440\mathrm{.}268\mathrm{.}3568$

$13$ CA$-2017-1144122017-04-152017-04-20$ Standard Class AA$-10480$ Andrew Allen Consumer United States Concord North Carolina $28027$ South OFF$-$PA$-10002365$ Office Supplies Paper Xerox $196715\mathrm{.}55230\mathrm{.}25\mathrm{.}4432$

$14$ CA$-2016-1613892016-12-052016-12-10$ Standard Class IM$-15070$ Irene Maddox Consumer United States Seattle Washington $98103$ West OFF$-$BI$-10003656$ Office Supplies Binders Fellowes PB$200$ Plastic Comb Binding Machine $407\mathrm{.}97630\mathrm{.}2132\mathrm{.}5922$

$15$ US$-2015-1189832015-11-222015-11-26$ Standard Class HP$-14815$ Harold Pawlan Home Office United States Fort Worth Texas $76106$ Central OFF$-$AP$-10002311$ Office Supplies Appliances Holmes Replacement Filter for HEPA Air Cleaner, Very Large Room, HEPA Filter $68\mathrm{.}8150\mathrm{.}8-123\mathrm{.}858$

$16$ US$-2015-1189832015-11-222015-11-26$ Standard Class HP$-14815$ Harold Pawlan Home Office United States Fort Worth Texas $76106$ Central OFF$-$BI$-10000756$ Office Supplies Binders Storex DuraTech Recycled Plastic Frosted Binders $2\mathrm{.}54430\mathrm{.}8-3\mathrm{.}816$

$17$ CA$-2014-1058932014-11-112014-11-18$ Standard Class PK$-19075$ Pete Kriz Consumer United States Madison Wisconsin $53711$ Central OFF$-$ST$-10004186$ Office Supplies Storage Stur$-$D$-$Stor Shelving, Vertical $5-$Shelf: $72"$H x $36"$W x $181/2"$D $665\mathrm{.}886013\mathrm{.}3176$

$18$ CA$-2014-1671642014-05-132014-05-15$ Second Class AG$-10270$ Alejandro Grove Consumer United States West Jordan Utah $84084$ West OFF$-$ST$-10000107$ Office Supplies Storage Fellowes Super Stor$/$Drawer $55\mathrm{.}5209\mathrm{.}99$

$19$ CA$-2014-1433362014-08-272014-09-01$ Second Class ZD$-21925$ Zuschuss Donatelli Consumer United States San Francisco California $94109$ West OFF$-$AR$-10003056$ Office Supplies Art Newell $3418\mathrm{.}56202\mathrm{.}4824$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

The following data are available: Returns Order ID People Person Region Orders Row ID Order ID Order Date Ship Date Ship Mode Customer ID Customer Name Segment Country City State Postal Code Region...

Q:

1 0 . For all parts of question 1 0 ( i . e . , 1 0 a - 1 0 d ) , you can choose any graph you like. However, remember that each part must be answered with one graph. Answer Questions 1 0 a - 1 0 d...

Q:

Logical Fact Diagram Forever Collectibles" Salesperson Time Product Customer Sales Summary Sales Detailed Shipping Fact Relationship Fact Sale Type Warehouse Trans Type TerritoryCreate a Logical fact...

Q:

Create a Logical fact table for the IKEA Super Store. The data of this store contains this information. Row ID, Order ID, Order Date, Ship Date, Ship Mode, Customer ID, Customer Name, Segment,...

Q:

Reference: Create a Logical fact table for the IKEA Super Store. The data of this store contains this information. Row ID, Order ID, Order Date, Ship Date, Ship Mode, Customer ID, Customer Name,...

Q:

You have been assigned as a business analyst for a leading online retail company specializing in furniture and office supplies. A dataset of 51290 transactions between 2013 to 2016 has been given to...

Q:

using Tableu, from the sample dataset, what do you think should be a brief summary of what you learned from the final results. Row ID Order ID Order Date Ship Date Ship Mode Customer ID Customer Name...

Q:

A dataset containing column Order ID, Oder Date, Ship Date, Ship Mode, Customer ID, Customer Name, Segment, Country, City, State, Postal Code, Region, Product ID, Category, Sub-Category, Product...

Q:

Put the data into 3NF (Third Normal Form) 1 B D E F G 1 Row ID Order ID Order Date Ship Date Ship Mode Customer ID Customer Name 2 32298 CA-2012-124891 31-07-2012 31-07-2012 Same Day RH-19495 Rick...

Q:

Please suggest a way to build a data warehouse out of this City Order ID IN-2011-79397 IN-2011-79397 HU-2011-1220 IT-2011-3647632 AG-2011-2040 CA-2011-1510 ES-2011-3848439 ES-2011-3848439...

Q:

Let X and Y equal the respective numbers of hours a randomly selected child watches movies or cartoons on TV during a certain month. From experience, it is known that E(X) = 30, E(Y) = 50, Var(X) =...

Q:

Three sisters, X, Y and Z, jointly inherit a small apartment building valued at $2.1 million. The building produces only a modest rental income. X and Y believe the apartment building could be more...

Q:

A True B False Dynamic processes are adaptive processes that change structure rapidly and readily. A True B False

Q:

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

Q:

What is the history of the group with whom you are working?

Q:

What is the climate within the group now and what does it need to be in order to be fully effective?

Q:

Have the group had any input to their goal?

Previous Question Next Question