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.
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.
An assessment will be conducted at the end of the course.
Fees and Funding
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.
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.
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