fbpx
🎉 Stay safe and learn from the convenience of your home. All classes are conducted virtually. 🧑‍💻
Online Instructor-Led Classes

Data Analytics Bootcamp

Learn Excel, SQL and Tableau from expert data analysts in Singapore.

✅  Up to 90% IBF Subsidy For All Singaporeans & PRs
✅  Balance fees claimable with SkillsFuture Credits or NTUC UTAP
✳️  Beginner-friendly, zero background knowledge required

Data Analytics Skills Command A Salary Premium

Data analytics is an integral part of every business in Singapore. To thrive in today’s business landscape, it is crucial to learn how to leverage data to make critical business decisions.

Learn industry tools: Excel, SQL and Tableau to analyse big data and create dashboards and visualisations to share your findings.

Our graduates from this data analytics course have come from GIC, GovTech, LinkedIn, JP Morgan, UBS, Citibank, Oracle, Lazada, ExxonMobil, and more.

Data Analytics Course Details

Vertical Institute’s Data Analytics course in Singapore is designed to equip individuals with the most in-demand skills and best practices in data analytics, covering industry tools: Excel, SQL and Tableau. Participants will culminate their learning by developing a capstone project to solve a real-world big data problem in the fintech industry.

This data analytics course is beginner-friendly. No prior background or experience is required.

What to expect?

  • Learn new concepts and tools through expert-led lectures, discussions, assignments and project work

  • Apply what you’ve learned to create a capstone project solving a real-world data problem

  • Receive individualised feedback and support from your instructional team with free 1-on-1 consultations

  • Be part of the VI community where members can leverage connections with alumni, instructors and experts

Course Fee & Government Subsidies

Self-Sponsored - June Intakes

Full Course Fee With GST $2,675 (for Foreigners)
Course Fee After 80% IBF Subsidy With GST $535 (for Singaporeans aged below 40 years and all PRs)
Course Fee After 90% IBF Subsidy With GST $267.5 (for Singaporeans aged 40 years and above)

*All Singaporeans aged 25 years old and above can use their SkillsFuture Credits to fully offset the remaining $267.5 or $535 after funding.

*In addition, NTUC members can utilize UTAP to offset 50% of remaining fees (capped at $250 per year).

Self-Sponsored - July Intakes

Full Course Fee With GST $2,675 (for Foreigners)
Course Fee After 70% IBF Subsidy With GST $802.5 (for Singaporeans aged below 40 years and all PRs)
Course Fee After 90% IBF Subsidy With GST $267.5 (for Singaporeans aged 40 years and above)

*All Singaporeans aged 25 years old and above can use their SkillsFuture Credits to fully offset the remaining $267.5 or $802.5 after funding.

*In addition, NTUC members can utilize UTAP to offset 50% of remaining fees (capped at $250 per year).

Company-Sponsored

For June intakes - Companies in Finance and Banking Industries
Full Course Fee With GST $2,675 (for Foreigners)
Course Fee After 80% IBF Subsidy With GST $675 (for Singaporeans aged below 40 years and all PRs)
Course Fee After 90% IBF Subsidy With GST $425 (for Singaporeans aged 40 years and above)

Companies NOT in the Finance and Banking Industries
Full Course Fee With GST $2,675 (for Foreigners)

For July intakes - Companies in Finance and Banking Industries
Full Course Fee With GST $2,675 (for Foreigners)
Course Fee After 70% IBF Subsidy With GST $925 (for Singaporeans aged below 40 years and all PRs)
Course Fee After 90% IBF Subsidy With GST $425 (for Singaporeans aged 40 years and above)

Companies NOT in the Finance and Banking Industries
Full Course Fee With GST $2,675 (for Foreigners)

Data Analytics Course Schedules

7 lessons,
3 hours each lesson

Online classes
via Zoom

1 Instructor and 2-3
Teaching Assistants

Data Analytics Course Curriculum

Pre-Work

As a VI student, you will be given access to online learning materials in our e-learning portal.

To get you ready for learning, this essential pre-work will familiarize you with the basics of the key concepts and tools we will be using throughout the course.

Although you will learn these topics remotely before you arrive in class, you won’t be far away from the resources of the VI community. Make use of our Telegram channel to leverage connections with students, alumni, instructors and experts. At the end of your pre-work, you’ll be ready for the fast pace on campus!

After the course, you can choose to participate in follow-up sessions with your instructor, either in a group and/or individually, included as part of the course fee.

Module 1: Data Analysis & Excel Fundamentals

