Better Business Through Data Analysis & Monitoring My Account
5 Elements of a Successful Data Analytics Program

5 Elements of a Successful Data Analytics Program

Building a successful, sustainable data analytics program takes effort…and a few other elements. The benefits are obvious including standardized processes, well-trained staff and abundant resources to continue the momentum. Auditors at the University of Texas System know firsthand what it takes to build a centralized data analytics program across a dispersed institution as broad as Texas itself.

The University of Texas System includes three types of geographically dispersed institutions including system administration, academic, and health/research. Each institution has a dedicated audit department with:

  • Chief Audit Executives at each institution
  • Audit plans developed by each audit department
  • Different budgets for each audit department, determined by the institution
  • Audit Committees dedicated to each institution

The System’s data is just as decentralized as the audit teams with:

  • Different ERP systems and implementations
  • Various data owners
  • Mix of data types including student data, patient data, organizational, financial, staff, etc.
  • Each institution owns its own data and has different practices regarding granting access to data
  • Data protection guidelines to meet regulatory requirements such as Health Insurance Portability and Accountability Act (HIPAA) and Family Educational Rights and Privacy Act (FERPA)
  • Varying use of how data fields are used by each institution
  • Remote access to data varies by location

While the interest and willingness to use data analytics also varied by institution, the initiative was supported by management, which is the first (and most important) element to establish when working to build a cohesive data analytics program.

Element #1: Management Support

Element #1 - Management & Support

A key driver in the success of the program was support from management. From adequate budget to support travel and tools, patience, support and even some cheerleading, the top-down backing of using data analytics made a difference in how the use of IDEA was rolled out across the organization.

Data Analytics Program Manager, Erin Baker, was tasked with leading the initiative. During her career, Erin attended multiple IDEA training courses where she received hands-on instruction for everything from importing data to developing custom IDEAScripts. Erin became a Certified IDEA Data Analyst (CIDA) and received the 2016 IDEA User of Excellence Award. She worked with management to develop a distribution plan which covered steps for sharing her knowledge with audit departments at each institution and long-term plans to sustain the program. Management backed the effort with adequate funding for the technology investment and travel required to provide hands-on training and support.

Element #2: Tools

Element #2 - Tools

While some professionals welcome new technology, others need help adjusting to the unfamiliarity of using a new tool and implementing new processes. The University selected IDEA for its ease of use and familiar Windows-based user interface. While custom IDEAScripts were developed to meet specific audit objectives and automate repeatable processes, University auditors also used pre-developed scripts available within Passport and online resources such as IDEAscripting.com. Staff expanded their skills in scripting through training exercises and guided help.

People are more likely to use something they are comfortable with. When they see the mechanics behind it and understand how it works, they are more likely to embrace it.

Erin Baker, University of Texas System

Easy-to-use, menu-driven tools were developed within IDEA to help the internal auditors acquire data based on their specific environment, analyze data in key financial areas, extract and index outliers for further investigation and review the results. The Financial Activity Tool, which provides basic summaries of activities related to multiple financial processes, is used for multiple purposes, including risk assessment development and change management for departmental audits. Erin also developed a Procard Tool and a Travel & Entertainment Tool, both of which can be used across multiple institutions.

Element #3: Training

Element #3 - Training

One of the most important elements of the centralized data analytics program was investment in training. Staff have access to a variety of training programs, both in-person and online, which offer CPE credit – an incentive for those who may not have much interest in learning data analytics.

A series of training opportunities are available to help staff become familiar with IDEA, then build on their experience and reach new levels of confidence in using data analytics. After some trial-and-error, the initial training plan was modified to provide:

  • Broad and diverse training topics to demonstrate different techniques and possibilities
    • On-site beginner training (2 days of instruction with progressive steps)
    • Webinars/lunch & learns (monthly sessions with presentations by peers on various topics)
    • Training videos (recorded series available for on-demand viewing)
  • General and topic-specific training to cover topics that apply to all institutions, which can also be customized to address specific institution challenges and environments.
  • Repository of “fake” data used to keep it looking as real as possible while protecting real information

Training Topics Include:

Navigation Functions & Nested Functions
Importing Data Field Creation & Manipulation
Appending Databases Complex Equations
Summarization Logic in Manipulating Data
Joins Project Overview
View Tab & Data Tab Extractions
Basic Scripting Duplicate Key Detection/Exclusion
Tuition Audits Top Records
Time Click Audits Visual Connector
Visualization Using the Procard Tool

A focused training program empowers the auditors to apply the analytics to suit their own audit needs. Having a dedicated trainer helps the “expert” be viewed as a mentor rather than someone pushing them to try something new or different. Training opens the door for consultations on audits and projects that require specific expertise.

Element #4: Consulting

Element #4 - Consulting

In addition to a robust and ever-expanding series of training opportunities, Erin works as an internal data analytics consultant to help answer questions and guide them using IDEA. Auditors must “own” the audit and remain independent, but they can rely on Erin’s data analytics expertise and the IDEA Help Desk for one-on-one assistance using IDEA, which saves hours and prevents undue frustration.

Element #5: Resources & Sharing

Element #5 - Resources & Sharing

