DA Nanodegree

Data Analytics Course

Data Analytics with SQL and Tableau

Learn to build professional analytical dashboards and deploy them to the cloud

IBF, SkillsFuture and UTAP subsidies available Deliver business insights with data dashboards in Tableau Suitable for beginners with ZERO programming background Get Certified In Data Analytics In 21 Hours

Upskill with Singapore's Top-Rated Digital Marketing Academy

5-Star Google Reviews 🎉

Companies our instructors come from 👩🏻‍🏫

Upcoming Data Analytics Course Dates

Select a suitable course schedule below to apply. Limited slots are available and are allotted on a first-come-first-served basis.

Why Learn Data Analytics

Data is the lifeblood of our digital world, and data analytics is the compass that navigates its course. For those considering a career in data analytics, our DA100 course propels you into the high-growth realm of data professionals, equipping you with proficiency in SQL and Tableau — the keys to unlocking complex insights from raw data.

Roles That Require Data Analytics

Software Engineer
Business Analyst
Data Scientist
Machine Learning Engineer
Business Intelligence Analyst
Supply Chain Specialist
Market Analyst
Product Manager
Project Manager
Data Journalist
Academic Researcher
Quantitative Researcher
Financial Analyst

Data Analyst

Junior

S$3.0k

S$4.5k

S$6.7k

Mid

S$4.3k

S$6.3k

S$9.5k

Senior

S$5.0k

S$7.5k

S$12.0k

Lead

S$6.0k

S$9.5k

S$15.8k

This Data Analytics Course Is Suitable For:

  • Beginners who have no experience in data analytics
  • Individuals looking for an introduction course to standard data workflows (where you query data in a database, clean it, and then perform data visualisation)

Data Analytics Certifications Available

Upon completion of the data analytics course, participants will be awarded with the DA Nanodegree.

DA Nanodegree

Gain valuable insights from your data by extracting it through SQL and visualise the findings using Tableau in this course — crucial abilities for both Data Analysts and Product Managers

Other Applications of Data Science

Basic data literacy is increasingly becoming a core skill in the job market even in non-data centric roles.

Sign up for DA100 today to learn how data analytics can help you be more effective, or contact us so we can help you decide if this is the right course for you.

Data Analytics Course Overview

 
📅

7 Lessons

🕒

3-Hour Lesson Duration

💻

Held On Zoom

👩🏻‍🏫

1 Instructor

👬🏻

1-2 Teaching Assistants

Part of:

DA Nanodegree

Learning Objectives

This Data Analytics course aims to equip students with essential skills in database management and data visualization, providing a strong foundation for those pursuing a data science certification. Throughout this data science course, students will:

  1. Gain foundational knowledge in databases and SQL: Learn how to manage and manipulate data through understanding basic database concepts and SQL operations, making it an excellent SQL course for beginners.
  2. Develop advanced SQL query techniques: Enhance skills for performing complex data analysis by mastering advanced SQL queries and operations, crucial for any comprehensive data analytics course.
  3. Learn to navigate Tableau and create various types of data visualizations: Become proficient in using Tableau to connect to data sources, prepare data, and create a wide range of visualizations.
  4. Master the design and deployment of interactive Tableau dashboards: Acquire expertise in designing professional dashboards and deploying them to the cloud with interactive features.
  5. Apply their knowledge in a capstone project involving real-world data analysis and visualization: Utilize SQL and Tableau skills to complete a comprehensive project, analyzing and visualizing real-world data, and deploying the results for end-user access.

Course Outline

Pre-Class Preparation

All Heicoders students will have access to course materials via our online e-learning portal.

To prepare for the course, essential resources are provided to familiarise you with the prerequisite concepts and tools used during the course.

Our friendly instructor and teaching assistants are always ready to assist if you encounter any issues. You are also welcome to join our Telegram channel to leverage connections with fellow students, alumni, instructors and tech hiring managers.

Lesson 1: Introduction to Databases and SQL
  • Learn about the concept of databases and SQL
  • Learn basic SQL syntax and how to create tables
  • Learn how to create, read, update and delete data from database tables
