Advance Diploma in Data Science & Analytics 

Introduction to Data Analytics 

Introduction to Data Science

Python Vs R for data science

Data Analytics Introduction

Business Intelligence Introduction

How all dimensions work together? Discussion on Real time Case studies

Data Science lifecycle

Anaconda Installation

Understanding different components of Anaconda

 

Basic Python Programming

Introduction to Python

Python Editors & IDE’s (Pycharm, Jupyter, Spyder etc…)

Understand Jupyter notebook & Spyder

Installing & loading Packages & Name Spaces

Introduction to strings, Tuples, Lists, Dictionaries

List, Set and Dictionary Comprehensions

File Handling in Python

Modules in Python

Control flow & conditional statements

OOPs concepts & Function Handling in Python

Exception Handing in Python

Introduction to Python Libraries NumPy, scikit-learn, Pandas, Matplotlib, Seaborn etc

 

Data Pre-processing Steps 

Data Cleansing

Stripping out extraneous information

Normalizing data

Formatting data

Important Python modules for data manipulation (Pandas, Numpy, re, math, string, datetime etc)

Data Handling- Sorting, filtering, duplicates, merging, appending, subsetting, derived variables, sampling, Data type conversions, renaming, formatting etc

 

Data Visualization Techniques

Descriptive statistics, Frequency Tables and summarization

Univariate Analysis- Distribution of data & Graphical Analysis

Bivariate Analysis- Cross Tabs, Distributions & Relationships, Graphical Analysis

Bar/pie/line chart/histogram/ boxplot/ scatter/ density etc

 

Introducing Statistics in Python

Mean, Measures of Central Tendencies and Variance

Probability Distributions, Normal distribution, Central Limit Theorem

Inferential Statistics -Sampling - Concept of Hypothesis Testing

Statistical Methods - Z/t-tests (One sample, independent, paired), Anova, Correlation and Chi-square

 

Advanced Statistics using Machine Learning

Data Pre-processing Revision

Regression Models – Linear, Logistic etc

Classification- Naïve Bayes, Decision Tree and Random Forest

Cluster Analysis – K-Means, Hierarchical (Dendograms) etc

Introduction to Neural Networks and Deep Learning

Gradient Descent Concepts

Introduction to Perceptron and Neural Network Types

Modelling Aritificial Neural Networks

Modelling CNN and RNN

Apply ML and DL techniques with Case Studies

Time-Series analysis Introduction

 

Natural Language Processing(NLP)

Introduction to NLP

Elaborating NLP Steps

Introduction to Text Processing & Text Classification

Sentiment Analysis

 

Introduction to Analytics using Tableau 

Data Preparation using Tableau Prep

Data Visualization

Business Intelligence tools

Introduction to Tableau

Tableau Architecture

Tableau Server Architecture

 

Data Connection with Tableau Desktop 

Features of Tableau Desktop

Connect to data from File and Database

Types of Connections

Joins and Unions

Data Blending

Tableau Desktop User Interface

 

Dashboards and Stories 

Introduction to Dashboards

The Dashboard Interface

Dashboard Objects

Building a Dashboard

Dashboard Layouts and Formatting

 

Introduction to Power BI & Basic Charts 

Power BI – Introduction

Download, Install and Activate new features in Power BI

Creating a Column Chart in Power BI

Create a Pie Chart in Power BI

Create a DONUT CHART in Power BI

Create a Funnel Chart in Power BI

Create a Ribbon Chart in Power BI

 

Maps, Tables & Matrix in Power BI 

Basic Map in Power BI

Creating a Filled Map

Map with Pie Chart

Format a Map

Creating a Table

Formatting a Table

Conditional Formatting in Table

Aggregation in Table

Matrix

Conditional Formatting in Matrix

 

Cards , Filters & Slicers In Power BI 

Introduction to Cards and Filters in Power BI

Number Card in Power BI

Text Card in Power BI

Formatting a Text Card in Power BI

Date Card

Date Card (Relative Filtering)

Multi-Row Card

Filters and Types

Drillthrough in Power BI

Slicers in Power BI

 

Advanced Charts In Power BI 

Advanced Charts in Power BI

Animated Bar Chart Race

Drill down donut Chart

Drill down Column chart

Scroller in Power BI

Sunburst Chart in Power BI

Histogram in Power BI

 

Power BI Objects, Bookmarks and Actions 

Insert Image in Power BI

Insert Text in Power BI

Insert Shape in Power BI

Insert Buttons in Power BI

Web URL Action in Power BI

Page Navigation Action in Power BI

Bookmark Action in Power BI

Drill through action in Power BI

 

Power BI Service & M Language 

Create a Report in Power BI

Create an account in Power BI Service

Publish Report to Power BI Service

Export Report to PPT, PDF, PBIX

Comment, Share and Subscribe to Power BI reports

Create a Dashboard in Power BI Service

Problems in Power BI Dashboard and its Solution

Automatically refresh reports in Power BI Service

Introduction To M Language

Writing code in M Language

 

Projects Highlights

Covid19 Data Analysis

Netflix Data Analysis

Google Stock Price Prediction

Crypto Currency Price Prediction

Taxi Fare Price Prediction

Face Detection Application

Image Classification

Mall Customer Segmentation

Twitter Sentiment Analysis