Use the database given below to answer this question. Instructions for attempting the answer: Create a Dashboard
Fantastic news! We've Found the answer you've been seeking!
Question:
Use the database given below to answer this question.
Instructions for attempting the answer:
Create a Dashboard to represent the following:
1. Pivot chart 1 to represent the region-wise Sales in a line chart.
2. Pivot chart 2 to represent the region-wise Costs in another line chart.
3. Create a slicer on the field "Region" to be able to select one or multiple regions at a time. Make sure that both the pivot charts respond to the selection in the slicer.
Transcribed Image Text:
CUSTOMER Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. REGION NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH ORDER DATE 15/1/13 14/2/13 16/3/13 15/4/13 15/5/13 14/6/13 14/7/13 13/8/13 12/9/13 12/10/13 11/11/13 11/12/13 10/1/14 9/2/14 11/3/14 10/4/14 10/5/14 9/6/14 9/7/14 8/8/14 7/9/14 7/10/14 6/11/14 6/12/14 5/1/15 4/2/15 6/3/15 5/4/15 5/5/15 4/6/15 4/7/15 3/8/15 2/9/15 2/10/15 1/11/15 1/12/15 31/12/15 SALES $26,884 $46,174 $44,802 $49,049 $80,369 $53,522 $67,320 $66,663 $58,146 $83,288 $22,024 $64,750 $53,586 $14,333 $29,570 $83,468 $25,263 $68,797 $49,562 $13,964 $23,798 $16,843 $78,715 $80,780 $56,959 $47,189 $37,544 $53,413 $20,816 $85,607 $14,659 $43,216 $56,959 $47,189 $37,544 $53,413 $20,816 COSTS $9,175 $9,384 $7,010 $7,665 $5,847 $7,623 $9,860 $9,214 $5,745 $8,657 $7,088 $7,945 $6,755 $8,045 $9,277 $9,533 $5,401 $9,876 $7,077 $5,124 $9,212 $9,386 $9,200 $5,447 $5,605 $9,364 $8,306 $9,841 $5,562 $5,266 $5,131 $8,800 $9,410 $8,342 $7,133 $7,456 $8,918 MONTH January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December December YEAR 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 CUSTOMER Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. Foo Bars ABC Telecom Fake Brothers Acme, inc. Widget Corp 123 Warehousing Demo Company Smith and Co. REGION NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH SOUTH EAST WEST NORTH ORDER DATE 15/1/13 14/2/13 16/3/13 15/4/13 15/5/13 14/6/13 14/7/13 13/8/13 12/9/13 12/10/13 11/11/13 11/12/13 10/1/14 9/2/14 11/3/14 10/4/14 10/5/14 9/6/14 9/7/14 8/8/14 7/9/14 7/10/14 6/11/14 6/12/14 5/1/15 4/2/15 6/3/15 5/4/15 5/5/15 4/6/15 4/7/15 3/8/15 2/9/15 2/10/15 1/11/15 1/12/15 31/12/15 SALES $26,884 $46,174 $44,802 $49,049 $80,369 $53,522 $67,320 $66,663 $58,146 $83,288 $22,024 $64,750 $53,586 $14,333 $29,570 $83,468 $25,263 $68,797 $49,562 $13,964 $23,798 $16,843 $78,715 $80,780 $56,959 $47,189 $37,544 $53,413 $20,816 $85,607 $14,659 $43,216 $56,959 $47,189 $37,544 $53,413 $20,816 COSTS $9,175 $9,384 $7,010 $7,665 $5,847 $7,623 $9,860 $9,214 $5,745 $8,657 $7,088 $7,945 $6,755 $8,045 $9,277 $9,533 $5,401 $9,876 $7,077 $5,124 $9,212 $9,386 $9,200 $5,447 $5,605 $9,364 $8,306 $9,841 $5,562 $5,266 $5,131 $8,800 $9,410 $8,342 $7,133 $7,456 $8,918 MONTH January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December December YEAR 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2013 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2014 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015 2015
Expert Answer:
Answer rating: 100% (QA)
create a dashboard to represent regionwise sales and costs using a slicer to filter data based on specific regions Several data visualization tools allow this functionality heres a general guideline I... View the full answer
Related Book For
Posted Date:
Students also viewed these business writing questions
-
The muscle enzyme lactate dehydrogenase catalyzes the reaction NADH and NAD + are the reduced and oxidized forms, respectively, of the coenzyme NAD. Solutions of NADH, but not NAD + , absorb light at...
-
What is the spring cloud API Gateway and how do you set it up to make a call to the product service via eureka service discovery server? Give me the complete code in detailed steps.
-
Design a controller to stabilize the system G(S) = with feedback H(S) +371
-
Consider the case when the cost function satisfies C xe ( )=0. This can arise for different reasons. Consider the following two possibilities: (a) Suppose production and abatement costs (AC) are...
-
If Avogadro's number of pennies is divided equally among the 300 million men, women, and children in the United States, how many dollars would each receive? How does this compare with the gross...
-
Find d1 and d2 in terms of m1 and m2, respectively (see figure). Then use the Pythagorean Theorem to find a relationship between m1 and m2. y (1, m,) di (0, 0) d(1, .)
-
When should different influence strategies be used?
-
Suppose two individuals (Smith and Jones) each have 10 hours of labor to devote to producing either ice cream (X) or chicken soup (Y). Smiths demand for X and Y is given by XS = 0:3/S /PX YS = 0:7/S...
-
Accounting. Examination of the ledger reveals many mistakes. Redo the trial balance with the correct numbers. Show all images Show all images Show all images done loading
-
The sector rotates with the indicated angular quantities about a fixed axis through point B. Simultaneously, the particle A moves in the curved slot with constant speed u relative to the sector....
-
undefined Transcribed image text: Patrick Corporation acquired 100 percent of O'Brien Company's outstanding common stock on January 1 for $617,900 in cash O'Brien reported net assets with a carrying...
-
10. Two similar models, A and B, are to be produced on a mixed-model assembly line. Hourly production rates for the two models are: for A, 7 units/hr; and for B, 5 units/hr. The work elements,...
-
2. Write a function sum_square in RISC-V where the function takes an integer n and returns the even- number summation below. If n is not positive, then the function returns 0. sum_square(n) = n +...
-
For each of these three firms, answer the following questions: a.Is the overall enterprise profitable? b.Is the equity of the firm profitable? c.Would each firm improve its profit if it increased its...
-
Compensation data for numerous jobs are more available due to the existence of various websites. The website of Salary.com provides pay data for numerous jobs in different companies in different...
-
3) Sustainability has been a recurring theme throughout the course. What are 5 major sustainability initiatives that private companies can undertake? (Name and explain 5 initiatives for 10 pts., does...
-
You can drag and drop files here to add them. Son 3 t ered d out of Con A Ltd. has the following capital structure: Equity share capital (of Rs. 10 each) 1,00,000 10% debentures (of Rs. 100 each)...
-
Do public and private companies follow the same set of accounting rules? Explain.
-
A linear regression analysis has produced the following equation relating profits to hours of managerial time spent developing the past years projects at a firm: Profits = $957+$85 Number of hours...
-
a. What does the result of the F test tell you? b. What are the two hypotheses of the F test? c. In order for the F test to be significant, do you need a high or a low value of R2? Why?
-
a. Why must a one-sided confidence interval always include the sample average? b. Must a one-sided confidence interval always include the population mean?
-
differentiate among the ethical models,
-
How do ethics and organizational mission and vision interrelate?
-
Prepare budgeted income statement (Learning Objective 2)} The budget committee of Vinning Office Supply has assembled the following data. As the business manager, you must prepare the budgeted income...
Study smarter with the SolutionInn App