What is the average salary for this position after the completion of this PG certification in Data Analytics online course?

Those who complete this online degree earn an average annual salary of $9.25 lakhs.

What is the highest salary for this data analyst course?

The highest annual salary for this data analyst is Rs 28 lakhs.

What are the training programs available for this course?

This training program is highly industry-focused and will help you clear interviews on your first or second attempt. You will also receive round-the-clock support and 100% placement assistance from the expert team

Are there any installments for the fee payments?

Yes, there are five installment methods, including GST.

Who explains this online course on the Nulearn platform?

The highly experienced professional mentors from the nulearn platform explain this online course.

What are the skills you are gaining for interview purposes by taking this online course?

It helps you create an impressive resume and LinkedIn profile, a GitHub profile that recruiters find difficult to reject, and get interview tips for getting placed with huge salaries.

Who issues the completion certificate for this online PG certification in Data Analytics?

A certificate of completion for this online course is provided by "The Scholar."

PG Certification in Data Analytics by The Scholar via Nulearn: Fee, Duration, How to Apply

PG Certification in Data Analytics

The Scholar via Nulearn

Learn more fundamental data analytics concepts so you can become a data analyst with The Scholar's online course for PG certification in Data Analytics

Online

6 Months

₹ 95000

particular	details
Medium of instructions English	Mode of learning Self study, Virtual Classroom	Mode of Delivery Video and Text Based	Frequency of Classes Weekdays, Weekends

particular

details

                                    Medium of instructions
                                    English

                                    Mode of learning
                                    Self study, Virtual Classroom

                                    Mode of Delivery
                                    Video and Text Based

                                    Frequency of Classes
                                    Weekdays, Weekends

Module 1: SQL

Introduction to Data Warehouse

What is data warehouse
Data warehouse architecture
Top down approach
Bottom up approach
Data lake architecture
Data lake and warehouse architecture
Data lake vs. Data warehouse
OLTP vs. OLAP

Facts and Dimensions

Additive Fact
Factless Fact
Non Additive Fact
Semi Additive Fact
Role playing dimension
Junk dimension
Degenerate Dimension
Conformed Dimension
Slowly Changing Dimension

Normal Forms

Normal Forms 1NF
Normal Forms 2NF
Normal Forms 3NF
Normal Forms 4NF

Introduction to Constraints - Part 1

Naming Rules
Data Types
Default Constraint
Primary Key Constraints
Foreign Key Constraints

Introduction to Constraints - Part 2

Not Null Constraint
Unique Constraint

Types of SQL Commands

Data Definition Language
Data Query Language
Data Manipulation Language
Data Control Language
Transaction Control Language

Operators and Clauses

Concatenation
Where Clause
Like Clause
Between and
Is null
Order by

Single Row Function - Part 1

Character
Number
Date

Single Row Function - Part 2

Conversion
General Functions
NVL
NVL2
COALESCE
Case When
Decode

Multi Row Function

Avg
Count
Min
Max
Stddev
Sum
Variance

Joins in SQL - Part 1

Different types of joins
Inner
Left Outer Join
Right Outer Join
Full Outer Join

Joins in SQL - Part 2

Self-Join
Non Equi Join
Cross Joins

Joins in SQL - Part 3

Self-Join

Single Row SubQuery

Detailed understanding of single row subquery

Multiple Rows SubQuery

Detailed understanding of multiple row subquery
In clause
Any Clause
All Clause

Multiple Column Sub Queries

Non Pairwise
Pairwise
Correlated Sub Queries

Exists and With Clauses

Detail understanding of Exists and With Clauses

Set Operators in SQL

Union
Union All
Intersection
Minus

Data Manipulation

Insert Statements
Update Statements
Delete Statements
Truncate

Views in SQL

Simple and Complex views
Update through views

Sequences, Synonyms and Index

Sequences and its uses
Synonyms and its uses
Index and its benefits and Drawbacks

Alter Statements in SQL

How to add the constraints
Alter statements
System tables

Multi Table Inserts

Unconditional Inserts
Conditional Inserts
Condition First Insert
Pivoting Insert

Merge in SQL

Update using Merge
Insert using Merge

Hierarchical Data Fetching

