Spreadsheet: 145233d1331398447-northwind-the-spreadsheet-northwind-the-ss
Sheet: SalesAnalysis

Order ID | Order Date | Employee | Customer Name | Product Name | Sales | Employee ID | Product ID | Customer ID | Year | Month | Quarter | QtrMonth | Month Name | Category | Product | Customer | State/Province | Country/Region
30 | 2011-01-15 00:00:00 | [NAME] | Company AA | Beer | 1400 | 9 | 34 | 27 | 2011 | 1 | 1 | 1 | January | Beverages | Beer | Company AA | NV | USA
30 | 2011-01-15 00:00:00 | [NAME] | Company AA | Dried Plums | 105 | 9 | 80 | 27 | 2011 | 1 | 1 | 1 | January | Dried Fruit & Nuts | Dried Plums | Company AA | NV | USA
31 | 2011-01-20 00:00:00 | Jan Kotas | Company D | Dried Pears | 300 | 3 | 7 | 4 | 2011 | 1 | 1 | 1 | January | Dried Fruit & Nuts | Dried Pears | Company D | NY | USA
31 | 2011-01-20 00:00:00 | Jan Kotas | Company D | Dried Apples | 530 | 3 | 51 | 4 | 2011 | 1 | 1 | 1 | January | Dried Fruit & Nuts | Dried Apples | Company D | NY | USA
31 | 2011-01-20 00:00:00 | Jan Kotas | Company D | Dried Plums | 35 | 3 | 80 | 4 | 2011 | 1 | 1 | 1 | January | Dried Fruit & Nuts | Dried Plums | Company D | NY | USA
32 | 2011-01-22 00:00:00 | [NAME] | Company L | Chai | 270 | 4 | 1 | 12 | 2011 | 1 | 1 | 1 | January | Beverages | Chai | Company L | NV | USA
32 | 2011-01-22 00:00:00 | [NAME] | Company L | Coffee | 920 | 4 | 43 | 12 | 2011 | 1 | 1 | 1 | January | Beverages | Coffee | Company L | NV | USA
33 | 2011-01-30 00:00:00 | [NAME] | Company H | Biscuits Mix | 276 | 6 | 19 | 8 | 2011 | 1 | 1 | 1 | January | Baked Goods & Mixes | Biscuits Mix | Company H | OR | USA
34 | 2011-02-06 00:00:00 | [NAME] | Company D | Biscuits Mix | 184 | 9 | 19 | 4 | 2011 | 2 | 1 | 2 | February | Baked Goods & Mixes | Biscuits Mix | Company D | NY | USA
35 | 2011-02-10 00:00:00 | Jan Kotas | Company CC | Chocolate | 127.5 | 3 | 48 | 29 | 2011 | 2 | 1 | 2 | February | Candy | Chocolate | Company CC | CO | USA
36 | 2011-02-23 00:00:00 | [NAME] | Company C | Clam Chowder | 1930 | 4 | 41 | 3 | 2011 | 2 | 1 | 2 | February | Soups | Clam Chowder | Company C | CA | USA
37 | 2011-03-06 00:00:00 | [NAME] | Company F | [NAME] | 680 | 8 | 8 | 6 | 2011 | 3 | 1 | 0 | March | Sauces | [NAME] | Company F | WI | USA
38 | 2011-03-10 00:00:00 | [NAME] | Company BB | Coffee | 13800 | 9 | 43 | 28 | 2011 | 3 | 1 | 0 | March | Beverages | Coffee | Company BB | TN | USA
39 | 2011-03-22 00:00:00 | Jan Kotas | Company H | Chocolate | 1275 | 3 | 48 | 8 | 2011 | 3 | 1 | 0 | March | Candy | Chocolate | Company H | OR | USA
40 | 2011-03-24 00:00:00 | [NAME] | Company J | Green Tea | 598 | 4 | 81 | 10 | 2011 | 3 | 1 | 0 | March | Beverages | Green Tea | Company J | IL | USA
42 | 2011-03-24 00:00:00 | [NAME] | Company J | [NAME] | 250 | 1 | 6 | 10 | 2011 | 3 | 1 | 0 | March | Jams, Preserves | [NAME] | Company J | IL | USA
42 | 2011-03-24 00:00:00 | [NAME] | Company J | [NAME] | 220 | 1 | 4 | 10 | 2011 | 3 | 1 | 0 | March | Condiments | [NAME] | Company J | IL | USA
42 | 2011-03-24 00:00:00 | [NAME] | Company J | Biscuits Mix | 92 | 1 | 19 | 10 | 2011 | 3 | 1 | 0 | March | Baked Goods & Mixes | Biscuits Mix | Company J | IL | USA
45 | 2011-04-07 00:00:00 | [NAME] | Company BB | Clam Chowder | 482.5 | 1 | 41 | 28 | 2011 | 4 | 2 | 1 | April | Soups | Clam Chowder | Company BB | TN | USA
45 | 2011-04-07 00:00:00 | [NAME] | Company BB | Crab Meat | 920 | 1 | 40 | 28 | 2011 | 4 | 2 | 1 | April | Canned Meat | Crab Meat | Company BB | TN | USA
46 | 2011-04-05 00:00:00 | [NAME] | Company I | Ravioli | 1950 | 7 | 57 | 9 | 2011 | 4 | 2 | 1 | April | Pasta | Ravioli | Company I | UT | USA
46 | 2011-04-05 00:00:00 | [NAME] | Company I | Mozzarella | 1740 | 7 | 72 | 9 | 2011 | 4 | 2 | 1 | April | Dairy Products | Mozzarella | Company I | UT | USA
47 | 2011-04-08 00:00:00 | [NAME] | Company F | Beer | 4200 | 6 | 34 | 6 | 2011 | 4 | 2 | 1 | April | Beverages | Beer | Company F | WI | USA
48 | 2011-04-05 00:00:00 | [NAME] | Company H | [NAME] | 1000 | 4 | 8 | 8 | 2011 | 4 | 2 | 1 | April | Sauces | [NAME] | Company H | OR | USA
48 | 2011-04-05 00:00:00 | [NAME] | Company H | Biscuits Mix | 230 | 4 | 19 | 8 | 2011 | 4 | 2 | 1 | April | Baked Goods & Mixes | Biscuits Mix | Company H | OR | USA
50 | 2011-04-05 00:00:00 | [NAME] | Company Y | Scones | 200 | 9 | 21 | 25 | 2011 | 4 | 2 | 1 | April | Baked Goods & Mixes | Scones | Company Y | IL | USA
51 | 2011-04-05 00:00:00 | [NAME] | Company Z | Olive Oil | 533.75 | 9 | 5 | 26 | 2011 | 4 | 2 | 1 | April | Oil | Olive Oil | Company Z | FL | USA
51 | 2011-04-05 00:00:00 | [NAME] | Company Z | Clam Chowder | 289.5 | 9 | 41 | 26 | 2011 | 4 | 2 | 1 | April | Soups | Clam Chowder | Company Z | FL | USA
51 | 2011-04-05 00:00:00 | [NAME] | Company Z | Crab Meat | 552 | 9 | 40 | 26 | 2011 | 4 | 2 | 1 | April | Canned Meat | Crab Meat | Company Z | FL | USA
56 | 2011-04-03 00:00:00 | [NAME] | Company F | Chocolate | 127.5 | 2 | 48 | 6 | 2011 | 4 | 2 | 1 | April | Candy | Chocolate | Company F | WI | USA
55 | 2011-04-05 00:00:00 | [NAME] | Company CC | Beer | 1218 | 1 | 34 | 29 | 2011 | 4 | 2 | 1 | April | Beverages | Beer | Company CC | CO | USA
79 | 2011-06-23 00:00:00 | [NAME] | Company F | Dried Pears | 900 | 2 | 7 | 6 | 2011 | 6 | 2 | 0 | June | Dried Fruit & Nuts | Dried Pears | Company F | WI | USA
79 | 2011-06-23 00:00:00 | [NAME] | Company F | Dried Apples | 1590 | 2 | 51 | 6 | 2011 | 6 | 2 | 0 | June | Dried Fruit & Nuts | Dried Apples | Company F | WI | USA
78 | 2011-06-05 00:00:00 | [NAME] | Company CC | Fruit Cocktail | 1560 | 1 | 17 | 29 | 2011 | 6 | 2 | 0 | June | Canned Fruit & Vegetables | Fruit Cocktail | Company CC | CO | USA
77 | 2011-06-05 00:00:00 | [NAME] | Company Z | [NAME] | 2250 | 9 | 6 | 26 | 2011 | 6 | 2 | 0 | June | Jams, Preserves | [NAME] | Company Z | FL | USA
76 | 2011-06-05 00:00:00 | [NAME] | Company Y | [NAME] | 660 | 9 | 4 | 25 | 2011 | 6 | 2 | 0 | June | Condiments | [NAME] | Company Y | IL | USA
75 | 2011-06-05 00:00:00 | [NAME] | Company H | Chocolate | 510 | 4 | 48 | 8 | 2011 | 6 | 2 | 0 | June | Candy | Chocolate | Company H | OR | USA
74 | 2011-06-08 00:00:00 | [NAME] | Company F | Chocolate | 510 | 6 | 48 | 6 | 2011 | 6 | 2 | 0 | June | Candy | Chocolate | Company F | WI | USA
73 | 2011-06-05 00:00:00 | [NAME] | Company I | Clam Chowder | 96.5 | 7 | 41 | 9 | 2011 | 6 | 2 | 0 | June | Soups | Clam Chowder | Company I | UT | USA
72 | 2011-06-07 00:00:00 | [NAME] | Company BB | Coffee | 230 | 1 | 43 | 28 | 2011 | 6 | 2 | 0 | June | Beverages | Coffee | Company BB | TN | USA
71 | 2011-05-24 00:00:00 | [NAME] | Company A | Crab Meat | 736 | 1 | 40 | 1 | 2011 | 5 | 2 | 2 | May | Canned Meat | Crab Meat | Company A | WA | USA
70 | 2011-05-24 00:00:00 | [NAME] | Company K | [NAME] | 800 | 1 | 8 | 11 | 2011 | 5 | 2 | 2 | May | Sauces | [NAME] | Company K | FL | USA
69 | 2011-05-24 00:00:00 | [NAME] | Company J | Dried Plums | 52.5 | 1 | 80 | 10 | 2011 | 5 | 2 | 2 | May | Dried Fruit & Nuts | Dried Plums | Company J | IL | USA
67 | 2011-05-24 00:00:00 | [NAME] | Company J | Almonds | 200 | 4 | 74 | 10 | 2011 | 5 | 2 | 2 | May | Dried Fruit & Nuts | Almonds | Company J | IL | USA
60 | 2011-04-30 00:00:00 | [NAME] | Company H | Mozzarella | 1392 | 6 | 72 | 8 | 2011 | 4 | 2 | 1 | April | Dairy Products | Mozzarella | Company H | OR | USA
63 | 2011-04-25 00:00:00 | [NAME] | Company C | Syrup | 500 | 4 | 3 | 3 | 2011 | 4 | 2 | 1 | April | Condiments | Syrup | Company C | CA | USA
63 | 2011-04-25 00:00:00 | [NAME] | Company C | [NAME] | 120 | 4 | 8 | 3 | 2011 | 4 | 2 | 1 | April | Sauces | [NAME] | Company C | CA | USA
58 | 2011-04-22 00:00:00 | Jan Kotas | Company D | Marmalade | 3240 | 3 | 20 | 4 | 2011 | 4 | 2 | 1 | April | Jams, Preserves | Marmalade | Company D | NY | USA
58 | 2011-04-22 00:00:00 | Jan Kotas | Company D | Long Grain Rice | 280 | 3 | 52 | 4 | 2011 | 4 | 2 | 1 | April | Grains | Long Grain Rice | Company D | NY | USA