Skip to content

This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Close
AICPA-CIMA
  • AICPA & CIMA:
  • Home
  • CPE & Learning
  • My Account
Journal of Accountancy
  • TECH & AI
    • All articles
    • Artificial Intelligence (AI)
    • Microsoft Excel
    • Information Security & Privacy

    Latest Stories

    • AI-driven spreadsheet tools — what CPAs need to know
    • Is spending on technology spinning out of control?
    • Using 3 Excel View tools to manage large spreadsheets
  • TAX
    • All articles
    • Corporations
    • Employee benefits
    • Individuals
    • IRS procedure

    Latest Stories

    • AICPA calls for fully staffed IRS regardless of shutdown length
    • Job cuts mean strong 2025 tax season may be hard to repeat, IRS watchdog warns
    • IRS removes associated property rule in final interest capitalization regulations
  • PRACTICE MANAGEMENT
    • All articles
    • Diversity, equity & inclusion
    • Human capital
    • Firm operations
    • Practice growth & client service

    Latest Stories

    • AICPA calls for fully staffed IRS regardless of shutdown length
    • PCAOB publishes guidance related to Audit Evidence amendments
    • AI-driven spreadsheet tools — what CPAs need to know
  • FINANCIAL REPORTING
    • All articles
    • FASB reporting
    • IFRS
    • Private company reporting
    • SEC compliance and reporting

    Latest Stories

    • SEC accepting Professional Accounting Fellow applications
    • SEC names new chief accountant
    • SEC ends legal defense of its climate rules
  • AUDIT
    • All articles
    • Attestation
    • Audit
    • Compilation and review
    • Peer review
    • Quality Management

    Latest Stories

    • PCAOB publishes guidance related to Audit Evidence amendments
    • AICPA unveils new QM resources to help firms meet Dec. 15 deadline
    • 8 steps to build your firm’s quality management system on time
  • MANAGEMENT ACCOUNTING
    • All articles
    • Business planning
    • Human resources
    • Risk management
    • Strategy

    Latest Stories

    • Business outlook brightens somewhat despite trade, inflation concerns
    • AICPA & CIMA Business Resilience Toolkit — levers for action
    • Economic pessimism grows, but CFOs have strategic responses
  • Home
  • News
  • Magazine
  • Podcast
  • Topics
Advertisement
  1. newsletter
  2. Extra Credit
Extra Credit Cover

Resources for teaching data analytics in accounting

Discover a wealth of free resources online.

By Jian Zhang, Ph.D.
June 11, 2019

Please note: This item is from our archives and was published in 2019. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

May 14, 2019

A problem-based learning project for accounting classes

April 9, 2019

Help students embrace emerging technologies

TOPICS

  • Technology
    • Information & Data Management
  • Accounting Education

Demands from both the business community and the Association to Advance Collegiate Schools of Business (AACSB) have made it more urgent for academics to incorporate data analytics in the accounting curriculum. To help educators teach this subject, software companies and accounting firms have produced a wide range of resources for use in the classroom. Here are some popular ones that also provide academic licenses:

From software providers:

ACL Academic Network

To access these resources, faculty must join the ACL Academic Network, which is free, and be verified as faculty members. It can take three to four weeks to obtain access.

Software and materials. Educators can obtain free access to ACL GRC (a cloud-based platform for audit management), ACL Analytics (a PC client-based data extraction and analysis software tool), and ACL Launchpad (a single access point for ACL GRC, ACL Analytics, ScriptHub, and ACL Academy). ACL also provides user guides, reference manuals, online self-paced learning, and sample data.

Alteryx for Good

Software. Both instructors and students can request a free Alteryx Designer license.

Teaching materials. Resources that could be used in the classroom include case studies, third-party research, an on-demand webinar, videos, and white papers.

Advertisement

Expert advice. Alteryx also connects educators with subject matter experts who volunteer their time through Co-Lab.

Excel

Software. Students and teachers can register to get Microsoft Office 365 Education for free, which includes Excel (as well as Word, PowerPoint, and Microsoft Teams). Microsoft also provides a “Welcome to Excel” template for novice users, other templates, and a help center.

IDEA Academic Program

To access these materials, faculty or students must join the free IDEA Academic Program.

Software. Faculty and students can access IDEA Data Analysis software, which enables students to learn about concepts such as Benford’s Law, fuzzy duplicates, gap detection, and summarization.

