Better Business Through Data Analysis & Monitoring My Account

Advancing Next-Gen Accounting & Audit Professionals

Case Study with Wipfli & University of Wisconsin–Eau Claire

Facts

Wipfli LLP

  • 1,200+ Associates
  • 25 Offices in U.S. & India
  • Ranked Among top 25 U.S. accounting firms
  • Member of PKF North America – 10th Largest global accounting network

University of Wisconsin—Eau Claire

  • Established in 1916
  • 10,000+ Students
  • Ranked 5th Best of Public Universities in the Midwest by U.S. News & World Report
  • Ranked as a “Best Value College” by Princeton Review

Nothing reinforces learning like experience. Recent graduates seeking entry-level positions with the struggling U.S. job market fare better if they can demonstrate mastery of technology used by other professionals in their industry. Yet many higher education institutions lack the resources and budget to purchase professional-grade software for student use.

Students taking basic systems courses learn about the challenges of analyzing big data, and the importance of using data analysis in addition to other technologies such as Excel and SAP. Gaining those skills prior to entering the workforce is critical. Accounting professor D’Arcy Becker at the University of Wisconsin—Eau Claire has consistently used data analytics in her courses to help students understand data outside of statistics.

Dr. Becker began using IDEA in different parts of the accounting and auditing curriculum at the University of Wisconsin—Eau Claire when it came packaged with an Auditing textbook starting in 2001. In 2005, that textbook changed to a different analytics package and IDEA temporarily was removed from the curriculum.

By 2007, powerhouse accounting firm Wipfli LLP, a major recruiter of students at the University, realized that students they were hiring no longer had the benefit of having learned IDEA at the University. Wipfli was among a handful of Universities who asked whether Becker could reincorporate IDEA data analysis software.

While IDEA returned to the curriculum in 2007, it was not until the 2012 IDEA Academic Partnership program came to the University that IDEA could begin to impact a wider array of courses and students. The Academic Partnership allowed the University to obtain enough licenses for each student, and received an in-kind software donation valued at $75,000. Students taking Fraud Investigation and Advanced Auditing courses were immediately impressed with IDEA’s ease of use and powerful functionality. Becker was able to provide step-by-step instruction to teach her students how auditors use data analytics to uncover fraud within complex data sets. The hands-on experience helped students gain a deeper understanding about how audit functions work, and find things they would have missed without the use of technology.

Becker would instruct students to perform analytics or sample selections by hand, which is required to pass the CPA exam, and then have them use IDEA to get the same answer. Students quickly grasped how much easier and faster tasks can be performed when using a professional tool.

When we’re able to teach students how functions work, they follow along and it’s easy for them to grasp. It makes the concepts more concrete for them, and as a result, they gain practical knowledge that firms like Wipfli look for when hiring and developing their staff.”

D’Arcy Becker, Accounting Professor, University of Wisconsin—Eau Claire

One of Becker’s students quickly realized the importance of learning data analytics, especially for analyzing large data sets and forensic analysis. Jennifer Thompson was introduced to IDEA by Becker, and craved more experience. Thompson began using IDEA for specific class assignments for her undergraduate degree.

Shortly after graduating, Thompson joined Wipfli LLP, which ranks among the top 25 accounting and business consulting firms in the nation.  She credits her experience using IDEA to her advancement within the firm.  Thompson leads a team of IDEA Power Users that train Wipfli employees in using IDEA to conduct more efficient and effective audits. Thompson is also the subject matter expert in data analysis at Wipfli, utilizing IDEA for numerous projects including forensic engagements, internal control assessments, and electronic data analysis.

“The more time I spent using IDEA, the more it created a desire to find other areas where it could be used. I immediately saw value in using it, and that drove me to where I am today. It gets me excited about going to work. While I use other technologies, IDEA is my go-to tool. We deliver a better work product as a result of using IDEA.”  

- Jennifer Thompson, CPA/CFF, CIDA, CFE, MBA
Manager, Wipfli LLP

Wipfli heavily recruits locally, especially at the University of Wisconsin—Eau Claire.  The firm has established a cross-niche internship program to give students a comprehensive audit and tax experience. Thompson and her colleagues make a conscious effort to bring interns and young professionals into the fold to share and grow their utilization of IDEA. Thompson regularly visits the campus to give class presentations, discuss case studies and explain how she uses IDEA in her daily work.

The University of Wisconsin—Eau Claire continues to expand its use of IDEA across four courses including Advanced Accounting Systems where students will learn how to import PDFs and use some IDEA’s advanced functions. When resources are limited, and technology changes at a rapid pace, many universities rely on programs like the IDEA Academic Partnership for software, course materials and resources. Students who gain experience using the tools of their profession prior to gradation have a much higher chance of being hired, and advancing in their careers. Those who have benefited from these partnerships, like Thompson, realize their importance and are sharing their experience with others to build a stronger workforce.

Print

Number of views (2288)/Comments (0)

Tags:
Lindsey Falconer
Lindsey Falconer

Lindsey Falconer

This is where the short info goes

Other posts by Lindsey Falconer
Contact author Full biography

Full biography

This is the full info, it's probably going to be much longer than the short info

x

Documents to download

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