All online trainings are recorded and archived for auditors to access. The team has built a repository they can use as a reference or refresher whenever needed including slide decks, practice data sets and @functions.

The intra-institutional training sessions have triggered discussions about ways each institution is using analytics in their audits and projects. This cross-sharing of information has helped auditors exchange ideas, best practices and troubleshooting tips with one another across the decentralized sets of institutions. Auditors post ideas and questions on a discussion board, which is also used to establish upcoming training topics. To help keep everyone’s skills sharp, weekly or monthly challenges are sent out to help staff increase their proficiency in using different functions and build their problem-solving abilities.

One of the most critical factors is sharing success to create momentum. Developing a cross-institutional sprit of, “we’re all in this together,” has helped the auditors build their confidence in using data analytics in their work. The program is treated as a journey rather than a destination. Additional training courses are being added each year including more advanced training to increase aptitude levels. The University is also partnering with other higher education institutions to gather new ideas about how data analytics can be used within the organization.

With the right tools, training, sharing and support from management, the function of internal auditor has helped evolve into one of trusted advisor. The University’s systemwide use of IDEA has benefited both the internal auditors who improve the quality of their work, and the auditees who gain more meaningful insights from the data.

Special thanks to Erin Baker for sharing how the University of Texas System Administration is growing its data analytics program. Information for this article was sourced from a presentation by Erin at the 2017 IDEA Innovations Conference.

Print

Number of views (1330)/Comments (0)

Scott Smith

Scott Smith

Other posts by Scott Smith
Contact author

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x
Jeremy Clopton Joins Integration Partnership Program to Help Professionals State & Sustain Their Use of Data Analytics
18 April 2018

Jeremy Clopton Joins Integration Partnership Program to Help Professionals State & Sustain Their Use of Data Analytics

Data analytics & fraud detection expert Jeremy Clopton joins the Audimation Integration Partnership program to help organizations leverage data analytics.

Read More

Think Like a Thief to Catch One
11 April 2018

Think Like a Thief to Catch One

Apply Logic to Detect Peculiar Behavior

When working with rows & columns of data to spot suspicious behaviors, fraud & errors can look very similar to one another. Tips on sniffing out fraud.

Read More

5 Elements of a Successful Data Analytics Program
12 March 2018

5 Elements of a Successful Data Analytics Program

Building a successful, sustainable data analytics program takes effort…and a few other elements.

Read More

The Power of Field Statistics
7 March 2018

The Power of Field Statistics

IDEA Tech Tip

IDEA’s Field Statistics can save you a wealth of time. It should be the first thing you go to after importing a file. Why?

Read More

Using Data Analytics to Prepare for Fieldwork
20 February 2018

Using Data Analytics to Prepare for Fieldwork

Automating High-Risk Transactions with IDEA

See how a global corporation used IDEA to develop an automated process to prepare auditors for on-site work.

Read More

People. Processes. Tools.
5 February 2018

People. Processes. Tools.

Successful Integration of Data Analytics

Expert IDEA users share their experiences and advice for building and sustaining a successful data analytics program.

Read More

Planning & Scoping Your Audit with Data Visualization
1 February 2018

Planning & Scoping Your Audit with Data Visualization

Data-Driven Insights Save Hours of Effort

Here are some ways IDEA can help you plan and scope an audit using the data visualization features within IDEA.

Read More

Classroom Collaboration at University of Missouri - St. Louis
30 January 2018

Classroom Collaboration at University of Missouri - St. Louis

Student Learn to Develop Analytic Tests

Masters students attending the University of Missouri - St. Louis share their results using data analytics to assess risk, test 100% of the data population.

Read More

Do One Thing Every Day that Scares You
30 January 2018

Do One Thing Every Day that Scares You

Virginia Tech Students Gain Confidence Using Data Analytics

Learn how Associate Professor of Practice Nadia Rogers, CPA, introduced students to IDEA, including types of audit tests that can be performed within the software and various documentation aspects of an audit engagement.

Read More

New Features in IDEA 10.3
29 January 2018

New Features in IDEA 10.3

IDEA now runs faster and offers more flexibility than ever before

The latest version of IDEA introduced a host of new features and improvements.  IDEA now runs faster and offers more flexibility than ever before.

Read More

5 Ways Data Analytics Saves Time
26 January 2018

5 Ways Data Analytics Saves Time

Turn Hours of Work into Minutes

5 time-saving ways data analytics can help you shrink your audit time, while improving the quality of your work.

Read More

Tired of Wrangling Cumbersome Client Data?
24 January 2018

Tired of Wrangling Cumbersome Client Data?

10 Ways Our Importing Services Make it Easy

10 reasons to try our data importing services, which save you time, effort and undue frustration. 

Read More

A Journey in Using Data Analytics
24 January 2018

A Journey in Using Data Analytics

Testimonial from Brian Cullum

Read how Brian Cullum used IDEA to help identify a multi-million-dollar fraud based on the overstatement of the borrower’s lending base.

Read More

Planning & Scoping Your Audit
15 January 2018

Planning & Scoping Your Audit

With Data Visualization

Data visualization is changing the way auditors are communicating with their audiences. Easy planning, find risk areas and prioritize your scope of work.

Read More

RSS