Certified Data Analyst

Learn to analyse data with Excel, SQL, and Tableau in this beginner-friendly, 10-week course. Gain the confidence to apply these high-demand skills across any industry or role.

Get In Touch

Learn more about our HRD Corp Signature Programmes and how we can help your organisation reach its transformative goals.

<script>hbspt.forms.create({ region: "na1", portalId: "8057651", formId: "6be12dea-f2a2-404a-afbf-965299ff1080"});</script>

About this course

Demand for Tableau skills has increased 1,103% in five years. Across industries, data analysis skills command a salary premium.

Beginner
Friendly

Individualized
Instructor
Support

500+ Students
Enrolled

GAIN VITAL SKILLS WITH UNIVERSAL RELEVANCE

  • Marketing managers who know SQL make 41% more than those who don’t, and General Managers earn 29% more with data analysis skills. Hone crucial proficiency in Excel, SQL, and Tableau and make career moves across industries and roles.

 

TAP INTO A VALUABLE PROFESSIONAL NETWORK

  • Form real connections that can change the course of your career. Meet practitioners and peers who can help you succeed through our global alumni network. Graduate with an industry-recognised GA certificate, and join an exclusive community.

 

LEARN ON A SCHEDULE DESIGNED FOR BUSY PROFESSIONALS

  • Join us for 10 weeks part-time in the evenings. Be a part of the GA community in the comfort of your home — wherever you’re based — via our Remote classroom.

 

APPLY YOUR KNOWLEDGE IN REAL-WORLD WORKING SCENARIOS

  • Led by industry-expert instructors, you'll be guided to create a real business module and apply learnings to a final project, utilising rigorous data analysis techniques to solve a real-world problem.

 

 

 

What you'll learn

Complete hands-on exercises with access to real-world data sets to reinforce new skills
Create a portfolio project based off a real-world data problem
Explore the the process of gathering and presenting data to tell a story

Check out our elite team of instructors

Avinnaash Suresh

Lead Instructor

Avinnaash Suresh

Lead Instructor

Premkumar Chandrashegaran

Data Analytics Instructor

Premkumar Chandrashegaran

Data Analytics Instructor

Bharath Kumar P

Lead Instructor

Bharath Kumar P

Lead Instructor

These experts bring in-depth experience from the field to the classroom each day, providing invaluable insights into succeeding on the job.

GA instructors* are committed to providing personalised feedback and support to help you gain confidence with key concepts and tools.

*GA instructors are subject to their availability

19K+ Premier Hiring Partners From Around the World

Course Outline

Explore the essentials of data wrangling — i.e., the process of finding, sifting through, cleaning, and transforming data — so it can be used to answer business questions.

The Data Framework
• Explain the value of data.
• Describe the data framework and how it’s used by analysts.
• Write a specific and testable question given a scenario.


Finding the Right Data
• Describe the data sources available for analysis.
• Evaluate data sets and their variables.
• Determine if a data set can be used to solve a business problem.


Cleaning Your Data
• Use the Filter feature to spot check for problematic data.
• Handle missing data based on industry norms.
• Use conditional formatting to identify duplicates and extreme values within a data set.
• Use Find and Replace to fix issues/errors that are easily identifiable.
• Select a data cleaning strategy based on a given scenario.


Organizing Data With Functions
• Use VLOOKUP and HLOOKUP.
• Use INDEX MATCH.
• Distinguish between the three functions.

Practice using Excel to conduct basic data cleaning, aggregation, analysis, and visualization.

Introduction to Data Analytics
• Outline goals, expectations, and logistics.
• Identify the skills and mindset of a successful data analyst.
• Discuss the discipline of data analytics, including topics such as data formats and data ethics.

Data Cleaning and Formulas
• Apply data cleaning best practices, including working with NULLs.
• Conduct exploratory analyses.
• Experiment with common Excel formulas.

Referencing and Lookups
• Build relationships between cells in Excel.
• Manipulate data sets using VLOOKUP.
• Look up values in other tables using INDEX and MATCH.

Aggregating Data With PivotTables
• Apply Excel aggregation functions to data sets.
• Use PivotTables to summarize data.
• Identify common problems and solutions for PivotTables
• Modify data structures with regular tables for efficient workbooks.

Communicating With Excel
• Identify the appropriate visualization types for the data set at hand.
• Create analytics visuals such as bar charts, pie charts, line graphs, histograms, and scatterplots.
• Explore data using conditional formatting for categorization and analysis.

Project: Apply what you’ve learned in Excel and present your process, findings, and challenges to the class, giving and receiving peer-to-peer feedback.

Use SQL to conduct advanced data querying, cleaning, and aggregation.

Introduction to SQL
• Navigate a relational database.
• Practice writing and executing SQL queries, including SELECT, FROM, WHERE, and DISTINCT SELECT.
• Work with logical and comparison operators in SQL.

Grouping in SQL
• Work with CASE to handle multiple conditions.
• Practice writing aggregate functions: MIN, MAX, SUM, AVG, and COUNT.
• Use advanced SQL commands such as GROUP BY and HAVING to group and filter data.

Combining Data With JOINs and UNIONs
• Combine data from multiple sources using INNER and LEFT JOINs.
• Compile data using UNION and UNION ALL.
• Compare use cases for JOINs and UNIONs.

Advanced JOINs and NULLs
• Practice the concepts and syntax of advanced JOINs such as EXCEPT, FULL, and OUTER.
• Handle NULLs in SQL
• Practice query optimization techniques.

