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 ES-2011-4869686 IN-2011-65159 IN-2011-65159 IN-2011-65159 IR-2011-770 IR-2011-770 IR-2011-770 IZ-2011-4680 IZ-2011-4680 MX-2011-135629 MX-2011-135629 MX-2011-160234 CA-2011-103800 CA-2011-106054 ES-2011-4939443 ES-2011-5433855 ES-2011-5433855 ES-2011-5433855 Order Date Ship Date Ship Mode Customer ID Customer Name 1/3/11 1/3/11 |Same Day KN-16450 Kean Nguyen 1/3/11 1/3/11 Same Day KN-16450 Kean Nguyen 1/1/11 1/5/11 Second Class AT-735 Annie Thurman 1/1/11 1/5/11 Second Class EM-14140 Eugene Moren 1/1/11 1/6/11 Standard Class TB-11280 Toby Braunhardt 1/2/11 1/6/11 Standard Class MM-7260 Magdelene Morse 1/5/11 1/7/11 First Class MG-17890 Michael Granlund 1/5/11 1/7/11 First Class MG-17890 Michael Granlund 1/3/11 1/7/11 Standard Class DD-13570 Dorothy Dickinson 1/3/11 1/7/11 Second Class LB-16735 Larry Blacks 1/3/11 1/7/11 Second Class LB-16735 Larry Blacks 1/3/11 1/7/11 Second Class LB-16735 Larry Blacks 1/3/11 1/7/11 Standard Class JO-5280 Jas O'Carroll 1/3/11 1/7/11 Standard Class JO-5280 Jas O'Carroll 1/3/11 1/7/11 Standard Class JO-5280 Jas O'Carroll 1/3/11 1/7/11 Standard Class LW-6990 Lindsay Williams 1/3/11 1/7/11 Standard Class LW-6990 Lindsay Williams 1/7/11 1/7/11 Same Day DD-13570 Dorothy Dickinson 1/7/11 1/7/11 Same Day DD-13570 Dorothy Dickinson 1/3/11 1/7/11 Standard Class SV-20785 Stewart Visinsky 1/4/11 1/8/11 Standard Class DP-13000 Darren Powers 1/7/11 1/8/11 First Class JO-15145 Jack O'Briant 1/4/11 1/8/11 Standard Class AP-10915 Arthur Prichep 1/7/11 1/8/11 First Class DP-13105 Dave Poirier 1/7/11 1/8/11 First Class DP-13105 Dave Poirier 1/7/11 1/8/11 First Class DP-13105 Dave Poirier Segment State Country Corporate Sydney New South Wales Australia Corporate Sydney New South Wales Australia Consumer Budapest Budapest Hungary Home Office Stockholm Stockholm Sweden Consumer Constantine Constantine Algeria Consumer St. Catharines Ontario Canada Home Office Echirolles Rhne-Alpes France Home Office Echirolles Rhne-Alpes France Consumer Southport England United Kingdom Consumer Manila National Capital Philippines Consumer Manila National Capital Philippines Consumer Manila National Capital Philippines Consumer Yazd Yazd Iran Consumer Yazd Yazd Iran Consumer Yazd Yazd Iran Corporate Mosul Ninawa Iraq Corporate Mosul Ninawa Iraq Consumer Barretos So Paulo Brazil Consumer Barretos So Paulo Brazil Consumer Mixco Guatemala Guatemala Consumer Houston Texas United States Corporate Athens Georgia United States Consumer Valence Rhne-Alpes France Corporate La Seyne-sur-Mer Provence-Alpes-Cte d France Corporate La Seyne-sur-Mer Provence-Alpes-Cte d France Corporate La Seyne-sur-Mer Provence-Alpes-Cte d France Product ID Category Sub-Category Product Name OFF-AP-10000304 Office Supplies Appliances Hoover Microwave, White OFF-LA-10003396 Office Supplies Labels Avery Color Coded Labels, Laser Printer Compatible OFF-TEN-10001585 Office Supplies Storage Tenex Box, Single Width OFF-PA-10001492 Office Supplies Paper Enermax Note Cards, Premium OFF-TEN-10000025 Office Supplies Storage Tenex Lockers, Blue TEC-OKI-10002750 Technology Machines Okidata Inkjet, Wireless OFF-AR-10001291 Office Supplies Art Sanford Canvas, Fluorescent OFF-AR-10000833 Office Supplies Art Binney & Smith Pencil Sharpener, Water Color FUR-BO-10000728 Furniture Bookcases Dania Corner Shelving, Traditional OFF-ST-10003020 Office Supplies Storage Tenex Lockers, Industrial FUR-TA-10002797 Furniture Tables Chromcraft Round Table, Adjustable Height OFF-FA-10002569 Office Supplies Fasteners Stockwell Staples, Metal OFF-BRE-10003081 Office Supplies Appliances Breville Coffee Grinder, Black OFF-ROG-10004393 Office Supplies Storage Rogers Folders, Industrial OFF-ADV-10000213 Office Supplies Fasteners Advantus Rubber Bands, Metal FUR-NOV-10002791 Furniture Chairs Novimex Swivel Stool, Set of Two OFF-CAM-10004338 Office Supplies Envelopes Cameo Interoffice Envelope, Set of 50 OFF-FA-10001871 Office Supplies Fasteners Stockwell Rubber Bands, Bulk Pack OFF-BI-10000136 Office Supplies Binders Ibico Index Tab, Durable TEC-PH-10002647 Technology Phones Nokia Headset, VolP OFF-PA-10000174 Office Supplies Paper Message Book, Wirebound, Four 5 1/2" X 4" Forms/Pg., 200 Dupl. Sets/Book OFF-AR-10002399 Office Supplies Art Dixon Prang Watercolor Pencils, 10-Color Set with Brush OFF-AR-10001546 Office Supplies Art Binney & Smith Sketch Pad, Easy-Erase OFF-ST-10004855 Office Supplies Storage Smead Lockers, Industrial OFF-FA-10002071 Office Supplies Fasteners Accos Thumb Tacks, Assorted Sizes FUR-BO-10000265 Furniture Bookcases Bush Floating Shelf Set, Pine Sales Quantity Discount Profit Shipping Cost Order Priority 276.102 0.1 110.412 125.32 Critical 35.883 3 0.1 4.743 7.46 Critical 66.12 4 0 29.64 8.17 High 44.865 3 0.5 -26.055 4.82 High 408.3 2 0 106.14 35.46 Medium 314.22 1 0 3.12 24.10 Medium 207.12 4 0 76.56 20.64 Medium 89.55 3 0 20.52 15.27 Medium 854.49 7 0 290.43 12.56 Medium 337.6395 3 0.45 -122.8005 33.75 High 211.1805 1 0.55 -70.3995 21.32 High 6.006 1 0.45 0.546 0.80 High 122.58 2 0 42.9 8.41 Medium 62.34 2 0 8.7 5.16 Medium 16.71 1 4.17 0.54 Medium 666.84 253.32 81.26 High 47.43 17.07 3.57 High 43.04 4 6 3.94 High 18.54 3 2.4 3.69 High 195.2 4 44.88 8.43 Medium 16.448 2 0.2 5.5512 1.82 High 12.78 5.2398 3.51 Critical 139.77 3 20.88 10.78 Medium 716.04 4 0.1 143.16 32.46 Medium 33.39 3 2.25 9.73 Medium 155.358 1 36.228 5.72 Medium mm tmnmn + + m nm mm 0.1
