Postgraduate Program In Data Science And Analytics

Aggregate Functions

Date functions

Union, Union All & Intersect Operators

Joins

Views

Indexes

Sub-Queries

Exercise on SQL

What is Probability?

Events and Types of Events

Sets in Probability

Probability Basics using Python

Conditional Probability

Expectation and Variance

Probability Distributions

Discrete Distributions

• - Uniform
• - Bernoulli
• - Binomial
• - Poisson

Continuous Distributions

• - Uniform
• - Normal

Probability Distributions using Python

Introduction to Hypothesis Testing

Terminologies used in Hypothesis Testing

Procedure for testing a Hypothesis

Test for Population Mean

Small Sample Tests

Large Sample Tests

Test for Normality

One-way ANOVA

Assumptions

ANOVA Hypothesis

Post Hoc Test

Chi-Square Test

Chi-Square Test Steps

Chi-Square Example

Introduction of Linear Regression

Types of Linear Regression

OLS Model

Math behind Linear Regression Decomposition Variability

Metrics to Evaluate Model

Feature Scaling

Feature Selection

Regularisation Techniques

Project - Property Price Prediction

Class Assessment on Linear Regression

Intro to Logistic Regression

Maximum Likelihood Estimation

Performance Metrics

Performance Measures

Bias-Variance Tradeoff

Overfitting and Underfitting Problems

Cross Validation

Project - Vaccine Usage Prediction

Home Assignment on Logistic Regression

Introduction to Decision Tree

Entropy

Information Gain

Greedy Algorithm

Decision Tree: Regression

Gini Index

Tuning of Decision Tree-Pruning

Project - Heart Disease Prediction

Introduction to Random Forests

Averaging

Bagging

Random Forest – Why & How?

Feature Importance

Advantages & Disadvantages

Project - Taxi Fare Prediction

Class Assessment on Classification

What is Clustering?

Prerequisites

Cluster Analysis

K-means

Implementation of K-means

Pros and Cons of K-means

Application of K-means

Project - E-commerce Customer Segmentation

Introduction to Hierarchical Clustering

Types of Hierarchical Clustering

Dendrogram

Pros and Cons of Hierarchical Clustering

Project - Travel Review Segmentation

Home Assignment on Clustering

Prerequisites

Introduction to PCA

Principal Component

Implementation of PCA

Case study

Applications of PCA

Project - Real Estate Data Analysis using PCA

Understand Time Series Data

Visualising Time Series Components

Exponential Smoothing

Holt's Model

Holt-Winter's Model

ARIMA

Project - Forecasting the Sales of a Furniture Store

Basics of Cloud

Machine Learning on Cloud

Deploying ML models on Cloud

Introduction to AWS

AWS Building Blocks

AWS well architected framework – six pillars

AWS Cloud Tour

Build a Simple Regression Model

Steps to install Visual Studio

Writing HTML Script

Web Application through Flask

What is Amazon EC2

Getting started with EC2

Step by step deployment

Mapping

Calculations

Dashboard and Stories

Introduction

Interface

Data Connections

Data Transformation

Advance Data Transformation

Data Modelling

DAX

Visual Data Analytics

Data Visualization

Optimization Algorithms

• - Gradient Descent
• - Batch Gradient Descent
• - Stochastic Gradient Descent (SGD)
• - Adam

Mean Squared Error

Binary Cross Entropy

Categorical Cross Entropy

Sparse Categorical Cross Entropy

What is CNN?

CNN Architecture

Intro to OpenCV

What is NLP?

Typical NLP Tasks

Sentence Segmentation & Tokenization

Stemming, Lemmatization

Named Entity Recognition (NER)

Stop Words Removal (English)

Applications of NLP

Introduction to the NLTK Library

Processing Raw Text

Bag-of-Words(BoW), TF-IDF

What is RNN?

RNN Architecture

Project - Fake v/s Real News Detection using RNN