Around the world, data availability is exploding. Recently, the International Data Corporation (IDC) forecasted the volume of data created in the next three years will exceed the volume of data created in the last thirty years. Organizations are increasingly turning to accountants to interpret the large amounts of data created by business operations. The public accounting firm EY, for instance, offers its clients analytics services in the areas of financial reporting, mergers and acquisitions, tax, and forensics. Public accounting firms, in general, are aggressively hiring business school graduates that also have technology skills. PwC plans to spend $12 billion and hire 100,000 employees. Other accounting employers are providing input to universities on the design of graduate programs to ensure new hires obtain the necessary analytics skills.
This course is designed to be hands on and introduce participants to topics such as data sources and extraction, data cleaning and preparation, data tables and PivotTables, and data modeling and visualizations. In addition to introducing participants to advanced Microsoft Excel techniques, the course will allow participants to work with the latest and greatest analytics software tools (e.g., Tableau, Power BI, Alteryx). Participants will learn how to perform descriptive, diagnostic, predictive, and prescriptive analytics and time will be spent on best practices in communicating the results of data analysis to key decision makers within a firm.
- Review topics such as data sources and extraction, data cleaning and preparation, data tables
- Design data models and visual tools
||Saturday, December 9th, 2023. 9:00 AM to 1:15 PM EST
||Your home or office
||Tom Adams, Ph.D., CPA, CGMA
||4 Accounting CPE
||4 Substantive CLE
||FREE for ALA Members / $75 for Non-Members
Tom Adams, Ph.D., is a licensed Certified Public Accountant (CPA) in Pennsylvania and a Chartered Global Management Accountant (CGMA). Prior to pursuing his Ph.D., he worked as a senior associate in the audit practice of KPMG LLP and as a senior financial analyst for Teleflex Incorporated (NYSE: TFX).
As a Ph.D. student, Adams received an Accounting Doctoral Scholars (ADS) award. His dissertation investigated changes in audit committees surrounding mergers and acquisitions and his current research focuses on shareholder activism, audit quality, auditor resignations, and group audits. He has published articles in the Journal of Accounting and Public Policy, the Journal of Futures Markets, Review of Financial Economics, the Journal of Accountancy, Practical Tax Strategies, and the Tax Insider.
* The ALA issues CLE credits through its partnership with McDevitt and Kline LLC, which is an accredited provider of CLE in Pennsylvania (PA CLE Provider # 5963). Live, internet-based courses are approved as Distance Learning courses by the PA Supreme Court CLE Board. For additional information, please visit http://www.pacle.org/. To the best of our knowledge, the following states have attorney self-reporting procedures for out-of-state provider programs or reciprocity with accredited providers in the state of Pennsylvania: Arizona, Arkansas, Colorado, Florida, Hawaii, Illinois, Indiana, Louisiana, Massachusetts, Michigan, Montana, New York, North Carolina, North Dakota, Ohio, South Carolina, and South Dakota. However, please review the specific rules and requirements in your state. Please contact member services with any questions at firstname.lastname@example.org.
McDevitt & Kline, LLC is registered with the National Association of State Boards of Accountancy (NASBA), as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417. Web site:www.nasba.org.