fbpx
Stay safe and learn from home. All our programmes are now conducted virtually.

Data Analytics Bootcamp

Master Excel, SQL, and Tableau to drive powerful analysis and insights.

Data Analytics Bootcamp

Master Excel, SQL, and Tableau to drive powerful analysis and insights.

Why Are Data Analytics Skills Relevant?

Data is now an integral part of every business. To thrive in today’s business landscape, it is crucial to learn how to leverage data to make critical business decisions.

Learn how to use industry tools: Excel, SQL and Tableau to analyse large real-world datasets and create data dashboards and visualisations to share your findings. Join the data conversation and see how data analytics drives decision making for the finance industry.

Our graduates from this bootcamp include individuals from GIC, Ministry of Home Affairs, LinkedIn, JP Morgan, UBS, Citibank, Oracle, Lazada, ExxonMobil, and more.

Why Should You Learn Data Analytics Skills?

Highly in Demand

With tech giants setting up data centres in Singapore, the local demand for data analysts has seen rapid growth.

High Demand = High Pay

A data analyst in Singapore can fetch up to S$102,000 in salary.

Flexible Job Paths

 Being an essential role in businesses, data analysts can find jobs virtually any industry.

Course Details

Vertical Institute’s Data Analytics Bootcamp is designed to equip individuals with the most in-demand skills and best practices in data analytics. Participants will be able to implement contemporary techniques, dynamic visual displays with illustrative and interactive graphics to present patterns, trends, analytical insights from data or new concepts in a strategic manner for the intended audience. Participants will culminate their learning by developing a capstone project to solve a real-world data problem in the finance industry. The pedagogy is practical and hands-on with in-class finance-related case studies and project work.

What to expect?

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

  • Make use of our e-learning portal to access course materials, assignments and submit work

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

  • Participate in hands-on exercises with real world data sets to apply newly learned tools and concepts

  • Receive individualised feedback and support from your instructional team

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

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 ofyour 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
  • 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
  • Introduction To SQL & Databases
  • Database Connection
  • SQL Syntax
  • SQL Aggregation Functions
    • Count, Sum, Group By, Having and Where
Module 3: SQL Fundamentals
  • 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
  • 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
  • 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
  • Dashboard Creation & Storytelling
  • Investment Analysis Dashboard
  • Create Maps
  • Interactive Dashboards
  • Table Calculations
Module 7: Advanced Tableau & Capstone Project
  • 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 financial dataset. You will acquire a real-world dataset, then prepare, clean, and analyze it to draw meaningful conclusions.

The capstone project will culminate your learning by applying the new tools and concepts learnt to create a 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

Hong Lin

Honglin is the Head of Business Intelligence at Ant Financial.

As a lifelong data expert, he previously enjoyed working stints at Apple, DBS Singapore and Advanced Micro Devices (AMD). He was also a past data analytics instructor at General Assembly.

Honglin graduated with a Masters in Knowledge Management and Bachelors in Engineering from Nanyang Technological University in Singapore.

Clarence

Clarence

Clarence is a data analyst at OCBC Bank.

As an analytics and tech enthusiast, he has done projects in front-end development, automation and analytics projects during his time in IBM, Standard Chartered Bank and OCBC Bank. He also taught data analytics at General Assembly.

Clarence graduated with a Masters in IT in Business (Analytics) and Bachelor of Accountancy from SMU. He often mentor students about careers in the tech industry during his free time.

Upcoming Course Schedules

The bootcamp consists of 7 lessons with each lesson lasting 3 hours long. Classes will be conducted virtually, done face-to-face with our Instructor via Zoom. You will have intimate access to our instructional team that’s ready to answer your questions and a strong peer community.

September Intake Schedule:

The next intake dates are to be confirmed. Kindly email us to indicate your interest.

Course Fee

Price: $2,500 SGD

Frequently Asked Questions

Q. Why are data analytics skills relevant today?

By 2028, 20% of Singapore’s full-time equivalent workforce will have their jobs displaced by technology. With digital disruption comes the need for workers with corresponding digital skills, and data analytics is at the forefront of this change. The ability to manipulate data to make critical decisions across all industries and professions is key to staying relevant in our increasingly data-driven world.

The relevance of data analytics skills is also evident in its employer demand. The introduction of data analytics into its operations saved DBS 600,000 man-hours while boosting recruitment, staff productivity and reducing attrition rates. Experts have predicted that about 11.5 million data job openings will be created by 2026, and the need for data-driven decision makers and functional analysts will be most acute.

In this course, you will gain an in-demand and marketable skill set that can be applied to virtually any industry or profession.

Q. 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. Take, for example, the above ‘viz’ created by Ranvir Kumar on Tableau to track COVID-19. We are able to see the regions affected, as well as segment the data according to the total confirmed cases, total new cases, amongst others..

Visit the Tableau Public Gallery to see beautiful real world projects by Tableau users.

Q. What are the backgrounds of data analytics students?

You’ll find a diverse range of peers in the classroom including:

• Data analysts looking to brush up on core techniques and formalize their skill set.
• Managers, marketers, UX researchers, analysts, professionals, executives and support staff who deal with data on a daily basis
• Professionals and entrepreneurs who need to present and share datadriven insights to business stakeholders for decision making
• Professionals looking for a practical skill set to boost their resumes.

Regardless of industry, this program attracts a community of like-minded individuals who are interested in using data to solve problems.

Q. Is there a certificate granted at the end of the course?

Upon successful completion of the course, participants will be awarded a digital certificate by Vertical Institute. VI alumni use their course certificate to demonstrate skills to employers and their LinkedIn network.

Our data analytics course is well-regarded by top companies, who contribute to our curriculum and use our courses to train their own teams.

    What Our Students Say

    It was a great learning experience. While I had very basic knowledge prior to the class, the content and structure of lessons made me have a better understanding and I feel better able to apply what I’ve learnt.

    Jasmine Tan

    My experience at VI was great. Hong Lin is very knowledgeable, patient and can explain the concepts clearly and effectively. The rest of the team were also very helpful through the course! Thanks all!

    Lauren Tan

    Really insightful and taught me how visualization could be done so easily. Would really hope to apply it at the workplace! Kudos to the team! ☺️

    Charis Yong

    Instructors & Students from