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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You will choose a dataset from work, home, church, or another source you are familiar with. Using Microsoft PowerBI, you should create a business intelligence dashboard which highlights the key...

please explain it too * Test Information Description Use the following variable definitions for the following questions. .data vari var2 var3 var4 SBYTE WORD SWORD DWORD 1, 3, -2, -4 4000h, 3000h,...

Dylan has been asked to help increase employee engagement at his firm. How should he proceed with this task? Write a research objective before using Microsoft Forms. Use Microsoft Forms to create a...

Dylan has been asked to help increase employee engagement at his firm. How should he proceed with this task? 1 point Use Microsoft Forms to send out an email to employees. Write a research objective...

Special instructions: Complete Requirements 1, 2, and 3 of Exercise 8-29 by completing the relevant tables on this document. For Requirements 4, and 5, use Microsoft Excel. The following data relate...

Please read the following scenario and answer the questions below. Use the data set below to complete this assignment. You may create your assignment using either Microsoft Word or Excel. When you...

Question 4 (25 marks) Case: Retail Database Design You have engaged a software vendor to design a database to capture both retail outlets essential data. The key areas of your concerns are sales...

Excel Case Assume that Sky's the Limit Parachute Company's budgeted income statement is as follows: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted Sales $40,000,000 $35,000,000 $45,000,000...

Compute the ratio of entity value to EBIT for Coca-Cola in 2000 and again in 2010. (a) Do the ratios make sense? (b) What do they tell you about the company?

The compressor in an ideal refrigeration cycle using R134a has an inlet pressure of 120 kPa. Referring to Fig. 104, state 1 has a quality of 1.0 and state 4 has a quality of 0.4. For a cooling load...

A trader has invested $ 1 0 0 , 0 0 0 in Stock A and $ 1 2 0 , 0 0 0 in Stock B . She knows the following: Stock A s daily average return is 0 % and its daily standard deviation is 1 % . Stock B s...

HJ 0 4 4 . . . c . e . 5 . - a . b . c . d . . 6 . - . . c . d . .

6. Ninety percent of new products fail within two yearsso you shouldnt be so eager to innovate. Do you agree? Explain why or why not. LO11.5

4. In long-run equilibrium, P = minimum ATC = MC. Of what significance for economic efficiency is the equality of P and minimum ATC? The equality of P and MC? Distinguish between productive...

3. Even if a firm is losing money, it may be better to stay in business in the short run. Is this statement ever true? Under what condition(s)? LO10.5