University of Illinois Urbana-Champaign
Introduction to Accounting Data Analytics and Visualization
University of Illinois Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization

Ronald Guymon

Instructor: Ronald Guymon

28,866 already enrolled

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
4.8

(435 reviews)

Beginner level
No prior experience required
Flexible schedule
Approx. 20 hours
Learn at your own pace
93%
Most learners liked this course
Gain insight into a topic and learn the fundamentals.
4.8

(435 reviews)

Beginner level
No prior experience required
Flexible schedule
Approx. 20 hours
Learn at your own pace
93%
Most learners liked this course

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

28 quizzes

Taught in English

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

Placeholder

Build your subject-matter expertise

This course is part of the Accounting Data 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
Placeholder
Placeholder

Earn a career certificate

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

Share it on social media and in your performance review

Placeholder

There are 9 modules in this course

In this module, you will become familiar with the course, your instructor and your classmates, and our learning environment. This orientation module will also help you obtain the technical skills required to navigate and be successful in this course.

What's included

2 videos6 readings1 discussion prompt1 plugin

In this module, you will learn how the accounting profession has evolved. You will recognize how data analytics has influenced the accounting profession and how accountants have the ability to impact how data analytics is used in the profession, as well as in an organization. Finally, you will learn how data analytics is influencing the different subdomains within accounting.

What's included

12 videos2 readings3 quizzes1 discussion prompt

In this module, you will learn to recognize the importance of making room for empirical enquiry in decision making. You will explore characteristics of an analytical mindset in business and accounting contexts, and link those to your core courses. You will then evaluate a framework for making data-driven decisions using big data.

What's included

12 videos2 readings4 quizzes

This module looks at specific characteristics of data that make it useful for decision making.

What's included

12 videos2 readings3 quizzes

In this module, you will learn fundamental principles that underlie data visualizations. Using those principles, you will identify use cases for different charts and learn how to build those charts in Excel. You will then use your knowledge of different charts to identify alternative charts that are better suited for directing attention.

What's included

17 videos2 readings4 quizzes1 peer review

In this module, you’ll learn how to use Tableau to do with data what spies do when observing their surroundings: get an overview of the data, narrow in on certain aspects of the data that seem abnormal, and then analyze the data. Tableau is a great tool for facilitating the overview, zoom, then filter details-on-demand approach. Tableau is a lot like a more powerful version of Excel's pivot table and pivot chart functionality.

What's included

13 videos2 readings3 quizzes

In this module, you'll be guided through a mini-case study that will illustrate the first three parts of the FACT model, with a focus on the C, or calculations part of the FACT model. First, you will perform a correlation analysis to identify two-way relationships, and analyze correlations using a correlation matrix and scatter plots. You will then build on your knowledge of correlations and learn how to perform regression analysis in Excel. Finally, you will learn how to interpret and evaluate the diagnostic metrics and plots of a regression analysis.

What's included

13 videos2 readings4 quizzes1 peer review

In this module, you’ll learn how the regression algorithm can be applied to fit a wide variety of relationships among data. Specifically, you’ll learn how to set up the data and run a regression to estimate the parameters of nonlinear relationships, categorical independent variables. You’ll also investigate if the effect of an independent variable depends on the level of another independent variable by including interaction terms in the multiple regression model. Another aspect of this module is learning how to evaluate models, regression or otherwise, to find the most favorable levels of the independent variables. For models that explain revenue, the most favorable levels of the independent variables will maximize revenue. In contrast, if you have a model that describes costs, like a budget, then the most favorable levels of the independent variables will minimize costs. Optimizing models can be difficult because there are so many inputs and constraints that need to be managed. In this module, you’ll learn how to use the Solver Add-In to find the optimal level of inputs. For some models, the dependent variable is a binary variable that has only two values, such as true/false, win/lose, or invest/not invest. In these situations, a special type of regression, called logistic regression, is used to predict how each observation should be classified. You’ll learn about the logit transformation that’s used to convert a binary outcome to a linear relationship with the independent variables. Excel doesn’t have a built-in logistic regression tool, so you’ll learn how to manually design a logistic regression model, and then optimize the parameters using the Solver Add-In tool.

What's included

12 videos2 readings3 quizzes

The lessons in this module are organized around several useful tasks, including stacking multiple dataframes together into one dataframe, creating multiple histograms to accompany the descriptive statistics, and learning how to perform k-means clustering. After going through this module, you’ll not only gain a foundation to help you understand coding, but you’ll also learn more about analyzing financial data. Along the way, I hope that you’ll also pick up on a few other useful Excel functions.

What's included

14 videos4 readings4 quizzes1 plugin

Instructor

Instructor ratings
4.9 (148 ratings)
Ronald Guymon
University of Illinois Urbana-Champaign
5 Courses77,650 learners

Offered by

Recommended if you're interested in Finance

Build toward a degree

This course is part of the following degree program(s) offered by University of Illinois Urbana-Champaign. If you are admitted and enroll, your completed coursework may count toward your degree learning and your progress can transfer with you.¹

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 435

4.8

435 reviews

  • 5 stars

    84.36%

  • 4 stars

    13.10%

  • 3 stars

    0.45%

  • 2 stars

    0.91%

  • 1 star

    1.14%

AZ
5

Reviewed on Sep 19, 2020

LY
5

Reviewed on Jun 2, 2020

KK
5

Reviewed on Jan 25, 2023

New to Finance? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions