MIS homework

MIS3003Chapter9HomeworkInstruction.pptx

Home >Information Systems homework help >MIS homework

MIS 3003 Chapter 9

Homework Instructions

Be careful! All instructions here are not for your homework questions, but just some very similar questions!!!

Question

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.

Open the Excel file Ch09Ex01_U7e.xlsx. The spreadsheet has the following column names: VendorName, EmployeeName, Date, Year, and Rating.

Under the INSERT ribbon in Excel, click Pivot Table.

Question

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.

Question

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. (3pts.)

The sum of rating may not make sense, you can change it by click Sum of Ratings under VALUES part, change it to average. Choose Value Field Settings

Question

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:

(1) drop Year just underneath EmployeeName

(2) Then move Year above Employee

(3) Now move Year below Vendor

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. (3pts. Create three pivot tables seperately)

Question

Explain your observations for action (1), (2), and (3) in the question e. (3pts.)

Think about what business question you can answer for these three different pivot tables.

Question

Extra credit: Calculate the average for ratings for each vendors in each years from each employees.

Upload to d2l

I will need you to upload only the excel spreadsheet and your question f answers (either put it in submission or put it in a word document) to dropbox.