Big Data, Data Warehouses, and Business Intelligence Systems - Database Processing: Fundamentals, Design, and Implementation - page 579

h. Write the SQL view equivalent of the SQL query you wrote to answer part G.
I. Create the SQL view you wrote to answer part H in your MI-DW database.
J. Create a Microsoft Excel 2013 workbook named MI-DW-BI-Exercises.xlsx.
K. 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 work-
sheet 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(d).
( Hint: If you need help with the needed Microsoft Excel actions, search in the Microsoft
Excel help system for more information.)