Advanced Data Analytics Certification | Analytics Training in Hong Kong

Home

Courses

Big Data and Analytics Training

Advanced Data Analytics Course

Hong Kong

Learn cutting-edge techniques for complex data analysis and interpretation
Gain practical skills in machine learning and big data technologies
Advanced Data Analytics Certification boosts your analytical skill set

Dates & Prices Dates & Prices

Course information

Advanced Data Analytics Certification Course Outline

Domain 1: Data Analytics

Module 1: Introduction to Data Analytics

Data Analytics Overview
Types of Data Analytics
- Descriptive Analytics
- Diagnostic Analytics
- Predictive Analytics
- Prescriptive Analytics
Benefits of Data Analytics
Data Visualisation for Decision Making
Data Types, Measure of Central Tendency, Measures of Dispersion
Graphical Techniques, Skewness and Kurtosis, Box Plot
Descriptive Stats
Sampling Variation, Central Limit Theorem, Confidence Interval
Optimisation Techniques for Data Analytics

Module 2: Introduction to Statistical Analysis

Counting, Probability, and Probability Distributions
Sampling Distributions
Estimation and Hypothesis Testing
Scatter Diagram
ANOVA and Chi-Square
Imputation Techniques
Data Cleaning
Correlation and Regression

Module 3: Data Wrangling with SQL

Introduction to SQL
Database Normalisation
Entity-Relationship Model
SQL Operators
Join, Tables, and Variables
SQL Functions
Subqueries
Views and Stored Procedures
User-Defined Functions
SQL Performance and Optimisation
Advanced Concepts
- Correlated Subquery
- Grouping Sets

Module 4: Presto

Introduction to Presto
Writing Queries in Presto on Large Data Sets

Module 5: Feature Engineering

Handling Unstructured Data
Machine Learning Algorithms
Bias Variance Trade-Off
Imbalance Data
Handling Unbalanced Data
Boosting
Model Validation
Hyper Parameter Optimisation
Advanced Machine Learning Libraries – Xgboost
Solving Problems on Kaggle

Domain 2: Business Analytics with Excel

Module 6: Introduction to Data Analysis with MS Excel

Steps to Analyse Data
Introduction to Tables

Module 7: Cleaning Data with Text Functions

Removing Unwanted Characters from the Text
- Steps for Data Cleaning

Module 8: Sorting and Filtering

What is Sorting and Filtering?
Applying Sorting on Two Columns
Steps to Sort Dates and Columns by Colours
Apply Filtering
Clear Filter
Apply Filter on Text

Module 9: Exploring Lookup Functions

VLookUp Functions in Excel
HLookUp Functions in Excel

Module 10: Introduction to Power Pivot and Formula Auditing

Working with Pivot Tables
How to Use Power Pivot?
Measures
Dimension Tables
Relationships
Advanced Functions
Data Visualisation and Analysis
Show Formulas
Trace Precedents
Trace Dependents
Evaluate Formula

Module 11: DAX Variables and Formatting

What is DAX?
Data Types and Operators
DAX Variables
Formatting DAX Code
Debugging Errors in DAX Code
Progressive DAX Syntax and Functions

Module 12: Introduction to Power Map

Create a Power Map
Explore Sample Datasets in Power Map
Visualise Data in Power Map
Create a Custom Map in Power Map

Module 13: Design a Dashboard Using Data Model

Using PowerPoint and Excel
Make a Dashboard in Excel
Customise with Macros, Colour, etc.
Make a Dashboard in Smartsheet

Domain 3: Programming Basics and Data Analytics with Python

Module 14: Python for Data Analysis - NumPy

Introduction to NumPy
NumPy Arrays
Aggregations
Computation on Arrays: Broadcasting
Comparison, Boolean Logic and Masks
Fancy Indexing
Sorting Arrays
NumPy’s Structured Arrays

Module 15: Python for Data Analysis – Pandas

Installing Pandas
Pandas Objects
Data Indexing and Selection
Operating on Data in Pandas
Handling Missing Data
Hierarchical Indexing
Concat and Append
Merge and Join
Aggregations and Grouping
Pivot Tables
Vectorised String Operations
Working with Time Series

Module 16: Python for Data Visualisation – Matplotlib

Overview
Object-Oriented Interface
Simple Line Plots and Scatter Plots
Visualising Errors
Contour Plots
Histograms, Binnings, and Density
Customising Plot Legends
Customising Colour Bars
Multiple Subplots
Text Annotation
Three-Dimensional Plotting

Module 17: Python for Data Visualisation – Seaborn

Installing Seaborn and Load Dataset
Plot the Distribution
Regression Analysis
Basic Aesthetic Themes and Styles
Distinguish Between Scatter Plots, Hexbin Plots, and KDE Plots
Use Boxplots and Violin Plots

Domain 4: Tableau Training

Module 18: Get Started

