Data Analytics Course Details

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.

• 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

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

• 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

• 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

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

• Dashboard Creation & Storytelling
• Investment Analysis Dashboard
• Create Maps
• Interactive Dashboards
• Table Calculations

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

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

View our alumni portfolio projects.

“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. 

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

Yes. For self-sponsored Singaporeans aged 25 years old and above, you can use your SkillsFuture Credit to offset the remaining course fees after IBF funding.

To check your SkillsFuture credit balance, please follow these steps:

1. Go to https://myskillsfuture.gov.sg
2. Click on ‘Submit SkillsFuture Credit Claims’
3. Login with your SingPass
4. Click on the arrow (>) at the top right hand corner. You will be able to see a drop-down list of your Available SkillsFuture Credits.
5. Please note that our bootcamps are not eligible for “Additional SkillsFuture Credit (Mid-Career Support)’. You will only be able to use available credits from ‘SkillsFuture Credit’ and ‘One-off SkillsFuture Credit Top-Up’.

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

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.

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

For illustration purposes only:

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 currently residing in Singapore and successfully complete the course will be eligible.

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

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

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.

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.

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.

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.

‘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.