Scribd
Upload
18 views24 pages

Data Analytics

The document outlines a comprehensive curriculum for applications of data analytics, covering foundational programming concepts, core tools like Excel and SQL, and advanced topics such as machine learning and data visualization. It includes practical exercises and projects in various areas, including statistics, data manipulation, and cloud-based machine learning. Additionally, it provides resources for further learning and career services.

Uploaded by

mayurnandankar000
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
18 views24 pages

Data Analytics

The document outlines a comprehensive curriculum for applications of data analytics, covering foundational programming concepts, core tools like Excel and SQL, and advanced topics such as machine learning and data visualization. It includes practical exercises and projects in various areas, including statistics, data manipulation, and cloud-based machine learning. Additionally, it provides resources for further learning and career services.

Uploaded by

mayurnandankar000
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 24

Applications of Data Analytics

Foundation

Introduction to Programming
Variables & Arithmetic Expressions
Data Types
Functions
Conditions and Conditional Statements
Lists
OOPS Concepts
Core Track MS-Excell

Intro to Excel
Importing Data
Formatting in Excel
Excel Formulae
Data Validation
Calculations
SQL (Basic/Advance)

DDL Statements
DML Statements
DQL Statements
Joins
Date Functions
Aggregate Functions
Sub-Queries
Exercise on SQL
Union, Union All &
Intersect Operators
Numpy

Array
Array Attributes
Array Methods
Array Indexing
Slicing Array
Array Operation
Iteration through Arrays
Pandas

Creating Panda Series


Concatenate a Series
Filtering a Series
Arithmetic Operations

Checking Null Values


Series Ranking and Sorting
Accessing Series Elements
Data Frame Manipulation

Dataframe Creation
Reading Data from Various Files
Understanding Data
Accessing Dataframe elements using Indexing
Dataframe Sorting
Ranking in Dataframe
Dataframe Concatenation
Reshaping Dataframe
Checking Duplicates
Data Frame Manipulation

Missing Value Analysis & Treatment


Dataframe Joins
Dataframe Merge
Pivot Tables
Cross Tables
Dataframe Operations
Dropping Rows and Columns
Replacing Values
Grouping Dataframe
Statistics for Data Science

Random Variables
Descriptive Statistics
Measure of Dispersion
Skewness and Kurtosis
Hypothesis Testing
Measure of Central Tendency
Probability Theory
Probability Distributions
Statistical Tests
Covariance and Correlation
Machine Learning

Introduction to Machine Learning


Linear Regression Using OLS
Decision Trees
Logistic Regression
Model Tuning Techniques
Project on Linear Regression
Project on Logistic Regression
Random Forest

K-means Clustering
Machine Learning (Contd…)

K-means Clustering
Hierarchical Clustering
Principal Component Analysis
Time Series Modelling
Basics of Cloud
Machine Learning on Cloud
Deploying ML models
Data visualisation with

Tableau / Power BI
Tableau Part 1 & 2
Project – Mortgage Analysis
Power BI – Part 1
Data analytics & ML Track

Ensemble Modeling Techniques


K Nearest Neighbours
Analytics in Healthcare/Finance
Analytics in Marketing/Sales
Linux Commands
Career Services
Thank You
References

https://youtu.be/i2jwZcWicSY
https://youtu.be/CCnCABJhAdU
https://www.whiteboardanimation.com/healthcare-data-and-analytics-ani
mations

You might also like