Create a new XLS file named: Assignment$8\_$Access$\_$DataFile$\_$YourName.xls

Add the AdventureWorks DW $2012$ database to your XLS file. Add the same $3$ tables to your XLS file.

Using DAX to create a calculated field that counts the number of products.

Create the same PivotTable as above.

Submit both XLS files into the appropriate dropbox in D$2$L$.$

Data Model

$\backslash$table$[[$DimReseller$,,$FactResellerSales,DimProduct$],[$ResellerKey$,,$ProductKey,ProductKey$],[$GeographyKey$,,$OrderDateKey,ProductAlternateKey$],[$ResellerAlternateKey$,,$DueDateKey,ProductSubcategoryKey$],[$Phone$,,$ShipDateKey,WeightUnitMeasureCode$],[$BusinessType$,,$ResellerKey,SizeUnitMeasureCode$],[$ResellerName$,,$EmployeeKey,EnglishProductName$],[$NumberEmployees$,,$PromotionKey,SpanishProductName$],[$OrderFrequency$,,$CurrencyKey,FrenchProductName$],[$OrderMonth$,,$SalesTerritoryKey,StandardCost$]]$