Case Requirement Part A: Descriptive analyses
Download the Excel file provided by the instructor for this assignment. Perform the visualization analysis of the gender and ethnicity of various groups over the period of 2011-2018. Compare among different groups in different years and discuss your observations.
A1. Overall accounting major enrollees (see tab Data 3 in Excel file)
A2. New bachelor’s and master’s of accounting graduates (see tab Data 6 in Excel file)
A3. New bachelor’s and master’s of accounting graduate hires hired into accounting/finance functions of
U.S. CPA firms (see tab Data 9 in Excel file)
A4. All professional staff in accounting/finance functions of U.S. CPA firms (see tab Data 11 in Excel file)
A5. CPAs in accounting/finance functions of U.S. CPA firms (see tab Data 12 in Excel)
A6. Partners in accounting/finance functions of U.S. CPA firms (see tab Data 13 in Excel)
• Deliverables:(1) One chart/dashboard in Tableau for each item listed above.(2) Report your analysis based on the results you got in Tableau (hint: compare across different groups). You may want to write one paragraph to discuss A1 to A3 and write another paragraph to discuss A4 to A6.
everything that also needs to be done, i have uploaded it for you to look at.