Advanced certification in data science – BI Consulting, Project Delivery & Training

Q: Module 6- DAV Using Python

• Introduction to Data Analysis and Visualization • Data – • Sources of Data • Cleaning the data • Central tendencies for cleaning • Hypothesis testing • Shape of the Data – Univariate, Bivariate, Multivariate with their plottings • Univariate – • Bar graphs • Histograms • Bivariate – • Covariance • Scatter Plot • Linear regression • Multivariate Data – • Correlation matrix • Multivariate regression • EDA • Plotting – Special plotting’s bubble plot, animated bubble plot etc. using • Seaborne • ggplot • Altair • Matplotlib • Bokeh • Case Studies

Advanced Certification In

Data Science

Opine Group is engaged in all activities related to Business Intelligence and Data Analytics. We work on complex projects and take up corporate consultancy assignments that require deep understanding of operations related data and it’s interpretation using various BI tools. To complement these activities, we have set up a School of Analytics. It provides industry- relevant training covering different aspects of BI and Analytics.

Months Duration

Trainer's Experience

0 + Years

Advanced Certification In

Data SCIENCE

Months Duration

Trainer's Experience

0 + Years

Data SCIENCE Course Content

Data SCIENCE Course Review

pratiksha ghube

Very good courses for beginners. And faculty was teaching friendly to the students. Specially thanks to kedar sir for sharing knowledge and experience with us

Aasavari Thakar

Learning at Opine Group has been an excellent experience. The staff is very friendly and helps you in every step of the way. It is an exceptional institute for learning about various tools of data analysis

Abhishek Thombare

One stop solution who wants to start their career into Data Analytics field.

Dhanesh Vadnerkar

It was a great learning experience and we really enjoyed the training

soham gokhale

I attended a foundations course here. The teaching was fantastic and very close to actual work. The teachers are very experienced working professionals, which adds to the learning experience.

Vijayraj More

Very good courses for beginners. And faculty was teaching friendly to the students. Specially thanks to Anand Sir for sharing knowledge and experience with us

Rohit pampatwar

Teaching skill is good and really we took industrial experience from here

Avinash Patil

I joined opine group for SQL class. Inspite of being from non-it background, Shubhangi mam has taught SQL effectively. As the class has all concepts from basic, it is an easy learning experience for everyone.

LEARNING PATH

KNOW MORE ABOUT

THE PROGRAM

Welcome to the fascinating world of data science! Discover the power of data and unlock its hidden treasures. In today's data-driven era, businesses and organizations are constantly seeking insights to make informed decisions, drive innovation, and gain a competitive edge. That's where data science comes in.
At ‘Opine Group’, we specialize in harnessing the potential of data science to help you uncover meaningful patterns, extract valuable insights, and make data-driven decisions with confidence.

Let’s walk through your journey at OPINE GROUP

Module 1- Fundamentals of Analytics

• Introduction of analytics

• Introduction to Business Intelligence – what, where
and how?

• Need for Business Intelligence / Analytics

• BI/DW Lifecycle

• Real life-based exercises to understand BI phases

• Requirements gathering, Data Modeling
(Dimensional)

• Analytics and Approach for Solution Design

• Dimensional Modeling Process and Scenario based
model designing

• Career Opportunities discussion and guidance

Module 2- Excel Analytics – Spreadsheet Analytics

• Introduction to Excel

• Excel features (Lookup, count blank, forecast)

• Formatting along with conditional formatting

• Pivoting (Reports and charts with pivot tables)

• Data Protections

• Data Population and error handling

• Statistical analysis

• Excel Function (useful for aggregation of data)

• Data Analysis using Excel

Module 3- SQL: Database Queries

• SQL Basic
• Introduction SQL (Structured Query Language)
• Fundamentals of SQL
• SQL Tables, Joins, Variables

• SQL Advance
• SQL Functions, Subqueries, Views, Rules
• Condition based queries using various operator
• Data Modeling
• Different type of joins (Basic, Advance)
• Aggregate Function
• Windows Functions
• Use of CTE (Common table expression) with
practice
• Hands on exercise on live projects

Module 4- Python: Programming Language

• Setting Python in Windows

• Introduction to print ()

• Variable and Data Type

• Enumerators, operators, building basic expressions

• More print (), input ()

• String data type indexing and slicing

• Program flow controls

• Loops

• Data structures – List, Dictionary, Tuple, Set

• Introduction to functions

• Exception Handling

• Object Oriented Programming concepts

• Reading from text files and writing to text files, .csv
files

• URL Libraries

Module 5- Machine Learning: ML1, ML2

• NumPy

• Data frames using panda’s library

• Datasets

• Introduction to Machine Learning

• Classification, Dimensionality

• Types of Supervised Learning

• Probability, Decision Tree, ID3 Algorithm

• Bayes Theorem, Naïve Bayes Classifier

• Managing Data Label Encoder, Data Scaling –
Standard Scalar

• Feature Selection – Select K Best

• Sampling and Evaluation – Confusion Matrix, Cross
Evaluations

• Linear Regression, Logistic Regression

• Support Vector Machines

• Clustering – KMeans

• Ensemble Learning, Reinforcement Learning, PAC
Learning

• Artificial Neural Network –
• Single Layer
• Multilayer Perceptron Algorithm

Module 6- DAV Using Python

• Introduction to Data Analysis and Visualization

• Data –
• Sources of Data
• Cleaning the data
• Central tendencies for cleaning

• Hypothesis testing

• Shape of the Data – Univariate, Bivariate,
Multivariate with their plottings

• Univariate –
• Bar graphs
• Histograms
• Bivariate –
• Covariance
• Scatter Plot
• Linear regression
• Multivariate Data –
• Correlation matrix
• Multivariate regression
• EDA

