Question
Using Microsoft PowerBI use the AdventureWorksDW2014 database and select the following tables: DimCurrency, DimCustomer, DimDate, DimEmployee, DimGeography, DimProduct, DimProductCategory, DimProductSubcategory, DimPromotion, DimSalesReason DimSalesTerritory, FactInternetSales, FactInternetSalesReason
Using Microsoft PowerBI use the AdventureWorksDW2014 database and select the following tables:
DimCurrency, DimCustomer, DimDate, DimEmployee, DimGeography, DimProduct, DimProductCategory, DimProductSubcategory, DimPromotion, DimSalesReason DimSalesTerritory, FactInternetSales, FactInternetSalesReason
Find;
Monthly sales of bikes bikes with a year filter (notice that youve done something of this kind with Excel and PowerPivot)
Evaluate sales persons performance. These individuals have a job title of Sales Representative. Examine dimEmployee table for details.
Examine sales representatives performance across sales territories.
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
Database Security XI Status And Prospects
Authors: T.Y. Lin, Shelly Qian
1st Edition
0412820900, 978-0412820908
