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

SINGAPORE CITIZENS BELOW 40 years old / PERMANENT RESIDENTSIndividual or Non-SME Sponsored$256.80*
Sponsored by SME1$96.80*
SINGAPORE CITIZENSAged 40 and above2$96.80*
Aged 35 and above, and earn <=$2,000 per month3$56.80*
OTHERS $856*

* includes 7% GST

** Singapore Citizens aged 25 and above may use their SkillsFuture Credit to offset respective course fees
Up to 90% course fee funding for employees of SMEs under Enhanced Training Support for SMEs ("ETSS")
Up to 90% course fee funding under SkillsFuture Mid-Career Enhanced Subsidy ("MCES")
Up to 95% course fee funding under Workfare Training Support Scheme ("WTS")


Funding Incentives
 

1. SkillsFuture Series

Singapore Citizens or Singapore Permanent Residents are eligible for 70% course fee funding (excluding GST) for successful enrolment into approved courses under the Programme. This funding is applicable to both individual and company sponsored participants.

Singapore Citizens aged 40 and above will enjoy 90% course fee funding (excluding GST).
 

2. SkillsFuture Credit**

Singapore Citizens aged 25 and above may use their SkillsFuture Credits (up to S$500) to pay for the course fees. The credits may be used on top of existing course fee funding.

This is only applicable to self-sponsored participants. Applications via MySkillsFuture.sg must be made within 60 days before course commencement. Please click here for the user guide on how to submit your claim.
 

3. 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.
 

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 622 May 2019 (Open for Registration)
INTAKE 726 July 2019 (Fully Subscribed)
Intake 824 September 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