dots bg

DATA ANALYTICS

Course Instructor: Talent Shine

₹498.00

(excluding GST & gateway fee)

dots bg

Course Overview

Module

Topics Covered

Foundations of Data Analytics

·       Introduction to Data Analytics

·       Data Types and Data Collection

·       Introduction to Excel for Data Analysis

·       Introduction to Python for Data Analysis

·       Basic Statistical Concepts

·       Hypothesis Testing

Data Handling, Cleaning & Exploration

·       Data Manipulation with Python

·       Data Cleaning Techniques

·       Data Exploration with Pandas

·       Exploratory Data Analysis (EDA)

·       Data Cleaning and Preprocessing for the Project

Data Visualization & Reporting

·       Data Visualization with Matplotlib and Seaborn

·       Introduction to Data Visualization with Tableau

·       Advanced Excel Techniques

·       Data Analysis and Visualization for the Project

SQL & Machine Learning Essentials

·       Introduction to SQL

·       SQL for Data Analysis

·       Introduction to Machine Learning

·       Modeling and Interpretation

Advanced Concepts & Project

·       Advanced Python for Data Analysis

·       Big Data Overview

·       Data Ethics and Governance

·       Project Planning and Setup

·       Project Work and Review

·       Final Review and Q&A

Schedule of Classes

Course Curriculum

1 Subject

DATA ANALYTICS

62 Learning Materials

Getting Started

Welcome Note

PDF

Profile Update

External Link

Introduction

Fundamentals of Data Analytics

Video
00:10:23

Python Programming

Keywords, Comments & Variables in Python

Video
00:20:22

Data Types in Python

Video
00:08:04

Sequence Data Types in Python

Video
00:06:56

Range Data Type in Python

Video
00:08:48

Operators in Python

Video
00:24:44

Identity Operators

Video
00:10:28

Set & Boolean

Video
00:10:27

Input Function in Python

Video
00:07:18

List Operators in Python

Video
00:26:27

Type Conversion

Video
00:16:04

Tuple Operations in Python

Video
00:09:44

Set Operations in Python

Video
00:06:59

Dictionary Operations in Python

Video
00:09:59

Functions in Python

Video
00:11:17

Types of Function Arguments

Video
00:05:04

SQL

SQL - 1

Video
00:10:16

SQL - 2

Video
00:11:54

Constraints

Video
00:07:33

DQL Statements - 1

Video
00:08:22

DQL Statements - 2

Video
00:11:06

DQL Statements - 3

Video
00:09:47

Alias & Distinct Clause

Video
00:09:51

Operators

Video
00:11:12

Special Operators

Video
00:16:42

Multi Row Functions

Video
00:12:14

Grouping Clause

Video
00:12:34

Grouping & Filtering Clause

Video
00:12:32

Sub Queries

Video
00:13:41

Nested Sub Queries

Video
00:10:51

Joins in SQL

Video
00:15:23

Outer Join

Video
00:08:43

Self Join & Natural Join

Video
00:11:38

Co-Related Sub Query

Video
00:08:27

Single Row Function

Video
00:21:40

Data Definition Language (DDL)

Video
00:16:16

Truncate & Drop

Video
00:08:50

Data Manipulation Language (DML)

Video
00:13:17

Numpy

Introduction

Video
00:05:27

Installation, Creation of Array

Video
00:08:00

Dimensions of Array

Video
00:09:39

Functions

Video
00:11:08

Indexing

Video
00:11:08

Operations on Arrays

Video
00:14:49

Pandas

Introduction

Video
00:09:30

Data Frame, Series

Video
00:07:59

Creating a DataSet From Dictionary

Video
00:07:59

Loading CSV File

Video
00:10:30

JSON File

Video
00:07:22

Data Cleaning

Video
00:11:32

Matplotlib

Matplotlib

Video
00:38:48

Excel

Introduction

Video
00:07:02

Interface

Video
00:06:40

Home Tab

Video
00:11:15

Conditional Formatting

Video
00:13:37

Operators

Video
00:07:46

Basic Functions

Video
00:12:57

IF Functions

Video
00:10:38

Introduction to Tables

Video
00:10:49

Dash Board in Excel

Video
00:22:34

Course Instructor

tutor image

Talent Shine

86 Courses   •   39927 Students