Question
The purpose of this assignment is to explore multidimensional querying in a data warehouse. Use the data warehouse that is part of the AdventureWorks 2016
The purpose of this assignment is to explore multidimensional querying in a data warehouse. Use the data warehouse that is part of the "AdventureWorks 2016 and Scripts for SQL Server 2016 CTP3" you previously installed from the Course and Topic Materials to complete the assignment. 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 an Excel file for a visual check of accuracy. Create a 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 "AdventureWorksDW2016CTP3" database and returns those amounts, organized by month, and showing a 3-month rolling average.
I need step by step directions on this, please.
SCHEMA IS AS FOLLOWS:
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
AdventureWorks2016CTP3 Sales SalesTaxRate BASE TABLE
AdventureWorks2016CTP3 Sales PersonCreditCard BASE TABLE
AdventureWorks2016CTP3 Person PersonPhone BASE TABLE
AdventureWorks2016CTP3 Sales SalesTerritory BASE TABLE
AdventureWorks2016CTP3 Sales SpecialOfferProduct_inmem BASE TABLE
AdventureWorks2016CTP3 Production Product BASE TABLE
AdventureWorks2016CTP3 Sales SalesOrderHeader_inmem BASE TABLE
AdventureWorks2016CTP3 Sales SalesTerritoryHistory BASE TABLE
AdventureWorks2016CTP3 Production ScrapReason BASE TABLE
AdventureWorks2016CTP3 HumanResources Shift BASE TABLE
AdventureWorks2016CTP3 Production ProductCategory BASE TABLE
AdventureWorks2016CTP3 Purchasing ShipMethod BASE TABLE
AdventureWorks2016CTP3 Production ProductCostHistory BASE TABLE
AdventureWorks2016CTP3 Sales SalesOrderDetail_inmem BASE TABLE
AdventureWorks2016CTP3 Production ProductDescription BASE TABLE
AdventureWorks2016CTP3 Sales ShoppingCartItem BASE TABLE
AdventureWorks2016CTP3 Production ProductDocument BASE TABLE
AdventureWorks2016CTP3 dbo DatabaseLog BASE TABLE
AdventureWorks2016CTP3 Production ProductInventory BASE TABLE
AdventureWorks2016CTP3 Sales SpecialOffer BASE TABLE
AdventureWorks2016CTP3 dbo ErrorLog BASE TABLE
AdventureWorks2016CTP3 Sales SpecialOffer_ondisk BASE TABLE
AdventureWorks2016CTP3 Production ProductListPriceHistory BASE TABLE
AdventureWorks2016CTP3 Person Address BASE TABLE
AdventureWorks2016CTP3 Sales SpecialOfferProduct BASE TABLE
AdventureWorks2016CTP3 Production ProductModel BASE TABLE
AdventureWorks2016CTP3 Person AddressType BASE TABLE
AdventureWorks2016CTP3 Production Product_ondisk BASE TABLE
AdventureWorks2016CTP3 Person StateProvince BASE TABLE
AdventureWorks2016CTP3 Production ProductModelIllustration BASE TABLE
AdventureWorks2016CTP3 dbo AWBuildVersion BASE TABLE
AdventureWorks2016CTP3 Production ProductModelProductDescriptionCulture BASE TABLE
AdventureWorks2016CTP3 Production BillOfMaterials BASE TABLE
AdventureWorks2016CTP3 Sales Store BASE TABLE
AdventureWorks2016CTP3 Production ProductPhoto BASE TABLE
AdventureWorks2016CTP3 Production ProductProductPhoto BASE TABLE
AdventureWorks2016CTP3 Production TransactionHistory BASE TABLE
AdventureWorks2016CTP3 Production ProductReview BASE TABLE
AdventureWorks2016CTP3 Person BusinessEntity BASE TABLE
AdventureWorks2016CTP3 Production TransactionHistoryArchive BASE TABLE
AdventureWorks2016CTP3 Production ProductSubcategory BASE TABLE
AdventureWorks2016CTP3 Person BusinessEntityAddress BASE TABLE
AdventureWorks2016CTP3 Sales SpecialOfferProduct_ondisk BASE TABLE
AdventureWorks2016CTP3 Person vAdditionalContactInfo VIEW
AdventureWorks2016CTP3 HumanResources vEmployee VIEW
AdventureWorks2016CTP3 Purchasing ProductVendor BASE TABLE
AdventureWorks2016CTP3 Person BusinessEntityContact BASE TABLE
AdventureWorks2016CTP3 HumanResources vEmployeeDepartment VIEW
AdventureWorks2016CTP3 Production UnitMeasure BASE TABLE
AdventureWorks2016CTP3 HumanResources vEmployeeDepartmentHistory VIEW
AdventureWorks2016CTP3 Sales vIndividualCustomer VIEW
AdventureWorks2016CTP3 Purchasing Vendor BASE TABLE
AdventureWorks2016CTP3 Sales SalesOrderHeader_ondisk BASE TABLE
AdventureWorks2016CTP3 Person ContactType BASE TABLE
AdventureWorks2016CTP3 Sales vPersonDemographics VIEW
AdventureWorks2016CTP3 HumanResources vJobCandidate VIEW
AdventureWorks2016CTP3 Sales CountryRegionCurrency BASE TABLE
AdventureWorks2016CTP3 HumanResources vJobCandidateEmployment VIEW
AdventureWorks2016CTP3 HumanResources vJobCandidateEducation VIEW
AdventureWorks2016CTP3 Person CountryRegion BASE TABLE
AdventureWorks2016CTP3 Production vProductAndDescription VIEW
AdventureWorks2016CTP3 Production WorkOrder BASE TABLE
AdventureWorks2016CTP3 Purchasing PurchaseOrderDetail BASE TABLE
AdventureWorks2016CTP3 Production vProductModelCatalogDescription VIEW
AdventureWorks2016CTP3 Sales CreditCard BASE TABLE
AdventureWorks2016CTP3 Production vProductModelInstructions VIEW
AdventureWorks2016CTP3 Sales vSalesPerson VIEW
AdventureWorks2016CTP3 Production Culture BASE TABLE
AdventureWorks2016CTP3 Sales vSalesPersonSalesByFiscalYears VIEW
AdventureWorks2016CTP3 Person vStateProvinceCountryRegion VIEW
AdventureWorks2016CTP3 Production WorkOrderRouting BASE TABLE
AdventureWorks2016CTP3 Sales Currency BASE TABLE
AdventureWorks2016CTP3 Sales vStoreWithDemographics VIEW
AdventureWorks2016CTP3 Purchasing PurchaseOrderHeader BASE TABLE
AdventureWorks2016CTP3 Sales vStoreWithContacts VIEW
AdventureWorks2016CTP3 Sales CurrencyRate BASE TABLE
AdventureWorks2016CTP3 Sales vStoreWithAddresses VIEW
AdventureWorks2016CTP3 Purchasing vVendorWithContacts VIEW
AdventureWorks2016CTP3 Sales Customer BASE TABLE
AdventureWorks2016CTP3 Purchasing vVendorWithAddresses VIEW
AdventureWorks2016CTP3 Sales SalesOrderDetail_ondisk BASE TABLE
AdventureWorks2016CTP3 Sales SalesOrder_json BASE TABLE
AdventureWorks2016CTP3 HumanResources Department BASE TABLE
AdventureWorks2016CTP3 Production Document BASE TABLE
AdventureWorks2016CTP3 Sales SalesOrderDetail BASE TABLE
AdventureWorks2016CTP3 Person EmailAddress BASE TABLE
AdventureWorks2016CTP3 Person Person_json BASE TABLE
AdventureWorks2016CTP3 Demo DemoSalesOrderDetailSeed BASE TABLE
AdventureWorks2016CTP3 HumanResources Employee BASE TABLE
AdventureWorks2016CTP3 Sales SalesOrderHeader BASE TABLE
AdventureWorks2016CTP3 Demo DemoSalesOrderHeaderSeed BASE TABLE
AdventureWorks2016CTP3 Sales CustomerPII BASE TABLE
AdventureWorks2016CTP3 HumanResources EmployeeDepartmentHistory BASE TABLE
AdventureWorks2016CTP3 HumanResources EmployeePayHistory BASE TABLE
AdventureWorks2016CTP3 Person Person_Temporal BASE TABLE
AdventureWorks2016CTP3 Sales SalesOrderHeaderSalesReason BASE TABLE
AdventureWorks2016CTP3 Person Person_Temporal_History BASE TABLE
AdventureWorks2016CTP3 HumanResources Employee_Temporal BASE TABLE
AdventureWorks2016CTP3 Sales SalesPerson BASE TABLE
AdventureWorks2016CTP3 Production Illustration BASE TABLE
AdventureWorks2016CTP3 Person PhoneNumberType BASE TABLE
AdventureWorks2016CTP3 Sales SpecialOffer_inmem BASE TABLE
AdventureWorks2016CTP3 HumanResources Employee_Temporal_History BASE TABLE
AdventureWorks2016CTP3 HumanResources JobCandidate BASE TABLE
AdventureWorks2016CTP3 HumanResources vEmployeePersonTemporalInfo VIEW
AdventureWorks2016CTP3 Production Location BASE TABLE
AdventureWorks2016CTP3 Sales TrackingEvent BASE TABLE
AdventureWorks2016CTP3 Sales OrderTracking BASE TABLE
AdventureWorks2016CTP3 Person Password BASE TABLE
AdventureWorks2016CTP3 Production Product_inmem BASE TABLE
AdventureWorks2016CTP3 Sales SalesPersonQuotaHistory BASE TABLE
AdventureWorks2016CTP3 Person Person BASE TABLE
AdventureWorks2016CTP3 Sales SalesReason BASE TABLE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started