Who Should Attend

This course is targeted to those who are currently working in

  • Sales, Marketing,
  • Supply Chain, 
  • Finance,
  • HR and/or
  • running your own business.

Although a good foundation in Excel and Pivot Table is recommended, it is okay to have little or no prior experience in data analytics but are interested to upgrade their knowledge and skills in this aspect to be able to extract and analyse financial and non-financial information to identify areas of growth in revenue and areas of wastage in cost.

Learning Objectives

Upon completion of the course, participants will be able to:

  1. Understand data management cycle to better handle information the organisation works with.
  2. Generate reports on trends and identify potential risks that affect organisation’s productivity.
  3. Collect appropriate data for analysis in an effective and efficient manner.
  4. Extract and validate data to ensure data accuracy and reliability.
  5. Identify trends and patterns across multiple datasets.
  6. Analyse data to derive insights and help organisation to make actionable business decisions 
  7. Evaluate the effectiveness of data analysis methods and approaches.

Course Outline

The course is divided into 4 main sections


  • What is Data?
  • How does Data flow from into your business and convert to insights?
  • Where is your data now and how to analyze it further?


  • Why you should protect your business data?
  • What tools are available in the market and how to choose the right one?
  • How you should handle your data and why it is important to get it right from the start?
  • What is Download, Transform and Load (DTL)?
  • Acquire practical skills in DTL through Power Query


  • Integrate information from multiple datasets
  • Combine data sets horizontally, similar but better than using VLOOKUP
  • Combine data sets horizontally, an automate way to copy and paste countries data together
  • Perform powerful calculations that you wish you can do with Pivot Table.


  • 6 different techniques you can use to analyze your business data
  • Identify patterns across different data sets
  • How to evaluate your data analytics performance

Program Dates

  • 28 - 30 Dec 2020 (Mon to Wed)
  • 18 - 20 Jan 2021  (Mon to Wed)
  • 03 - 05 Mar 2021 (Wed to Fri)
  • 27 - 29 Apr 2021 (Tue to Thu)
  • 17 -19 May 2021 (Mon to Wed)
  • 09 - 11 Jun 2021 (Wed to Fri)
  • 14 - 16 Jul 2021 (We to Fri)
  • 16 - 18 Aug 2021 (Mon to Wed)
  • 15 - 17 Sep 2021 (Wed to Fri)
  • 11 - 13 Oct 2021 (Mon to Wed)
  • 24 - 26 Nov 2021 (Wed to Fri)

Mode of Delivery

  • Face-to-Face

Course Duration

  • 3 days (8 hours each day) - 9 am to 6pm


Before Subsidy: S$1,600 per pax

Fundings and Support you can Apply to Defray the Cost of the Training

Self Sponsored

Company Sponsored

(Click on the individual Funding Types to find out more.)


If you need further clarifications, please send us a message using the form below and we will reply you ASAP.

[NOTE: The form is not a registration form. You have to contact us via email to register.]