Certificate Programme in

DATA ANALYTICS
& MACHINE LEARNING
Weekend Batch | 3.5 Months Online / Offline
Weekday Batch | 3 Months Online / Offline

Certification by

VISHWAKARMAINSTITUTE
OF TECHNOLOGY, PUNE
 VISHWAKARMAINSTITUTE
OF TECHNOLOGY, PUNE
The Vishwakarma Group with its pioneering and entrepreneurial spirit has dedicated its Group entities around the core idea that
people will succeed if given an opportunity.
The Group operates in areas that are the building blocks that drive economic growth and enjoy a leadership position in all endeavours.
Since its inception in 1983, Vishwakarma Institute of Technology, Pune (VIT, Pune) has believed in providing education that empowers
its students. A rigorous focus on academic excellence, a culture of research and innovation and a thriving learning environment have
made it a top engineering college in Pune. VIT, Pune, has had an illustrious track record of achievements and achievers in leadership
positions worldwide.
The Institute was granted autonomous status in AY 2008-09, valid until 2030. The Institute ranks among the premier technical
institutes in the western region of India.

edu plus now is an educational initiative of the Vishwakarma Group founded to positively impact the careers of experienced as well
as beginners by helping them upskill in the futuristic and contemporary fields!
The mission of edu plus now is to assist learners to overcome industrial and professional challenges and reach their full career
potential in the industry.
Aimed at providing learners with essential skills, edu plus now courses are created with inputs from industry experts and highly
qualified professionals.
Operational since June 2020, edu plus now is preferred as a lifelong learning partner by thousands of learners across the globe from
a significant number of corporates. Our dedicated student mentorship from industry experts and real-time projects and case studies
that provide our learners with just the right push to accelerate their careers!

COURSE DESCRIPTION
Accelerate your career with the Certificate Program in Data analytics & Machine learning with edu plus now. This program provides
in-depth theoretical knowledge extensive hands-on practice & case studies. Certificate Program in Data analytics & Machine learning
is ideal for working professionals and freshers who wish to make a career in Data analytics domain. The course will cover topics
like Core Analytics, Machine Learning Algorithms, Data Visualization. This Program is delivered via live sessions by Industry expert.

COURSE FEATURES
Candidate will learn the implementation of Core Statistics & Analytics concepts, Machine Learning using python, Data Visualization
with PowerBI.

WHO SHOULD APPLY FOR THIS PROGRAM

• Experienced professional or fresher with minimum bachelor’s degree with an average of 50% or higher marks
• Basic understanding of Object oriented programming (Preferred not mandatory)
• Working professionals with an interest in Data Science.

LEARNING OUTCOMES
• Hands on training in the Data Analytics Life Cycle.
• Hands on training in Statistics, Hypothesis Testing, Data Mining, Clustering, Decision Tree, Linear & Logistic
Regression, Regression Models and Time Series Analysis etc.
• Machine Learning – Supervised & Unsupervised Learning, Machine Learning libraries like Pandas, Scikit learn,
NumPy, SciPy, Seaborn, Matplotlib etc.
• Data visualization with Power BI

COURSE HIGHLIGHTS
Intensive 120 hours hands on training, along with project support & guidance.
Tools Covered – Sql, Python, Power BI, Advanced excel.
Get access to edu plus now’s Online Learning Management System (LMS).
COURSE CURRICULUM
The modules will be centred around case-study specific examples as well as complete case studies from
across functionaries like:
• Product Analytics • Energy Analytics
• Customer Churn Analytics • Retail Analytics • Survival Analytics
• Market Analytics • Social Media Analytics • Financial Analytics
• Network Analytics • Agro analytics • Risk Analytics
• Operations Analytics • Insurance Analytics - Actuarial Statistics • Legal Analytics
• Supply Chain Analytics • Healthcare /Clinical Analytics – Biostatistics • Telecom Analytics
• HR Analytics • Balance sheet Analytics - To attract total business
Module 1 - SQL
I.SQL Overview IV. SQL Updating
• Relational database concepts, specific products • The INSERT, UPDATE and DELETE statements
• SQL syntax rules • Column constraints and defaults
• Data definition, data manipulation, and data control • Referential integrity constraints
statements
• Getting acquainted with the course database and editor V. SQL Joins
• Inner joins
II. SQL SELECT statements • Left, right and full outer joins
• Clauses
• SELECT clause: columns and aliases, where VI. SQL Subqueries and Unions
expressions, order by expressions how null values • Intersection with IN and EXISTS
behave • Subqueries
• Difference with NOT IN and NOT
III. SQL Functions and Expressions
• Eliminating duplicates with DISTINCT arithmetic VII. SQL Summarization
expressions • The column functions MIN, MAX, AVG, SUM and COUNT
• Replacing null values • GROUP BY and clauses grouping in a combination with
• Literals, concatenation, other string functions joining
• Numeric operations, including rounding
• Date and time functions
• Nested table expressions

