Вернуться к Introduction to Accounting Data Analytics and Visualization

4.8
звезд
Оценки: 386

## О курсе

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R. We’ve divided the course into three main sections. In the first section, we bridge accountancy to analytics. We identify how tasks in the five major subdomains of accounting (i.e., financial, managerial, audit, tax, and systems) have historically required an analytical mindset, and we then explore how those tasks can be completed more effectively and efficiently by using big data analytics. We then present a FACT framework for guiding big data analytics: Frame a question, Assemble data, Calculate the data, and Tell others about the results. In the second section of the course, we emphasize the importance of assembling data. Using financial statement data, we explain desirable characteristics of both data and datasets that will lead to effective calculations and visualizations. In the third, and largest section of the course, we demonstrate and explore how Excel and Tableau can be used to analyze big data. We describe visual perception principles and then apply those principles to create effective visualizations. We then examine fundamental data analytic tools, such as regression, linear programming (using Excel Solver), and clustering in the context of point of sale data and loan data. We conclude by demonstrating the power of data analytic programming languages to assemble, visualize, and analyze data. We introduce Visual Basic for Applications as an example of a programming language, and the Visual Basic Editor as an example of an integrated development environment (IDE)....

## Лучшие рецензии

YH

30 мая 2020 г.

It teaches us the basics of data analytics and it is very progressive. There are assignments to help us understand and practice the methods being taught. This allows us to have first-hand experiences.

CT

6 нояб. 2021 г.

I have learn a lot of solid knowledge about Data Visualization, Excel VBA, and programming hints from this course. I recommend this course to those who wants to skill up on Excel and Data analytic.

Фильтр по:

## 26–50 из 71 отзывов о курсе Introduction to Accounting Data Analytics and Visualization

автор: Yeo Z H

31 мая 2020 г.

It teaches us the basics of data analytics and it is very progressive. There are assignments to help us understand and practice the methods being taught. This allows us to have first-hand experiences.

автор: CHENG L T

7 нояб. 2021 г.

I have learn a lot of solid knowledge about Data Visualization, Excel VBA, and programming hints from this course. I recommend this course to those who wants to skill up on Excel and Data analytic.

автор: Lee Y

3 июня 2020 г.

The lecturer is very concise and goes through concepts in depth by showing examples that build on top of previous knowledge and used dataset that was previously introduced.

автор: Michael J

18 дек. 2020 г.

Instruction was clear and I found all of the information presented to be useful in my current work with Excel spreadsheets. Now I'm keen to learn Python!

автор: Toh P Q

27 сент. 2020 г.

For a beginner at excel, this course really teaches you a lot about data visualisation and organising data in excel and other similar applications.

автор: Raji R

24 авг. 2020 г.

Excellent course. I loved it from the beginning to the end. Enjoyed throughly the two assignments. Professor teaching skill is increadible

автор: Annabelle S S Z

20 сент. 2020 г.

Love the enthusiasm of the professor Ronald Guymon and the module helps me with learning more about the use of Excel and its VBA functions

автор: GOH K Y

9 июля 2020 г.

Being the first online module I've ever taken to date, the content and videos far surpassed my expectations. Looking forward to more!

автор: Jaslyn L

9 июля 2020 г.

This is a really helpful course! I have learned not only about using Excel for accounting, but also the many functions of Excel.

автор: Yunchae S

20 мая 2021 г.

It was really good.

Actually, before week 7, general contents are a bit tedious, but week 7 and 8 was perfect.

Thank you so much

автор: Sithandazile Z D

2 сент. 2020 г.

I really enjoyed the course and the lecture was very interactive, clear & precise in such a way i felt i was in a classroom.

автор: Chiam Z S

1 июня 2020 г.

The two lab sessions were useful and the speaker was well present himself and his points making it easy to understand him.

автор: Goh J Y D

12 авг. 2020 г.

The course enables its learners to get a hands-on experience using tools to accounting data analytics and visualisation.

автор: Fabian T

5 июля 2020 г.

Excellent and interesting videos, not too long but not too short. Lengthy enough to be very informational and helpful.

автор: Jesús A S G

2 февр. 2022 г.

enought materials, good teacher, I feel confident just want to keep learning about interpreting the numbers/data

автор: Jurgita Z

19 июля 2020 г.

This course is so useful. The instructor is awesome!

I am very happy to have attended this cours. Thanks!

автор: Edmund K C H

20 июля 2020 г.

Enriching course that really helps brings new comers into the world of data analytics and visualization

автор: Muhammad A B A R

25 июня 2020 г.

It provides a lot of hands on example that really help with the explanation of the concepts taught

автор: Mutra T T W K

16 июля 2020 г.

Great overview of data analytics. Teaches you basic tools that can be useful for basic analysis.

автор: Loh D W

27 мая 2020 г.

автор: Kyoungmo K

22 окт. 2021 г.

Great course to transform traditional mindset of accounting into data analytics

автор: Phoa J L

31 мая 2020 г.

A course with an excellent overview of data analytics suitable for beginners.

автор: Lim T F

11 авг. 2020 г.

Fantastic course with many infomative videos which is really helpful.

автор: Chow K M

17 июня 2021 г.

G​reat introduction to the basics of data analysis using Excel.

автор: Manmohan D

10 нояб. 2021 г.

Covered a wide range of topics in a brief and clear manner !