Analytics for Non-Analytics Professionals
(IBF Level 1)

Course Dates:

18 – 19 November 2019

Duration:

2 days (9am – 5pm)

Level:

Basic

Course Fee:

SGD $1,200*
(as low as SGD $120 after maximum funding).

*Fee is inclusive of tea-break snacks and lunch buffet.

Make Smarter Decisions with Data Analytics

This is an awareness workshop designed for professionals without an analytics background to give you a good understanding of, and appreciation for, data analytics and how to effectively use it. It is also designed to give you some critical skills in data analysis.

This workshop will introduce you to the world of analytics through examples, stories and case studies. You will also get multiple opportunities to apply your insights to come up with ideas on the applications of analytics within your organisation and your respective teams.

This workshop is a 2-day classroom facilitated workshop and involves activities, hands-on exercises and brainstorming sessions. On day 1, you will experience a hands-on session during which you will learn how to use pivot tables in Excel to analyse large datasets quickly and efficiently. On day 2, you will also get to learn and apply regression, a very popular and versatile predictive analytics technique.

Overview

Course Objectives

Course Modules

Fees and Funding

Trainer Profile

Who Should Attend
This course is ideal and suitable for:

  • Managers and Directors
  • Professionals in the banking and finance industry
  • Those who are relatively new to data analysis
  • Those who needs to make business decisions

Key Highlights

  • Hands-on approach to learning analytics
  • Learning through case studies and examples
  • Tools to make data analysis faster, richer and more insightful

Pre-Requisite
Basic knowledge of MS Excel

Assessment and Certification
An assessment will be conducted at the end of the course. Upon successful completion of both the course and assessment, participants will be awarded a Certificate of Completion.

  • Understand the banking system and the process of revenue generation in a bank
  • Identify the types of data available in consumer banking
  • Understand the importance of data in aligning consumer behaviour with bank activities
  • Understand the objectives of data mining and data analytics
  • Understand methods to create and capture data for MIS or analysis
  • Understand data collection processes and systems
  • Understand data validation methods
  • Understand the importance of data quality in the data collection process
  • Understand what is data analytics and the different types of data analytics
  • Appreciate the key questions that analytics can answer
  • See examples of the applications of analytics across functions and industries
  • Learn 6 key steps in analytical decision making
  • Understand some of the basic data and statistical principles that form the foundation of data analytics
  • Perform data analysis using Microsoft Excel (including pivot tables and Excel functions)
  • Create basic dashboards in Excel using pivot tables, charts and slicers
  • Appreciate some of the common techniques used in predictive analytics
  • Perform regression using Excel for predictive analytics on case studies
  • Identify opportunities for the application of analytics within the organisation
  • Learn about the global trends in analytics and how they are impacting the world

Module 1: What is data analytics

  • Overview of data analytics
  • Classification of data analytics

Module 2: Analytics in action

  • Applications of analytics
  • When analytics cannot be applied

Module 3: Framework for analytical decision making

  • The 6-step framework for analytical decision making

Module 4: Understanding data and its tools

  • Statistical techniques and data analysis
  • Data analysis using pivot tables and Excel

Module 5: Introduction to predictive analytics

  • Principles of predictive modelling and machine learning
  • Common applications of predictive analytics

Module 6: Regression with MS Excel

  • Simple linear regression
  • Multiple linear regression

Module 7: Case study analysis and presentation

  • Case study analysis
  • Communicating insights through data visualizations

Module 8: The future of analytics and trends

  • How can analytics impact organizations

A) IBF Standards Training Scheme (IBF-STS)

This programme has been accredited under the IBF Standards, and is eligible for funding under the IBF Standards Training Scheme (IBF-STS), subject to all eligibility criteria being met.

Funding Available for Singapore Citizen / 
Permanent Resident
Singapore Citizen
(Aged 40 years and above)
Course Fee $1,200 $1,200
Less Grant Amount
(Subsidy)
$840
(70%)
$1,080
(90%)
Nett Fee $360 $120

Eligible participants:

1. Non-Company sponsored
Non company-sponsored participants are required to be Singapore Citizens or Singapore Permanent Residents physically based in Singapore.

2. Company-sponsored
Company-sponsored participants are required to be Singapore Citizens or Permanent Residents, physically based in Singapore. Company sponsors refer to Financial Institutions regulated by MAS (either licensed or exempted from licensing).

For more information on the funding, please visit: www.ibf.org.sg

B) Skills Future Credit (SFC)

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. To find out how to submit your claim, visit the SkillsFuture Credit website at www.skillsfuture.sg/credit.

Saurabh Anand is an experienced business management professional, trainer and second generation entrepreneur with expertise in technology, strategy, analytics, business management and learning and development. He has lived and worked in India, Singapore, Philippines, Germany, UAE and USA and has travelled extensively in Asia, Europe and USA which has helped him develop excellent cross-cultural skills and sensitivities.

Saurabh is a Distinction Engineering Graduate from the University of Mysore, India and a Distinction MBA Graduate from the Asian Institute of Management, Manila, Philippines. He has also been an exchange student at the Tuck School of Business, Dartmouth New Hampshire, USA.

Saurabh has an Advanced Certificate in Training and Assessment (ACTA) qualification. He serves as an empanelled trainer of the Civil Service College, Singapore. He has also received the Adult Education Professionalisation (AEP) Award from the Institute of Adult Learning (IAL).

View Profile

What our participants say about this workshop…

Need help? Speak with us today.




Stay in the know!

Join our mailing list and be the first to receive notifications about our workshops and upcoming events.

*By providing the above information, I give my consent for Accord to contact and/or send me marketing related materials about their products and services.