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 to analyse large real-world data sets and create data dashboards and visualisations to share your findings. Join the data conversation and see how data analytics drives decision making across industries.
Our graduates from this bootcamp include individuals from LinkedIn, JP Morgan, Citibank, Oracle, Lazada, ExxonMobil, and more.
Why 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 between S$72,000 and S$168,000 in salary.
Flexible Job Paths
Being an essential role in businesses, data analysts can find jobs virtually any industry.
Vertical Institute’s Data Analytics Bootcamp is designed by industry practitioners to equip individuals and professionals 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. Our pedagogy is practical and hands-on with in-class 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
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 & Excel Fundamentals
Practice using Excel functions to conduct data preparation, referencing and analysis.
- Introduction to Data Analysis
- Data preparation
- Excel formula
- Data referencing
- Index + Match
- In class exercise
- Using Excel to do data preparation and data referencing
Module 2: Data Aggregation & Statistics
Learn to apply Excel aggregation commands to data such as Min, Max, Sum, Average, Count, and their conditoinal variants.
Summarize data using Pivot Tables.
Understand the basics of statistics, such as histogram, central tendency, skewness and variance.
- Data aggregation
- Excel formulas including: min, max, sum, average, count, etc
- Pivot tables
- Central tendency
- Assignment 1
- Using pivot tables to do data analysis
Module 3: SQL Fundamentals
Understand database essentials and how to install database server and tools.
Understand the fundamentals of SQL query to extract data.
- Database introduction
- Installation of MySQL server and workbench
- Create database and insert data
- Navigate database and tables
- Learn SQL
- Select, From, Where, Group by
- Functions: councat, count, sum
- In class exercise
- Write SQL to answer business questions
Module 4: SQL for Data Analysis
Understand how to extract and combine data from multiple database tables using JOIN.
Understand how to apply complicated logic and filter to SQL query.
- SQL Functions
- String: concat, length, left, substring, trim, replace
- Math: avg, min, max, sum
- Date: current_date, year
- Assignment 2
- Analyzing historical revenue as a business owner
Module 5: Data Visualisation Fundamentals
Understand data visualisation best practices.
Understand important visualisation tools and installation of Tableau.
Understand how to connect datasets and navigate data using Tableau.
Understand how to manipulate text using Tableau functions such as: upper, lower, replace, mid, find.
Understand how to organize data using Tableau features such as: hierachies, group, set, filter.
- Introduction of data visualisation
- Visualisation best practices
- Data visualisation tools
- Installation of tableau
- Connecting to datasets
- Data manipulation
- Organising data
- In class exercise
- Connect to dataset and manipulate data
Module 6: Charts & Data Analysis
Leverage Tableau to visualise and map data, and connect across Excel, SQL and Tableau.
Understand how to use calculated fields to do complicated data analysis.
Understand how to use Tableau to join multiple data-sets.
Understand how to build charts, such as map, dual axis and pie chart.
- Calculation fields
- Join multiple datasets
- Create maps
- Build charts
- Filters on charts
- Groups on chart
- Adding annotations
- Assignment 3
- Using Tableau to visualize company performace as an analyst
Module 7: Advanced Tableau & Capstone Project
Develop Tableau dashboards with multiple charts.
Understand how to make charts interactive to enable flexible data exploration, drilldown and analysis.
Learn how to build storyboards to present findings.
- Build dashboards
- Build stories
- Making dashboard interactive
- Create animations
- Capstone project and presentation
The Capstone Project
Our capstone project will require you to use a real-world data set to solve a business problem in your chosen field of interest.
On the last lesson, students culminate their learning by applying the new tools and concepts learnt to create a stakeholder presentation that includes:
- A walkthrough of the data acquisition, cleaning, and analysis stages
- A clear visualization or dashboard that displays insights to communicate the deliverables
- Analyses of high-level insights and resulting actions that are relevant to key stakeholders
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.
The bootcamp is 21 hours long and conducted on weekends or weekday evenings.
Due to COVID-19 measures, classes will be conducted 100% online, 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; all immediately available through messaging and web chat.
June Intake Schedule:
This intake schedule consists of 3 lessons, 7 hours each.
Saturdays, 9am – 5pm (luchtime break from 12pm – 1pm)
Lesson 1: 12 June 2021
Lesson 2: 19 June 2021
Lesson 3: 26 June 2021
Course fees are discounted to provide support for individuals and businesses to transform with technology in the post-COVID-19 economy. There are no government subsidies for this programme.
Usual Price: $2,500 SGD
Discounted Price: $740 SGD
Employees of SGTech Members are eligible to use the STAR Fund to offset course fees.
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. How long is this course?
This introductory bootcamp consists of 7 modules to be completed. Our course schedule can either be in a bootcamp (3 full days) or a part-time (7 three-hour lessons) format. The course is rigorous in nature with class practices, assignments, and capstone project work.
Q. Who are the instructors?
VI courses are created and led by industry practitioners from tech giants such as Apple, Amazon and Alibaba. They combine in-depth experience as practitioners with a passion for nurturing the next generation of tech talent.
Q. How are VI's courses conducted?
All our courses are held on weekends or weekday evenings to minimize disruption to regular business hours.
Our students will have access to our e-learning portal where they can access course materials and submit assignments before class.
Q. How much time do I need to dedicate to a course outside the classroom?
It varies by course and by person, but, as a part-time student, be prepared to work hard and dedicate some time outside of the classroom each week to review course material and complete homework assignments. Our courses are designed to be rigorous and intensive, but, most importantly, incredibly rewarding!
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.
Instructors & Students from