Module 2 - Python Programming

Overview of Python Features Numbers Variable Scope in Functions
Python Installation DataType declarations Functions with variable arguments
Python Documentation Control Statement Nested Functions
using help() and help interactive mode Code Structuring Iterators
in shell Strings - Closures
Virtual Environments Introduction to Strings Generators (yield)
IDE (Spyder, Jupyter Notebook, ASCII and Unicode String Decorators
Vscode, Pycharm) String Operators Exception Handling
Python shell String Functions Understanding Time
Programs using Command prompt Raw Strings Lambda functions
Comments Filter, Map and Reduce
Introduction to Data Structures
Operators - List Comprehensions
Lists
Operators (unary and binary) and Object Oriented Programming
Concept of Mutability and immutability
Expressions Tuples Classes and Objects -
Operator Precedence and Associativity Dictionaries Inheritance
Relational and Boolean operations Sets Encapsulation
Quotations in python Set Operation Polymorphism
Functions - Difference in Sets and other Modules and Packages
Print function Datastructure File Handling -
Identifiers & Keywords Loops Threading in Python
Creating and Using Variables Return Statements in loops Regular Expressions
Type Function Break and Continue Statements Database management
Input Function Functions
 Data Analytics & Machine Learning

Module 1- Data Analytics

7 Steps of analytics –
1. Data Preparation & selection of case study days
1. Data Preparation
2. Visual Analytics & Exploratory Data Analytics
2. Basic Analytics
• System of BI & EDA( Using tools –R or Python)
3. Data Visualization / Visual Analytics
3. Exploratory Data Analyses
4. Prescriptive Analytics – Classification Modeling
5. Descriptive Analytics – Clustering & MBA
6. Predictive Analytics - Time Series Analytics

Probability & Probability distribution

• Summary of statistics & graphs Multivariate Statistics
• Estimation – maximum likelihood estimation • Multivariate fenomenal
• Expectation • Variance – co variance metrics
• Exercise – Probability based predictive model, • Co relation metrics
conditional, Mutual independent probability Bayesian • MANOVA(Multivariate ANOVA)
theory • PCA ( Principal component analysis)
• FA( Factor Analysis)
4. Modeling
a) Introduction to modeling
b) Steps of Modeling –
1. Determine what all models can be identified for the given data set.
2. Identify significant variable for each model.
3. Build Model
4. Check for adequacy of each model using minimally AIC,ROCURVE, AVC
5. Check for accuracy of each model including using MAC (Minsquare Error) or misclassification percentage as the case may be.
6. Check for predictability & accuracy of each model using K – Fold cross validation or bootstrap or Jacknife.
7. Select Model

C) Types of Models

Types of Model

Operation Research Model Statistical Model

Liniar Programing
Non liniar programing Bayesan Model Ensembling
Classical Statistical
Dynamic Programing (Hybrid) Model
Model
Intiger Programing Naïve Bayse
Mixed Programing Classifier, Wavel of
Queing Theory regression
Scheduling Theory

Classification Survival & Reliability Regression

Analysis

Logistic regression Logistic Regression Multiple liniar regression

SVM, ANN, CNN, RNN Tree based models Stepwise Regression
K nearest neighbor CART RIDGE Regression
PRUNED Tree BAGGING TREE LASSO Regression
RANDOM FOREST BOOSTING POISSON Regression

Clustering –
• Concept & provocation | • Types of clustering | • Distance Concept | • Clustering method | • Case Study

Market Basket Analysis –

• Frequent item set concept | • Support, confidence & lift | • Apriori algorithm
(Aim of MBA is to select most frequent level combination of EDA)

