Applying Data Analytics in Accounting

Applying Data Analytics in Accounting

This course is part of Business Analytics Specialization

Instructor: Gies College of Business, University of Illinois

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 quizzes

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Business Analytics Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

This course explores business analytic applications in accounting. First, it presents a survey of technology topics in accounting, including process mining, blockchain and applications in audit, tax, and assurance. Next, the course explores visualization and basic analytics in audit and control testing using R and Alteryx. Next, the course examines the uses of text analysis in accounting and conducts text analysis using R and RStudio. Finally, the course examines robot process automation in general using UiPath and its applications in accounting.

In this module, we provide a broad overview of the role of accounting as it interacts with data analytics and new technological advances. We begin by understanding what accounting is and the environment surrounding it. We then introduce you to the recent trends in the technology of accounting. We conclude the module with a discussion of three important topics in accounting: cybersecurity, process mining, and blockchain.

What's included

16 videos6 readings2 quizzes1 discussion prompt1 plugin

16 videosTotal 70 minutes

Course Introduction3 minutesPreview module
About Professor Jessen Hobson1 minute
The Impact of the Gies Community2 minutes
Survey of Analytics Topics in Accounting: Introduction1 minute
Accounting is The Language of Business4 minutes
Basics of Accounting and Key Accounting Terms9 minutes
Basics of Accounting and Key Accounting Terms 25 minutes
Academic Research in Accounting3 minutes
Accounting and Technology Overview3 minutes
Tax Technology Overview3 minutes
Technology in Managerial Accounting5 minutes
Cybersecurity8 minutes
Process Mining5 minutes
Blockchain for Accounting 15 minutes
Blockchain for Accounting 27 minutes
Survey of Analytics Topics in Accounting: Conclusion1 minute

6 readingsTotal 60 minutes

Syllabus10 minutes
About the Discussion Forums10 minutes
Online Education at Gies College of Business10 minutes
Updating Your Profile10 minutes
Module 1 Overview10 minutes
Survey of Analytics Topics in Accounting: Readings & Files10 minutes

2 quizzesTotal 60 minutes

Orientation Quiz30 minutes
Survey of Analytics Topics in Accounting: Graded Quiz30 minutes

1 discussion promptTotal 10 minutes

Getting to Know Your Classmates10 minutes

1 pluginTotal 15 minutes

Welcome! Please Tell Us About Yourself15 minutes

This module introduces you to important concepts related to auditing. We begin by reviewing the different types of technology that can be used by the auditors to increase the effectiveness and efficiency of audits. We then examine how and why mistakes or fraud occur. We also discuss how internal controls can be placed to prevent misstatements. Finally, we demonstrate the control test workflow using a real-world dataset in both Alteryx Designer and RStudio.

What's included

18 videos2 readings1 quiz

18 videosTotal 147 minutes

Controls and Auditing: Introduction1 minutePreview module
Audit Technology Overview7 minutes
Reporting Pressures, Earnings Management and Reporting Fraud7 minutes
The Fraud Triangle and Employee Fraud5 minutes
Need for Controls, Definition of Controls, Introduction of Internal Audit4 minutes
Introduction to The Case8 minutes
Screen Shot Solutions in Alteryx - ETL Part 19 minutes
Screen Shot Solutions in Alteryx - ETL Part 212 minutes
Screen Shot Solutions in Alteryx - EDA Part 111 minutes
Screen Shot Solutions in Alteryx - EDA Part 29 minutes
Screen Shot Solutions in Alteryx - Control Tests Part 112 minutes
Screen Shot Solutions in Alteryx - Control Tests Part 210 minutes
Screen Shot Solutions in RStudio - ETL, EDA, Control Tests Part 110 minutes
Screen Shot Solutions in RStudio - ETL, EDA, Control Tests Part 210 minutes
Introduction to Alteryx6 minutes
Installing and Getting Started with Alteryx8 minutes
Accessing and Installing R and RStudio6 minutes
Controls and Auditing: Conclusion2 minutes

2 readingsTotal 20 minutes

Module 2 Overview10 minutes
Controls and Auditing: Readings & Files10 minutes

1 quizTotal 90 minutes

Controls and Auditing: Graded Quiz90 minutes

Numbers are everywhere in the financial statements. However, accounting is also about more than numbers. In this module, we discuss how text in accounting disclosure and other accounting information can contain useful information. We also demonstrate how to implement a basic natural language processing (NLP) pipeline using R.

What's included

11 videos2 readings1 quiz

11 videosTotal 83 minutes

Text Processing and Analysis in Accounting: Introduction2 minutesPreview module
Definitions for Text Analysis and NLP (Natural Language Processing)4 minutes
Text Analysis in Financial and Tax Accounting Part 111 minutes
Text Analysis in Financial and Tax Accounting Part 27 minutes
Text Analysis in Accounting6 minutes
Case Introduction4 minutes
NLP with Conference Calls Part 19 minutes
NLP with Conference Calls Part 210 minutes
NLP with Conference Calls Part 311 minutes
NLP with Conference Calls Part 414 minutes
Text Processing and Analysis in Accounting: Conclusion1 minute

2 readingsTotal 20 minutes

Module 3 Overview10 minutes
Text Processing and Analysis in Accounting: Readings & Files10 minutes

1 quizTotal 60 minutes

Text Processing and Analysis in Accounting: Graded Quiz60 minutes

Accountants do many things that are standardized and mundane. This module introduces you to robotic process automation (RPA) that can be used to automate those routine tasks. We begin by looking at the definition of RPA and where it stands in the automation continuum. We then examine suitable tasks for RPA, steps in implementing RPA, and pros and cons associated with using RPA. We will also discuss the effect of RPA on accounting. We conclude the module with a demonstration of RPA using UiPath.