Certificate in Accounting Data and Analytics

Programme Code: CRS-N-0047143

Overview

This course which comprises the following topics will give participants an overview of how data and analytics can be applied in accounting

  • Introduction to Accounting Data and Analytics
  • Data Visualisation and Dashboarding
  • Data Management
  • Data Modelling and Forecasting
Next Course Starts On21 Feb 2019 (Thu) See Full Schedule
Fee SGD3424.00* (as low as SGD387.20* after maximum funding) Learn more
Duration

4 days

Level
Basic
Venue

SMU

Topics/Structure

Introduction to Accounting Data and Analytics
There is an increasing focus on big data for the accounting profession. Big data represents an opportunity for accountants to analyse the internal and external forces that influence their companies’ performance. By capitalising on big data, the role of accountants is moving beyond optimising the finance function to transforming the enterprise to sharpen competitive advantage.

The workshop focuses on how an organisation can leverage information through business analytics to achieve its goals. Participants will learn how to identify the information needs of an organisation as well as information that would drive competitive advantage. The objective of this workshop is to ensure that participants are able to:

  • Explain the fundamental concepts of business analytics, and how it can be a competitive advantage to the business.
  • Explain how business analytics may impact accounting function.
  • Understand how to establish analytics culture and capability.
  • Understand different types of analytics and analytical tools.
  • Understand how analytics may be embedded in business processes.


Data Visualisation and Dashboarding
This course will introduce participants to the principles behind data visualization and how to apply these principles using the MicroStrategy visualization tool. Participants will learn the techniques required to operate MicroStrategy and the enhanced functions it has for deeper analysis. This will form the basis for them to then use MicroStrategy to better analyse accounting data.


Data Management
By accurately recording data, updating and tracking them on an efficient and regular basis, companies can address their challenges on one hand and make use of the immense potential offered by this sector on the other hand. Database management systems are therefore crucial and important links in the creation as well as management of data. They are needed for effective running and management of data. One of the most popular database management system, available in the market is called relational database management system, because they are very easy and simple to operate. Topics include Database Design, ER Modeling and SQL basics. We will use MySQL server to practice the implementation of DB and querying of the data. The students will be given hands-on class activities to enable problem based learning environment.


Data Modelling and Forecasting
This course will introduce participants to a variety of data modelling & forecasting techniques. Participants will apply them in developing, implementing, and utilising analytical data models used to solve decision problems that accountants regularly face.

Who Should Attend

Finance and accounting professionals who want to learn more about how data and analytics can be applied in accounting.

Assessment

An assessment will be conducted at the end of the course.

Fees and Funding

SkillsFuture Series 

Course fee grant at 70% of course fees (excluding GST) for participants who are successfully enrolled by SMU into approved courses under the Programme. Participants must be Singapore Citizens or Singapore Permanent Residents.

SkillsFuture Mid-Career Enhanced Subsidy ("MCES")
Up to 90% of course fees for Singapore Citizens aged 40 years and above

Enhanced Training Support for SMEs ("ETSS")
Up to 90% of course fees for employees of SMEs who are Singapore Citizens or Permanent Residents

Workfare Training Support Scheme ("WTS")
Up to 95% of course fees for Singapore Citizens aged 35 years and above (13 years and above for persons with disabilities) earning a monthly income of not more than S$2,000.

SkillsFuture Credit
Singapore Citizens aged 25 and above, and self-funding may use their SkillsFuture Credit (up to S$500) to defray part of the course fee. Please click User Guide on how to submit your claim. SkillsFuture Credit claims may be submitted by logging in via MySkillsFuture.sg.

Absentee Payroll
Companies who sponsor their employees for the course may apply for Absentee Payroll via the SkillsConnect system. For more information, please visit SkillsConnect.

 

Full Fee: S$3,424 per participant (including GST)

 

Nett fee payable after SkillsFuture Singapore (SSG) Funding:

  • S$1,027.20 (including GST) for Singapore Citizens and Singapore Permanent Residents
  • S$387.20 (including GST) for Singapore Citizens aged 40 years and above

Schedule

Start Date(s)
Intake Information
intake 1

(Completed)

  • Introduction to Accounting Data and Analytics (6 September 2018)
  • Data Visualisation and Dashboarding (7 September 2018)
  • Data Management (13 September 2018)
  • Data Modelling and Forecasting (14 September 2018)
INTAKE 2

(Open for Registration)

  • Introduction to Accounting Data and Analytics (21 February 2019)
  • Data Visualisation and Dashboarding (22 February 2019)
  • Data Management (28 February 2019)
  • Data Modelling and Forecasting (1 March 2019)

 

 

Policies

Share this course