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

Data Analytics Bootcamp

Make use of the COVID downturn to learn a new in-demand skill.
Up to 90% IBF Funding & SkillsFuture Credits Eligible.

Data Analytics Skills Command A Salary Premium

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 industry tools: Excel, SQL and Tableau to analyse large real-world datasets and create data dashboards and visualisations to share your findings.

Our graduates from this bootcamp have come from GIC, GovTech, LinkedIn, JP Morgan, UBS, Citibank, Oracle, Lazada, ExxonMobil, and more.

Why Learn Data Analytics?

Highly in Demand

The local demand for data analysts has seen rapid growth.

High Demand = High Pay

A data analyst is highly in demand globally and paid competitively.

Flexible Job Paths

Data analysts can find jobs virtually any industry.

Up To 90% Funding Support For Eligible Singaporeans & PRs*
Vertical Institute is accredited by the Institute of Banking and Finance (IBF) as an IBF-STS Accredited Training Provider.

Eligible Singaporeans & PRs can obtain up to 90% funding support for our above IBF-accredited courses.

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 culminate their learning by developing a capstone project to solve a real-world data problem in the fintech industry. This course is suitable for beginners. No prior background or prerequisite is required.

What to expect?

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

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

    • 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 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: Data Analysis & Excel Fundamentals

    Tutorials:

    • 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

    Tutorials:

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

        Tutorials:

        • 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

        Tutorials:

        • 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

        Tutorials:

        • 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

        Tutorials:

        • Dashboard Creation & Storytelling
        • Investment Analysis Dashboard
        • Create Maps
        • Interactive Dashboards
        • Table Calculations
        Module 7: Advanced Tableau & Capstone Project

        Tutorials:

        • 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

        Head of Business Intelligence @ Ant Financial
        MSc in Knowledge Management &

        BSc in Engineering
        Nanyang Technological University
        Clarence

        Clarence

        Analyst @ Google
        Masters in IT Business (Analytics) & BAcc
        Singapore Management University

        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.

         

        November/December Schedules (Limited Slots Left)

        Weekend Morning Intake
        ✅ 9am – 12pm
        ✅ Saturdays & Sundays
        ✅ November 20, 21, 27, 28, December 4, 5, 11

        Weekend Afternoon Intake
        ✅ 1pm – 4pm
        ✅ Saturdays & Sundays
        ✅ November 20, 21, 27, 28, December 4, 5, 11

        Weekday Evening Intake
        ✅ 7pm – 10pm
        ✅ Tuesdays & Thursdays
        ✅ November 16, 18, 23, 25, 30 December 2, 7

        December Schedules (New Release)

        Weekday Evening Intake
        ✅ 7pm – 10pm
        ✅ Tuesdays & Thursdays
        ✅ December 2, 7, 9, 14, 16, 21, 23

        Fast Track Morning Intake
        ✅ 9am – 12pm
        ✅ Monday – Sunday
        ✅ December 13, 14, 15, 16, 17, 18, 19 

        Fast Track Afternoon Intake
        ✅ 1pm – 4pm
        ✅ Monday – Sunday
        ✅ December 13, 14, 15, 16, 17, 18, 19 

        Course Fee & Government Subsidies

        Course fee before 90% IBF funding: S$2,500

        Course fee after 90% IBF funding: S$250 nett (for Singaporeans & PRs)

        All Singaporeans aged 25 years old and above can use their SkillsFuture Credits to offset the remaining $250.

        Funding Support

        IBF Standards Training Scheme (IBF-STS)

        This programme has been accredited under the IBF Standards, and is eligible for funding under the IBF Standards Training Scheme (IBF-STS), subject to all eligibility criteria being met.

        Find out more on www.ibf.org.sg.

        Frequently Asked Questions

        Q. Can I use SkillsFuture Credits to offset the remaining course fee?

        Yes. For Singaporeans aged 25 years old and above, you can use your SkillsFuture Credits to offset the remaining course fee.

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

        Q. Is there funding support available?

        Yes, there is funding support from The Institute of Banking & Finance (IBF) for our IBF-accredited programmes:

        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 accredited under the IBF Standards, eligible Singaporeans & PRs may receive funding support under the IBF Standards Training Scheme (IBF-STS), subjected to all eligibility criteria being met.

        For training programmes commencing between 8 April 2020 and 31 December 2021 (both dates inclusive):

        • Funding Support: 90% of direct training cost

        For more information on the funding support, please visit : https://www.ibf.org.sg/programmes/Pages/IBF-STS.aspx

        • Training Allowance Grant (TAG): $10/hour (only for Financial Institutions/FinTech Firms)

        The Training Allowance Grant (TAG) aims to help Financial Institutions and FinTech firms manage manpower costs and support the skills upgrade of their employees.  FIs/FinTechs will be able to further claim their course fees after funding (in this case, $250) upon successful completion of the course.

        Q. Who is eligible for funding support?
        • Both self-sponsored individuals and company-sponsored* individuals.
        • All Singapore Citizens or Singapore Permanent Residents physically based in Singapore.
        • Successfully complete the IBF-accredited Data Analytics Bootcamp (including passing the capstone project assessment).​

        *Please note that company-sponsored individuals have to 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.

        Q. How do I obtain funding support?

        This funding support works on a nett fee model. This means that participants only need to pay the unfunded portion of the course fees (10%). This nett fee can be fully paid with your SkillsFuture Credits.

        For Self-Sponsored:

        You must be a Singaporean or Singapore Permanent Resident (PR) that is physically based in Singapore. You will only need to pay the course fees minus the funding support which is 10% of the course fees. For example, if the course fees are S$2500, you will only be paying S$250 nett which can be paid with your SkillsFuture Credits.

        For Company-Sponsored:

        You must be a Singaporean or Singapore Permanent Resident (PR) that is physically based in Singapore and working in an eligible company which refers to Financial Institutions that are regulated by the Monetary Authority of Singapore (MAS) (either licensed / exempted from licensing) and Fintech companies that are registered with the Singapore Fintech Association.

        Your company will pay the course fees minus the funding support which is 10% of the course fees. For example, if the course fees are S$2500 , the company will be paying S$250 nett for company-sponsored participants.

        Companies will further be able to claim the remaining $250 paid with the Training Allowance Grant (TAG) upon successful completion of the course.

        Q. Are there course requirements for funding support?

        For you to receive funding support, please take note of the following:

        • Minimum of 75% attendance (this means that you must attend at least 6 out of 7 lessons)
        • Pass the Capstone Project Assessment

        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.  Visit the Tableau Public Gallery to see beautiful real world projects by Tableau users.

            Q. Are there any pre-requisites for this course?

            This program is designed for beginners with no prerequisites.

            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 user experience 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 gave me 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

                Vertical Institute is the official training partner of the Government Technology Agency of Singapore, upskilling the government’s workforce with in-demand tech skills.

                Instructors & Students from