ADVANCED

CERTIFICATION IN
DATA SCIENCE (213
HOURS ) 75,999/-

Key Highlights
• 100% placement assistance • BI /DW Lifecycle
• Course completion certification from Opine Group • Real life based exercises to understand BI phases
• Hands on Assignments
• Experienced faculty (30+ years) • Data Modeling (Dimensional)
• Access to free guest lecture & webinars • Dimensional Modeling Process and Scenario Module 2: Excel Analytics –
• Profile building/Resume Writing support
• Mock & Final Interview preparation
based model designing Spreadsheet Analytics
• Membership to Communication Gym
• Real time hands on work to understand Data
Visualization
( 20 hours )
• Practitioner’s Approach • Analytics Demo • Fundamentals and Excel interface
• Real life demo • Introduction to analytics, Organizational structure,
Concepts of OLTP, OLAP, Normalization, De-
Curriculum Module • Career Opportunities discussion and guidance
• Open discussion normalization, Primary Key, Dimensions, Facts,
1: Fundamentals of • Steps to be carried out Factless fact, Foreign Key, VLookup, Ribbon Tabs,

Analytics ( 12 hours ) • Short Term Formatting features, Speak Cells, Quick Access
toolbar
• Long Term
• Business Intelligence & Data Warehouse • Charts
concepts • Basic chart, Series, Combination charts, Dynamic
• Introduction to Business Intelligence – chart ranges with Excel tables, Histogram, Treemap
what, where and how? chart, Sunburst, Pie and Doughnut charts, Sparklines,
• Need for Business Intelligence / Analytics Use of dashboard
• Pivoting Functions like COUNT, COUNTA, COUNTBLANK,
• Pivoting – Pivot tables, Slicers and Timelines, COUNTIFS, SUM, AVERAGE, SUMIFS,
Creating Pivot charts AVERAGEIFS, MAX and MIN (Include by
• Excel features / Data quality criteria), Basic DATE functions, Time
• Auto Fill, Flash Fill, Fill Series, Use of formula, calculations
Recognizing formula and input cells, Adding note
/ comment, Creating custom list, Data Validation, • Data population and error handling
Screen Tip and few shortcuts, Assignment, Excel • Handling formulae errors, Different types of
shortcuts for navigation, Copying, Moving and errors, IF (then, else) function, VLOOKUP
Hiding Worksheets, Freeze panes and split screen, function, Assignment, Sort, Unsort, Subtotal,
Hide and unhide, Insert and adjust columns and Filter, Remove blank cells, Fill empty cells,
rows, Copying and pasting data Conditional formatting
• Automation
• Macro Introduction
• Conclusion
• Project

Module 3: Database
and SQL ( 16 hours ) MODULE 4: PYTHON
PROGRAMMING (30 HOURS)
• RDBMS
• What is RDBMS? • Setting Python in Windows
• Basic concepts of RDBMS • Introduction to print()
• Different data types • Variable and Data Type
• KEYS concepts • Enumerators, operators, building basic
expressions
• SQL Basic
• More print(), input()
• Introduction SQL (Structured Query Language)
• String data type indexing and slicing
• Fundamentals of SQL
• Program flow controls
• SQL Tables, Joins, Variables
• Loops
• SQL Advance • Data structures – List, Dictionary, Tuple, Set
• SQL Functions, Subqueries, Views, Rules • Introduction to functions
• Data Protection • Condition based queries using various operator • Exception Handling
• Protecting Worksheets and specific ranges, • Data Modeling • Object Oriented Programming concepts
Assignment, Order of precedence, Simple • Different type of joins (Basic, Advance) • Reading from text files and writing to text
formulae, Excel’s Essential rule, Absolute and • Aggregate Function files, .csv files
Relative referencing • Windows Functions • URL Libraries
• Use of CTE (Common table expression) with
• Excel functions • Range names for clarity,
practice
Referencing other Workbooks or Worksheets,
• Hands on exercise on live projects
Circular references, Combine values from two or
more cells to one cell, Assignments,
 – programs, Spread-range, quartile, standard
MODULE 4: DATA ANALYSIS deviation, Programs . Use in analysis, Distribution-
AND VISUALIZATION USING Discrete, continuous, Python Programs
o Univariate Data, Visualization:- Plotting Bar
PYTHON (45 HOURS) graphs, Pie charts, Histograms
o Inferential Statistics:- Population and sample
o Hypothesis testing:- What do you mean by
hypothesis ?Parametric Hypothesis testing, One
tailed test, two tailed test program

• Multivariate Data
o What is bivariate data?:- Examples, Scatter plot
o What is multivariate data? :- Advantages and
disadvantages of multivariate regression
o Plotting in multivariate data
o Python program:- Python program for cars.csv
multivariate data
o What is correlation matrix ? :- Multivariate
analysis for Iris data set, Correlation matrix
o Correlation matrix coefficient:- Correlation
coefficient, pearson coefficient
o Pair plot, Finding from EDA
• Introduction to Data Analysis and Visualization o Revision
o Why learn Data science - Its objectives ? Role of o Assignment
o Plotting 1
Data Scientist and Analyst.
o Superstore case study:- Univariate, Bivariate,
o Statistical modelling, Role of Statistics in Data • Plotting Data
Multivariate data and their study
Science o Showing Distributions using Histograms:-
o Different kinds of plots
o Data Frames:- What are they ? Reading of .csv Histograms, Python program
o Tips data set:- Understanding Tips dataset .
into dataframe, Reading of .xls into dataframe, o Scatter plot:- Scatter plot for correlation among
How to use?
Pandas, Numpy – Arrays in Python, reading from .csv, variables, Python program
o Plotting 2
.xlsx o Box plot
o Case study discussion 1
o Sources Of Data, Cleaning Of Data:- Sources Of o Bubble plot, animated bubble plot
o Case study discussion 2
Data, Why do we have to clean the data, o Area plot
o Revision:- Processes in Case Study
techniques, Techniques to clean the data, Program
to fill missing values using .csv • Tools And techniques
• Shape of the Data o Bar plot using Seaborne Library
o Univariate, Bivariate, Multivariate data:- Types of o ggplot:- What is ggplot?
data. What is Univariate data used for? o 3 D Scatter Plot
o Univariate Data, Central values:- Central
tendencies-Mean, Median, Mode use for cleaning • Case Study
univariate data, Central tendencies-Programs, o Data Science Case Study:- Framing questions,
Spread range Analysis
 • Datasets