Teaching materials. IDEA provides a workbook and data files that contain case studies dealing with accounts receivable, accounts payable, fraud investigation, and inventory audits. It also offers tutorials and an online resource center that contains case studies with assignments, tests, sample data, and other materials. Faculty can also upload their own customized resources to its online portal.

Advertisement

PowerBI

Software. Power BI Desktop is the free version of Microsoft’s Power BI: business intelligence software that allows users to analyze data and create data visualizations and interactive reports.

Tableau Academic Programs

Software. Free software for both instructors and students. Instructors can request individual and course software through the Tableau for Teaching program, and students can request Tableau Desktop and Tableau Prep through the Tableau for Students program.

Training videos (registration required). Topics include preparing, analyzing, and sharing data. Along with the videos, the company provides transcripts, datasets, and solution workbooks.

White papers (registration required). Topics include business dashboards, business intelligence, data visualization, industry analysts, and working with data.

Curriculum materials. Course titles include Data Visualization, Tableau Desktop Training, Social Media Analytics With Tableau, and Intro to Data Journalism With Tableau. The curricula are quite thorough. For example, the data visualization course includes a syllabus, 10 different modules with data files, readings, lecture PowerPoints, assignments, and grading rubrics. (To access these materials, faculty must request membership in the Tableau for Teaching program.)

Advertisement

Teradata University Network (TUN)

To access these resources, faculty must join TUN, which is free, and be verified as faculty members.

Software. Free software including Teradata, SAS Visual Analytics, Planners Lab, Tableau, and ERDPlus.

Teaching materials. TUN’s teaching materials include University of Arkansas resources datasets, PowerPoint presentations, articles, book chapters, case studies, podcasts, research reports, tutorials, webinars, white papers, course syllabuses, and projects and assignments with teaching notes. For example, TUN offers 13 Business Scenario Investigations (BSI) cases that allow students to use evidence-based decision-making in various business functional areas in multiple industries. The cases include instructions, videos, datasets, and teaching notes. 

UiPath

Software. UiPath provides a free community edition of its software for educators.

Teaching materials. UiPath provides video tutorials, guides and other resources, and a Community Forum.
 

Advertisement

From firms:

Editor’s note: The resources below are specific to teaching data analytics. Visit this article for a broader look at the educator resources firms offer.

PWC University Relations

To access these materials, faculty must have a valid university email address.

Case study: Pixystems Toy Company Inc. Students examine the business processes and controls of a fictitious toy company using Excel and Tableau. Materials provided include the case study, a faculty guide, an introductory presentation on data analytics, data sets, worksheets and sample results.

Case study: Inventory Analysis. Students use SQLite and Tableau (or can use similar software) to work with large data sets. Materials include instructor guide, data files, and other instructional resources.

Data Management and Analysis Course. A sample 12-session graduate level course including materials such as a syllabus, lectures, classroom exercises and assignments, case studies, and a final project. It covers topics such as Excel, SQL, Tableau, programming using R, application of analytics in auditing, big data and SBRL.

Ernst & Young Academic Resource Center

Faculty must email director Catherine Banks for access.

The analytics mindset module. This module introduces the analytics mindset and a competency framework. The module prepares students to raise the right questions; extract, transform, and load (ETL) data; analyze data; and interpret and communicate the results.   

Data analytics cases. Eleven cases are available, including cases suitable for accounting information systems and data analytics and business statistics courses. The analytics tools used in these cases include Excel, Access, Tableau or Power BI, and statistics (R, SAS, SPSS). A user guide, dataset, video, and solutions are provided for each case.

KPMG University Connection

Faculty must register to access these materials. 

Case study: Urgent Medical Device Inc. A data analytics case designed for financial statement audit classes. Materials provided include the case study, datasets, a leader guide, and teaching notes. The case uses IDEA and Tableau.

Excel videos. Students can view a series of technical videos on some of the most important Excel functions, including a guide to 24 of the most commonly used functions.

Deloitte Foundation Educator Resources

Faculty must register to access these materials.

First Course in Foundations of Data Analytics. Deloitte and the University of Illinois have developed eight modules, each containing videos, lessons, and reading assignments, that can be incorporated into existing courses or used together as a full 60-hour course.