Tutorials:

  • Introduction To The Course
  • The Data Analysis Process
  • Introduction To Data Visualization
    • Pre-attentive vs Attentive Processing
    • Good And Bad Visualisation Practices
  • Data Referencing, Aggregation And Analysis With Excel
    • VLookup
    • Pivot Table
    • Pivot Chart
Module 2: Introduction to SQL & Databases

Tutorials:

  • Introduction To SQL & Databases
  • Database Connection
  • SQL Syntax
  • SQL Aggregation Functions
    • Count, Sum, Group By, Having and Where
      Module 3: SQL Fundamentals

      Tutorials:

      • Combining Data in SQL
        • JOIN Function
        • Inner, Outer, Left, Right and Full JOINS
        • UNION Function
      • Applying SQL Functions
        • String, Math & Date Functions
      • Using Logic In SQL
        • Conditional Expressions
      Module 4: Data Visualization Fundamentals

      Tutorials:

      • Introduction To Data Visualization
      • Data Visualisation Tools In The Industry
      • Introduction to Tableau
      • Charts & Table Calculations
        • Bar Chart
        • Quick Table Calculations
        • Line Chart
        • Area Chart
      Module 5: Data Analysis With Tableau

      Tutorials:

      • Data Analysis Techniques With Tableau
      • Segmentation Analysis
        • Groups, Sets
        • Difference between Groups & Sets
        • Combine Sets
        • Bins
      • Investment Scenario & What-If Analysis
      Module 6: Dashboards & Storytelling With Tableau

      Tutorials:

      • Dashboard Creation & Storytelling
      • Investment Analysis Dashboard
      • Create Maps
      • Interactive Dashboards
      • Table Calculations
      Module 7: Advanced Tableau & Capstone Project

      Tutorials:

      • Advanced Analytics With Tableau
        • Data Blending
        • Scatter Plot Animation
        • Level Of Detail (LOD)
        • Tableau Server
      • Capstone Project Discussion
      The Capstone Project

      Participants will be required to address a data-related problem using a real-world dataset. You will acquire a real-world dataset, then prepare, clean, and analyze it to draw meaningful conclusions.

      The individual open-book capstone project will culminate your learning by applying the new tools and concepts learnt to create a short report that includes:

      • A summary of the data acquisition, cleaning, and parsing stages.
      • A clear visualization or dashboard that displays insights both numerically and graphically.
      • A description of high-level insights and resulting actions that are relevant to key stakeholders.

      Instructors

      Hong Lin

      Hong Lin

      Head of Business Intelligence @ Ant Financial
      MSc in Knowledge Management &
      B.Eng
      Nanyang Technological University

      Clarence

      Clarence

      Analyst @ Google
      Masters in IT Business (Analytics) & BAcc
      Singapore Management University

      Sifat

      Sifat

      Analytics Consultant @ SIFT Analytics
      Bachelor of Engineering
      Singapore University of Technology & Design

      Stan

      Stan

      Data Scientist @ Standard Chartered
      Masters in Computing, B.Sc
      National University of Singapore

      Lindsay

      Lindsay

      Data Analyst @ FoodPanda
      Bachelor of Science
      Nanyang Technological University

      Funding Support

      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.

      Find out more on www.ibf.org.sg.

      Frequently Asked Questions

      Are there course fee subsidies available?

      Yes, there is up to 90% funding support from The Institute of Banking & Finance (IBF) for our IBF-accredited programmes:

      The IBF Standards Training Scheme (“IBF-STS”) provides funding for training and assessment programmes accredited under the Skills Framework for Financial Services.

      For our training programmes that are IBF-accredited, eligible Singaporeans & PRs may receive funding support under the IBF Standards Training Scheme (IBF-STS), subjected to all eligibility criteria being met.

      For more information on the funding support, please visit: https://www.ibf.org.sg/programmes/Pages/IBF-STS.aspx

      Can I use SkillsFuture Credits to pay for the remaining course fee after funding?

      Yes. For self-sponsored Singaporeans aged 25 years old and above, you can use your SkillsFuture Credits to fully offset the remaining course fees after funding. This means that you do not need to pay any cash.

      After you have registered for a course, a VI representative will reach out to guide you with the SkillsFuture Credits claim application.

      Can NTUC Union members use UTAP to offset the remaining course fee after funding?

      Yes, all our courses are eligible for Union Training Assistance Programme (UTAP) Funding. NTUC Union members can use UTAP to offset 50% of unfunded course fees (capped at $250 per year).

      For example: If your remaining course fees are $267.50, you can offset $133.75 with UTAP.

      This claim must be done after completion of the course. Please refer to the UTAP FAQ for more information.

      Can I use SkillsFuture Credits and UTAP at the same time?

      Yes, you can utilize both at the same time. UTAP can only be applied after SFC has been applied.

      For illustration purposes only:

      (a) Full Course Fees with GST $2,675
      (b) Less IBF Subsidy (e.g. 90%) ($2407.50)
      (c) Course Fee Payable (after IBF Subsidy) $267.50
      (d) SkillsFuture Credit ($200)
      (e) NTUC Member pays $67.50
      (f) NTUC Member claims 50% of (e) from UTAP $33.75

      Who is eligible for IBF funding support?

      For Self-Sponsored:

      All Singaporeans or Singapore Permanent Residents (PRs) that are physically based in Singapore and successfully complete the course will be eligible.

    • Be a Singaporean Citizen or PR physically based in Singapore
    • Minimum of 75% attendance (this means that you must attend at least 6 out of 7 lessons)
    • Pass the assessment
    •  

      For Company-Sponsored:

    • Be from Financial Institutions that are regulated by the Monetary Authority of Singapore (MAS) (either licensed / exempted from licensing) or Fintech companies that are registered with the Singapore Fintech Association.
    • Be a Singaporean Citizen or PR physically based in Singapore
    • Minimum of 75% attendance (this means that you must attend at least 6 out of 7 lessons)
    • Pass the assessment
    • How do I obtain IBF funding support? Do I need to pay the full fee first?

      This funding support works on a nett fee model. This means that participants only need to pay the remaining course fees after IBF funding. This nett fee can be fully paid with your SkillsFuture Credits.

      For Self-Sponsored:

      You must be a Singaporean or Singapore Permanent Resident (PR) that is physically based in Singapore. You will only need to pay the course fees minus the funding support. For example, if you are eligible for 90% funding support, you will only be paying S$267.50 nett, which can be paid with your SkillsFuture Credits.

      For Company-Sponsored:

      You must be a Singaporean or Singapore Permanent Resident (PR) that is physically based in Singapore and working in an eligible company:

    • Financial Institutions that are regulated by the Monetary Authority of Singapore (MAS) (either licensed / exempted from licensing)
    • Fintech companies that are registered with the Singapore Fintech Association
    •  

      Your company will pay the course fees minus the funding support. For example, if you are eligible for 90% funding support, the company will be paying S$425 nett for company-sponsored participants.

      Eligible companies will further be able to claim the remaining course fees after funding with the Training Allowance Grant (TAG) (S$10/hour of eligible training and assessment hours).

      Are there any pre-requisites for this course?

      This program is suitable for beginners with no pre-requisites.

      Is there a certificate granted at the end of the course?

      Upon successful completion of this IBF-accredited course, participants will be awarded a digital certificate recognized by employers. VI alumni use their course certificate to demonstrate skills to employers and their LinkedIn network.

      Our programmes are well-regarded by top companies, who contribute to our curriculum and use our courses to train their own teams.

          What is Tableau?

          Tableau is one of the most powerful and fastest growing data visualization tools used in the Business Intelligence industry. It helps in simplifying raw data into easily understandable formats to derive actionable results. It is becoming one of the most useful tools for any business organization. 

          It has an easy to use drag and drop interface to build beautiful visualizations easily and in a short amount of time.  Visit the Tableau Public Gallery to see beautiful real world projects by Tableau users.

              What is SQL?

              Structured Query Language (SQL) is the standard and most widely used programming language for relational databases. It is used to manage and organize data in all sorts of systems in which various data relationships exist. SQL is a valuable programming language with strong career prospects.

                  What softwares do I need to download?

                  In the data analytics course, you will be learning 3 key industry tools: Excel, SQL and Tableau.

                  The SQL portion will be web-server based, hence no installation is required. You will only need to download Tableau Public, which is free and easy to download.

                  Your instructional team will guide you step-by-step on the installation process.

                  Marcella Tang

                  Data Analytics Alumni

                  Currently working at Amazon Web Services (AWS), this course has equipped me with data analytics skills needed for my tech career!

                  Data Analytics Capstone Project by Ng Shao Zhi

                  Our Students’ Works

                  A Data Analytics project by Ng Shao Zhi. The bank observes that a number of loans are not paid on time. This analysis seeks to understand loan customers’ profiles and behaviour.

                  What Our Alumni Say

                  Vertical Institute is the official training partner of the Government Technology Agency of Singapore, upskilling the government's workforce with in-demand tech skills.

                  Instructors & Students from