Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions