MIS Assignment
OLAP cubes are very similar to Microsoft Excel pivot tables. For this exercise, assume that your organization's purchasing agents rate vendors similar to the situation described in homework 8.
a. Open the Excel file Ch09Ex01_U7e.xlsx. The spreadsheet has the following column names: VendorName, EmployeeName, Date, Year, and Rating.
b. Under the INSERT ribbon in Excel, click Pivot Table.
c. When asked to provide a data range, drag your mouse over the column names and data values so as to select all of the data. Excel will fill in the range values in the open dialog box. Place your pivot table in a new worksheet. Click OK.
d. Excel will create a field list on the right-hand side of your spreadsheet. Underneath it, a grid labeled Drag fields between areas below: should appear. Drag and drop the field named VendorName into the area named ROWS. Observe what happens in the pivot table to the left (in column A). Now drag and drop EmployeeName on to COLUIMNS and Rating on to VALUES. Again observe the effect of these actions in the pivot table to the left. Now you will have a pivot table.
e. To see how the pivot table works, drag and drop more fields onto the grid in the bottom right hand side of your screen. For example, drop Year just underneath EmployeeName(1). Then move Year above Employee (2). Now move Year below Vendor(3). All of this action is just like an OLAP cube, and in fact, OLAP cubes are readily displayed in Excel pivot tables. The major difference is that OLAP cubes are usually based on thousands or more rows of data. (Create three pivot tables seperately)
f. Explain your observations for action (1), (2), and (3) in the question e.
g. Calculate the average for ratings for each vendors in each years from each employees.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.
Attachment:- Instruction.rar