Connect by Prior

Regular Expressions

REGEXP_LIKE
REGEXP_INSTR
REGEXP_SUBSTR
REGEXP_REPLACE
REGEXP_COUNT

Analytics Functions - Part 1

Row Number
Rank
Dense Rank

Analytics Functions - Part 2

Row Number
Rank
Dense Rank

Materialized Views

Importance of Materialized Views
Complete on Demand
Complete on Commit
Fast on Demand
Explain Plan

SQL Interview Prep - Advanced Select

Understanding of advanced Select

SQL Interview Prep U+2013 Joins

Understanding of Joins and advanced joins

Module 2: Tableau

Tableau - An introduction

Understanding Tableau and its products
Tableau Public
Tableau Desktop
Tableau Reader
Tableau Online
Tableau Server
Tableau Prep
Tableau Mobile

Tableau - Creating first chart

Understanding the Calculated Field concept
If and Else statements
Left Function
Making data ready for visualization using Tableau Prep

Tableau - Mode of connection

Understanding the concept of Live and Extract connections
Data Source filters
Union and its usage

Tableau - Data from Heterogeneous data sources

Dive deep into the concept of Joins and how can we achieve in Tableau
Applying the data joining using Tableau Prep
Dive deep into the concept of Cross database joins
Applying Cross database joins using Tableau Prep
Understanding of Data Blending
Understanding the concept of Primary and Secondary data sources

Tableau - Data Blending in Tableau

Dive Deep into Data Blending
Understanding the usage of Data Joining, Cross Database Join and Data Blending
Solving the end-to-end problem using Data Blending

Tableau - Bins, Parameters and creating our first dashboard

Creating the map view and understanding the idea of maps
Creating the histogram and dynamic histogram using parameters
Creating Donut chart
Creating the stackbar chart
Creating the interactive dashboard

Tableau - Dashboard and Story

Difference between Tiled and Floating options
Adding the buttons to download the dashboard as ppt, image and pdf
Creating the story
Understanding the difference between Dashboard and Story

Tableau - Time series analysis

Understanding the concepts of Data dimension
Difference between Discrete and continuous date field
What is the relation between aggregation and Granularity?
How to apply normal filters or Quick Filters
Options in the Normal Filters or Quick Filters
Understanding on Context Filters

Tableau - Sets and Parameters for more dynamic visualization

Create a dynamic scatter plot using the concepts of Sets and Parameters
Understanding the concept of sets
Understanding the concept of Static Sets
Understanding the concept of Dynamic Sets
How to tag parameters with sets to make it dynamic sets
How to tag parameters with reference lines

Tableau - Combined Sets and Formatting of the visuals

Understanding the concept of Combined sets
Formatting the visuals
Adding sets as filters

Tableau - Animation in Tableau - Data Prep

Formatting the data as per the requirement using Tableau Prep
Formatting the data as per the requirement using Tableau Desktop
Advantage and Disadvantage of using Tableau Desktop as data preparation tool

Tableau - Animation in Tableau - Visualization

Creating the animated scatter plot using Animation concept
How to animate the chart using page shelf
Which data to choose as Primary data source
Formatting the plot
Sorting the secondary data source
Adding show history option in the animation

Tableau - Level of Details (Include)

Understanding the concept of Include Function
Creating the visual using Include function in Tableau

Tableau - Level of Details (Include and Exclude)

Implementing the include function on the real time use case
Creating the visual using Include function in Tableau
Understanding the concept of Exclude and where to use it
Implementing the exclude function on the real time use case
Creating the visual using exclude function in Tableau

Tableau - Level of Details (Fixed)

Understanding the concept of Fixed and where to use it
Implementing the Fixed function on the real time use case
Creating the visual using Fixed function in Tableau

Tableau - Level of Details (Real time use cases)

Customer Order Frequency
Cohort Analysis
Daily Profit KPI
Percentage of Total
New Customer Acquisition
Average of top deals by city
Actual vs. Target
Value on the last day of the period
Return Purchase by cohort
Percentage difference from average across a range
Relative Period Filtering
User login frequency
Proportional Brushing
Annual Purchase frequency by customer cohort
Comparative sales analysis

