Data Analytics Course in Chennai

Learn how to perform data transformation, data analysis, and other crucial data analysis functions. Discover the fundamentals of Python and how to use it for data analytics.

Module 2 – Data wrangling with SQL

2.1 Introduction to SQL
2.2 Database normalization
2.3 Entity-relationship model
2.4 SQL operators
2.5 Join, tables, and variables
2.6 SQL functions
2.7 Subqueries
2.8 SQL functions, views, and stored procedures
2.9 User-defined functions
2.10 SQL performance and optimization
2.11 Advanced concepts

Correlated subquery
Grouping sets

Module 3 – Presto

3.1 Introduction to Presto
3.2 Writing Queries in Presto on Large Data Sets
3.3 Data Transformation using Presto

Module 4 – Introduction to Data Science and Statistics

4.1 Descriptive Statistics

Mean
Median
Mode
Tables
Charts

4.2 Introduction to Probability

Probability in Business Analytics

4.3 Probability Distributions

Binomial distribution
Poisson distribution
Normal distribution

4.4 Hypothesis Testing and Estimation

Hypothesis testing
Estimation

4.5 Goodness of Fit

How the sample adequately fits a distribution from an observational set

Module 5 – Business Problem Solving, Insights and Storytelling

5.1 Business domains

Finance
Marketing
Retail
Supply Chain

5.2 Understanding the business problem and formulating hypotheses
5.3 Exploratory data analysis
5.4 Data storytelling: Narrate stories in a memorable way
5.5 Project on deriving business insights and storytelling

Module 6 – Optimization Techniques

6.1 Linear programming
6.2 Goal programming
6.3 Integer programming
6.4 Mixed integer programming
6.5 Distribution and network models

Module 7 - KNIME

7.1 Introduction to KNIME
7.2 Working with data in KNIME
7.3 Loops in KNIME
7.4 Webscraping in KNIME
7.5 Hyperparameter optimization in KNIME
7.6 Hyperparameter optimization for Machine Learning Models using loops in KNIME
7.7 Feature Selection in KNIME

Module 8 – Statistics and Machine Learning using R Programming

8.1 Programming with R
8.2 Advance Statistics

ANOVA
Regression analysis
Dimension reduction techniques

8.3 Data Mining

Supervised and unsupervised learning
Clustering
Market Basket Analysis
Decision trees
Random forest
Neural networks

Module 9 – Predictive Modeling

9.1 Multiple linear regression
9.2 Logistic regression
9.3 Linear discriminant analysis

Module 10 – Time-Series Forecasting

10.1 Introduction to time-series
10.2 Correlation
10.3 Forecasting
10.4 Autoregressive models

Module 11 – Feature Engineering

11.1 Handling unstructured data
11.2 Machine Learning algorithms
11.3 Bias variance trade-off
11.4 Handling unbalanced data
11.5 Boosting
11.6 Model validation

Module 12 – Advance Machine Learning Techniques

12.1 Hyper parameter optimization
12.2 Advance Machine Learning Libraries – XGBoost
12.3 Solving Problems on Kaggle

Module 13 - Data Science Execution Strategy

13.1 Framework to Data Science strategy
13.2 Mapping Data Science with data architecture strategy
13.3 Executing Data Science strategy

Module 14 – Business Case Studies

14.1 Marketing & retail analytics
14.2 Social analytics
14.3 Logistics & supply chain
14.4 Financial analytics

Module 15 – Visualization using Power BI

15.1 Introduction to Power BI
15.2 Data Extraction
15.3 Data Transformation – Shaping & Combining Data
15.4 Data Modelling & DAX
15.5 Data Visualisation with analytics
15.6 Power BI Service (Cloud), Q&A, and Data Insights
15.7 Power BI Settings, Administration & Direct Connectivity
15.8 Embedded Power BI with API & Power BI
15.9 Power BI Advance & Power BI Premium

Module 16 – Data Science Capstone Project

In the Data Science and Business Analytics Capstone Project, you will use all the knowledge and skills you have acquired throughout this advanced certification program and get real-world industry project exposure.

Job Readiness

Job Search Strategy
Resume Building
Linkedin Profile Creation
Interview Preparation Sessions by Industry Experts
Mock Interviews
Placement opportunities with 400+ hiring partners upon clearing the Placement Readiness Test.

Free Career Counselling

We are happy to help you 24/7

Project Work

Projects will be a part of your Data Analyst Master’s program to consolidate your learning. It will ensure that you have real-world experience in Data Analytics.

Predicting Class of a Flower with Petals Data

This project is to predict the class of a flower. By analyzing the data about the petals and their dimensions, the class of the flower would be determined using a trained machine learning model that has optimum accuracy.

