Advanced Data Analytics Bootcamp
Advanced Data Analytics Course
Pay less with government subsidies
Trusted by 50,000+ learners
Online Classes
Via Zoom
21 Hours Total
7 Lessons + 1 Capstone Project
Flexible Schedule
Weekdays or Weekends Available
Beginner Friendly
No prior background needed
Learn Advanced Data Analytics with Vertical Institute
Who is This Course For
All Professionals
Enhance your analytical skills to make data-driven decisions. Whether you’re in marketing, finance, healthcare, or any sector, these skills will elevate your professional profile.
Aspiring Data Analysts
Open doors to exciting opportunities and dive deep into analytics with Advanced Data Analytics skills.
Entrepreneurs and Business Owners
Understand your customers and market better by tapping into advanced data insights. Make informed decisions that drive your business forward.
Students and Lifelong Learners
Whether you’re a student or a lifelong learner, acquire a valuable skill set that is crucial in today’s data-driven world.
Skills You Will Learn
Course Fee & Government Subsidies
Looking to train your team? Check out our corporate pricing View Corporate Pricing
View Corporate PricingSingapore Citizens (40 years and above)
Singapore Citizens (Below 40 years) and PR
Have questions? Read FAQs or Contact Us.
Advanced Data Analytics Course Details
Our Advanced Data Analytics course, exploring AI methodologies, advances upon the foundational teachings of our Data Analytics Course, delving into advanced Excel, SQL, and Tableau techniques to tackle genuine challenges and elevate storytelling through visualisation. Prior experience or knowledge with data analytics concepts is required.
Learn From the Best in the Industry
Excel Skills for Insights
Use Excel to organise numbers, spot patterns, and make better decisions at work or at home.
SQL Fundamentals
Learn to find and combine data using simple SQL steps—no coding background needed.
Tableau Storytelling Made Simple
Turn data into clear charts and dashboards that are easy to understand and great for presentations.
Clarence
Senior Data Analyst @ Google
Master’s in IT Business (Analytics) Singapore Management University
Lindsay
Lead Data Scientist - Citi
Bachelor’s in Mathematical Science Nanyang Technological University
Beverly
APAC Fraud Lead @ Stripe
Double Bachelor’s in Acc & Biz Nanyang Technological University
How We Make Learning Different
Beginner-Friendly
Expert-Led Learning
Hands-On Training
Out of Class Support
Lifetime Resource Access
Career Support
Earn a Certification in Data Analytics
You will be awarded a Data Analytics certification recognised by employers in Singapore that can be used to demonstrate skills to employers and network.
Career Support & Alumni Benefits
After mastering in-demand skills with Vertical Institute, we provide you with additional support to steer you towards career success. Through our partnership with e2i (Employment and Employability Institute), you'll receive tailored career guidance to navigate your next steps. Plus, gain exclusive access to networking events and workshops led by industry experts, designed to boost your professional journey.
Recommended By Over 50,000+ Alumni
Cheng Yee
Data Analytics Course Alumni
Bertha Tjahyadi
Data Analytics Course Alumni
Andy Tan
Data Analytics Course Alumni
Upcoming Advanced Data Analytics Course Schedules
Advanced Data Analytics Course FAQs
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.
How do I secure my seat in the Advanced Data Analytics Course?
To reserve your place, pay the S$10.90 registration fee (incl. GST) when you sign up. This holds your seat while our student services team contacts you within 24 hours to guide you through funding applications and payment arrangements. In many cases, eligible learners pay little to nothing out of pocket after subsidies.
Is the S$10.90 registration fee refundable?
No. The S$10.90 registration fee is strictly non-refundable under all circumstances.
What funding subsidies are available for this Advanced Data Analytics course in Singapore?
Eligible Singaporeans and PRs can access up to 70% course fee funding through the IBF Standards Training Scheme (IBF-STS). Additional offsets are available via SkillsFuture Credit (SFC) for Singaporeans aged 25 and above and NTUC UTAP which offsets 50% of unfunded fees capped at S$500/year (claimed after course completion).
Funding approval is subject to eligibility criteria set by the relevant authorities. Vertical Institute does not guarantee funding approval and is not liable for rejections, delays, or clawbacks.
Can I use SkillsFuture Credit and UTAP at the same time?
Yes. You can combine SkillsFuture Credit and UTAP to further reduce your out-of-pocket costs. UTAP must be applied after SkillsFuture Credit has been applied. UTAP claims are submitted after course completion via the NTUC portal.
Am I eligible for IBF funding support?
To qualify for IBF funding, you must be at least 21 years old, a Singapore Citizen or PR based in Singapore, achieve at least 75% attendance (minimum 6 out of 7 lessons), and pass the final assessment. Visit ibf.org.sg for the full eligibility criteria.
What is the refund and withdrawal policy?
| Timing of Withdrawal | Refund |
| >14 days before course start | 100% refund (excluding $10.90 fee) |
| 7–14 days before | 50% refund (excluding $10.90 fee) |
| <7 days before | No refund |
| After course starts | No refund |
An administrative fee of $15 applies to all approved withdrawals.
What happens if I don’t show up for the course?
If you do not attend without prior notice:
- No refund will be given
- You will be liable for the full course fee (including any funding clawback)
Can I reschedule my course intake?
Yes, subject to the following:
- Must be requested at least 14 days before course start
- Maximum of 3 reschedules allowed
Fees:
- 1st reschedule: Free
- 2nd & 3rd reschedule: 5% of full course fee each (non-waivable)
- $15 administrative fee applies
No rescheduling is allowed after the course has started.
What happens if I don’t show up for the course?
If you do not attend without prior notice:
- No refund will be given
- You will be liable for the full course fee (including any funding clawback)
What are the minimum entry requirements for the Advanced Data Analytics course?
This course is not beginner-friendly and builds on foundational knowledge from data analytics. Prior experience or understanding of data analytics concepts is required.
Applicants must be aged 21 and above with basic computer literacy (Level 2 equivalent). The SQL component is web-based, so no installation is needed, while Tableau Public is required for visualisation and can be downloaded for free. You will also need your own laptop or PC to attend the course.
You’ll be supported with pre-work materials, experienced instructors, teaching assistants, and access to an e-learning platform for course content and assignments.
What are the completion requirements?
To successfully complete the course, you must:
- Meet the minimum attendance requirement
- Complete all required assessments
- Be graded as “Competent”
What happens if I do not meet attendance or assessment requirements?
If you fail to meet these requirements:
- You will not receive certification
- You may lose funding eligibility
- You will be required to pay the full course fee (unsubsidised amount)
What if I miss a lesson?
You may:
- Attend a makeup class (subject to availability), or
- Watch the recorded session
However, attendance is only counted if you attend the makeup session.
Will I get a job after completing the course?
No. Job placement is not guaranteed.
However, we provide:
- Career support
- Industry connections
- Opportunities through hiring partners
Your outcomes depend on your individual effort and performance.
What happens after I complete the course?
You gain:
- A recognised certificate
- Access to our alumni network
Opportunities for networking and career support
Advanced Data Analytics
Method: Online classes via Zoom
Duration: 21 Hours Total
Lessons: 7 Lessons + 1 Capstone Project
Trusted by 50,000+ learners
Join the Advanced Data Analytics Course Today!
Advanced Data Analytics Course Curriculum
Master the fundamentals of Advanced Data Analytics through our comprehensive and hands-on curriculum.
Pre-Work
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
- 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
- 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
- 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
- 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.
Discuss your career goals
Decide which course is the best for you
Understanding the government subsidies
Other ways to reach us
🏢 CORPORATE TRAINING
Strengthen Strategic Decisions with Advanced Analytics Skills
Why Advanced Data Analytics Skills training for your team matters:
Deeper Business Insights
Analyse complex datasets for high-impact decisions.
Improved Forecast Accuracy
Apply advanced techniques to predict trends reliably.
Optimised Business Strategy
Use data to refine operations and planning.
Advanced Data Analytics Course Fee Breakdown for Corporate
Book a call with our team
Discuss your career goals
Decide which course is the best for you
Understanding the government subsidies
Other ways to reach us
Trusted by 50,000+ learners