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.

✓ Gain an accredited Data Analytics Certification in Singapore.

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

  • 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

  • Dedicated career support and matching with hiring partners New

  • 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

  • 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

  • Dedicated career support and matching with hiring partners New

Course Fee & Government Subsidies

*Please note that IBF Subsidy level will drop to 70%-50% after 31st December 2022.
Sign up early to enjoy higher course fee subsidies.

Course Fees (with GST) IBF Subsidy
Singaporeans aged
40 and above 
$425 90%
Singaporeans below 40
and all PRs 
$925 70%
Foreigners $2,675 -

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

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

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

      Head of Business Intelligence @ Ant Financial

      M.Sc, Bachelor’s in Engineering
      Nanyang Technological University

      Clarence

      Analyst @ Google

      Master’s in IT Business (Analytics)
      Singapore Management University

      Lindsay

      Data Analyst @ Foodpanda

      Bachelor’s in Mathematical Science
      Nanyang Technological University

      Beverly

      APAC Fraud Lead @ Stripe

      Double Bachelor’s in Acc & Biz
      Nanyang Technological University

      THE NEW STRIPE LOGO PNG

      Stan

      Data Scientist @ Standard Chartered

      Master’s in Computing
      National University of Singapore

      Sifat

      Analytics Consultant @ SIFT Analytics

      Bachelor’s in Engineering
      Singapore University of Technology & Design

      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

      What is Data Analytics?

      “The rise of the digital economy will drive up the demand for tech jobs – among others, we will need data analysts, software developers, infrastructure architects and cyber security engineers.”
      – Manpower Minister Tan See Leng, 16 Dec 2021

      In today’s digital world, the growth in big data has created a surge in the utilisation of data analytics. 

      From tech companies to banks – companies and institutions are collecting, storing, and analysing data like never before. Data analysis refers to the process of analysing this information and drawing valuable insights from it. These insights and conclusions can then be further used by businesses to improve their operations. 

      Data analytics also involves data visualisation – a key process of translating and presenting data through the use of visuals, both static and interactive. It is a powerful tool that makes it easier for researchers to explain their findings and allow readers to better comprehend data trends. 

      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:

    • P210816IRN – Data Analytics Bootcamp
    • P210806QMF – Data Science Bootcamp
    • P210802XCG – User Experience Design Bootcamp
    • P220722SBE - Digital Marketing Bootcamp
    • 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 $425, you can offset $212.50 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$425 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 data analytics certificate granted at the end of the course?

      Upon successful completion of this IBF-accredited course, participants will be awarded a data analytics certification recognized by employers in Singapore. 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.

                  What if I cannot attend a class?

                  If you miss a lesson, you are allowed to attend a makeup class. This would be the corresponding class of another intake that same week, subject to availability. If you cannot make it for the makeup class, then you can simply watch the recorded lesson video.

                  Your attendance is only counted if you attend a makeup class.

                  Why are data analytics skills relevant today?

                  ‘Singapore Tech Salaries May Soar Up to 30% in Two Years’ – The Straits Times, 2022

                  As market competition stiffens, top organisations are turning to data analytics to identify new market opportunities and provide insights to make critical business decisions.

                  To thrive in today’s business landscape, it is crucial to pick up industry tools such as Excel, SQL, and Tableau. Learn how to analyse and make insightful conclusions from raw data. Develop visualisation skills to create dashboards and effectively share your findings. 

                  With data analytics skills, you will gain an in-demand and marketable skillset that can be applied to virtually any industry or profession.

                  Kickstart a career in Data Analytics with the beginner-friendly Data Analytics Bootcamp by Vertical Institute. The course allocates 3-4 instructional team members per class to ensure dedicated peer and mentor support for your Data Science journey. You will graduate with an IBF-accredited Data Analytics certification, as well as a polished, portfolio-ready project to showcase your analytical and visualization skills.

                  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!

                  What Our Alumni Say

                  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.

                  Instructors & Students from