Overview

Data are increasingly become the valuable assets to modern companies. Vast amount of data is being reported, collected, and analyzed by the companies involving the critical data such as accounting and finance. Accounting Analytics assist accounting professionals to analyse their accounting data. Accounting analytics help the companies to keep track of their firm performance, stay afloat in the complex and competitive business by remaining relevant through the digital transformation.

This 2-day workshop is suitable for professionals who have a basic understanding of Data Analytics. The workshop will focus on Accounting Analytics with the following skills, (1) extract, transform, and loading (ETL), (2) design principles for data visualization for accounting, and (3) generate insight from the accounting data. This workshop provides participants with extensive hands-on practice on accounting analytics using a popular business intelligence tool, PowerBI.


Teaching Team

What You’ll Learn

Topics
Objectives
Extract, Transform and Loading To handle and manipulate multiple data sets and data cleansing. To access, retrieve and prepare data for further analytics. To build data model.
Visualising Data: Dashboard Configuration To build rich and intuitive dashboard comprising multiple relevant and insightful visuals. To embed analytical context into visualisation.
Analytics and Intelligence To apply more in-depth analytics using formula and intelligence features.

Who Should Attend

  • Accountants and Auditors

SITizens Learning Credits (SLC) - Eligible Course

SIT Alumni: Before registering for courses, please activate your SITizens Learning Credits via the email sent by SIT Alumni Team, on behalf of SITLEARN Professional Development.

REGISTRATION CLOSED

Certificate and Assessment

A Certificate of Participation will be issued to participants who
  • Attend 75% of the workshop; and
  • Undertake non-credit bearing assessment (during course)

Schedule

Day 1
Topics
Extract, Transform and Loading
  1. Data Management & Relationships
  2. Data Cleansing
  3. Data Transformation
Extract, Transform and Loading
  1. Case Study
Visualising Data: Dashboard Configuration
  1. Familiarising with Power BI Visuals
  2. Visual Interaction Control
  3. Custom Visuals
Visualising Data: Dashboard Configuration
  1. Visualizing Accounting Data Case Study

Day 2
Topics
Analytics and Intelligence
  1. Time Intelligence
  2. Advanced Report
  3. Data Analysis Expressions (DAX)
Analytics and Intelligence
  1. Accounting Analytics Case Study 1
Analytics and Intelligence
  1. Accounting Analytics Case Study 2
Analytics and Intelligence
  1. Accounting Analytics Case Study 3
Assessment, Q&A, Summary

Fees

Category Full Fee After SF Funding
Singapore Citizen (Below 40) /
Singapore PR
$2,033.00 $609.90
Singapore Citizen (40 & above) $2,033.00 $229.90
Non-Singaporeans $2,033.00 Not Eligible

Note:
  • All figures include GST. GST applies to individuals and Singapore-registered companies.
  • You can opt for either SF Series Funding or Mid-Career Enhanced Subsidy. Both cannot be combined.

» Learn more about funding types available

Terms & Conditions:

SkillsFuture Series Course Funding


In order to be eligible for the 70% training grant awarded by SkillsFuture, applicants (and/or their sponsoring organisations where applicable) must:
  1.  Be a Singaporean Citizen or Singapore Permanent Resident
  2.  Not receive any other funding from government sources in respect of the actual grant disbursed for the programme

SkillsFuture Mid-Career Enhanced Subsidy

To be eligible for the 90% enhanced subsidy awarded, applicants (and/or their sponsoring organisations where applicable) must:
  1.  Be a Singaporean Citizen
  2.  Be at least 40 years old
  3.  Not receive any other funding from government sources in respect of the actual grant disbursed for the programme

SIT reserves the right to collect the balance of the programme fees (i.e. the potential grant amount) directly from the applicants (and/or their sponsoring organisations where applicable) should the above requirements not be fulfilled.

SIT reserves the right to make changes to published course information, including dates, times, venues, fees and instructors without prior notice.

Key Info

Venue SIT@Dover, 10 Dover Drive S138683
Time 09:00 AM to 06:00 PM
Date 24 Jun 2021 (Thu) to
25 Jun 2021 (Fri)
Registration is Closed.

You May Also Like