Advanced Data Analytics Course
Online Classes
Via Zoom
7 Lessons
3 hours each session
Certification
Gain a professional certification
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
Singapore Citizens (40 years and above)
Singapore Citizens (Below 40 years) and PR
Use up to $1,000 SkillsFuture Credits
Use up to $500 SkillsFuture Credits
Advanced Data Analytics Course Details
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.Learn From the Best in the Industry
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
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 40,000 Alumni
Upcoming Advanced Data Analytics Course Schedules
Advanced Data Analytics Course FAQs
What is Advanced Data Analytics?
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?
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?
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?
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?
For illustration purposes only:
Am I eligible for IBF funding support?
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?
Email: contact@verticalinstitute.com
Phone: 6950 7023
Is there a data analytics certificate granted at the end of the course?
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?
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?
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/PC to attend the course.
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?
Your attendance is only counted if you attend a makeup class.
Why are data analytics skills relevant today?
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?
- Data Analytics Course
- Cybersecurity Course
- Digital Marketing Course
- Blockchain & Cryptocurrency Course
- UX Design Course
- Data Science Course
- Generative AI 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.
What are Vertical Institute's Refund Policy and Withdrawal Policy?
Withdrawal Policy: If you drop out of a course halfway / fail to meet the minimum attendance requirements / fail to submit and pass the assessment, IBF will not subsidise your course fees, and you will be liable for the full course fee amount. Vertical Institute reserves the right to claw back the funded amount from the trainee if he/she did not fulfil the eligibility criteria.
Are there any minimum requirements to enrol in the course?
- Be aged 21 and above
- Possess basic computer literacy (equivalent to Level 2)
- Hold a minimum of one of the following academic qualifications:
- GCE “N”, “O” or “A” Level
- NITEC
- Diploma or higher
- Have at least 2 years of working experience
- Demonstrate English language proficiency equivalent to or higher than any of the following:
- Pass in GCE “N” or “O” Level English
- WPLN Level 5
- IELTS 5.5
- TOEFL iBT score between 46–59
If you are unsure about your eligibility, feel free to reach out to our team for a quick assessment.
What is the Attendance requirement for Vertical Institute’s courses?
What are the Course Completion requirements for Vertical Institute's courses?
Additionally, participants must complete course feedback surveys and meet any specific course requirements, such as those for WSQ qualifications.
Join the Advanced Data Analytics Course Today!
Advanced Data Analytics Course 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
- 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
- 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
- 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
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.
Other ways to reach us
Book a call with our team