Debit Databases, Credit Analytics for Accounting

Author

Jianyuan(Andy) Hu

Description

Between self-analytics and big data, accountants are directly exposed to databases, more often than ever. This specialty seminar introduces accountants to relational databases and inspires audience how to satisfy reporting and data analysis tasks — making workflows efficient, and scalable. With hands-on examples tailored to accounting workflows, audience will gain confidence in managing and querying data with relational database, preparing them for collaboration across teams in modern analytics environment.As a big bonus, audience get to develop analytics mindset and further enhance their analytical literacy through exposure to a modern data platform, Microsoft Fabric.

Length

8 hours.

Key Takeaways

Upon completion of this course, you will understand:

  • Using R to conduct data processing and automate workflows
  • Introduction to relational databases, SQL and server-client computing
  • Develop and application of analytics engineering mindset
  • Understanding key components to modecrn data platform through one of the most popular option, Microsoft Fabric
  • Navigating the Analytics Landscape: Understand the current trends in analytics and data technology, along with foundational concepts of cloud computing.

Target Audience

This course appeals to several demographics:

  • Analysts, especially who

    1. have access to detailed data through databases and seek opportunities to improve work life through automation

    2. want to advance skills in or pivot toward data analytics speace;

  • Managers, especially who

    1. seek inspirations to improve team’s financial reporting productivity with Power BI,

    2. lead financial reporting modernization projects,

    3. want to stay relevant with staff and colleagues about Power BI and effective data visualization techniques

Prerequisite(s)

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

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.