Background Information $$ Diversity is what makes each individual unique. Tangible or intangible, diversity is any dimension or characteristic gained through personal experience that offers people the ability to differentiate from one another. Examples of characteristics that make individuals diverse include age, ethnicity, gender, sexual orientation, and abilities. $$ Inclusion can be simply defined as the state of being valued, respected, and supported and is cultivated by $$creating a culture that strives for equity and embraces, respects, and values differences from all people$.$ Diversity recognizes differences among individuals while inclusion focuses on acknowledging and accepting those differences. Consequently, equity is the outcome of diversity and inclusion. Enhancing equity promotes $$justice$,$ impartiality, and fairness within the procedures, processes, and distribution of resources$$ and ensures equal access to opportunities and resources to individuals at all levels of an organization. Diversity, equity, and inclusion $($DE&I$)$ are important to the accounting profession. Diversity leads to innovative and creative solutions to business problems, and metrics such as forming a management team composed of at least $30\%$ women can be used as a benchmark for success within the accounting profession. In addition, firms that are strong in DE&I have greater financial success and experience high morale and engagement among employees. When accounting firms invest in DE&I, employees feel valued, understood, and their contributions to the firm matter. This feeling of acceptance significantly reduces stress levels and improves both mental and physical health which leads to emotional well$-$being and higher morale among employees. When employees feel such a sense of belonging, firms experience $$greater team collaboration, higher revenue growth, and higher gross margin.$$ 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($see below for the group information$).$ Compare among different groups in different years and discuss your observations. $$ A$1.$ Overall accounting major enrollees $($see tab Data $3$ in Excel file$)$ A$2.$ New bachelor's and master's of accounting graduates $($see tab Data $6$ in Excel file$)$ A$3.$ 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$)$ A$4.$ All professional staff in accounting$/$finance functions of U$.$S$.$ CPA firms $($see tab Data $11$ in Excel file$)$ A$5.$ CPAs in accounting$/$finance functions of U$.$S$.$ CPA firms $($see tab Data $12$ in Excel$)$ A$6.$ 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 A$1$ to A$3,$ and write another paragraph to discuss A$4$ to A$6.$ Part B: Trend analysis $$ B$1.$ Use $$Data $1$ in the Excel file to create a graph about accounting enrollments in the below programs over $1993-2018$: o Bachelor in Accounting o Master in Accounting o Master in Taxation o MBA Accounting o Total Accounting Program Enrollment $$ B$2.$ Use $$Data $2$ in the Excel file to create a graph of $2018$ ethnicity distribution in the supply and demand in the accounting profession $$ B$3.$ Use $$Data $5$ in the Excel file to create a graph showing trends in bachelor$$s and master's accounting enrollees by race $/$ ethnicity $2006-2018$ B$4.$ Use $$Data $14$ in the Excel file to perform trend analysis in number of new CPA candidates by year $|2006-2018$ B$5.$ Use $$Data $15$ in the Excel file to perform Trends in number of CPA candidates who passed their $4$th section of the CPA Exam by year $|2006-2018$ Deliverables: For each of the $5$ items, please submit $(1)$ one graph$/$dashboard demonstrating your analysis and $(2)$ one paragraph of write up regarding your analysis of B$1$ to B$5($five items$).$ Part C: Age$-$Gender$-$Ethnicity Analysis of Accounting and Auditing Profession, relative to overall US workforce and other business professionals $$ C$1.$ Use $$Data $16$ in the Excel file to perform visualization analysis of age group distribution, and discuss how accounting and auditing professionals differ from $$Business and financial operations occupations$$ and general workforce in the US$,$ over the period of $2011-2020.$ C$2.$ Use $$Data $17$ in the Excel file to perform visualization analysis of percentage represented by different ethnicity in accounting and auditing, discuss changes over Year $2011-2020,$ and how does accounting and auditing differ from $$Business and financial operations occupations$$ and general workforce in the US $$ C$3.$ Use $$Data $18$ in the Excel file to perform visualization