1

ADVANCED DATA
ANALYTICS
TRAINING AND
CERTIFICATION
As per International Standards
 2

Unichrone Training Advantages

4 Day Interactive Instructor –led Online/Classroom or Group Training

Course study materials designed by subject matter experts

Mock Tests to prepare in a best way

Highly qualified, expert & accredited trainers with vast experience

Enrich with Industry best practices and case studies and present trends

Advanced Data Analytics training course adhered with International

Standards
End-to-end support via phone, mail, and chat

Convenient Weekday/weekend Advanced Data Analytics training Training

Course schedule
 3

About Unichrone
We are a professional training institute with an extensive portfolio
of professional certification courses. Our training programs are
meant for those who want to expand their horizons by acquiring
professional certifications across the spectrum. We train small-
and medium-sized organizations all around the world, including
in USA, Canada, Australia, UK, Ireland and Germany.

Guaranteed Quality Handpicked Trainers

Global Presence Online Training Option

 4
Importance of Advanced Data Analytics Certification Training

Advanced Data Analytics Certification molds a professional to use the data constructively and to
coerce innovation-driven decisions in their career. By attaining this certification, an individual
encompasses their awareness in various aspects of data analytics. It includes descriptive analytics,
diagnostic analytics, predictive analytics, and prescriptive analytics. Furthermore, Advanced Data
Analytics Certification adorns professionals with obligatory knowledge in data visualization, text mining,
social media analysis, and more.

Advanced-Data Analytics Certification Training covers the latest techniques such as data mining,
predictive modeling, machine learning, and data visualization. It empowers data analysts to take up
real-world data projects by supporting them with real data examples to work with. This training
program lets professionals gain knowledge from a basic level right from importing intricated data,
cleaning and sorting data, merging, grouping, aggregating, and exploring data analysis to processing
the resultant data for statistics, presentation, and so on.
 5

ELIGIBILITY CRITERIA
Aspirants need not meet any requirements to pursue Advanced Data Analytics Training Course. However,
having prior knowledge of the ISO standard is beneficial.

WHO SHOULD ATTEND

Anyone involved in and wanting to gain knowledge about data analytics can attend Advanced Data
Analytics Training Course.
 6

HELPS
BUILDING

ADVANCED DATA VALUES

ANALYTICS TRAINING CERTIFIES GLOBAL

CERTIFICATION YOUR TALENT RECOGNITION

Advantages
PERFECT
EXECUTION

BUILDS
CUSTOMER MORE
LOYALTY EMPLOYABILITY
OPTIONS
 7

Syllabus of Advanced Data Analytics Training

Domain 1: Data Analytics

Lesson 01 – Introduction to Data Analytics Lesson 02 – Introduction to Statistical Analysis

1. Data Analytics Overview

1. Counting, Probability, and Probability Distributions
• Types of Data Analytics
Descriptive Analytics
2. Sampling Distributions
2. • Diagnostic Analytics
• Predictive Analytics
• Prescriptive Analytics 3. Estimation and Hypothesis Testing

3. Benefits of Data Analytics

4. Scatter Diagram
4. Data Visualisation for Decision Making
Data Types, Measure of Central Tendency, Measures of 5. ANOVA and Chi-Square
5.
Dispersion
6. Graphical Techniques, Skewness and Kurtosis, Box Plot 6. Imputation Techniques

7. Descriptive Stats
Sampling Variation, Central Limit Theorem, Confidence
7. Data Cleaning
8.
Interval
9. Optimisation Techniques for Data Analytics
8. Correlation and Regression

2022 All Rights Reserved

 8

Syllabus of Advanced Data Analytics Training

Lesson 03 – Data Wrangling with SQL

Lesson 04 – Presto
1. Introduction to SQL

2. Database Normalisation 1. Introduction to Presto

3. Entity-Relationship Model
2. Writing Queries in Presto on Large Data Sets
4. SQL Operators

5. Join, Tables, and Variables

6. SQL Functions

7. Subqueries

8. Views and Stored Procedures

9. User-Defined Functions

10. SQL Performance and Optimisation

Advanced Concepts
11.
Correlated Subquery
Grouping Sets
2022 All Rights Reserved
 9

Syllabus of Advanced Data Analytics Training

Lesson 05 – Feature Engineering

1. Handling Unstructured Data

2. Machine Learning Algorithms

3. Bias Variance Trade-Off

4. Imbalance Data

5. Handling Unbalanced Data

6. Boosting

7. Model Validation

8. Hyper Parameter Optimisation

9. Advanced Machine Learning Libraries – Xgboost

10. Solving Problems on Kaggle

2022 All Rights Reserved
 10

Syllabus of Advanced Data Analytics Training

Domain 2: Business Analytics with Excel
Lesson 06 – Introduction to Data Analysis with MS
Excel
Lesson 07 – Cleaning Data with Text Functions
1. Steps to Analyse Data

2. Introduction to Tables Removing Unwanted Characters from the Text

1.
• Steps for Data Cleaning

2022 All Rights Reserved

 11

Syllabus of Advanced Data Analytics Training

Lesson 08 – Sorting and Filtering

Lesson 9 – Exploring Lookup Functions

1. What is Sorting and Filtering?

1. VLookUp Functions in Excel

2. Applying Sorting on Two Columns

2. HLookUp Functions in Excel

3. Steps to Sort Dates and Columns by Colours

