Course Information

  • 3 Days
Time: 9am to 6pm
Fee: $1605 (Inclusive of GST)

Online Self-Assessment

Not sure of which course to enrol?
Take this quick online-self assessment!
(not more than 5 minutes)

Register Your Interest

To register, please email us at or call us at 6386 5638.


Understanding more about data analytics and knowing how to process data beyond the basic knowledge of using MS Excel, is fast becoming an asset in a highly data-driven working environment.

This Fundamental course is a step ahead of the Basic-level programme and will further expose you to more advanced statistical tools and analytical techniques, including descriptive and prescriptive analysis and its application in the public sector. You will also get to work on hands-on exercises to explore basic programming using Visual Basic for Applications in Excel.

Topics Covered

  • Overview of Data Analytical Process
  • Population & Sampling
  • Data Cleaning & Preparation
  • Review of Descriptive Analysis
  • Basic Predictive Analysis
  • Using Excel to Perform Basic Predictive Analysis
  • Introduction to Coding & Visual Basic for Applications (VBA) in Excel
  • Effective Data Visualisation using Qlik Sense/ Power BI
  • Case Studies

Who Should Attend

  • Officers who use data frequently at work and want to be better equipped to explore, analyse and present their data better
  • Recommended Entry Requirements: Basic understanding of statistics and data analysis. Proficient in using MS Excel


  • Excel
  • Qlik Sense/ Power BI

Other Information

  • Refreshments and tea breaks will be provided twice daily
  • Participants must achieve 70% for the Applied Learning Assessment and 85% attendance to receive the Certificate of Completion
  • Registration closes 2 weeks before the scheduled class date or when the class is full, whichever is earlier
  • FMG reserves the right to postpone or cancel the class should the minimum class size is not met and participants will be informed accordingly ahead of the scheduled date
  • Learning materials, laptop and software are provided on site