Lesson 2: Advanced Databases and SQL
  • Build conditional queries with WHERE clause
  • Order query results with ORDER BY clause
  • Perform complex queries with SQL Joins
  • Export SQL Queries to CSV file
Lesson 3: Introduction to Tableau
  • Embark on an orientation of the Tableau Workspace
  • Learn to connect to various data sources
  • Prepare data for visualisation in Tableau
  • Create Charts in Tableau
Lesson 4: Graphical Visualisations with Tableau
  • Build professional charts for distribution-related use cases (Histogram, Box Plot)
  • Visual storytelling with comparison-related and composition-related charting tools
Lesson 5: Geospatial Visualisations with Tableau
  • Format geospatial datasets for visualisation on Tableau
  • Build choropleth maps on Tableau with customization options
Lesson 6: Data Analytics Dashboard
  • Learn fundamental Tableau dashboard design principles
  • Create professional dashboards in Tableau
  • Use filters in Tableau charts
  • Add advanced interactivity features to Tableau charts
Lesson 7: Deployment of Dashboard and Forecasting with Tableau
  • Learn to deploy Analytics Dashboards to the cloud
  • Forecasting with Tableau dashboards
  • Walkthrough of capstone project
Capstone Project
  • Part 1: Use SQL to query customers’ credit card transaction history
  • Part 2: Build Tableau dashboard to visualise customers’ credit card transaction behaviours
  • Part 3: Deploy Tableau dashboards to the cloud so they can be accessible to end users

    All DA100 graduates have the option of continuing with subsequent courses in our nanodegrees, such as Python programming and applied machine learning, where we prepare and equip you with the skills needed to secure prestigious jobs at top companies.

    Course Fees & Subsidies

    IBF Subsidy Course Fees after Subsidy (incl. GST)
    Singaporeans aged 40 and above 70% $819
    Singaporeans below 40 and all PRs 50% $1,239
    Non-Singapore Citizens and Non-PRs 40%* $1,449

    Further reduce your out-of-pocket costs with:

    Heicoders Academy
    SkillsFuture Credits can be used to offset course fees for Singapore Citizens aged 25 and above
    Heicoders Academy
    NTUC Union members can offset 50% of unfunded course fees (up to $250 a year) with UTAP
    Heicoders Academy
    *Heicoders Scholarship available for non-subsidy qualifiers to receive up to 40% course fee support from our Inclusive Education Fund

    SkillsFuture For Data Analytics

    If you are a Singapore Citizen aged 25 and above, you can use your SkillsFuture Credits to offset the course fees for this Data Analytics course.

    To use your credits, you will have to sign up for the course and submit a claim by:

    1. Visiting the SkillsFuture portal
    2. Selecting ‘Submit SkillsFuture Credit Claim’ on the homepage
    3. Logging in via Singpass and filling out the claim form

    For more detailed steps on how to claim your credits and submit a claim, check out our comprehensive SkillsFuture guide.

    Data Analytics Course Highlights

    When you enrol in a course with Heicoders Academy, we guarantee:

    Industry-Relevant Skills

    A course filled with content and skills that you will find not only immediately useful but also valuable for your future endeavours

    Expert Instructors

    A dedicated instructor personally interviewed by the founders, someone from whom you'll be eager to learn

    Personalised Mentorship

    1-to-1 guidance and mentorship towards in-demand careers as part of our Nanodegree program (provided you put in the hard work as well!)

    Beginner-Friendliness

    A course designed to accommodate and support learners who are new to the subject matter, making it easy to understand and engage with the material

    The Heicoders Guarantee

    Heicoders Academy was founded and run by a team of passionate technology industry practitioners who believed their collective expertise and insights could fill the increasing technology skill gap in Singapore.

    Eager to share their experiences, they set out on a mission to create a learning experience that not only addressed the shortcomings of existing courses but also aimed to inspire the next generation of technology-sector talents in Singapore.

    Each Heicoders Academy course is crafted and regularly updated by an esteemed Academic Board of university professors and industry veterans with extensive experience as practitioners and hiring managers.

    Our Instructors

    All instructors at Heicoders Academy have been carefully screened and selected for their excellence and passion for teaching. With their extensive industry experience, we are confident that you will gain a wealth of knowledge from them.

    Course Reviews and Testimonials

    Heicoders Academy is proud to be recognised by our graduates for our ability to deliver comprehensive and practical content in a beginner-friendly manner. Embark on your Heicoders experience today and discover our dedication to delivering high-quality education.

    Frequently Asked Questions

    Here are the questions we receive most often:

    I have zero data analytics or programming experience. Is DA100 suitable for me?
    Course Design

    DA100 was designed specifically for people with no background in data analytics. You should have no problems catching up with the class as our materials are well-organised for after-class review. Our ourses are also taught by experienced instructors and supported by teaching assistants who provide in-class and after-class support.

    Is there any form of certification upon completing the course?
    For payment could I make a deposit first, and complete the payment closer to the course’s commencement date?
    I am keen on your class but can’t make it for one session. Is there a makeup class?
    Makeups On Case By Case Evaluation

    We strongly advocate for full attendance among students, yet we recognize that severe unforeseen events may occur. We will grant such students a one-time accommodation to attend a makeup session or a live stream of the recorded class.

    For Learners Intending To Use Subsidies

    If you are planning on using any subsidies (e.g. UTAP, IBF, SkillsFuture Credits), do note that these subsidies require learners to have at least 75% class attendance before you are eligible for subsidies.

    Any difference between Windows and macOS laptops for students? Is one preferred?
    Device Advice

    Both Windows and Mac operating systems are suitable options, as previous students have successfully used them without significant problems. Approximately two weeks prior to the commencement of the course, we will distribute a detailed installation manual that includes tailored guidelines for both Mac and Windows users. Additionally, we recommend that students consider utilising external monitors for a more comfortable learning experience.

    Will students be provided recorded sessions to revise the weekly lectures?
    Lesson Recordings Are Provided

    You are welcome to use the lesson recordings and materials for reference whenever you need a review of a particular lesson. Our Heicoders curriculum team takes great pride in documenting the class content thoroughly, so feel free to go through the lesson materials at your own pace. You could always reach out to your teaching assistants as well if you have questions outside of class.

    I just registered for the course and am a NTUC Union member. How do I apply for the UTAP subsidy?
    Instructions

    The UTAP subsidy is disbursed by NTUC to eligible students on a reimbursement basis. After completing the course, Heicoders students can then apply on the NTUC website for reimbursement, and upon approval they would usually receive a direct deposit from NTUC to their bank accounts within two to three weeks. You may find more details on the eligibility requirements and claims process on this NTUC UTAP website. On Heicoders’ end, we provide a PDF step-by-step guide on how to submit the claim to all students at the end of the course.

    Have a question we haven't answered?

    Media Features

    Singapore Today’s Lance Alexander and Melanie Oliveiro speak with Kong Yu Ning, Heicoders Academy Co-Founder, about Artificial Intelligence’s continuing rise and impact on the future of work

    Heicoders Academy Co-Founder Min Yan discusses the need to reframe tech education with TIA's Jonathan Chew, emphasising the importance of AI and computational thinking, and advocating for a shift from traditional learning methods to more innovative approaches

    Heicoders Academy Co-Founders Yu Ning and Min Yan shares with The Straits Times' Venessa Lee about their efforts to weave in digital and AI tools to save $8k/month for the academy

    TSL’s Faith Leong discusses Heicoders Academy’s AI courses, which is led by industry professionals and focuses on making machine learning accessible and relevant through practical capstone projects and real-world applications

    Also featured on:

    AsiaOne
    Yahoo
    Vulcan
    LianHeZaoBao
    GoodyFeed

    Upskill Today with Heicoders Academy

    Secure your spot in our next cohort! Limited seats available.