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...
-
High Flyer, Inc., wishes to maintain a growth rate of 13 percent per year and a debt-equity ratio of .35. The profit margin is 6 percent, and total asset turnover is constant at 1.10. Is this growth...
-
Why is Ethics Importantto Risk Management? Explain with examples. What is the Role of the Ethics Committee? I NEED ANSWER IN TEXT FORM Please provide correct answer i will definitely give u positive...
-
The consolidated financial statements of General Electric Company (GE) combine the industrial manufacturing and services businesses of GE with the financial services businesses of General Electric...
-
1. Based on the conversation, what are the main causes of SSIs global transportation problems? 2. Given their product lines, is SSI using the right mix of global transportation services? Explain. 3....
-
A mobile home manufacturer decided to stop outsourcing the painting on aluminum back in-house. They decided to install their own paint line using a powder coat finish, which essentially blasts the...
-
? ?? ? ? Assume that Alpha and Omega compete in the same four-digit SIC code industry and offer comparable products and services. The following table contains their reported financial performance and...
-
You ran a new anomaly detection test which detected an anomaly in a server's traffic. Af- ter careful statistical analysis of the data, you determined that it was just an innocuous vari- ability with...
-
Why were so many people quitting their jobs? What occupations were losing the most workers? Why? Would there have been as many job quits if the unemployment rate were higher? Does the analysis in...
-
1. Explain the meaning and what things need to be considered in "Acquiring IS & Application" 2. Give examples of cases of implementation in industry in Indonesia and their linkages with existing...
-
Romeo Corporation is producing goods mostly by manual labour and considering replacing it by a machine. There are two alternative models for the machine: Machine Alpha and Machine Beta. Information...
-
The text offers five ways to build "Affective Commitment" in our organizations. Thinking about an organization you are familiar with, give three examples of how that organization makes an effective...
-
Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March April May June July August $ 42,000 51,000 33,000 48,000 59,000 63,000 Sales...
-
Please note that 1 1 (x 3)(x - 2) T 11 Put the final answer in the answer box. 3 1 (x 3)(x - 2) C - 2 Evaluate the integral
-
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?
-
KRH Enterprises has two service departments (S1 and S2) and two production departments (P1 and P2). Information from the most recent year shows the following for each department: KRH allocates S1 to...
-
Environmental Business Consultants, LLC (EBC) worked on and completed two projects during June 2019: a review of appropriate rates for solid waste and recycling collection within Klamath County, and...
-
The annual budget for Diamond Corporation for 2019 included the following costs and expenses: Required a. Compute the plant-wide predetermined manufacturing overhead rate for 2019 using direct labor...
Study smarter with the SolutionInn App