Enriching Experience
I'm immensely grateful for the invaluable knowledge imparted by our dedicated instructors who are always there to guide and support me. It has been an enriching experience!
Data Analytics Bootcamp learner
Data Analytics
Equip teams with the skills to effectively use key data tools such as Excel, SQL, and Tableau for comprehensive data analysis, valuable insights communication, and the successful execution of end-to-end data projects with our programmes.
Note: Python programming is available for Immersive
Data Analytics Bootcamp
Overview:
Prerequisites:
This is a beginner-friendly program 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.
Ideal for:
This program was created for analysts, digital marketers, sales managers, product managers, and data novices looking to learn the essentials of data analysis.
Outcomes:
- Use Excel, SQL, and Tableau to collect, clean, and analyze large data sets.
- Present data-driven insights to key stakeholders using data visualization and dashboards.
- Tell compelling stories with your data.
Curriculum Outline:
- Pre-work on Data Analytics Fundamentals
- Data Cleaning & Interpretation
- Querying & Organising
- Visualisation & Narrative
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 visualise 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 visualisations.
• Aggregate measures and dimensions.
• Work with the Marks Card and discrete versus continuous dates.
Data Manipulation in Tableau
• Connect to the PostgreSQL server.
• Create calculated fields to analyse 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.
• Finalise dashboards and stories for the capstone project.
Capstone Project:
Wrap up and reflect on your Data Analytics journey, applying what you’ve learnt throughout the course to a real-world dataset.
Data Analytics Immersive
Overview:
Prerequisites:
This is a beginner-friendly programme for those who are looking to transition into a career in data. Show up on day one with no data experience whatsoever, and leave on week 12 ready to start an entry-level data analyst position – with the portfolio to back it up.
Ideal for:
Those wanting a career transformation. This full-time data analytics course is designed to help learners launch a career in one of the most in-demand fields today.
Outcomes:
Learn to problem solve, and effectively communicate, like an analyst. This course teaches you to use industry-standard tools to make ethical, data-driven decisions. Hands-on training to master SQL, Excel, Tableau, PowerBI, and Python – tools listed in virtually every data analytics job posting across industries.
Curriculum Outline:
- Data Ethics & Diagnosis
- Statistics & Mathematics
- Data Acquisition & Cleaning
- Data Analysis & Interpretation
- Data Analysis withTableu & Power BI
- Data Analysis with Python
- Data in the Organisation
- Capstone Projects
- Post-Training - Career Planning (option for individuals)
Prefer personalised consultation on corporate training?
WHAT LEARNERS SAY ABOUT OUR DATA ANALYTICS COURSE
Extensive Training Course
The course was extensive and the instructor was good. He is patient to explain complex things and simplify them through explanations.
Management Trainee at a leading financial services group
Engaging Class
I really appreciate the instructor's effort to keep us engaged in class. Additional knowledge and sharing from the instructor also allows us to know more about real scenarios.
Analyst of a leading financial services group
AKADEMI GA
is an exclusive partner of General Assembly (GA) in Malaysia. Akademi GA is now a member of the Excelerate Group.
Akademi GA has acquired all rights to market and deliver General Assembly digital courses. It is registered as a training provider with the Ministry of Finance (MOF), Human Resource Development Corporation (HRD Corp) and Malaysia Digital Economy Corporation (MDEC).
FAQs About Our Data Analytics Course
Yes! Upon passing this course, you will receive a signed certificate of completion. Thousands of GA alumni use their course certificate to demonstrate skills to employers and their LinkedIn networks. GA’s front-end developer course is well-regarded by many top employers, who contribute to our curriculum and use our tech programmes to train their own teams.
Yes! All of our part-time courses are designed for busy professionals with full-time work commitments.
You will be expected to spend time working on homework and projects outside of class hours 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.
DA students come from all walks of life but share one common mission: They are passionate about launching a career in data analytics. We see career-changers from diverse professional backgrounds, including engineers and recent STEM graduates, mid-career marketing and financial analysts, and business strategists, as well as more those from more far-flung fields like sales and the law.
Our exclusive content partnership with General Assembly sets us apart from other providers in Malaysia. General Assembly is a globally renowned tech training provider that offers various courses in coding, data, and UX. General Assembly Malaysia (Akademi GA) is a subsidiary of Excelerate, and as such, we have exclusive rights to market and deliver General Assembly digital courses in Malaysia, including this power-packed data analytics course.
We offer both bootcamp (part-time) and immersive (full-time) style programmes that cater to different needs. Our bootcamp is ideal for those with full-time jobs to learn the essentials of data analysis. It's 100% HRD Corp Claimable, so you can confidently approach your employer about signing you up at zero cost.
The immersive programme, on the other hand, helps those who want to transition into a career in data analytics by equipping them with all the skills required for an entry-level position, including Python programming.
The quality and flexibility we offer our students is what makes this one of the best data analytics courses in Malaysia.
Yes! This data analysis course for beginners has no prerequisites. You don’t need any experience in data analytics or programming to join the course.
If you are interested in learning Python for data analysis, our immersive (full-time) course will teach you Python programming in addition to SQL, Excel, Tableau, and PowerBI. You will leave this 12-week training programme with the skills required to start an entry-level data analyst position.
If you prefer a shorter course, without Python programming, to learn all the essentials of data analysis, our bootcamp (part-time) course is a great choice.
Yes! Students in our data analyst bootcamp who are new to data analysis are given access to three hours of pre-work to help them prepare for the course and hit the ground running.
Our pre-work materials will help you learn the fundamentals of data analysis such as how to find, clean and organise data with functions. You can review the pre-work at your own pace and start the course confidently having learned some of the key fundamentals.