fbpx
🎉 Get certified in 21 hours, with up to 70% subsidy. Enquire now! 🧑‍💻
Online Instructor-Led Classes

Advanced Data Analytics Bootcamp

Learn advanced Excel, SQL, and Tableau from expert data analysts in Singapore.
Advanced Data Analytics Course Singapore - Vertical Institute
Google reviews
Course Reviews 5 / 5
Google reviews
Google Review 5 / 5
SwitchUp Reviews
Switchup 4.98 / 5
Course Report Reviews
Course Report 5 / 5
Advanced Data Analytics Course Singapore - Vertical Institute
Our Advanced Data Analytics course graduates come from industry-leading companies.

Take the next step with Advanced Data Analytics

Advanced Data Analytics Course Singapore - Vertical Institute
Advanced Data Analytics Course Singapore - Vertical Institute

As the importance of big data grows, companies are increasingly relying on skilled data analysts who are proficient in advanced analytic tools to help derive actionable insights, making accurate predictions, and facilitating informed decision-making for stakeholders.

In this bootcamp, you’ll learn how to use advanced functions and operations in analytic tools like Excel, SQL and Tableau to better transform complex data sets into valuable insights to help companies gain a competitive edge in today’s data-centric business landscape.

Our graduates from this Advanced Data Analytics course include individuals from GIC, GovTech, LinkedIn, JP Morgan, UBS, Citibank, Oracle, Lazada, ExxonMobil, and more.

As the importance of big data grows, companies are increasingly... relying on skilled data analysts who are proficient in advanced analytic tools to help derive actionable insights, making accurate predictions, and facilitating informed decision-making for stakeholders.

In this bootcamp, you’ll learn how to use advanced functions and operations in analytic tools like Excel, SQL and Tableau to better transform complex data sets into valuable insights to help companies gain a competitive edge in today’s data-centric business landscape.

Our graduates from this Advanced Data Analytics course include individuals from GIC, GovTech, LinkedIn, JP Morgan, UBS, Citibank, Oracle, Lazada, ExxonMobil, and more.

read more

Advanced Data Analytics Course Details

Beginner Friendly

Beginner-Friendly

Participants are required to have prior knowledge or experience in data analytics before attending this bootcamp. Otherwise, participants are recommended to complete the basic Data Analytics Bootcamp first.
Professional Certificate

Professional Certificate

Gain an accredited Advanced Data Analytics Certification in Singapore.

Advanced Data Analytics Course Singapore- Vertical Institute
The Advanced Data Analytics course is our advanced course after the basic Data Analytics course. Participants will learn to apply advanced Excel functions to tackle real-world problems, apply advanced SQL functions, and effectively conduct advanced storytelling through visualisation in Tableau.

Benefits of taking VI’s Advanced Data Analytics course

Learn New Concept and Tools

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

1 on 1 Consultation

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

Real-world Data Problem

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

Connect with Vertical Institute Community

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

Dedicated Career Support

Dedicated career support and matching with hiring partners New

Fully Hand-on Training

Fully hands-on training with industry tools

Course Fee & Government Subsidies

Course Fee Subsidies - Vertical Institute

Course Fee Subsidies

Course Fee Subsidies - Vertical Institute
Subsidy Calculation 2 - Vertical Institute
Course Fees after Subsidy - Vertical Institute
Check

All Singaporeans aged 25 years old and above can use their SkillsFuture Credits to fully offset the remaining fees after funding.

Check

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

Advanced Data Analytics Course Schedules

Choose from our flexible course schedules outside working hours. We have timeslots available on weekday evenings or on weekends.

7 Lessons, 3 hours each lessons
7 lessons,
3 hours each lesson
Online Classes via Zoom
Online classes
via Zoom
Teaching Assistants
1 Instructor,
1-2 Teaching Assistants

How to Apply in 3 Simple Steps

Select Course

Select Class Schedule

Choose convenient classes on evenings or weekends.

Arrow
Calculate Your Subsidy

Calculate Your Subsidies

Fill out the form to calculate your government subsidies.

Arrow
Pay Deposite

Pay $50 Deposit To Secure Your Spot

Instead of paying the full fee, place a small deposit to secure your slot.

Advanced 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 familiarise 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: Advanced Excel

