DATA SCIENCE COURSE IN KANPUR

MODULE 1: DATA SCIENCE ESSENTIALS 

 • Introduction to Data Science
 • Evolution of Data Science
 • Big Data Vs Data Science
 • Data Science Terminologies
 • Data Science vs AI/Machine Learning
 • Data Science vs Analytics

MODULE 2: DATA SCIENCE DEMO

 • Business Requirement: Use Case
 • Data Preparation
 • Machine learning Model building
 • Prediction with ML model
 • Delivering Business Value.

MODULE 3: ANALYTICS CLASSIFICATION 

 • Types of Analytics
 • Descriptive Analytics
 • Diagnostic Analytics
 • Predictive Analytics
 • Prescriptive Analytics
 • EDA and insight gathering demo in Tableau

MODULE 4: DATA SCIENCE AND RELATED FIELDS

 • Introduction to AI
 • Introduction to Computer Vision
 • Introduction to Natural Language Processing
 • Introduction to Reinforcement Learning
 • Introduction to GAN
 • Introduction to Generative Passive Models

MODULE 5: DATA SCIENCE ROLES & WORKFLOW

 • Data Science Project workflow
 • Roles: Data Engineer, Data Scientist, ML Engineer and MLOps Engineer
 • Data Science Project stages.

MODULE 6: MACHINE LEARNING INTRODUCTION

 • What Is ML? ML Vs AI
 • ML Workflow, Popular ML Algorithms
 • Clustering, Classification And Regression
 • Supervised Vs Unsupervised

MODULE 7: DATA SCIENCE INDUSTRY APPLICATIONS

 • Data Science in Finance and Banking
 • Data Science in Retail
 • Data Science in Health Care
 • Data Science in Logistics and Supply Chain
 • Data Science in Technology Industry
 • Data Science in Manufacturing
 • Data Science in Agriculture

MODULE 1: PYTHON BASICS 

 • Introduction of python
 • Installation of Python and IDE
 • Python Variables
 • Python basic data types
 • Number & Booleans, strings
 • Arithmetic Operators
 • Comparison Operators
 • Assignment Operators

MODULE 2: PYTHON CONTROL STATEMENTS 

 • IF Conditional statement
 • IF-ELSE
 • NESTED IF
 • Python Loops basics
 • WHILE Statement
 • FOR statements
 • BREAK and CONTINUE statements

MODULE 3: PYTHON DATA STRUCTURES 

 • Basic data structure in python
 • Basics of List
 • List: Object, methods
 • Tuple: Object, methods
 • Sets: Object, methods
 • Dictionary: Object, methods

MODULE 4: PYTHON FUNCTIONS 

 • Functions basics
 • Function Parameter passing
 • Lambda functions
 • Map, reduce, filter functions

MODULE 1: OVERVIEW OF STATISTICS 

 • Introduction to Statistics
 • Descriptive And Inferential Statistics
 • Basic Terms Of Statistics
 • Types Of Data

MODULE 2: HARNESSING DATA 

 • Random Sampling
 • Sampling With Replacement And Without Replacement
 • Cochran's Minimum Sample Size
 • Types of Sampling
 • Simple Random Sampling
 • Stratified Random Sampling
 • Cluster Random Sampling
 • Systematic Random Sampling
 • Multi stage Sampling
 • Sampling Error
 • Methods Of Collecting Data

MODULE 3: EXPLORATORY DATA ANALYSIS 

 • Exploratory Data Analysis Introduction
 • Measures Of Central Tendencies: Mean,Median And Mode
 • Measures Of Central Tendencies: Range, Variance And Standard Deviation
 • Data Distribution Plot: Histogram
 • Normal Distribution & Properties
 • Z Value / Standard Value
 • Empirical Rule and Outliers
 • Central Limit Theorem
 • Normality Testing
 • Skewness & Kurtosis
 • Measures Of Distance: Euclidean, Manhattan And Minkowski Distance
 • Covariance & Correlation

MODULE 4: HYPOTHESIS TESTING 

 • Hypothesis Testing Introduction
 • P- Value, Critical Region
 • Types of Hypothesis Testing
 • Hypothesis Testing Errors : Type I And Type II
 • Two Sample Independent T-test
 • Two Sample Relation T-test
 • One Way Anova Test
 • Application of Hypothesis testing