Predictive Analytics
Refinement of models with inclusion of new found explanatory variable based on descriptive analysis.
Time Series Analysis –
• Introduction to TSA | • Errors in TSA – MAPE,MAD,MSE
Family of Time Series module -
• Trend Models | • Decomposition models | • Exponential smoothing models | • ARIMA | • Mix models

Prediction Strategy –
• Time series based prediction | • Cause based modeling | • Determine sting prediction | • Intuity forecasting
Module 2 - Machine Learning using Python
Machine learning libraries Supervised Learning
Pandas Tensorflow ML algorithms Classification
Numpy Nltk Regression Logistics Regression
Matplotlib Keras Linear regression Decision tree
Seaborn Pytorch Lasso regression Random forest
Scikitlearn Scipy Ridge regression K nearest neighbour
Decision tree regressor Support vector machines
Support vector regressor Naive bays classifier

Unsupervised learning Time series analysis algorithms

K means clustering Auto Regression
Market basket analysis Moving Average
Apriori algorithm ARMA
Principal component analysis ARIMA model
SARIMA
SARIMAX

Module 2 - Machine Learning using Python

1) Machine Learning
• Applying Business Intelligence via Statistical Modeling
• Types of Machine Learning
- Supervised Learning | - Classification | - Regression | - Unsupervised Learning | - Clustering | - Dimensionality Reduction
• Phases of Machine Learning Project
- Data Collection | - Data Visualization | -Data Preprocessing | - Data Modeling | -Deployment | -Maintenance

2) Machine Learning Ecosystem in Python

• Python Overview
• IPython
- Jupyter Notebook | - Matplotlib & Seaborn for Data Visualization | - Pandas & Numpy for Data Preprocessing &
Cleanup | - Scikit-learn for Machine Learning Modeling
• Understanding End-to-End Small Machine Learning | Case study.

3) Matplotlib & Seaborn for Data Visualization 4) Pandas for Data Preprocessing & Cleanup
• Need for Data Visualization • Doing Data Scaling, Fill Missing Values using Pandas
• Draw plots using seaborn for gaining data insights • Using Numpy

5) Scikit-learn for Machine Learning Model Creation

• Choosing machine learning algorithm for modeling • Avoiding Over fitting
• Model Evaluation • Understanding metrics of Model Evaluation
• Improving accuracy by feature engineering • Trying different models & creating final ensemble
• Hyper-Parameter Fine Tuning to improve accuracy model

6) Doing End-to-End Machine Learning Case Study Demo 7) Machine Learning Algorithms
• Classification • Algorithms Overview & Comparison
• Regression Different trade-offs while deciding the final ML Model
• Clustering - Bias-Variance Tradeoff
- Model Complexity vs Model Interpretability
Module 3 - Excel from Data Anyalitics Perspective
Basic Excel Environment NOW and TODAY Functions Protecting worksheets and cells
Main Features and advantages of Conditional Formatting Adding comments to cells
Excel – Overview Working with Data Sharing workbooks | Tracking changes
Workbook, worksheets structure Using Excel as a database Auditing Workbooks | Viewing formulas
Options settings and configurations Sorting Data | Custom sorts Tracing precedents and dependents
Working with Functions Filtering using AutoFilter Error checking
Using the Paste Function tool The Advanced Filter tool Pivot Table
Cell Ref/Freezing Concept Working with External Data Golden Rule of Pivot | Create Pivot Table
Using Named Ranges in Formulas Data consolidation Create multiple pages | Classic pivot
Naming a Single Cell Linking to another workbook table
Naming a Range of Cells Linking to an external database Consolidate
Naming Multiple Single Cells Quickly Getting data from the web Merging Summary data from
Formulas That Span Multiple different sheets
Charting with Excel Merging Summary data from
Worksheets | IF Function
Selecting the data to chart different files
AND/OR Functions
Creating a chart Merging non-summary data
SUMIF, AVERAGEIF, and COUNTIF
Choosing the right chart for the job
Functions | LOOKUP Function Templates
Moving and re-sizing charts
VLOOKUP Function Concept and advantage of
Customizing charts
HLOOKUP Function templates
Saving and copying a chart’s design
CONCATENATE Function Creating template
TRANSPOSE Function Tables Using the template
PROPER, UPPER, and LOWER Creating an Excel table
Table formatting AddIns
Functions Difference between Addins and
Using Max, Min, Large, Small Adding rows and columns
Automatic calculation in tables Templates
The TRIM Function Creating a AddIn
Text To Column Collaboration Tools
Using a AddIn
Date Functions Protecting a workbook

