IDEA Users Working Remotely: We’re here to help! Please contact our IDEA Help Desk to ensure there is minimal disruption to your daily workflow.

X
Icon

Training & Events

Event Image

Dominate Data Quality with Enhanced Cleansing & Processing

Start
Oct 14, 2020 | 01:00 PM - 02:00 PM | Virtual
End
Address
Live Online | 1:00 PM Central   View map

FREE

Status

Unlimited tickets

0 Has Sold


Data cleansing is a critical step in any effective analysis process. It can be extremely tedious and time consuming without the proper aptitude and proficiency to import and blend raw data to provide the comprehensive analysis required. This webinar will guide intermediate IDEA users through the more complicated @Functions and equation logic to cleanse, format, and profile data to ultimately extract maximum value and deliver meaningful insights.
 
Delivery MethodGroup Internet-Based
Event Time1:00 PM - 2:00 PM Central

Mario Perez, CIDA

Senior Audit Analytics Consultant, Audimation
 
Mario Perez
Mario Perez brings more than 20 years of auditing and advanced IDEA experience to his position at Audimation, where he delivers training, instructional videos, technical support, and consulting services. Mario was introduced to IDEA as an audit associate at BDO New York in the late 1990s. He has since traveled the world, sharing his enthusiasm for data analytics. He has held exciting roles as an IDEA distributor in Scandinavia to providing training and consulting services in Saint Vincent and the Grenadines and The Bahamas.
Learning Objectives:
 
  • Examine field statistics to uncover errors and missing data
  • Obtain records containing specific words or phrases contained anywhere in a field
  • Identify duplicates using Extractions and Fuzzy logic
  • Utilize exclusion joins to identify unmatched data
  • Build nested @Functions Work with dates
  • Extract multiple values from a column of information
  • Combine with multiple conditions by nesting @if statements
NASBA CPE LogoAudimation 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.
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×