Data Analytics @ Work

Programme Code: CRS-N-0044721

Overview

Learn simple but powerful ways to work with data.

Have you ever wondered how you could generate relevant information and gain insights from your data using Microsoft Excel? Become an Excel power user and increase your job efficiency by equipping yourself with emerging data analysis skills in an increasingly digitalised workplace.

Developed in partnership with Deloitte, this basic level course is designed to equip you with relevant Excel skills for the purpose of analysing data in business applications.

You will learn how to import data from various sources, merge data and organise them for visual presentation, and analyse the data to gain insights to support decision making. 

Next Course Starts On30 Apr 2019 (Tue) See Full Schedule
Fee SGD856.00* (as low as SGD96.80* after maximum funding) Learn more
Duration

1 day

Level
Basic
Venue

SMU

Programme Partner

Deloitte

Learning Objectives

By the end of the course, participants will be able to

  • Structure, clean, validate, and mine large datasets

  • Prepare classic horizontal-vertical financial statement analyses

  • Apply graphical and statistical analytics tools to reveal patterns, signals, and meanings in the data

  • Produce robust project finance analyses (including NPV and RoI)

  • Build simple models to forecast trends

  • Create dashboards and geospatial presentations within MS Excel to aid communication 

Who Should Attend

Managers, Data Analysts, Professionals, Executives and support staff involved in data collection, analysis and presentation for management decision making.

Assessment

Course assessment will be based on classroom exercises and case studies.

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$856 per participant (including GST)

 

Nett fee payable after SkillsFuture Singapore (SSG) Funding:

  • S$256.80 (including GST) for Singapore Citizens and Singapore Permanent Residents
  • S$96.80 (including GST) for Singapore Citizens aged 40 years and above

Schedule

Start Date(s)
Intake Information
intake 117 April 2018 (Completed)
intake 226 July 2018 (Completed)
intake 310 December 2018 (Completed)
INTAKE 418 February 2019 (Completed)
INTAKE 530 April 2019 (Fully Subscribed)
INTAKE 626 July 2019 (Open for Registration)

 

Speaker/Trainer Bio

Dr Lim Chun Ping
Cognitive Analytics Solution Centre Lead
Deloitte Southeast Asia

Dr Lim is the lead of Cognitive Analytics Solution Centre of Excellence with Deloitte Southeast Asia, a Centre of Excellence set up in collaboration with the Singapore Economic Development Board hosted in Singapore, focussing on applying cognitive, predictive analytics to solve critical risk issues. His experience spans research and product development in the areas of seeking balance between innovation, risk, and sustainability. In the field of analytics, Dr Lim’s work include:

  • Risk sensing technology platform for near real time analytics in on-demand topic monitoring using natural language processing, product defects/complaints monitoring from social media, and cyber security risk scoring of suspicious IP addresses
  • A proprietary and awards winning technology AI-based risks discovery, predictive analytics and continuous monitoring platform, providing on-demand intelligence

Dr Lim’s current projects are centered on technology foresight, advanced analytics, and risk management.

Policies

Share this course