Data Visualization

Module 1 - Power BI
Introduction to Microsoft Power BI 4. Data Visualization
The key features of Power BI workflow working with Power View to create Reports, Charts,
Desktop application visually rich formats, categorizing,
Building dashboard filtering and sorting data using Power View,
Data visualization Hierarchies.
Publishing to cloud
5. DAX
DAX data computation
Introduction to DAX and Its Importance in Power BI, What
2. Extracting Data is DAX in Power BI, Steps to Create Calculated Columns
Learning about Power Query for self-service ETL in DAX - Power BI, Creation of Measures in Power BI and
functionalities, Its Types, Understanding DAX Syntax in Power BI, DAX
introduction to data mashup, Functions in Power BI, Date and Time Functions in DAX -
working with Excel data. Power BI, Date and Time Functions in DAX - Power BI, Text
3. Power Query for Data Transformation Functions Using DAX in Power BI, Logical Functions Using
Installing Power BI, DAX in Power BI, DAX Operators, How the DAX engine
the various requirements and configuration settings, the works, Using DAX to model and analyze your data.
Power Query, introduction to Query Editor,
adding & filling columns and number column,
column formatting | transpose table | appending |
splitting | formatting data
ASSESSMENT & CERTIFICATION:
• MCQs & Practical Assessments of All modules
• Equal weightage for case studies & projects.

Course fees: INR 35000 + GST

Payment Schedule
Installment Amount + GST
1st Instalment 17500
2nd Instalment 17500
HEAR FROM OUR LEARNERS

Amritha M. L. Bhagavathy
ISRO ISRO

The trainer was very good and technically experienced. Mam covered The training was excellent and the trainer was guiding and helping at full
from basics and ensured that all the participants were brought to the extent in all the occasions. She helped to fix bugs and understand the
same level. subject in an effective manner.

Swapnil Kedari Supriya Suryawanshi

AVP TATA Technologies
CityBank Jaguar And Land Rover Project

The class provides an engaging and stimulating learning atmosphere, The Data engineering course provided a comprehensive overview of key
led by an experienced tutor proficient in various technologies, such as concepts, tools, andbest practices in the field. The hands-on projects
Python and real-time data applications used by data engineers and data areparticularly valuable, allowing us to apply theoreticalknowledge to
scientists. Instructors offer tailored guidance, ensuring that students real-world scenarios. The instructors are knowledgeable and responsive,
gain both practical skills and theoretical insights. The curriculum enhancing thelearning experience. Overall, it is an engaging andinformative
emphasizes hands-on projects and real-world applications, preparing course that equipped me with essential skills for data engineering.
learners for diverse professional environments.

Dhiraj Mendre Saurabh Kumar

Deputy Manager Senior Pricing Analyst at Medline
Whirlpool GTEC India

Having recently completed the program, I can confidently say that it I extend my sincere gratitude to the edu plus now team. Your exceptional
has been a transformative learning experience that has significantly dedication, profound knowledge, and constant encouragement have
enhanced my knowledge and skills in the field of data analytics and been pivotal in shaping my academic journey. Your unwavering support
machine learning. Each module was well-structured, and the content and personalized guidance have helped me navigate through challenges
was presented clearly and concisely, making it accessible to both and excel in my future career. Each module was well-structured, and the
beginners and those with prior experience in the field. Furthermore, content was presented clearly and concisely, making it accessible to
the faculty members themselves are experts in the field, possessing both beginners and those with prior experience in the field. The faculty
extensive industry experience. They were always approachable and members are also experts in the field, possessing extensive industry
willing to address our queries, providing valuable insights. I highly experience. The Data Science program provides deep knowledge of data
recommend EduPlusNow’s for its Certification Programme to anyone insights and is covered with live examples as well. I highly recommend
seeking to enhance their existing skills. Once again, Thanks to the edu plus now’s Certification Program to anyone.
EduPlusNow team

Anup Pranav
UPS LOGISTICS INDIA Pvt. Ltd. Jr. Data Scientist
Flynaut

