K2's Data Analytics For Accountants And Auditors

Overview

In the world of “Big Data,” virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in auditing, where internal and external auditors increasingly turn to data analytics to identify situations requiring follow-up and investigation. Those who understand how to use various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time.

In this session, you will learn about various tools and techniques you can use for more thorough data analyses. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft’s Power BI application. If you’re seeking to improve your skills in the field of data analytics, this session is the one for you!

Highlights

Understanding the importance of data analytics in modern business environments

Generating and interpreting data analytics using everyday applications such as Microsoft Office Excel and Microsoft's Power BI platform

Using regression analysis to create and validate forecasts and projections

Prerequisites

Basic knowledge of technology strategy and standards

Designed For

Practitioners and business executives who need to know more about data analytics and their importance

Objectives

List the four types of data analytics and identify situations in which each can be useful in auditing environments

Identify opportunities to use features in Excel to analyze data in the context of auditing

Distinguish between Business Intelligence and Data Analytics

Differentiate between correlation and causation

Cite examples of how Power Query, Power BI, and other tools can streamline and enhance Data Analytics

Preparation

None

Credits

Level

Code

Vendor

Fields of Study

Leader(s):

Stephen Yoss Jr., Stephen M. Yoss, Jr., CPA, MS is a ce, K2 Enterprises

Leader Bios

Stephen Yoss Jr., Stephen M. Yoss, Jr., CPA, MS is a ce, K2 Enterprises

Stephen M. Yoss, Jr., CPA, is the partner, and principal of Devmatics, LLC, a software development company that focuses on solving problems through the implementation of technology. Stephen has consulted with several companies on how to lower overhead, personnel and compliance costs by investing in technology and reengineering their business practices. He teaches his clients to embrace technology at every opportunity in order to increase efficiency and productivity.
Stephen began working with technology at age ten, and started his first IT company at age 13, designing web applications for local businesses. He has presented to thousands of practitioners nationwide on topics such as cloud computing, mobile technology, spreadsheet design and best practices, information security, identity theft prevention and many more.

Return to Top