Subqueries in SQL
• Construct subqueries for multi-step operations.
• Identify subquery use cases for various business scenarios.
• Practice common table expressions (CTEs) with SELECT statements.

Functions in SQL
• Apply string, math, and date functions in SQL to prepare and analyze data.
• Practice writing SQL queries with advanced functions to solve business problems.

Project: Apply what you’ve learned in SQL and present your process, findings, and challenges to the class, giving and receiving peer-to-peer feedback.

Leverage Tableau to visualize and map data, and connect data across Excel, SQL, and Tableau.

Introduction to Tableau
• Prepare data for import into Tableau.
• Navigate the Tableau interface to build visualizations.
• Aggregate measures and dimensions.
• Work with Marks Card and discrete versus continuous dates.

Data Manipulation in Tableau
• Connect to the PostgreSQL server.
• Create calculated fields to analyze data.
• Apply filters to single or multiple worksheets.

Dashboards in Tableau
• Apply visual analytics best practices.
• Design interactive dashboards with parameters, advanced filters, and layout containers.

Data Narratives
• Create stories in Tableau to illustrate data-driven decisions.
• Finalize dashboards and stories for the capstone project.

Capstone Project: Wrap up and reflect on your Data Analytics journey, applying what you’ve learned throughout the course to a real-world data set.

Pricing & Payment Plans

Installments

from as low as

RM -/month

Full Tuition

RM 7,500

excluding admin fees and 6% SST

Frequently Asked Questions

Data is an integral part of every successful business. Regardless of industry, companies need to learn how to harness data to make critical decisions. In this course, you will gain a robust and marketable skill set that can be applied to almost any industry or profession.

According to IBM, more than 2.7 million data job openings are expected in 2020, and the need for data-driven decision-makers and functional analysts will be most acute. Learning data analytics can help you advance in your current profession or explore a growing field.

Data Analytics is our best entry-level data course for professionals looking to hone analysis skills and evolve their careers. You’ll find a diverse range of students in the classroom including:

  • Data analysts who want to brush up on core techniques and formalise their skill set.

  • Digital marketers, sales managers, product managers, UX researchers, and others who deal with large volumes of data on a daily basis.

  • Managers who need to tell compelling, data-driven stories to business stakeholders to influence decision-making.

  • Career-starters looking for a practical skill set to boost their resumes.

Regardless of their backgrounds, this programme attracts students that are interested in manipulating large data sets to solve problems.

Our instructors represent the best and brightest senior analysts from top companies like Atlassian, Capital One, and Deloitte. They combine in-depth experience as practitioners with a passion for nurturing the next generation of talent.

We work with a large pool of experienced instructors around the world.

This is a beginner-friendly programme with no prerequisites. If you are new to data analysis, you will have access to three hours of pre-work to help you prepare for the course, and your Admissions producer may recommend that you take a short Excel workshop. If you already work with basic functions in Excel or have dabbled in SQL, our curriculum will enable you to perform more powerful analyses. 

Our Admissions team can discuss your background and learning goals to advise if this course is a good fit for you.

Here are just some of the things you can expect as a GA student:

  • 40 hours of expert instruction in performing defensible data analysis with Excel and SQL and communicating insights with visualization and dashboarding tools.
  • 10 hours of self-paced pre-work to brush up on data wrangling in Excel before the course begins.
  • Robust coursework, including expert-vetted lesson decks, lab materials, and more. Refresh and refine your knowledge throughout your professional journey as needed.
  • A portfolio-ready capstone project built with support from your instructor.
  • Individual feedback and guidance from instructors and TAs during office hours. Stay motivated and make the most of your experience with the help of GA’s dedicated team.
  • Exclusive access to alumni discounts, networking events, and career workshops.
  • A certificate of completion to showcase your new skill set on Linkedin.
  • Connections with a professional network of instructors and peers that lasts well beyond the course. The global GA community can help you navigate and succeed in the data analytics field.

Yes! Upon passing this course, you will receive a data analytics certificate. Thousands of GA alumni use their course certificate to demonstrate skills to employers and their Linkedin network. GA’s Data Analytics course is well-regarded by many top employers, who contribute to our curriculum and use our data courses to train their own teams.

Yes! All of our part-time courses are designed for busy professionals with full-time work commitments. 

You’ll be expected to spend time working on homework and projects outside of class each week, but the workload is designed to be manageable with a full-time job.

If you need to miss a session or two, we offer resources to help you catch up. We recommend you discuss any planned absences with your instructor.

For your capstone project, you’ll select a real-world data set for exploration and apply all of the techniques covered throughout the course to solve a problem. You’ll craft a problem statement, prepare technical documentation, and communicate findings through a stakeholder presentation. You’ll graduate with a polished, portfolio-ready project to showcase your analytical and visualisation skills. We encourage you to tackle a problem that’s related to your work or a passion project you’ve been meaning to carve out time for.

While 1-week students will concentrate on their capstone piece, 10-week students will complete two additional, smaller projects that designed to reinforce what you’ve learned in each unit. Note that the vast majority of project development will be completed outside of class.

Data Analytics is our best entry-level course for professionals wanting to develop analysis skills that can be applied in a wide range of business contexts.

Some Data Analytics graduates who have existing programming knowledge may go on to enrol in a Data Science course and learn more complex analysis techniques involving computation.

For those committed to a career change, the full-time Data Science Immersive programme provides the most direct pathway to data science and other advanced analytics roles.

We use cookies

This website and/or it's third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes outlined in our Privacy Policy and Terms and Conditions.

You accept the use of cookies or other identifiers by closing or dismissing this notice, by clicking a link or button or by continuing to browse otherwise.