The Data Science program serves as an excellent add-on skill, enriching I’m currently enrolled in the Data science coursewith edu plus now, and
one’s existing expertise. The institute’s focus on practical scenarios it’s been a game-changer for my career. The course offers acomprehensive
further ensures that individuals can immediately apply their learning curriculum, covering everythingfrom foundational Python programming
to real-world situations, making them more valuable to prospective toadvanced machine learning. I’ve alreadysecured a job in data science
employers. The Instructor was interactive and keep us engaged, as a junior datascientist. The instructors are highlyknowledgeable and
ensuring that learners gain practical experience in real-time. supportive, always readyto help with any questions.
HEAR FROM OUR LEARNERS

Sagar Bhandge Temitayo Adeosun

Data Engineer
Cologne, Bonn - Germany
Aera Technology

I recently completed the Advanced Post-Graduate Program in Data Science A big thank you to edu plus now for the incredibly well-structured and
with AI & ML by edu plus now and Vishwakarma Institute of Technology insightful PGD program in Data Science, ML, and Al. The course provided
Group, and it has been an enriching experience. The course delves deep clear explanations and practical examples that made complex topics easily
into crucial concepts such as the Hadoop framework, Kafka, and gaining an understandable. Your enthusiasm and depth of knowledge were evident
understanding of AWS cloud services. throughout, which truly enhanced my learning experience.
I highly recommend this program to anyone looking to advance their career
The professors are exceptional, demonstrating a profound knowledge of in this field. Thank you once again for such a transformative educational
the subject matter. The hands-on approach to learning, coupled with real- experience.
world applications, provided practical insights. I highly recommend it to
anyone aspiring to excel in the field of data science.

Aniket Pawar Ashwin Chaudhari

Dassault Systèmes Semantic Data Science Team

The course has really helped me understand thekey concepts in Python This course has enhanced my understanding of Python programming, data
programming, datascience, and machine learning. The content iswell- science, and machine learning. The well-structured lessons and focus on
structured, and the practical approachmakes it easy to connect what practical exercises have helped me grasp how these concepts apply in real-
I’m learning toreal-world use cases. I’m excited to continue thejourney world situations. I have acquired valuable skills and look forward to further
and further build my skills in theseexciting and rapidly-evolving expanding my knowledge.
technologies.

Abhinav Salve Ashwini

Mechanical Engineer B.Pharm

This course has deepened my understanding of Python programming, The course was extremely good. The faculty members who taught us are
data science, and machine learning. The lessons are well-structured, superbly talented, and their guidance has helped me work towards my
and the emphasis on practical exercises has made it easier to see how future goals. The trainers’ backgrounds and experience instilled confidence
these concepts apply in real-world scenarios. I’ve gained valuable skills in the training.
and i am excited to keep advancing my knowledge

and many more...

OUR CLIENTS

OUR GOVT. CLIENTS

Indian Space Ministry of Defence Ministry of Micro, Small,

Research Organisation and Medium Enterprises

INTERVIEWS CONDUCTED FOR

OUR ALUMNI WORK AT

and many more...

Empowering the careers of
learners around the globe!

Our other training programs:

• Adv PG Program in Data Science with AIML • Certificate Program in Data Analytics & • Six Sigma Yellow Belt
• Adv PG Program in Data Engineering Machine Learning • Six Sigma Green Belt
• Adv PG Program in Data Analytics with AIML • Statistics for Researchers • Six Sigma Black Belt
• Adv PG Program in Full Stack Development • Design for Six Sigma Supplement • Six Sigma Master Black Belt

• Certificate Course in Biological Data Analytics • Certificate Course on Computational Drug Discovery
• Certificate Course on Molecular Modelling • PG Program in molecular modelling and drug Designing
• Certificate Course on transcriptome data analysis

TM Other initiatives of Vishwakarma Group

An initiative of Vishwakarma Group Pune.

Vishwakarma Institute of Technology (VIT, Pune), Vishwakarma Institute of Information Technology (VIIT, Pune),
Vishwakarma University (VU, Pune), Vishwakarma Schools, Wisdom World School

34A/1, Suyog Center, 6th Floor, Gultekadi Marketyard Road,

Giridhar Bhavan Chowk, Pune, Maharashtra 411037
For further details,
02047170528
[email protected] Scan QR Code
www.eduplusnow.com for more details
@eduplusnow