Results
Oncor is using data analytics to help bridge the gap between its disparate systems to analyze high volumes and variances of data to identify business and operational improvement opportunities. The Internal Audit Manager used IDEA to prepare a time summary analysis in 10 minutes, which previously required 15-20 hours using Excel. Administrative Audit reports that once required 80-100 hours of work are now completed in a few hours. IDEA has significantly reduced the amount of time to prepare raw data for analysis and provides better uniformity of data.
The Oncor internal audit team continues to expand their use of IDEA with plans to analyze service order and contractor billing projects, something the company has not previously been able to do. They are also using IDEA to make process and contract audit testing much faster and more effective.