• Plotting –
Special plotting’s bubble plot, animated bubble plot
etc. using
• Seaborne
• ggplot
• Altair
• Matplotlib
• Bokeh

• Case Studies

Module 7- Membership of Communication Gym

• Learn to communicate effectively in English through
various activities.

Module 1- Fundamentals of Analytics

• Introduction of analytics

• Introduction to Business Intelligence – what, where and how?

• Need for Business Intelligence / Analytics

• BI/DW Lifecycle

• Real life-based exercises to understand BI phases

• Requirements gathering, Data Modeling (Dimensional)

• Analytics and Approach for Solution Design

• Dimensional Modeling Process and Scenario based model designing

• Career Opportunities discussion and guidance

Module 2- Excel Analytics – Spreadsheet Analytics

• Introduction to Excel

• Excel features (Lookup, count blank, forecast)

• Formatting along with conditional formatting

• Pivoting (Reports and charts with pivot tables)

• Data Protections

• Data Population and error handling

• Statistical analysis

• Excel Function (useful for aggregation of data)

• Data Analysis using Excel

Module 3- SQL: Database Queries

• SQL Basic
• Introduction SQL (Structured Query Language)
• Fundamentals of SQL
• SQL Tables, Joins, Variables

Module 4- Python: Programming Language

• Setting Python in Windows

• Introduction to print ()

• Variable and Data Type

• Enumerators, operators, building basic expressions

• More print (), input ()

• String data type indexing and slicing

• Program flow controls

• Loops

• Data structures – List, Dictionary, Tuple, Set

• Introduction to functions

• Exception Handling

• Object Oriented Programming concepts

• Reading from text files and writing to text files, .csv files

• URL Libraries

Module 5- Machine Learning: ML1, ML2

• NumPy

• Data frames using panda’s library

• Datasets

• Introduction to Machine Learning

• Classification, Dimensionality

• Types of Supervised Learning

• Probability, Decision Tree, ID3 Algorithm

• Bayes Theorem, Naïve Bayes Classifier

• Managing Data Label Encoder, Data Scaling – Standard Scalar

• Feature Selection – Select K Best

• Sampling and Evaluation – Confusion Matrix, Cross Evaluations

• Linear Regression, Logistic Regression

• Support Vector Machines

• Clustering – KMeans

• Ensemble Learning, Reinforcement Learning, PAC Learning

• Artificial Neural Network –
• Single Layer
• Multilayer Perceptron Algorithm

Module 6- DAV Using Python

• Introduction to Data Analysis and Visualization

• Data –
• Sources of Data
• Cleaning the data
• Central tendencies for cleaning

• Hypothesis testing

• Shape of the Data – Univariate, Bivariate, Multivariate with their plottings

• Plotting –
Special plotting’s bubble plot, animated bubble plot etc. using
• Seaborne
• ggplot
• Altair
• Matplotlib
• Bokeh

• Case Studies

Module 7- Membership of Communication Gym

• Learn to communicate effectively in English through various activities.

Our Alumni works at

meet your mentors

Dr. Anand
Kolharkar

30+ years of Industry Experience. Headed BI practice for IT companies. Nurtured and developed BI teams in different domains like Banking, Manufacturing, Chemical & Pharma to name a few. Worked with leading Indian and Multi-National brands. Conducted more than thousand hours of training in Corporate and Management Institutes.

Mrs. Manjusha
Kalgaonkar

28 years of development + teaching experience in Aftek, Zensar Technologies, MIT College, SICSR etc. Trained students of MCA, MSc (Computer Science), BCA, BBA, FE, SE TE students in Opine. Also trained working professionals. Developed systems in C, C++ for protocols and scheduler jobs for point of sales terminal, Air flow calibration, hardware and testing software etc. Conducted training in C, C++, DS, Python, Machine Learning, Artificial Intelligence, Oracle, Data Analysis and Visualization etc. More than 1000+ hours in training MSc, BE and Corporate students.

Mrs. Suvarna
Siraskar

Industrial experience of more than 20 years Worked for large fortune 100 organizations like Cummins and Merck Manufacturing and Pharmaceutical domain experience. Project delivery and management experience for large Oracle, SQL based projects. Visiting faculty for reputed institutions like Symbiosis and PUMBA (Pune University).

Mr. Shirish
Kulkarni

32+ years of experience in IT industry in various areas from development to support and maintenance projects to quality. Has worked with domestic as well as international clients. Consultation to profit organization as well as non-profit organization. Providing training in data analysis tools and techniques.

why opine ?

We are a group of senior Business Intelligence experts with the passion and definite objective to leverage the ever-expanding base of data and drive ‘change’ in every sphere using Business Intelligence.

With knowledge precipitated from the data, we use Business Intelligence and Analytics to enable intelligent, timely and actionable decisions and deliver greater value from same resources for you

14 YEARS experience

We are decade old organization working in BI space having combination of junior and senior BI experts.

Empowering the users

Extensive user training to demonstrate the potential of BI, earn their Buy-in and drive improvement

Our Unique Methodology

From gathering business requirements to applying the technology, we focus on solving business questions.

Playlist

4 Videos

Advanced Certification In

Data Science

Advanced Certification In

Data SCIENCE

Data SCIENCE Course Content

Fundamentals Of Analytics

Excel Analytics

SQL Server

Python

Machine Learning

DAV Using Python

Communication Gym Membership

Data SCIENCE Course Review

LEARNING PATH

KNOW MORE ABOUT

THE PROGRAM

Let’s walk through your journey at OPINE GROUP

Our Alumni works at