MODULE 5: MACHINE o Datasets - What are datasets, Creation of
LEARNING USING PYTHON datasets from dataframes, dictionary
o Inbuilt datasets - Iris, sales
(90 HOURS)
• Introduction to Machine Learning
o What is Machine Learning - Definition, Diagram,
Working, Applications
o Types Of Machine Learning - Supervised ,
Unsupervised, Semisupervised Machine Learning

• Classification
o Classification - What is classification in Machine
Learning ? Introduction to sklearn

• Dimensionality
o Dimensionality - What is Dimensionality? Features?
Curse of Dimensionality • Feature Selection
o Reducing Dimensionality - Feature Selection, Feature o Managing data - Managing Categorical
Extraction data, Managing missing features, Data scaling
• NumPy and normalization
• Types Of Supervised Learning o Managing data - LabelEncoder,
o Arrays in NumPy - 1 D and 2 D Arrays with NumPy,
o Classification, Regression - Classification, Regression DictVectorizer, etc
What are Arrays in Python ? Using of basic array
in Supervised Learning with Python Example o Data Scaling - What is it ? Why is it needed ?
Operations, Iterating over an array reshape o Arrays
Standard Scaler, Robust Scaler
in NumPy Mathematical function and Arithmetic
• Probability o Normalization - What is it ? Min, Max, Least
Functions - sin, cos, floor, ceil, Transpose,
o Probability - Basics Of Probability, Binomial Square error
Reciprocal, Mod etc
Distribution o Feature Selection - Feature Selection,
o Arrays in NumPy Statistical Functions - amin, amax,
o Probability in Machine Learning - Probability Density Feature Extraction, Understand Variance
median etc
Function, Bayes Theorem Threshold, Select K Best, Select Percentile
o Arrays in NumPy Statisitcal Functions - argmax,
o Applying Probability to Feature Set - Naive Bayes o PCA - Principal Component Analysis
argmin
Classifier o PCA - Implement PCA for load_digits
o NumPy Linear Algebra - determinant, solve
o Numpy and matplotlib - Use of arrange, Plot basic
graph scatter, line subplot, Histogram • Decision Trees • Sampling And Evaluation
o What are decision Trees? - How are decision trees o Confusion Matrix - What is it? Accuracy,
• Dataframes using pandas library created ? Precision Recall with numerical examples,
o Dataframes - What are dataframes ? Creation of o Entropy - What is Entropy ? Python implementation
dataframes from Lists, ndarrays, dictionary o Information Gain - How is information Gain o CrossValidations - Crossvalidations, KFold
o Dataframes from files - Dataframes from files (xls, csv) Calculated? CrossValidations
o Dataframe accessing - Accessing rows, columns, o ID3 Algorithm - Understanding and implementing ID3
adding rows, columns algorithm
o Dataframe accessing - Summarising and grouping o Creating Dt - Decsion tree using entropy
data o accuracy_score
 • Ensemble Learning
o Ensemble Learning - What is Ensemble Learning ?
Strong and Weak Learners, Bagging, Boosting ,
Random Forests, Implementations for Diabetes
• Linear Regression dataset
o Regressions - What is Linear Regression? o Random Forest - Implementing for Digits dataset
Corelation Coefficient, Linear Regression o Adaboost - Understanding , Implementing
(Implementing)
o Regressions - Minimising Errors, Mean Squared • Clustering
Error, RMS etc o Kmeans - Kmeans, Finding Optimal K, Implemeting TO KNOW MORE ABOUT THE
o Regressions - ROC Curve o KNN - Understanding and implementing the algos -
COURSE AND PAYMENT
(New point to be added by Manjusha ma’am)
• Logistic Regression OPTIONS CONTACT US –
o Scholastic Gradient Descent - What is Scholastic • Reinforcement Learning
Gradient Descent ? o Reinforcement Learning - What is Reinforcement
Learning ? Advantages, Disadvantages etc, Markov
Contact Number: +91 7276326565
• Support Vector Machines Chain, Markov Model Email: info@opinegroup.com
o What are Support Vectors ? - SVMs, Advantages,
Disadvantages • PAC Learning
o Linear SVM - Understanding , Implementing Connect with us:
o PAC Learning - PAC Learning, VC Dimension
o Kernel Based Classification - Kernel Function , https://linktr.ee/OpineGroup
Kernel Trick • Artificial Neural Network
o Types Of Kernels - Radial, Polynomial, Sigmoid, o ANN - Single Layer Perceptron, PLA Numerical, Flat No. 3, Yogeshwari Society,
Implementation for generated data set and digit Implementation
data set Mehendale Garage Road, Above IDBI
o MLP - Multilayer Perceptron, Back Propagation
o Soft Margin Classifier - What is it ? Implementing it Algorithm Bank, S.No.27/1, Near Abhishek Veg,
Erandwane, Pune- 411 004 India