Better Business Through Data Analysis & Monitoring My Account

University of Georgia Students Compare Data Analytics and Spreadsheets

Students Assess Efficiency Levels and Compare Functionality

HOUSTON – November 9, 2016 – Students attending the University of Georgia recently completed an IT audit exercise using Microsoft® Excel and CaseWare IDEA® to compare attributes of both products including speed, ease of use and functionality.

Students reported a 30-minute time savings using IDEA for the same tasks performed in Excel. While Excel was more familiar to them and did not require installation, students preferred IDEA’s ability to consolidate data and create graphs without programming, and the built-in data analysis tasks. Students used the Project Overview feature in IDEA to graphically represent all tasks completed within their project to create an audit trail.

“Our students did multiple exercises in IDEA; however, I had them do a similar IT Audit exercise in Microsoft Excel prior to completing it in IDEA,” said Holly Hawk, CPA, CGMA, Lecturer with the University of Georgia. “Two big takeaways for the students included the efficiency of using IDEA, demonstrated through the time difference in completing both exercises being dramatically different, as well as the ease of importing data and data analysis within IDEA. Overall, IDEA has been a great data analysis tool to introduce to our students, even though they were hesitant to learn new software, they have now started to understand and appreciate the functionality of IDEA.”

The University of Georgia recently joined the IDEA Academic Partnership to offer students the opportunity to learn data analytics techniques used by professionals to identify internal control weaknesses and anomalies within data. An in-kind software donation of 148 CaseWare IDEA licenses is valued at $74,000.00 was made to the University to give students hands-on experience with importing, analyzing and testing data. Students will also benefit from using the IDEA Workbook, which includes case studies and data sets, available to them at no cost through the IDEA Academic Partnership.

“After working with the software, I feel that IDEA shows how powerful and beneficial data analytics can be for audits,” said Kevin Williams, University of Georgia student. “I think that the largest benefit of IDEA was the capability to import data from common sources such as Microsoft Access and Excel. During the assignment, this capability allowed me to quickly address key audit objectives and detect signs of fraud in files provided by the "client;" the IDEA software could be very beneficial for both internal and external audit processes.”

IDEA is a powerful and user-friendly tool designed to help accounting and financial professionals extend their auditing capabilities, detect fraud and meet documentation standards. It allows users to quickly import, join, analyze, sample and extract data from almost any source, including reports printed to a file, such as PDFs. With unlimited file size capabilities and an intuitive user interface, IDEA has the ability to analyze large volumes of data in seconds. IDEA is used in more than 90 countries, by major accounting firms, government, corporations in all industry sectors and by nearly 500 universities as a teaching tool.

The IDEA Academic Partnership is sponsored by Audimation Services, Inc., the U.S. distributor of CaseWare IDEA, CaseWare Monitor™ and SmartExporter. Participation is offered at no cost to U.S. accredited college and university educators. Additional information is available at www.audimation.com/academic.

About Audimation Services, Inc.
Founded in 1992, Audimation Services, Inc. is a leader in providing data analysis technology to help companies understand their data, assess risks, test controls, and fight fraud. As the sole U.S. distributor of IDEA® Data Analysis, CaseWare™ Monitor and SmartExporter for SAP®, we help our clients maximize their technology investments by providing support, training and other valuable resources. For more information about Audimation Services, visit www.audimation.com or call 888.641.2800.

About CaseWare Analytics
CaseWare Analytics is home to IDEA Data Analysis, Collaborative Analytics and Continuous Monitoring solutions. All CaseWare Analytics technologies are built upon the foundation of best practices in assessing risk and controls, hereby enabling audit and finance professionals to use real data insights to create remarkable ROI & business improvement opportunities.  Visit www.caseware.com for more information.

IDEA is a registered trademark of CaseWare International Inc. All product and company names are trademarks™ or registered® trademarks of their respective holders.

Print

Number of views (2110)/Comments (0)

Tags:
Brad Newman

Brad Newman

Other posts by Brad Newman
Contact author

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x
2018 IDEA® User of Excellence Award Winner Selected
15 June 2018

2018 IDEA® User of Excellence Award Winner Selected

Jennifer Girard, CIDA with American Red Cross Recognized for Exceptional Use of Data Analytics

Jennifer Girard, Sr Auditor with the American Red Cross is the recipient of the 2018 US IDEA UoE Award. She utilized IDEA to assist Finance Department during a natural disaster.

Read More

The Rules of Nature and Audit
6 June 2018

The Rules of Nature and Audit

What’s missing is often as important as what’s present. The rules of nature apply very well to audit if you consider, “Everyone knows it, but do you test for it?”

Read More

Using IDEA to Import QuickBooks General Ledger Data
4 June 2018

Using IDEA to Import QuickBooks General Ledger Data

The General Ledger is typically the starting point to an expanse of detailed information, see a step-by-step guide on how to get a readable version in idea.

Read More

New Features in IDEA 10.3 Part II
10 May 2018

New Features in IDEA 10.3 Part II

IDEA Tech Tip

In a recent article, we introduced the improvements to Stratified Random Samples and Python integration added in IDEA 10.3. But that’s just a small part...

Read More

Cargo Company Swaps Programming-Intensive Data Analytics Software for CaseWare IDEA
10 May 2018

Cargo Company Swaps Programming-Intensive Data Analytics Software for CaseWare IDEA

Auditors Achieve More Success in First Year with IDEA Than 5+ Years with Other Tool

With the entire audit team up and running using data analytics, they are finding new ways to integrate IDEA into other areas of the business and automate repeatable processes.

Read More

Maximizing Your Environment - Global Variables
8 May 2018

Maximizing Your Environment - Global Variables

Consider scope to be a building in which people work. The tools required to accomplish their tasks will of course be housed in that building, but in scripting it’s important to determine which tools need to be shared among the buildings.

Read More

Tips on Acquiring Data
8 May 2018

Tips on Acquiring Data

An IDEA User Shares Frequent Practices

When working with rows and columns of data to spot suspicious behaviors, fraud and errors can look very similar to one another. While Yeriazarian often uses Excel as an interim format for data, he also understands there are several avenues to navigate before getting the right data.

Read More

Identifying Churn in AR
19 April 2018

Identifying Churn in AR

IDEA Tech Tip

Customer churn (customer attrition, turnover, or defection) is when a customer decides to stop engagement with your company. IDEA can help easily identify “churn” in accounts receivable by following these steps...

Read More

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

RSS