MODULE 1: MACHINE LEARNING INTRODUCTION 

 • What Is ML? ML Vs AI
 • Clustering, Classification And Regression
 • Supervised Vs Unsupervised

MODULE 2:  PYTHON NUMPY  PACKAGE 

 • Introduction to Numpy Package
 • Array as Data Structure
 • Core Numpy functions
 • Matrix Operations, Broadcasting in Arrays

MODULE 3:  PYTHON PANDAS PACKAGE 

 • Introduction to Pandas package
 • Series in Pandas
 • Data Frame in Pandas
 • File Reading in Pandas
 • Data munging with Pandas

MODULE 4: VISUALIZATION WITH PYTHON - Matplotlib

 • Visualization Packages (Matplotlib)
 • Components Of A Plot, Sub-Plots
 • Basic Plots: Line, Bar, Pie, Scatter

MODULE 5: PYTHON VISUALIZATION PACKAGE - SEABORN

 • Seaborn: Basic Plot
 • Advanced Python Data Visualizations

MODULE 6: ML ALGO: LINEAR REGRESSSION

 • Introduction to Linear Regression
 • How it works: Regression and Best Fit Line
 • Modeling and Evaluation in Python

MODULE 7: ML ALGO: LOGISTIC REGRESSION

 • Introduction to Logistic Regression
 • How it works: Classification & Sigmoid Curve
 • Modeling and Evaluation in Python

MODULE 8: ML ALGO: K MEANS CLUSTERING

 • Understanding Clustering (Unsupervised)
 • K Means Algorithm
 • How it works : K Means theory
 • Modeling in Python

MODULE 9: ML ALGO: KNN

 • Introduction to KNN
 • How It Works: Nearest Neighbor Concept
 • Modeling and Evaluation in Python

MODULE 1: FEATURE ENGINEERING 

 • Introduction to Feature Engineering
 • Feature Engineering Techniques: Encoding, Scaling, Data Transformation
 • Handling Missing values, handling outliers
 • Creation of Pipeline
 • Use case for feature engineering

MODULE 2: ML ALGO: SUPPORT VECTOR MACHINE (SVM)

 • Introduction to SVM
 • How It Works: SVM Concept, Kernel Trick
 • Modeling and Evaluation of SVM in Python

MODULE 3: PRINCIPAL COMPONENT ANALYSIS (PCA)

 • Building Blocks Of PCA
 • How it works: Finding Principal Components
 • Modeling PCA in Python

MODULE 4:  ML ALGO: DECISION TREE 

 • Introduction to Decision Tree & Random Forest
 • How it works
 • Modeling and Evaluation in Python

MODULE 5: ENSEMBLE TECHNIQUES - BAGGING 

 • Introduction to Ensemble technique 
 • Bagging and How it works
 • Modeling and Evaluation in Python

MODULE 6: ML ALGO: NAÏVE BAYES

 • Introduction to Naive Bayes
 • How it works: Bayes' Theorem
 • Naive Bayes For Text Classification
 • Modeling and Evaluation in Python

MODULE 7: GRADIENT BOOSTING, XGBOOST

 • Introduction to Boosting and XGBoost
 • How it works?
 • Modeling and Evaluation of in Python

MODULE 1: TIME SERIES FORECASTING - ARIMA 

 • What is Time Series?
 • Trend, Seasonality, cyclical and random
 • Stationarity of Time Series
 • Autoregressive Model (AR)
 • Moving Average Model (MA)
 • ARIMA Model
 • Autocorrelation and AIC
 • Time Series Analysis in Python 

MODULE 2: SENTIMENT ANALYSIS 

 • Introduction to Sentiment Analysis
 • NLTK Package
 • Case study: Sentiment Analysis on Movie Reviews

MODULE 3: REGULAR EXPRESSIONS WITH PYTHON 

 • Regex Introduction
 • Regex codes
 • Text extraction with Python Regex

MODULE 4:  ML MODEL DEPLOYMENT WITH FLASK 

 • Introduction to Flask
 • URL and App routing
 • Flask application – ML Model deployment

