About this Course
18,329 recent views

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 42 hours to complete

Suggested: Eight weeks of study, three to five hours per week....

English

Subtitles: English

Skills you will gain

Develop an analytic mindsetClean and Merge DataVisualize DataAnalyze DataIntroduction to coding

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 42 hours to complete

Suggested: Eight weeks of study, three to five hours per week....

English

Subtitles: English

Syllabus - What you will learn from this course

Week
1
1 hour to complete

INTRODUCTION TO THE COURSE

2 videos (Total 5 min), 4 readings
2 videos
About Ronald Guymon2m
4 readings
Syllabus10m
Glossary10m
About the Discussion Forums10m
Update Your Profile10m
1 hour to complete

MODULE 1: INTRODUCTION TO ACCOUNTANCY ANALYTICS

12 videos (Total 60 min), 1 reading, 3 quizzes
12 videos
1.1.1 History and Future of Accounting6m
1.1.2 The Importance of Data and Analytics in Accounting4m
1.1.3 Humans' Relationship with Data6m
1.1.4 Accountants' Role in Shaping How Data Is Used6m
1.1.5 Data Analytics Tools: Spreadsheets vs. Data Science Languages6m
1.2.1 Advanced Data Analytics in Managerial Accounting Overview5m
1.2.2 Advanced Data Analytics in Auditing Overview4m
1.2.3 Advanced Data Analytics in Financial Accounting Overview7m
1.2.4 Advanced Data Analytics in Taxes Overview3m
1.2.5 Advanced Data Analytics in Systems Accounting Overview4m
Module 1 Conclusion1m
1 reading
Module 1 Overview and Resources10m
3 practice exercises
Lesson 1.1 Knowledge Check
Lesson 1.2 Knowledge Check
Module 1 Quiz
Week
2
2 hours to complete

MODULE 2: ACCOUNTING ANALYSIS AND AN ANALYTICS MINDSET

12 videos (Total 75 min), 1 reading, 4 quizzes
12 videos
2.1.1 Making Room for Empirical Enquiry6m
2.1.2 System 1 vs. System 2 Mindset7m
2.2.1 Linking Core Courses to Analytical Thinking6m
2.2.2 Inductive and Deductive Reasoning7m
2.2.3 Advanced Analytics and the Art of Persuasion7m
2.3.1 FACT Framework: Frame the Question6m
2.3.2 FACT Framework: Assemble the Data8m
2.3.3 FACT Framework: Calculate Results8m
2.3.4 FACT Framework: Tell Others About the Results6m
2.3.5 FACT Framework Review6m
Module 2 Conclusion1m
1 reading
Module 2 Overview and Resources10m
4 practice exercises
Lesson 2.1 Knowledge Check
Lesson 2.2 Knowledge Check30m
Lesson 2.3 Knowledge Check30m
Module 2 Quiz
Week
3
2 hours to complete

MODULE 3: DATA AND ITS PROPERTIES

12 videos (Total 57 min), 1 reading, 3 quizzes
12 videos
3.1.1 Characteristics that Make Data Useful for Decision Making6m
3.2.1 Structured vs. Unstructured Data6m
3.2.2 Properties of a Tidy Dataframe4m
3.2.3 Data Types5m
3.2.4 Data Dictionaries4m
3.3.1 Wide Data vs. Long Data3m
3.3.2 Merging Data4m
3.3.3 Data Automation1m
3.4.1 Visualization Distributions6m
3.4.2 Visualizing Data Relationships5m
Module 3 Conclusion1m
1 reading
Module 3 Overview and Resources10m
3 practice exercises
Lesson 3.2 Knowledge Check30m
Lesson 3.4 Knowledge Check30m
Module 3 Quiz
Week
4
3 hours to complete

MODULE 4: DATA VISUALIZATION 1

17 videos (Total 103 min), 1 reading, 5 quizzes
17 videos
4.1.1 Why Visualize Data?7m
4.1.2 Visual Perception Principles6m
4.1.3 Data Visualization Building Blocks9m
4.2.1 Basic Chart Data2m
4.2.2 Scatter Plots9m
4.2.3 Bar Charts7m
4.2.4 Box and Whisker Plots5m
4.2.5 Line Charts6m
4.2.6 Maps5m
4.3.1 Financial Chart Data5m
4.3.2 Waterfall Charts6m
4.3.3 Candlestick Charts6m
4.3.4 Treemaps and Sunburst Charts6m
4.3.5 Sparklines and Facets5m
4.3.6 Charts to Use Sparingly8m
Module 4 Conclusion2m
1 reading
Module 4 Overview and Resources10m
4 practice exercises
Lesson 4.1 Knowledge Check
Lesson 4.2 Knowledge Check
Lesson 4.3 Knowledge Check
Module 4 Quiz

Instructor

Avatar

Ronald Guymon

Senior Lecturer of Accountancy
Accountancy

Start working towards your Master's degree

This course is part of the 100% online Master of Science in Accountancy (iMSA) from University of Illinois at Urbana-Champaign. If you are admitted to the full program, your courses count towards your degree learning.

About University of Illinois at Urbana-Champaign

The University of Illinois at Urbana-Champaign is a world leader in research, teaching and public engagement, distinguished by the breadth of its programs, broad academic excellence, and internationally renowned faculty and alumni. Illinois serves the world by creating knowledge, preparing students for lives of impact, and finding solutions to critical societal needs. ...

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.