What is Tableau?
Steps in Creating Tableau Data Analysis Report
Navigation
Data Terminology
Design Flow
File Types
Data Types
Show Me

Module 19: Data Sources

Types of Data Sources
Custom Data View
Extracting Data
Fields Operations
Editing Metadata
Data Joining
Data Blending

Module 20: Worksheets

Add and Rename
Save and Delete
Reorder Worksheet
Paged Workbook

Module 21: Calculations

Operators
Functions
Calculations
- Numeric
- String
- Date
- Table
LOD Expressions

Module 22: Sort and Filters

Basic Sorting
Basic Filters
Filters
- Quick
- Context
- Condition
Top Filters
Filter Operations

Module 23: Tableau Charts

Chart
- Bar
- Line
- Pie
Crosstab
Scatter Plot
Bubble Chart
Bullet Graph
Box Plot
Tree Map
Bump Chart
Gantt Chart
Histogram
Motion Charts
Waterfall Charts

Who should attend this Advanced Data Analytics Certification Course?

The Advanced Data Analytics Certification Training is designed for individuals aiming to delve deep into Data Analysis techniques, methodologies, and applications. This course can be beneficial for a wide range of professionals, including:

Data Scientists
Data Analysts
Business Analysts
Machine Learning Engineers
Business Intelligence Professionals
Database Administrators
Quantitative Researchers

Prerequisites of the Advanced Data Analytics Certification Course

There are no formal prerequisites for attending this Advanced Data Analytics Certification Course.

Advanced Data Analytics Certification Course Overview

Advanced Data Analytics stands at the forefront of enabling businesses and organisations to make data-driven decisions. By leveraging complex datasets, analytics techniques, and tools, professionals can uncover valuable insights, predict trends, and optimise operations, making it a critical skill in today’s data-centric world.

Proficiency in Advanced Data Analytics is crucial for data scientists, business analysts, and IT professionals who aim to excel in predictive analytics, extensive data analysis, and visualisation. Mastering this domain enables them to drive strategic decisions, enhance business outcomes, and maintain a competitive edge in the rapidly evolving digital landscape.

This 4-day training is designed to equip delegates with the knowledge and skills to apply advanced analytics techniques effectively. Participants will learn to navigate complex data, utilise modern analytics tools, and implement best practices in data analysis, preparing them for immediate application in real-world scenarios and advancing their careers.

Course Objectives

To understand the foundational and advanced principles of data analytics
To learn to apply statistical models and machine learning algorithms for predictive analytics
To gain proficiency in using leading analytics software and tools
To develop skills in data visualisation and interpretation of results for strategic decision-making
To enhance data handling capabilities, including big data platforms

After completing this Data Analytics Course, delegates will receive a certification, signifying their ability to handle complex analytics projects. This certification boosts career prospects, showcases expertise, and empowers data-driven contributions in organisations.

What’s included in this Advanced Data Analytics Certification Course?

World-Class Training Sessions from Experienced Instructors
Advanced Data Analytics Certificate
Digital Delegate Pack

Why choose us

Our Hong Kong venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Hong Kong is an autonomous territory of the People’s Republic of China and can be located on the southern coast of China. Hong Kong has a population of around 7 million people. The education system in Hong Kong is mostly based around the English system and it is overseen by the Education Bureau and the Social Welfare Department. One of the earliest schools in Hong Kong was Li Ying College established in 1075. The education level begins with preschool education that is payable education, paid by pupil’s parents. The primary and secondary education is mandatory for every child in Hong Kong to attend from the age of 6 to 18. Higher education remains exclusive in Hong Kong and adult education is a growing sector in Hong Kong, with two non-profit school running evening courses. The University of Hong Kong was founded in 1911 and is the oldest tertiary (higher education) institution in Hong Kong and is organised into 10 academic faculties with English as the main language of instruction. The Education Bureau in Hong Kong also provides educational services for immigrant children from mainland China and other countries. Hong Kong also has 175 internal schools.

Address

62/F & 66/F
The Center
99 Queens Road
Central
Hong Kong

T: +852 2592 5349

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Advanced Data Analytics Certification | Analytics Training in Hong Kong. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

Learn more in our FAQs

Unlock your potential with The Knowledge Academy's Advanced Data Analytics Certification | Analytics Training in Hong Kong, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Learn more in our FAQs

What our customers are saying

Great!

Paul Cross

Advanced Data Analytics Certification | Analytics Training in Hong Kong FAQs

What is the Advanced Data Analytics Certification about?

The Advanced Data Analytics Certification by The Knowledge Academy equips learners with the skills to handle complex datasets, perform predictive and prescriptive analytics, and make data-driven decisions. It covers advanced tools and techniques, including machine learning, statistical analysis, and big data analytics.

How do I become an Advanced Data Analyst?

To become an Advanced Data Analyst, you need a strong foundation in data analytics, followed by specialised training in advanced techniques like machine learning, data modeling, and predictive analytics. The Knowledge Academy's Advanced Data Analytics Certification is an excellent pathway to gain these skills and enhance your expertise.

