Skip to main content

K2's Data Analytics for Accountants and Auditors

Thursday, Aug. 13
 10:00am - 2:00pm

(Check-In )

Add to Calendar

Online

4.00 Credits

Member Price $160.00

Price will increase by $20 after 8/6

Non-Member Price $225.00

Price will increase by $20 after 8/6

Overview

In today’s world of “Big Data,” every business professional is a data analyst to some extent. This is especially true for auditors, who increasingly rely on data analytics to identify situations that require follow-up and investigation. Those who master the tools and techniques for thorough data analysis can achieve superior results in less time.

Join our dynamic session to unlock the full potential of data analytics! You’ll explore various tools and techniques, including Excel, multiple Excel add-ins, and Microsoft’s Power BI application. Whether you’re looking to enhance your skills or dive deeper into the world of data analytics, this course is designed for you.

Our expert instructors will guide you through practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. Don’t miss this opportunity to elevate your data analysis skills and stay ahead in your field. Enroll now and transform your approach to data analytics!

Objectives

  • Compare 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
  • Compare examples of how Power Query, Power BI, and other tools can streamline and enhance Data Analytics

Highlights

  • Understanding the importance of data analytics in modern business environments
  • Generating and interpreting data analytics using everyday applications such as Microsoft Excel and Microsoft's Power BI platform
  • Using regression analysis to create and validate forecasts and projections
  • ,/ul>

    Designed For

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

    Prerequisites

    Basic knowledge of technology strategy and standards

    Preparation

    None

    Notice

    To access this program, log into your CTCPA account at https://www.ctcpas.org/my-cpe/upcoming and click on the orange "Launch Event" button.

Leader(s):

Leader Bios

Lawrence McClelland, Associate, K2 Enterprises, LLC

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Return to Top

Non-Member Price $225.00

Member Price $160.00