Data Analytics on Census Dataset

The project is meant to analyze and predict whether an individual has an annual income of more than Rs 50000 or less using various machine learning techniques, some of which are supervised and unsupervised.

Fraud Detection

The project will create a model that would help in detecting credit card fraud using machine learning subcategories like supervised, unsupervised, and reinforcement learning techniques like neural networks and random forests.

Analyzing Impact Factors of the Pre-paid Model in Telecom

The goal of this project is to find the factors that have the maximum impact on the preferences of the pre-paid model. It also aims at identifying the variables that are highly correlated with these impacting factors.

Pokemon Analysis

Select a pokemon whose primary type is “grass" and whose secondary type is “poison” with the maximum speed. It creates a model that predicts whether the selected Pokemon is legendary or not using machine learning and data analysis techniques.

Stock Market Analysis

This project focuses on machine learning by creating a predictive data model to predict future stock prices. It also analyzes the current trends in the stock market using algorithms like linear regression and k-nearest neighbors.

Comment Identity and Classification

Work on the comment dataset of Yelp to build a multi-headed model that can identify and categorize various types of toxic comments (obscenity, insults, threats, etc.). It must allow the user to find and select the required type

Book Recommender

This project aims at building a book recommendation engine based on the past reading and buying history of an individual. It will analyze the dataset using machine learning techniques, R programming, and its various libraries.

Loan Approval Prediction

The project aims to analyze whether the applied loan would be approved or not by identifying the variables correlated with impacting factors. It is predicted using techniques such as logistic regression, decision tree, and random forest.

Recommendation Engine using Netflix prize dataset

The recommendation engine is built using the Netflix prize dataset and will collect data from various sources about a user, anticipate their preferences, and recommend movies according to the user’s behavior and choices made earlier.

Career Transition

Shubham Shinde

Data Analyst | India

300% salary hike

Intellipaat training helped me crack interviews successfully and transition to a data analytics role with a 300% hike at Deloitte. The support staff and mentorship from seasoned educators have greatly contributed to my career growth. Read More

Business Intelligence Specialist

Data Analyst

Kiran Kulkarni

Sr. Data Analyst | India

Non-tech to Tech

I started working in the BPO sector. I wanted to grow in some technical domain and eventually chose data analytics. I found the course immensely interesting and the support staff was of great help.

BPO Associate

Sr. Data Analyst

Aditya Ahuja

Data Analyst | India

130% salary hike

Successful career transition from a quality analyst to a data analyst at Accenture. Intellipaat’s training and excellent placement assistance fetched me offers from companies like Mindtree, Cognizant, and Accenture.

Software Test Engineer

Data Analyst

Lucky Bajetha

Data Analyst | India

Job as Data Analyst

After completing my B.Tech, I was working in human resources. While pursuing Intellipaat’s course, I mentioned it in my resume, and that made a great impact. I started getting calls from various MNCs like Infosys, Capgemini, and EY. Read More

Human Resource Executive

Data Analyst

Abhilasha Kumari

Executive | India

25% Salary Hike

After developing an interest in data analysis, I enrolled in the training. I am glad I got a job in this domain and shifted from a non-tech role to a data analyst. Also, I am now much more confident in data analysis than before.

Associate , Client support

Executive

Akinola Obafemi Sanyaolu

Non-tech to Data Analyst

Intellipaat has guided me to take the right course where I learned the latest tools and technologies from R to Tableau, MS Excel, and SQL, allowing me to switch my career from sales to a tech role.

Project Manager

Data Analyst

Melwin Rodrigues

Data Scientist | India

Job as Data Scientist

Becoming a data scientist after working as a customer service agent was possible only due to expert guidance from Intellipaat trainers. Even after working for 10 years in customer care, I am a data scientist today.

Customer Service Agent

Data Scientist

Shehzin Mulla

Marketing Data Analyst | India

Job with a salary hike

Thanks to Intellipaat, I was able to shift from a data analyst to a marketing data analyst with a 35% salary hike and gain a deep understanding of analytics.

Data Analyst

Marketing Data Analyst

Vishal Sharma

Senior Analyst | India

Job with a 300% hike

I was able to successfully make an internal transition from a business analyst to a senior analyst. The training has helped me effectively execute the projects in my organization. I am glad to have chosen Intellipaat.

Business Analyst

Senior Analyst

Ankit Kumar

Data Scientist | India

Non-tech to Tech

Intellipaat has given me the confidence that anyone who aspires can become a data scientist because of the rich course and expert guidance. I managed to switch from a non-tech education background to becoming a data scientist.

B.com Graduate

Data Scientist

Nishchay Agrawal

Data Engineer | India