What is the difference between Data Analytics and Advanced Analytics?

Data analytics involves examining datasets to draw basic insights and trends, while advanced analytics goes a step further with predictive and prescriptive techniques, using tools like machine learning and artificial intelligence to forecast future trends and make strategic decisions.

Who should attend this Data Analytics Course Online?

This course is ideal for Data Professionals looking to advance their skills, as well as individuals aspiring to transition into advanced data roles. It’s also suitable for business analysts, IT professionals, and anyone involved in data-driven decision-making.

What topics are covered in the Advanced Data Analytics Certification?

The course covers a wide range of topics, including data mining, statistical analysis, predictive analytics, machine learning, big data tools, and data visualisation techniques. You will also learn how to use platforms like Python, R, and SQL for advanced analytics.

Are there any prerequisites to attend this Advanced Data Analytics Training Online?

There are no formal prerequisites for this Advanced Data Analytics Training. However, a basic knowledge of data analysis, statistics, or programming languages like Python or R will be beneficial.

Do you provide corporate training for this Data Analytics Course?

Yes, The Knowledge Academy offers tailored corporate training for teams, helping organisations upskill their workforce in advanced data analytics. Our corporate packages are flexible and designed to meet the specific needs of businesses across industries.

What are the benefits of taking this Data Analytics Training and Certification?

The Advanced Data Analytics Certification offers a competitive edge by providing hands-on experience with cutting-edge tools and methodologies. It boosts your analytical capabilities, improves decision-making skills, and enhances your career prospects in a rapidly growing industry.

Do you provide self-paced Online Data Analytics Training?

Yes, The Knowledge Academy offers a flexible self-paced option for this course, allowing learners to study at their own convenience. This option is ideal for those with busy schedules or those who prefer to learn at their own pace.

What is included in the course?

The course includes comprehensive study materials, practical exercises, real-world case studies, and access to leading data analytics software. You’ll also receive support from expert trainers throughout your learning journey.

What is the duration of this Online Data Analytics Course?

The course duration for this Online Data Analytics Course is 4 days.

Do you offer 24/7 support for this Online Data Analytics Training?

Yes, we provide 24/7 support for all learners attending our online courses. Whether you need help with technical issues or have questions about the course content, our dedicated support team is always available.

What will I learn in this Data Analytics Training Course?

You will learn advanced data analytics techniques, including predictive modeling, machine learning, big data handling, and data visualisation. Additionally, you’ll master tools like Python, R, and SQL to perform complex data analysis and make informed decisions.

What can be my next steps after completing the Advanced Data Analytics Certification?

After completing the certification, you can pursue advanced roles such as Data Scientist, Senior Data Analyst, or Analytics Consultant. You may also consider specialising in areas like machine learning, AI, or big data analytics to further enhance your skills.

How will this Advanced Data Analytics Certification benefit my career?

The certification opens up numerous career opportunities in data-driven industries. It demonstrates your expertise in advanced analytics, making you a strong candidate for roles like Data Scientist, Analytics Manager, or Data Engineer in top organisations.

Can I access the course materials after the training period ends?

Yes, The Knowledge Academy provides continued access to the course materials even after the training period ends. This allows you to revisit the content and reinforce your learning whenever necessary.

What kind of certification will I receive upon completion of the course?

Upon successful completion, you will receive a globally recognised certification in Advanced Data Analytics from The Knowledge Academy, which showcases your proficiency and expertise in advanced data analytics techniques.

How can I attend the course?

Attending the course is easy. You can sign up directly through The Knowledge Academy's website or contact our support team to assist you with the registration process. We offer multiple course delivery options to suit your needs.

What kind of jobs can I expect based on this Data Analytics Course?

After completing this course, you can pursue roles like Data Scientist, Senior Data Analyst, Business Intelligence Analyst, or Analytics Manager. These roles offer excellent career growth opportunities in various industries, including finance, healthcare, and technology.

Why choose The Knowledge Academy in Hong Kong over others?

The Knowledge Academy stands out as a prestigious training provider known for its extensive course offerings, expert instructors, adaptable learning formats, and industry recognition.

What is the cost/training fees for Advanced Data Analytics Course in Hong Kong?

The training fees for Advanced Data Analytics Coursein Hong Kong starts from HKD11995

Which is the best training institute/provider of Advanced Data Analytics Course in Hong Kong?

The Knowledge Academy is the Leading global training provider for Advanced Data Analytics Course.

What are the best Big Data and Analytics Training courses in Hong Kong?

Please see our Big Data and Analytics Training courses available in Hong Kong

Why choose us

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Looking for more information on Big Data and Analytics Training?

Back to course information

Upcoming classes
Package deals

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on +852 2592 5349 and speak to our training experts, we should be able to help you with your requirements.

Book now