Core Python for Data Analytics Introduction

Challenge 1

Input and Output in Python

Challenge 2

Collection 1

Collection 2

Collection 3

Collection 4

Challenge 3

Control Flow Statement

Loops in Python

Challenge 4

Functions in Python

Challenge 5

File Handling in Python

Challenge 6

Exception Handling in Python

Challenge 7

OOPS

Introduction to Sql

Database Languages and Datatypes

DDL-SQL

Challenge 1

Constraints

Challenge 2

DML, DQL - SQL

Challenge 3

JOINS - SQL

Challenge 4

Subquery

Challenge 5

Operator, Clauses in SQL

Inbuild Function

Challenge 6

Windows Function

Challenge 7

DCL

TCL

Challenge 8

Pandas

NumPy

EDA Process

Matplotlib

Seaborn

Challenge 1

Challenge 2

Challenge 3

Challenge 4

Challenge 5

Challenge 6

Excel Overview

Basic Functions 1

Basic Functions 2

Data Cleaning

Lookup Function

Descriptive Statistics Introduction

Descriptive Analysis in Excel

Pivot Table

What If Analysis

Basic and Advance Charts

Advanced Functions and Formulas

Data Validation and Macros

Tableau Introduction

Data Cleaning and Data Structuring in Tableau

Basic Charts in Tableau

Advance Visualisation

Calculation & Expression

Dashboard

Netflix Project

Power Bi Introduction

Data Cleaning and Data Transformation

DAX Functions

Charts in Power Bi

Power Bi Dashboard

Customer Purchase Behaviour Analysis (Python)

Employee Performance & Attrition Analytics (Excel)

Online Food Delivery Insights (SQL)

Hospital Patient Analytics Dashboard (Power Bl)