A. Create the SQL view you wrote to answer part H in your MI_DW database. B. Create a Microsoft Excel 2013 workbook named MI-DW-BI-Exercises.xlsx. C. Using either the results of your SQL query from...

A. Create the SQL view you wrote to answer part H in your MI_DW database.

B. Create a Microsoft Excel 2013 workbook named MI-DW-BI-Exercises.xlsx.

C. Using either the results of your SQL query from part G (copy the results of the query into a worksheet in the MI-DW-BI.xlsx workbook and then format this range as a worksheet table) or your SQL view from part I (create a Microsoft Excel data connection to the view), create an OLAP report similar to the OLAP report shown in Figure 12-21(j). (Hint: If you need help with the needed Microsoft Excel actions, search in the Microsoft Excel help system for more information.)