Project BackgroundThe learning objective of this module is to introduce you to data analytics which employers consistently tell us are important to new accountants. We will be using an EY-developed case, Implementing the DuPont Method, which I have edited for ACCT 3371. A key purpose of financial statements is to provide useful information to decision makers, including investors. Investors can use the information contained in financial statements to better understand company performance so they can make better investment decisions. One introductory framework that has been especially useful in understanding company performance is the DuPont Method (sometimes called DuPont Analysis, DuPont Model or DuPont Framework).To understand the DuPont Method, it helps to use an analytics mindset. For this case, we (1) define an analytics mindset, (2) discuss the history of and ratios involved in the DuPont Method and (3) use the DuPont Method to perform data analytics and data visualization techniques. Project DetailsFor this case, you will implement an analytics mindset by comparing and contrasting different companies within different industries using the accounting ratios from the DuPont method. Your overall goal is to develop an investment recommendation for an investor.The module has two parts: In Part 1 of the case, you will gain an understanding of a few accounting ratios, which will help you to develop good questions about the companies you are analyzing in Tableau Part 2. Tableau is not needed for this portion of the module. Part 1 is an exercise and is only counted as a completion grade. Therefore, the grade is not used in any grade calculation. Although the grade is not counted, Tableau Part 1 is required. Consequently, if you do not complete it, you will not be eligible for a curve in this class.In Part 2 you will load the data into Tableau, perform some simple tests to verify that you have loaded it correctly, analyze the data, develop an investment recommendation for your investor, and finally, leverage the power of data visualization to present the data so that it can be easily interpreted and understood by your investor.Tableau DescriptionNewGenApp.com describes Tableau as data visualization software used for data science and business intelligence. Tableau can create a wide range of different visualization to interactively present the data and showcase insights. It comes with tools that allow to drill down data and see the impact in a visual format that can be easily understood. Tableau specializes in transforming boring tabulated data into eye-candy graphs and representations. You can easily import data into Tableau’s data engine from multiple sources and integrate them by combining multiple views in an interactive dashboard.Step 1 14Question 1 - total assets 3 Question 2 - count companies 3 Question 3 - companies per industry 3 Question 4 - net revenues per industry 5 Step 2 20Calculate ROE 5 Calculate profit margin 5 Calculate asset turnover 5 Calculate financial leverage 5 Step 3 23Question 1 - Median ROE 4 Question 2 - Median PMR 4 Question 3 - Median AT 4 Question 4 - Dashboard 3 Question 5 - Multiple viz on one sheet (2pts per ratio) 8 Step 4 24Question 1 - student choice 6 Question 2 - student choice 6 Question 3 - student choice 6 Question 4 - student choice 6 Step 5 19Story - opinion well presented and supported by 4 viz 19 Project Total 100

InstructionsIn the textbook, The ROI of Human Capital: Review Chapter 5, Section “An Integrated Reporting System”Read Chapter 6, “Human Capital Analytics: The Leading Edge of Measurement”Read Chapter 7, “Predictive Analytics: Leading Indicators and Intangible Metrics”Download and read the Kaplan and Norton (2004b) article “How Strategy Maps Frame an Organization’s Objectives” via http://tinyurl.com/l25m9w9. Download and read the Ingham (2011) article “Using a Human Capital Scorecard as a Framework for Analytic Discovery” via http://tinyurl.com/mwjhwrf. Review the Strategy Map Templates found at the website: http://www.slideshare.net/Intrafocus/intrafocus-st....Write an 800-1000 word paper guided by the following requirements: Introduction: Write a brief introduction to the paper.HC Scorecard Article Summary: Write a one-paragraph summary of the Ingham (2011) article.Framing Objectives Article Summary: Write a one-paragraph summary of the Kaplan and Norton (2004b) article.Appendix Part 1 – Scorecard Map and Outcomes: Complete a single-theme strategy map and outcomes using the Strategy Map Balanced Scorecard Action Plan.xlsx listed in the Resources section.Single HR Theme Strategy Map: Complete the single theme Strategy Map section by selecting one of the HR themes from the original strategy map completed in Workshop Three. This is a different map than the original more complete strategy map constructed in the prior workshop. You will select only one of the key strategies (or pillars as they are referred to at times in the HR Scorecard research literature) from the prior map for use in this assignment. For clarification on single theme strategy maps, review the Intrafocus PowerPoint. You may also refer to the example single theme strategy map: “Figure 2. A Strategic Theme Defines the Process, Intangible Assets, Targets, and Initiatives Required to Execute a Piece of the Strategy,” shown on page 44 of the Kaplan and Norton (2004b) article.Strategy Map Objectives: Using “Figure 2. A Strategic Theme Defines the Process, Intangible Assets, Targets, and Initiatives Required to Execute a Piece of the Strategy” (on page 44 of the Kaplan and Norton, 2004b article), complete the Objectives section of the strategy map by identifying one measureable objectives for each initiative illustrated in the four HR balanced scorecard perspectives: Financial, Customer, Internal (Operations), and Learning and Growth (People/Strategic).Appendix Part II – Scorecard Measurements and Targets: Complete the Measurement and Target sections of the Balanced Scorecard (middle section) in the one-page strategic scorecard:Balanced Scorecard Measurement: Using “Figure 2. A Strategic Theme Defines the Process, Intangible Assets, Targets, and Initiatives Required to Execute a Piece of the Strategy” (on page 44 of the Kaplan and Norton, 2004b article), identify one measurement for each one of the objectives you identified in Step 7.d.ii.Balanced Scorecard Target: Using “Figure 2. A Strategic Theme Defines the Process, Intangible Assets, Targets, and Initiatives Required to Execute a Piece of the Strategy” (on page 44 of the Kaplan and Norton, 2004b article), identify one target for each measurement that you identified in Step 7.e.i.Killers of Measurement Systems: Reflect on the statement in Chapter 5 of the textbook by Fitz-enz (2009), who concedes: After setting up measurement systems around the world for more than thirty years, I can tell you that there are three things that eventually kill them: The amount of work involved in collecting the data on a timely basisNot finding a way to report the data that makes them easy to understandNot sustaining staff and management’s commitment to the system (p. 160)Formulate how you would address each of Fitz-enz’s “killers of measurement systems” to salvage your own proposed measurement system (i.e., scorecard).Conclusion: Provide a brief conclusion.Include a cover page and a reference page in addition to the 800-1000 words required for the assignment. Use appropriate headings for each of the above lettered items in the paper.Do not complete the Action Plan portion of the scorecard in Workshop Four. (You will complete this section in Workshop Five.) However, you may include this blank section as part of your one-page model, illustrating your scorecard as it is shown in “Figure 2. A Strategic Theme Defines the Process, Intangible Assets, Targets, and Initiatives Required to Execute a Piece of the Strategy” (on page 44 of the Kaplan and Norton, 2004b article).