CSCL 1101 Lecture 5: Season of Migration to the North
Get access
Related Documents
Related Questions
Week One: Hands-on MIS Application Software ExerciseSolution
Store & Region Sales Database
This exercise helps students understand how a raw file of salestransactions can be analyzed to produce valuable information formanagers. Your challenge is to ask the right questionsabout the data and then present your case!
Import the data into Excel or Access (or compatiblespreadsheet/database). Use the data to perform the belowanalyses:
Analyze ALL THREE of the below items:
1.Best Performing Regions by TotalRevenue
2.Best Performing Stores by TotalRevenue
3.Best Selling Products by TotalRevenue
Select ONLY ONE of the below items:
A.Strongest Selling Period for eachProduct by Total Revenue
B.Strongest Selling Period for eachRegion by Total Revenue
C.Strongest Selling Period for eachStore by Total Revenue
Provide a business case â in the form of ONE descriptiveparagraph and ONE data table-- for eachanalysis. Each paragraph must refer to the informationpresented in the table using the labeled Table #. UseAPA format to label your tables.
SUBMITâ your final report with one WORDdocument and one EXCEL/ACCESS file.
Store & Region Sales Database | |||||||
ID | StoreNo | SalesRegion | ItemNo | ItemDescription | UnitPrice | UnitsSold | WeekEnding |
1 | 1 | South | 2005 | 17"Monitor | $229.00 | 28 | 10/27/10 |
2 | 1 | South | 2005 | 17"Monitor | $229.00 | 30 | 11/24/10 |
3 | 1 | South | 2005 | 17"Monitor | $229.00 | 9 | 12/29/10 |
4 | 1 | South | 3006 | 101Keyboard | $19.95 | 30 | 10/27/10 |
5 | 1 | South | 3006 | 101Keyboard | $19.95 | 35 | 11/24/10 |
6 | 1 | South | 3006 | 101Keyboard | $19.95 | 39 | 12/29/10 |
7 | 1 | South | 6050 | PC Mouse | $8.95 | 28 | 10/27/10 |
8 | 1 | South | 6050 | PC Mouse | $8.95 | 3 | 11/24/10 |
9 | 1 | South | 6050 | PC Mouse | $8.95 | 38 | 12/29/10 |
10 | 1 | South | 8500 | DesktopCPU | $849.95 | 25 | 10/27/10 |
11 | 1 | South | 8500 | DesktopCPU | $849.95 | 27 | 11/24/10 |
12 | 1 | South | 8500 | DesktopCPU | $849.95 | 33 | 12/29/10 |
13 | 2 | South | 2005 | 17"Monitor | $229.00 | 8 | 10/27/10 |
14 | 2 | South | 2005 | 17"Monitor | $229.00 | 8 | 11/24/10 |
15 | 2 | South | 2005 | 17"Monitor | $229.00 | 10 | 12/29/10 |
16 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 10/27/10 |
17 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 11/24/10 |
18 | 2 | South | 3006 | 101Keyboard | $19.95 | 8 | 12/29/10 |
19 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 10/27/10 |
20 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 11/24/10 |
21 | 2 | South | 6050 | PC Mouse | $8.95 | 8 | 12/29/10 |
22 | 2 | South | 8500 | DesktopCPU | $849.95 | 18 | 10/27/10 |
23 | 2 | South | 8500 | DesktopCPU | $849.95 | 18 | 11/24/10 |
24 | 2 | South | 8500 | DesktopCPU | $849.95 | 20 | 12/29/10 |
25 | 3 | South | 2005 | 17"Monitor | $229.00 | 38 | 10/27/10 |
26 | 3 | South | 2005 | 17"Monitor | $229.00 | 30 | 11/24/10 |
27 | 3 | South | 2005 | 17"Monitor | $229.00 | 3 | 12/29/10 |
28 | 3 | South | 3006 | 101Keyboard | $19.95 | 30 | 10/27/10 |
29 | 3 | South | 3006 | 101Keyboard | $19.95 | 32 | 11/24/10 |
30 | 3 | South | 3006 | 101Keyboard | $19.95 | 33 | 12/29/10 |
31 | 3 | South | 6050 | PC Mouse | $8.95 | 25 | 10/27/10 |
32 | 3 | South | 6050 | PC Mouse | $8.95 | 5 | 11/24/10 |
33 | 3 | South | 6050 | PC Mouse | $8.95 | 26 | 12/29/10 |
34 | 3 | South | 8500 | DesktopCPU | $849.95 | 28 | 10/27/10 |
35 | 3 | South | 8500 | DesktopCPU | $849.95 | 27 | 11/24/10 |
36 | 3 | South | 8500 | DesktopCPU | $849.95 | 29 | 12/29/10 |
37 | 4 | North | 2005 | 17"Monitor | $229.00 | 18 | 10/27/10 |
38 | 4 | North | 2005 | 17"Monitor | $229.00 | 20 | 11/24/10 |
39 | 4 | North | 2005 | 17"Monitor | $229.00 | 4 | 12/29/10 |
40 | 4 | North | 3006 | 101Keyboard | $19.95 | 12 | 10/27/10 |
41 | 4 | North | 3006 | 101Keyboard | $19.95 | 24 | 11/24/10 |
42 | 4 | North | 3006 | 101Keyboard | $19.95 | 36 | 12/29/10 |
43 | 4 | North | 6050 | PC Mouse | $8.95 | 29 | 10/27/10 |
44 | 4 | North | 6050 | PC Mouse | $8.95 | 11 | 11/24/10 |
45 | 4 | North | 6050 | PC Mouse | $8.95 | 38 | 12/29/10 |
46 | 4 | North | 8500 | DesktopCPU | $849.95 | 21 | 10/27/10 |
47 | 4 | North | 8500 | DesktopCPU | $849.95 | 24 | 11/24/10 |
48 | 4 | North | 8500 | DesktopCPU | $849.95 | 30 | 12/29/10 |
49 | 5 | North | 2005 | 17"Monitor | $229.00 | 27 | 10/27/10 |
50 | 5 | North | 2005 | 17"Monitor | $229.00 | 25 | 11/24/10 |
51 | 5 | North | 2005 | 17"Monitor | $229.00 | 23 | 12/29/10 |
52 | 5 | North | 3006 | 101Keyboard | $19.95 | 80 | 10/27/10 |
53 | 5 | North | 3006 | 101Keyboard | $19.95 | 82 | 11/24/10 |
54 | 5 | North | 3006 | 101Keyboard | $19.95 | 75 | 12/29/10 |
55 | 5 | North | 6050 | PC Mouse | $8.95 | 65 | 10/27/10 |
56 | 5 | North | 6050 | PC Mouse | $8.95 | 24 | 11/24/10 |
57 | 5 | North | 6050 | PC Mouse | $8.95 | 55 | 12/29/10 |
58 | 5 | North | 8500 | DesktopCPU | $849.95 | 55 | 10/27/10 |
59 | 5 | North | 8500 | DesktopCPU | $849.95 | 57 | 11/24/10 |
60 | 5 | North | 8500 | DesktopCPU | $849.95 | 47 | 12/29/10 |
61 | 6 | East | 2005 | 17"Monitor | $229.00 | 24 | 10/27/10 |
62 | 6 | East | 2005 | 17"Monitor | $229.00 | 85 | 11/24/10 |
63 | 6 | East | 2005 | 17"Monitor | $229.00 | 56 | 12/29/10 |
64 | 6 | East | 3006 | 101Keyboard | $19.95 | 52 | 10/27/10 |
65 | 6 | East | 3006 | 101Keyboard | $19.95 | 58 | 11/24/10 |
66 | 6 | East | 3006 | 101Keyboard | $19.95 | 69 | 12/29/10 |
67 | 6 | East | 6050 | PC Mouse | $8.95 | 35 | 10/27/10 |
68 | 6 | East | 6050 | PC Mouse | $8.95 | 39 | 11/24/10 |
69 | 6 | East | 6050 | PC Mouse | $8.95 | 44 | 12/29/10 |
70 | 6 | East | 8500 | DesktopCPU | $849.95 | 78 | 10/27/10 |
71 | 6 | East | 8500 | DesktopCPU | $849.95 | 88 | 11/24/10 |
72 | 6 | East | 8500 | DesktopCPU | $849.95 | 99 | 12/29/10 |
73 | 7 | East | 2005 | 17"Monitor | $229.00 | 34 | 10/27/10 |
74 | 7 | East | 2005 | 17"Monitor | $229.00 | 36 | 11/24/10 |
75 | 7 | East | 2005 | 17"Monitor | $229.00 | 35 | 12/29/10 |
76 | 7 | East | 3006 | 101Keyboard | $19.95 | 49 | 10/27/10 |
77 | 7 | East | 3006 | 101Keyboard | $19.95 | 47 | 11/24/10 |
78 | 7 | East | 3006 | 101Keyboard | $19.95 | 48 | 12/29/10 |
79 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 10/27/10 |
80 | 7 | East | 6050 | PC Mouse | $8.95 | 42 | 11/24/10 |
81 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 12/29/10 |
82 | 7 | East | 8500 | DesktopCPU | $849.95 | 55 | 10/27/10 |
83 | 7 | East | 8500 | DesktopCPU | $849.95 | 57 | 11/24/10 |
84 | 7 | East | 8500 | DesktopCPU | $849.95 | 55 | 12/29/10 |
85 | 8 | East | 2005 | 17"Monitor | $229.00 | 18 | 10/27/10 |
86 | 8 | East | 2005 | 17"Monitor | $229.00 | 17 | 11/24/10 |
87 | 8 | East | 2005 | 17"Monitor | $229.00 | 23 | 12/29/10 |
88 | 8 | East | 3006 | 101Keyboard | $19.95 | 22 | 10/27/10 |
89 | 8 | East | 3006 | 101Keyboard | $19.95 | 18 | 11/24/10 |
90 | 8 | East | 3006 | 101Keyboard | $19.95 | 22 | 12/29/10 |
91 | 8 | East | 6050 | PC Mouse | $8.95 | 14 | 10/27/10 |
92 | 8 | East | 6050 | PC Mouse | $8.95 | 16 | 11/24/10 |
93 | 8 | East | 6050 | PC Mouse | $8.95 | 17 | 12/29/10 |
94 | 8 | East | 8500 | DesktopCPU | $849.95 | 32 | 10/27/10 |
95 | 8 | East | 8500 | DesktopCPU | $849.95 | 28 | 11/24/10 |
96 | 8 | East | 8500 | DesktopCPU | $849.95 | 30 | 12/29/10 |