Apr 29, 2016 IDEA 10: Summarization The next several sections will deal with executing specific tasks which are commonly used in data analysis. The first one we’ll look at is called Summarization.
Auditors were using a programming-intensive analytics package and when the software provider moved to subscription-based pricing model, Oncor looked for alternatives. Internal Audit Manager Sam Steinfath and several staff members had used IDEA in the past and found it easy to utilize for data analysis. The Internal Audit department attended public and private training led by Audimation Services to either rekindle or build their skills to increase productivity levels.
Using IDEA, auditors have streamlined their process of preparing data for analysis including pulling and joining data from different systems, scanning and reconciling PDFs and handling large batches of individual transactions to identify trends year over year. IDEA is used in a variety of ways including:
Using IDEA, auditors have streamlined their process of preparing data for analysis including pulling and joining data from different systems, scanning and reconciling PDFs and handling large batches of individual transactions to identify trends year over year. IDEA is used in a variety of ways including:
- Analyzing data from more than 19,000 projects each year to quantify costs, material charges and other information to improve business processes
- Comparing dispatch tickets to billing information for meter change-out services to ensure accuracy
- Validating contract audits performed by third-party providers
- Analyzing up to 40 types of billing codes for hourly services to benchmark and track work performed by employee, type, and frequency
- Conducting contract audits for high-volumes of transactions
- Preparing and cross-matching data for administrative staff using Just_Numbers, which provides an alternative approach to address cross-matching to avoid the problems of variances in punctuation, spelling, and abbreviations to return a higher number of true matches