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. This introductory course will provide participants with the fundamental knowledge, skills and abilities to extract, transform, analyse and model data.
Learn how to use industry tools: Excel, SQL and Tableau 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, Alibaba, and more.
Why learn data analytics skills?
1. Highly in-demand
According to the Bureau of Labor Statistics (BLS), employment of computer and information research scientists, including data analysts, is projected to grow 11 percent from 2014 to 2024, faster than the average for all occupations.
2. High demand means high pay
As a mid career data analyst, you can earn up $113,000* a year.
3. Flexible job paths
Being a data analyst in a data driven economy is a critical role to many businesses. Data analysts help companies to organise and aggregate results to form a cohesive action plan. Being an essential role in businesses, data analysts can find jobs from multiple industries ranging from banking and finance, health care to marketing agencies.
Vertical Institute’s Data Analytics Bootcamp is designed by industry practitioners 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. Our pedagogy is practical and hands-on with in-class case studies and project work.
The screen below is a visualisation (‘viz’) created with Tableau to track the coronavirus COVID-19.
Who is this for?
This programme is for
- Anyone interested in looking to learn the essentials of data analysis
- Managers, analysts, professionals, executives and support staff involved in data collection, analysis and presentation
- Individuals, students and professionals looking to explore a career path in data analytics
What to expect?
As a student, you’ll:
- Learn new concepts and tools through expert-led lectures, discussions, assignments and project work
- Participate in hands-on exercises with real-world data sets to apply newly learned tools and concepts
- Make use of our e-learning portal to access course materials, assignments and submit work
- Receive individualized feedback and support from your instructional team
- Apply what you’ve learned to create a capstone project: a presentation detailing your approach to and findings from solving a real-world data problem
- Receive pre and post-course support from both our instructional and admissions team
- Be part of the VI community where members can leverage connections with students, 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.
Lesson 1: Saturday (5 September 2020)
Lesson 2: Saturday (12 September 2020)
Lesson 3: Saturday (19 September 2020)
Time: 9:00am – 5:00pm
Location: Singapore Management University
Due to COVID-19 measures, classes will be conducted 100% online, done face-to-face with our Instructor via Zoom.
Course fees are discounted during this COVID-19 period to provide support for individuals and businesses.
Usual Price: $2,500.00 SGD
Discounted Price: $880.00 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. 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 part-time and classroom-based, 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. Are there any pre-requisites for this course?
This program is designed for beginners with no prerequisites. Students completely new to data analysis will have access to pre-work in our e-learning portal to help you prepare for the course. If you do have existing experience with the industry tools, our program will further empower you to see actionable results in data analysis.
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.
Clients and Instructors from
Upskill yourself today