4. Apply Filtering

5. Clear Filter

6. Apply Filter on Text

2022 All Rights Reserved

 12

Syllabus of Advanced Data Analytics Training

Lesson 10 – Introduction to Power Pivot and Formula

Auditing
Lesson 11 – DAX Variables and Formatting
1. Working with Pivot Tables

2. How to Use Power Pivot?

1. What is DAX?
3. Measures

4. Dimension Tables
2. Data Types and Operators
5. Relationships
3. DAX Variables
6. Advanced Functions

7. Data Visualisation and Analysis 4. Formatting DAX Code

8. Show Formulas
5. Debugging Errors in DAX Code
9, Trace Precedents

10. Trace Dependents 6. Progressive DAX Syntax and Functions

11. Evaluate Formula

2022 All Rights Reserved

 13

Syllabus of Advanced Data Analytics Training

Lesson 12 – Introduction to Power Map

Lesson 13 – Design a Dashboard Using Data Model

1. Create a Power Map

1. Using PowerPoint and Excel
2. Explore Sample Datasets in Power Map
2. Make a Dashboard in Excel

3. Visualise Data in Power Map

3. Customise with Macros, Colour, etc.

4. Create a Custom Map in Power Map

4. Make a Dashboard in Smartsheet

2022 All Rights Reserved

 14

Syllabus of Advanced Data Analytics Training

Domain 3: Programming Basics and Data Analytics with Python

Lesson 14 – Python for Data Analysis - NumPy Lesson 15 – Python for Data Analysis – Pandas

1. Introduction to NumPy 1. Installing Pandas

2. Pandas Objects
2. NumPy Arrays
3. Data Indexing and Selection
3. Aggregations 4. Operating on Data in Pandas

5. Handling Missing Data

4. Computation on Arrays: Broadcasting
6. Hierarchical Indexing
5. Comparison, Boolean Logic and Masks
7. Concat and Append

6. Fancy Indexing 8. Merge and Join

9. Aggregations and Grouping

7. Sorting Arrays
10. Pivot Tables

8. NumPy’s Structured Arrays 11. Vectorised String Operations

12. Working with Time Series

2022 All Rights Reserved
 15

Syllabus of Advanced Data Analytics Training

Domain 3: Programming Basics and Data Analytics with Python
Lesson 16 – Python for Data Visualisation – Matplotlib
Lesson 17 – Python for Data Visualisation – Seaborn
1. Overview

2. Object-Oriented Interface
1. Installing Seaborn and Load Dataset
3. Simple Line Plots and Scatter Plots

4. Visualising Errors 2. Plot the Distribution

5. Contour Plots
3. Regression Analysis
6. Histograms, Binnings, and Density

7. Customising Plot Legends 4. Basic Aesthetic Themes and Styles

8. Customising Colour Bars

Distinguish Between Scatter Plots, Hexbin Plots, and KDE
5.
9. Multiple Subplots Plots

10. Text Annotation

6. Use Boxplots and Violin Plots
11. Three-Dimensional Plotting

2022 All Rights Reserved

 16

Syllabus of Advanced Data Analytics Training

Domain 4: Tableau Training

Lesson 18 – Get Started

Lesson 19 – Data Sources

1. What is Tableau?
1. Types of Data Sources
2. Steps in Creating Tableau Data Analysis Report
2. Custom Data View
3. Navigation
3. Extracting Data
4. Data Terminology
4. Fields Operations
5. Design Flow
5. Editing Metadata
6. File Types

7. Data Types 6. Data Joining

8. Show Me 7. Data Blending

2022 All Rights Reserved

 17

Syllabus of Advanced Data Analytics Training

Domain 4: Tableau Training

Lesson 20 – Worksheets Lesson 21 – Calculations

1. Add and Rename 1. Operators

2. Functions
2. Save and Delete Calculations
• Numeric
3. • String
• Date
3. Reorder Worksheet
• Table

4. LOD Expressions
4. Paged Workbook

2022 All Rights Reserved

 18

Syllabus of Advanced Data Analytics Training

Domain 4: Tableau Training

Lesson 23 – Tableau Charts

Lesson 22 – Sort and Filters
Chart
• Bar
1.
1 • Line
Basic Sorting
. • Pie
2. Crosstab
2 3. Scatter Plot
.
Basic Filters
4. Bubble Chart
Filters
3 • Quick
5. Bullet Graph
. • Context 6. Box Plot
• Condition
7. Tree Map
4
.
Top Filters 8. Bump Chart
9. Gantt Chart
5 10. Histogram
.
Filter Operations
11. Motion Charts
12. Waterfall Charts

2022 All Rights Reserved

 19

Exam Format of Advanced Data Analytics Training Certification

Examination Format

Advanced Data Analytics

Exam Name
exam

Exam Format Multiple Choice

30 Questions, 1 Hour
Total Questions & Duration

Passing Score Minimum passing score of 70%

Exam Cost Included in training fee

To get you fully prepared with the knowledge and skills for the Advanced Data Analytics, a training session at Unichrone
gives immense importance to mock questions at the end of every module and problem-solving exercises within the
session. Prepared by certified faculty, the practice tests are a true simulation of Advanced Data Analytics exam.

2022 All Rights Reserved

Contact Us
support@unichrone.com

https://unichrone.com/

Copyright © Unichrone. All Rights Reserved