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
|When:||Saturday, October 23rd, 2021. 9:00 AM to 5:00 PM EST|
|Where:||Your home or office|
|Speaker:||Joseph Ugras, Ph.D., CPA|
|CPE Credits:||8 Accounting CPE|
|CLE Credits:||7 Substantive CLE |
|Delivery Method:||Group Internet-Based|
Dr. Joseph Ugras is the Dean of the College of Professional and Continuing Studies at La Salle University in Philadelphia, PA. Dr. Ugras also teaches Accounting for Managerial Decision Making at the Graduate Level. He holds a Ph.D. in accounting from Temple University, an M.B.A. in Accounting and Taxation from Fairleigh Dickinson University, and is a Certified Management Accountant (CMA). His areas of expertise include managerial accounting, activity-based costing/management, strategic cost management, measurement of financial performance, and ethical issues in business. Dr. Ugras has consulted with an international pharmaceutical company, Subaru America, UNISYS, Binney and Smith and Carpenter Tech. He has made presentations at the American Accounting Association National and Regional Conferences, European Management Accounting Conference, Annual Management Accounting Research Symposia and Philadelphia Controllers Conference. He has also served as the President of the American Accounting Association Mid-Atlantic Region, as well as a variety of positions with the Institute of Management Accountants. Dr. Ugras’ research has been published in Advances in Management Accounting, Accounting Enquiries, Southern Business and Economic Journal, Journal of Business Ethics and Journal of Management Systems.
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 submitted to the National Registry of CPE Sponsors through its website: https://www.nasbaregistry.org/ McDevitt and Kline's 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/. Check with your State CLE Board for rules pertaining to live webcasts. These rules differ from state to state.