Tutorials:

  • Introduction To The Course
    • Course Contents
    • Introduction
    • Data Analysis Workflow
    • Data Analyst Role
  • Data Cleaning in Excel
    • Dealing with Errors & Missing Values
    • Converting Texts to Columns
  • Advanced Operations in Excel
    • Data Formatting using TEXT
    • Conditional Statements
    • Index & Match

Module 2: Introduction to Advanced SQL

Tutorials:

  • Introduction to Advanced SQL
    • Database Connection
    • Review of SQL Fundamentals
    • Advanced Comparison Operators
    • Data Cleaning
    • Advanced Joins

      Module 3: Advanced SQL Functions

      Tutorials:

      • Window Function Explained
        • OVER
        • PARTITION BY
        • ORDER BY
      • Window Function Types
      • Offset rows using LAG(), LEAD()
      • Rank rows with RANK(), DENSE_RANK()
      • Indeex rows with ROW_NUMBER()

      Module 4: Advanced SQL Queries

      Tutorials:

      • Introduction to Subqueries
      • Subquery Types
      • Manage complex queries with Common Table Expressions (CTEs)
      • Write looping queries using Recursive Statements

      Module 5: Advanced Tableau Functions

      Tutorials:

      • Introduction to Advanced Data Visualisation
      • Review of Tableau Fundamentals
      • LOD (Level of Detail) Calculations
      • Advanced String Manipulation
      • Advanced Date Formatting

      Module 6: Advanced Tableau Applications

      Tutorials:

      • Advanced Filters
      • Dynamic Dashboard Actions
      • Predictive Analytics in Tableau
      • Explaining the unknown with Regression
      • Forecasting the Future with Time Series
      • Discover meaningful segments with Clustering

      Module 7: Tableau Storytelling

      Tutorials:

      • Capstone Project Discussion
      • Principles of Storytelling
        • Ask the Right Questions
        • Create a Storyline with a Climax
        • Tell a story through Tableau Storyboard
      • Industry landscape/Opportunities

      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 analyse 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 portfolio project that includes:

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


      View our alumni portfolio projects.

      Instructors

      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

      Stan

      Data Scientist @ Standard Chartered

      Master’s in Computing

      National University of Singapore

      Zane

      Chief Technology Officer @ Worq Health

      Masters in Knowledge Engineering, NUS

      BEng in Aerospace Engineering, NTU

      Sifat

      Analytics Consultant @ SIFT Analytics

      Bachelor’s in Engineering Singapore

      University of Technology & Design

      Hong Lin

      Head of Business Intelligence @ Ant Financial

      M.Sc, Bachelor’s in Engineering

      Nanyang Technological University

      Clarence - Vertical Institute Instructor

      Clarence

      Analyst @ Google

      Master’s in IT Business (Analytics)

      Singapore Management University

      Lindsay - Vertical Institute Instructor

      Lindsay

      Data Analyst @ Foodpanda

      Bachelor’s in Mathematical Science

      Nanyang Technological University

      Beverly - Vertical Institute Instructor

      Beverly

      APAC Fraud Lead @ Stripe

      Double Bachelor’s in Acc & Biz

      Nanyang Technological University

      Stan - Vertical Institute Instructor

      Stan

      Data Scientist @ Standard Chartered

      Master’s in Computing

      National University of Singapore

      Zane - Vertical Institute Instructor

      Zane

      Chief Technology Officer @ Worq Health

      Masters in Knowledge Engineering, NUS

      BEng in Aerospace Engineering, NTU

      Sifat - Vertical Institute Instructor

      Sifat

      Analytics Consultant @ SIFT Analytics

      Bachelor’s in Engineering

      Singapore University of Technology & Design

      Hong Lin - Vertical Institute Instructor

      Hong Lin

      Head of Business Intelligence @ Ant Financial

      M.Sc, Bachelor’s in Engineering

      Nanyang Technological University

      Job Placement Assistance

      Vertical Institute offers Job Placement Assistance to graduates that have successfully completed any of our courses.

      Over 1000 hiring partners

      Over 1000
      hiring partners

      Land internship & industry opportunities

      Land internship &
      industry opportunities

      Apply New Skills

      Apply your
      new skills learnt

      Terms and conditions apply. Find out more.

      Frequently Asked Questions

      What is Advanced Data Analytics?

      Going beyond basic data analysis, advanced data analytics focuses on utilising sophisticated methods and tools that goes a step further in helping companies extract valuable insights and conclusions that drive improvement in their future operations.

      By applying advanced functions and formulas, data analysts can gain a deeper understanding of the data at hand, such as uncovering hidden relationships, identify trends, and develop predictive models which tell a story using data visualisation tools that contribute to the future success of businesses.

      Are there course fee subsidies available?

      Yes, you can receive up to 70% funding support from The Institute of Banking & Finance (IBF) for our IBF-accredited programmes. The balance course fees (after subsidy) can be offset using your SkillsFuture Credits or NTUC UTAP funding.

      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/home/for-individuals/skills-and-jobs-development/training-support/IBF-STS

      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 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 $500 per year).

      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 utilise both at the same time. UTAP can only be applied after SFC has been applied.

      For illustration purposes only:Vertical Institute Updated Calculation

      Am I eligible for IBF funding support?

      The IBF funding support works on a nett fee model. This means that the subsidy is applied upfront, and you will only need to pay the balance course fees after the subsidy. For example, if you are eligible for 70% subsidy, you only need to pay the remaining 30% upfront.

      To be eligible, you’ll have to meet the following prerequisites.

      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 based in Singapore
      • Minimum of 75% attendance (this means that you must attend at least 6 out of 7 lessons)
      • Pass the final assessment

      Any balance course fees can be offset using your SkillsFuture Credits & NTUC UTAP funding.


      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 final assessment

      Are there instalment plans available?

      We offer interest-free instalment plans to ensure tech education is accessible to all Singaporeans and PRs. You may reach out to our admissions team for more information via:

      Email: [email protected]
      Phone: 6950 7023

      Are there any pre-requisites for this course?

      Participants are required to have prior knowledge or experience in data analytics before attending this bootcamp. Otherwise, participants are recommended to complete the basic Data Analytics Bootcamp first.

      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 recognised 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 visualisation 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 organisation. 

          It has an easy to use drag and drop interface to build beautiful visualisations 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 organise 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.

                  You will need to have your own personal laptop to attend the bootcamp.

                  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 visualisation skills.

                  What are the other in-demand courses at Vertical Institute?

                  Apart from the Advanced Data Analytics Course, Vertical Institute presents numerous in-demand courses in Singapore. These are additional pathways that you can consider to carve out a career in the tech industry.

                  1. Data Analytics Course
                  2. Cybersecurity Course
                  3. Digital Marketing Course
                  4. Blockchain & Cryptocurrency Course
                  5. UX Design Course

                  With these resources, students have the opportunity to cultivate their tech skills and set a strong foundation for a successful career in the ever-evolving technology industry. Singaporeans and PRs are eligible for government course subsidies at Vertical Institute.

                  Got another Question?

                  Contact Us

                  Meet Marcella Tang

                  I successfully landed my dream job after the bootcamp. Currently working at Amazon Web Services (AWS), this bootcamp has equipped me with skills needed for my career!

                  Marcella Tang – Data Analytics Alumni

                  Data Analytics Course Reviews

                  Need to speak to someone?

                  Fill out this form and we will reach out shortly!

                  Need to speak to someone: Advanced Data Analytics Bootcamp

                  Contact Us

                  Si Min / Nicole

                  Admissions Team


                  Call Us

                  +65 6950 7023

                  Featured on

                  Vertical Institute with Deputy Prime Minister Lawrence Wong on CNA

                  Media Logos - Vertical Institute

                  Singapore Tech salaries may soar up to 30% in two years.

                  — The Straits Times (2022)

                  Learn in-demand skills

                  Gain skills that top employers want

                  • Expert Instructors

                    Learn from experienced industry practioners from Google, Alibaba and other top companies.

                  • Flexible Learning

                    Attend classes from home outside of working hours.

                  • Professional Certificate

                    Graduate with a certificate accredited by IBF.

                  • Career Support

                    Dedicated career support and matching with partners.

                  Student Works - Vertical Institute

                  US Insurance Fraud Analysis

                  A Data Analytics project by Michelle Eng. Through in-depth research, Michelle explores how to detect insurance fraud cases and reduce unnecessary costs due to fraud.

                  Instructors and Students from

                  Supercharge your career today!