Tableau - Table Calculation - Data Prep Part 1

Preparing the data using Tableau Prep
Understanding the datetime dimension and its purpose

Tableau - Table Calculation - Data Prep Part 2

Preparing the data using Tableau Desktop
Pivoting using Tableau Prep
Pivoting using Tableau Desktop

Tableau - Table Calculation - Functions Part 1

Running Sum
Difference
Percentage Difference
Understanding Table Across, Table Down
Fixing the calculation by dimension
Understanding the difference between Table calculation and Calculated Field
Dive deep on the functions Lookup, ZN

Tableau - Table Calculation - Functions Part 2

Moving Average

Creating the logic for Quality assurance in the output

Module 3: Python

Module 4: Power BI (Self Paced)

Introduction to PowerBI and its architecture
Import data from CSV files
Import data from Excel files
Import data from Web 1
Import data from Web 2
Import Real-time Streaming Data
Import data from Oracle
Import Data from Folder
Dataflows - Introduction
Dataflows - Create Gateway from Scratch
Dataflows - Create Entities from CSV file
Dataflows - Create Entities Using SQL Server
Remove Rows
Remove Columns
Make first row as headers
How to create calculate columns
How to remove duplicates
Unpivot columns and split columns
Change Data type, Replace Values and Rearrange the columns
Append Queries
Merge Queries
Visuals Intro
Visuals-Bar Charts
Visuals-Line Charts
Visuals-Pie Chart
Stacked bar Chart
Clustered Column Chart
Visuals-Area Chart and Analytics Tab Explained-0
Visuals-Area Chart and Analytics Tab Explained-1
Visuals-Combo Chart
Visuals-Scatter Chart
Visuals-Treemap Chart
Visuals-funnel Chart
Visuals-Card and Multi-Row Card
Visuals-Gauge Card
Visuals-KPIs
Visuals-Matrix
Visuals-Table
Visuals-Text boxes - Shapes - Images
Visuals-Slicers
Visuals-Maps
Custom Visuals - Word Cloud
Visualization interactions
Modeling and Relationships
Other ways to create Relationship
OLTP vs OLAP
Star Schema vs Snowflake Schema
DAX101 - Importing Data for Dax Learning
DAX101 - Resources for Dax Learning
DAX101 - What is Dax
DAX101 - Dax Data Types
DAX101 - Dax Operators and Syntax
DAX101 - M vs Dax
DAX101 - Create a Column
DAX101 - Rules to Create Measures
DAX101 - Calculated Columns vs Calculated Measures-0
DAX101 - Calculated Columns vs Calculated Measures-1
DAX101 - Sum()
DAX101 - AVERAGE()-MIN()-MAX()
DAX101 - SUMX()
DAX101 - DIVIDE()
DAX101 - COUNT()-COUNTROWS()
DAX101 - CALCULATE()-0
DAX101 - CALCULATE()-1
DAX101 - FILTER()
DAX101 - ALL()
DAX101 - Time Intelligence - Create Date Table in M (important)
DAX101 - Time Intelligence - Create Date Table in DAX
DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()
DAX101 - Time Intelligence - TOTALYTD()
DAX101 - Display Last Refresh Date
DAX101 - Time Intelligence - PREVIOUSMONTH()
DAX101 - Time Intelligence - DATEADD()
DAX101 - Quick Measures
PowerBI Reports
PowerBI Workspaces
PowerBI Datasets
What are Dashboards
How to create Workspace and Publish Report
Favorite dashboards, reports, and apps in Power BI
Subscribe to a Report or Dashboard
Rename Workspace or Report or Dashboard
Display Reports or Dashboards in Full screen mode
Delete Reports or Dashboards
Dashboard Menus
File and View Options
Printing Dashboard and Reports
PATH Function
PATHCONTAINS Function
PATHITEM Function
PATHITEMREVERSE Function
PATHLENGTH Function
RLS - Static Row Level Security
RLS - Dynamic Row Level Security
RLS - Organizational Hierarchy
Sharing and Collaboration
Sharing Dashboard
Sharing Workspaces
Sharing App
Publish To Web

Popular Courses

Popular Platforms

Description	Amount
Course Exam Fee	Rs.95000

Popular Searches