MCCEMCC Exploring the Multidimensional Querying in Data Warehouse Discussion

The purpose of this assignment is to explore multidimensional querying in a data warehouse.

Use the data warehouse that is a part of the “AdventureWorksDW2017” that’s already being added to your SSMS in your LopesCloud.

The finance department wants to be able to project future financing details. The department manager has sent you a request for a rolling 3-month average on past financials.

Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a Microsoft Excel file for a visual check of accuracy.

Create a Microsoft Word document that includes the SQL query code used to explore the database tables and write a query that retrieves finance amounts from “FactFinance” in the “AdventureWorksDW2017” database and returns those amounts, organized by month, and showing a 3-month rolling average.

Compile the Excel data file and Word document containing the SQL query code and answers to the questions into a .zip file and submit to your instructor.

APA style is not required, but solid academic writing is expected.