MODULE 5: ADVANCED DATA ANALYSIS WITH MS EXCEL

 • MS Excel core Functions
 • Advanced Functions (VLOOKUP, INDIRECT..)
 • Linear Regression with EXCEL
 • Data Table
 • Goal Seek Analysis
 • Pivot Table
 • Solving Data Equation with EXCEL

MODULE 6:  AWS CLOUD FOR DATA SCIENCE

 • Introduction of cloud
 • Difference between GCC, Azure, AWS
 • AWS Service ( EC2 instance)

MODULE 7: AZURE FOR DATA SCIENCE

 • Introduction to AZURE ML studio
 • Data Pipeline
 • ML modeling with Azure

MODULE 8:  INTRODUCTION TO DEEP LEARNING

 • Introduction to Artificial Neural Network, Architecture
 • Artificial Neural Network in Python
 • Introduction to Convolutional Neural Network, Architecture
 • Convolutional Neural Network in Python

MODULE 1: DATABASE INTRODUCTION 

 • DATABASE Overview
 • Key concepts of database management
 • Relational Database Management System
 • CRUD operations

MODULE 2:  SQL BASICS

 • Introduction to Databases
 • Introduction to SQL
 • SQL Commands
 • MY SQL workbench installation

MODULE 3: DATA TYPES AND CONSTRAINTS 

 • Numeric, Character, date time data type
 • Primary key, Foreign key, Not null
 • Unique, Check, default, Auto increment

MODULE 4: DATABASES AND TABLES (MySQL) 

 • Create database
 • Delete database
 • Show and use databases
 • Create table, Rename table
 • Delete table, Delete table records
 • Create new table from existing data types
 • Insert into, Update records
 • Alter table

MODULE 5: SQL JOINS 

 • Inner Join, Outer Join
 • Left Join, Right Join
 • Self Join, Cross join
 • Windows function: Over, Partition, Rank

MODULE 6: SQL COMMANDS AND CLAUSES 

 • Select, Select distinct
 • Aliases, Where clause
 • Relational operators, Logical
 • Between, Order by, In
 • Like, Limit, null/not null, group by
 • Having, Sub queries

MODULE 7 : DOCUMENT DB/NO-SQL DB 

 • Introduction of Document DB
 • Document DB vs SQL DB
 • Popular Document DBs
 • MongoDB basics
 • Data format and Key methods

MODULE 1: GIT  INTRODUCTION 

 • Purpose of Version Control
 • Popular Version control tools
 • Git Distribution Version Control
 • Terminologies
 • Git Workflow
 • Git Architecture

MODULE 2: GIT REPOSITORY and GitHub 

 • Git Repo Introduction
 • Create New Repo with Init command
 • Git Essentials: Copy & User Setup
 • Mastering Git and GitHub

MODULE 3: COMMITS, PULL, FETCH AND PUSH 

 • Code Commits
 • Pull, Fetch and Conflicts resolution
 • Pushing to Remote Repo

MODULE 4: TAGGING, BRANCHING AND MERGING 

 • Organize code with branches
 • Checkout branch
 • Merge branches
 • Editing Commits
 • Commit command Amend flag
 • Git reset and revert

MODULE 5: GIT WITH GITHUB AND BITBUCKET

 • Creating GitHub Account
 • Local and Remote Repo
 • Collaborating with other developers

MODULE 1: BIG DATA INTRODUCTION 

 • Big Data Overview
 • Five Vs of Big Data
 • What is Big Data and Hadoop
 • Introduction to Hadoop
 • Components of Hadoop Ecosystem
 • Big Data Analytics Introduction

MODULE 2 : HDFS AND MAP REDUCE 

 • HDFS – Big Data Storage
 • Distributed Processing with Map Reduce
 • Mapping and reducing stages concepts
 • Key Terms: Output Format, Partitioners,
 • Combiners, Shuffle, and Sort

MODULE 3: PYSPARK FOUNDATION 

 • PySpark Introduction
 • Spark Configuration
 • Resilient distributed datasets (RDD)
 • Working with RDDs in PySpark
 • Aggregating Data with Pair RDDs

