Data Analytics Course
Data Analytics with SQL and Tableau
Learn to build professional analytical dashboards and deploy them to the cloud
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
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.
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:
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:
- 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.
- 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.
- 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.
- Master the design and deployment of interactive Tableau dashboards: Acquire expertise in designing professional dashboards and deploying them to the cloud with interactive features.
- 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.
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.
Valerie Lim
Data Scientist, OCBC Bank
Jonathan Chew
Data Product Manager, MariBank
Celeste Ang
Senior Data Scientist, Grab
Lee Yu Long
Business Intelligence Lead, Atome
Travis Tang
Data Scientist, ByteDance
Beh Min Yan
Data Scientist, Gojek
Foo Yong Long
Senior Data Analyst, Grab
Shauna Loh
Data Scientist, OCBC Bank
Lee Yingqiu
Data Engineer, QuantumBlack
Kelvin Heng
Head of Data, Gojek
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:
For more information on Heicoders' financial support, visit this link here.
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:
- Visiting the SkillsFuture portal
- Selecting ‘Submit SkillsFuture Credit Claim’ on the homepage
- 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.
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?
Any difference between Windows and macOS laptops for students? Is one preferred?
Will students be provided recorded sessions to revise the weekly lectures?
I just registered for the course and am a NTUC Union member. How do I apply for the UTAP subsidy?
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:
Upskill Today with Heicoders Academy
Secure your spot in our next cohort! Limited seats available.