Data analytic tools help auditors scale their audit tests over the entire data population with minimal or no increase in time and cost, generating analyses and evidence with laser precision. However, the output is only as good as the input. Data preparation is a critical step in the analysis process, one that can be time-consuming without proper know-how. Our expert instructor will walk you through the steps to import, cleanse, format and profile data to extract maximum value and deliver meaningful insights. Attendees will return to work with a better understanding of how to improve data quality in IDEA.
- Understand why data quality is integral for professionals applying data analytics in their engagements
- Learn techniques such as cleansing, formatting and profiling data to extract maximum value
- Validate the data to ensure high levels of accuracy
- Test data correctness, timeliness, relevance and completeness
| Course Level |
Intermediate |
| Length |
One day (8 CPE) |
| Delivery Method |
Group Internet-Based |
| Event Time |
8:30 AM - 4:30 PM |
| Prerequisites |
IDEA Fundamentals or CI101: IDEA Data Analysis Level 1 |
Mario Perez, CIDA
Audit Analytics Consultant
Mario has over 12 years of experience as an IDEA user, trainer, and provider of technical support and consulting services. Starting with his introduction to IDEA as an audit associate at BDO New York in the mid-90s, he credits his enthusiasm for Data Analytics and knowledge of IDEA with traveling the world, working with the IDEA distributor in Scandinavia as well as training and consulting engagements in Saint Vincent and the Grenadines and The Bahamas.
Audimation Services, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of the 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:
nasbaregistry.org
CPAs may contact us by email at
[email protected] to receive promotional materials containing details on the required elements of the National Registry of CPE Sponsors.