Case studies and datasets. Materials from the Deloitte Foundation/FSA (Federation of Schools of Accountancy) annual consortium, including case studies and datasets.

Jian Zhang, Ph.D., is an associate professor of accounting at San José State University. To comment on this article or to suggest an idea for another article, contact senior editor Courtney Vien at Courtney.Vien@aicpa-cima.com.

Advertisement

latest news

October 6, 2025

AICPA calls for fully staffed IRS regardless of shutdown length

October 3, 2025

PCAOB publishes guidance related to Audit Evidence amendments

October 2, 2025

Job cuts mean strong 2025 tax season may be hard to repeat, IRS watchdog warns

October 2, 2025

Is spending on technology spinning out of control?

October 1, 2025

IRS removes associated property rule in final interest capitalization regulations

Advertisement

Most Read

Why accountants need to master the art of reading the room
MAP Survey finds CPA firm starting pay on the rise
IRS finalizes regulations for Roth catch-up contributions under SECURE 2.0
Paper tax refund checks on the way out as IRS shifts to electronic payments
NASBA, AICPA release proposed revisions to CPE standards
Advertisement

Podcast

October 2, 2025

Car talk: M&A, AI and EVs changing the dealership landscape

September 25, 2025

Professional liability risks related to Form 1065, CPA firm acquisitions

September 18, 2025

‘We’re still the thinkers’ — a reminder for tax pros in the AI era

Features

AI-powered hacking in accounting: ‘No one is safe’
AI-powered hacking in accounting: ‘No one is safe’

AI-powered hacking in accounting: ‘No one is safe’

Building a better firm: How to pick the proper technology
Building a better firm: How to pick the proper technology

Building a better firm: How to pick the proper technology

Why accountants need to master the art of reading the room
Why accountants need to master the art of reading the room

Why accountants need to master the art of reading the room

How BI and analytics enhance management accountants’ partnering role
How BI and analytics enhance management accountants’ partnering role

How BI and analytics enhance management accountants’ partnering role

SPONSORED REPORT

Preparing clients for new provisions next tax season

Preparing clients for new provisions next tax season

As the 2025 filing season approaches, H.R. 1 introduces significant tax reforms that CPAs must be prepared to navigate. These legislative changes represent some of the most comprehensive tax updates in recent years, affecting both individual and corporate taxpayers. This report provides in-depth analysis and guidance on H.R. 1.

From The Tax Adviser

September 30, 2025

Current developments in taxation of individuals: Part 1

August 30, 2025

2025 tax software survey

August 30, 2025

Are you doing all you can to keep the cash method for your clients?

July 31, 2025

Current developments in S corporations

MAGAZINE

October 2025

October 2025

October 2025
September 2025

September 2025

September 2025
August 2025

August 2025

August 2025
July 2025

July 2025

July 2025
June 2025

June 2025

June 2025
May 2025

May 2025

May 2025
April 2025

April 2025

April 2025
March 2025

March 2025

March 2025
February 2025

February 2025

February 2025
January 2025

January 2025

January 2025
December 2024

December 2024

December 2024
November 2024

November 2024

November 2024
view all

View All

http://JofA_Default_Mag_cover_small_official_blue

PUSH NOTIFICATIONS

Coming soon: Learn about important news

CPA LETTER DAILY EMAIL

CPA Letter Logo

Subscribe to the daily CPA Letter

Stay on top of the biggest news affecting the profession every business day. Follow this link to your marketing preferences on aicpa-cima.com to subscribe. If you don't already have an aicpa-cima.com account, create one for free and then navigate to your marketing preferences.

Connect

  • X Logo JofA on X
  • facebook JofA on Facebook

HOME

  • News
  • Monthly issues
  • Podcast
  • A&A Focus
  • PFP Digest
  • Academic Update
  • Topics
  • RSS feed rss feed
  • Site map

ABOUT

  • Contact us
  • Advertise
  • Submit an article
  • Editorial calendar
  • Privacy policy
  • Terms & conditions

SUBSCRIBE

  • Academic Update
  • CPE Express

AICPA & CIMA SITES

  • AICPA-CIMA.com
  • Global Engagement Center
  • Financial Management (FM)
  • The Tax Adviser
  • AICPA Insights
  • Global Career Hub
AICPA & CIMA

© 2025 Association of International Certified Professional Accountants. All rights reserved.

Reliable. Resourceful. Respected.