Elevate Accounting with Analytics of R

Author

Jianyuan(Andy) Hu

Description

This seminar provides hands-on experience in completing a comprehensive data project and is designed by accountants for accountants. Participants will learn to harness power of R to transform a dataset into a vareity of professional reports (like PDFs, webpages, Excel workbooks, even PowerPoint) using open-source solutions, inspiring you to enhance your accounting workflows. We will delve into the mindset of analytics professionals and explore the synergy between analytics and accounting. The seminar will conclude with an overview of the current analytics and technology landscape, highlighting how accountants can capitalize on these trends. This course is designed to be welcoming for those new to analytics.

Length

8 hours.

Key Takeaways

Upon completion of this course, you will understand:

  • Introduction to R: Learn the fundamentals of R, an open-source data-focused programming language for beginners.

  • Data Management with R: Gain skills in importing, exporting, and processing data using R.

  • Automate Reporting with R: Build a practical department distribution workflows with R.

  • Advanced Data Visualization Techniques: Discover how to create impactful visualizations with R.

  • Professional and Versatile Publishing: Learn to build and publish professional reports of various file formats (webpage/html, PDF, PowerPoint, Word) effectively.

  • Adopting an Analytics Mindset: Explore essential concepts and key components of successful analytics projects.

  • Navigating the Analytics Landscape: Understand the current trends in analytics and data technology, along with foundational concepts of cloud computing.

Target Audience

This course caters to several professionals, including the following groups:

  • Analysts: Ideal for those with access to detailed data who seek to automate professional reports and visualizations using free open-source tools.

  • Managers: Designed for managers looking for inspiration and strategies to boost team productivity in reporting, particularly within budget constraints, or those interested in enhancing their understanding of modern analytics processes.

Prerequisite(s)

No previous programming knowledge required. This is beginner friendly session.

If you have never had programming experience before, it is highly recommended to take Excel Accounting with R first.

To get the most out of this session, you should have a few years of experience using Microsoft Excel. You should be comfortable with concepts like Pivot Tables, lookups, and basic functions such as SUM and SUMIFS.