MODULE 4: SPARK SQL and HADOOP HIVE 

 • Introducing Spark SQL
 • Spark SQL vs Hadoop Hive

MODULE 1: TABLEAU FUNDAMENTALS 

 • Introduction to Business Intelligence & Introduction to Tableau
 • Interface Tour, Data visualization: Pie chart, Column chart, Bar chart.
 • Bar chart, Tree Map, Line Chart
 • Area chart, Combination Charts, Map
 • Dashboards creation, Quick Filters
 • Create Table Calculations
 • Create Calculated Fields
 • Create Custom Hierarchies

MODULE 2:  POWER-BI BASICS

 • Power BI Introduction 
 • Basics Visualizations
 • Dashboard Creation
 • Basic Data Cleaning
 • Basic DAX FUNCTION

MODULE 3 : DATA TRANSFORMATION TECHNIQUES 

 • Exploring Query Editor
 • Data Cleansing and Manipulation:
 • Creating Our Initial Project File
 • Connecting to Our Data Source
 • Editing Rows
 • Changing Data Types
 • Replacing Values

MODULE 4: CONNECTING TO VARIOUS DATA SOURCES 

• Connecting to a CSV File
 • Connecting to a Webpage
 • Extracting Characters
 • Splitting and Merging Columns
 • Creating Conditional Columns
 • Creating Columns from Examples
 • Create Data Model

Data Science is the art of collecting, classifying, summarizing data sets, and deriving valuable insights from these data sets. These insights are used to take further decisions. Data Science has become instrumental in adding value to the business.

There are no mandatory prerequisites. However, basic knowledge of Statistics would be an added advantage.

• Analytical skills

• Basic knowledge of Mathematics and Statistics 

• Knowledge of coding

• Skills of working with programming languages like ‘R’ and Python.

The various business skills required, to become a Data Scientist are as follows:-

• Industry Knowledge

• Problem Solving Skills

• Communication Skills 

• Curiosity  

Industry Knowledge:- A Data Scientist should have a clear understanding of the areas that need to be paid attention and the areas that need to be ignored. This is possible only if the Data Scientist has sound knowledge of the industry.

Problem Solving Skills:- A Data Scientist is known for finding solutions to problems. For doing so, a Data Scientist must understand the problem, which can be achieved only after a deep study of the scenario.

Communication Skills:- A Data Scientist often needs to communicate the findings arrived at, with regards to analytics and business insights. A Data Scientist should be a good conversationalist. 

Curiosity:- A Data Scientist should always be curious enough while approaching a problem. Finding out the root of the problem depends upon the curiosity of a Data Scientist. 

As far as Data Scientist is concerned Python is the most effective programming language, with a lot of libraries available. Python can be deployed at every phase of data science functions. It is beneficial in capturing data and importing it into SQL. Python can also be used to create data sets.

Data Science is all about managing a set of information received from various sources, to arrive at conclusions. The data that is acquired needs to be analysed and decisions need to be taken. Statistics makes it easier to work on data. Various statistical techniques such as Classification, Regression, Hypothesis Testing, Time Series Analysis is used to construct data models. With the help of Statistics, a Data Scientist can gain better insights, which enables to effectively streamline the decision-making process. 

• The different roles, Data Science is subjected to, in an organisation.

• Analysing and managing projects.

• Employing various data models.

• Making use of sampling techniques

• Prediction and Analysis

• Segmentation through clustering technique

• Making use of Linear and Logistics regression methods

The duration of the Data Science course in Kanpur is 8 months, a total of 120 hours of training. The training sessions are provided on weekdays and weekends. You can opt between the two, as per your convenience.

The Data Science course fee in India ranges from Rs 50000 to Rs 150000. DataMites offers online training in Kanpur at an affordable price of Rs 88000/-. 

Data Science is a vast subject for study, it is a mix of Statistics and Computer Science. DataMites in Kanpur, offers quality training sessions in Data Science, Artificial Intelligence, Machine Learning etc. The data science courses provided by DataMites in Kanpur are exclusively designed in tune with the current industry requirements. Also with many projects to work on, under the mentoring of industry experts.