Data Analytics

Diploma In Data Analytics

1

Python basics & syntax

2

Data types, loops, functions

3

NumPy for numerical analysis

4

Pandas for data manipulation

5

Data cleaning & preprocessing

6

Data visualization (Matplotlib, Seaborn)

7

Exploratory Data Analysis (EDA)

8

Working with CSV, Excel, and databases

1

Database concepts & RDBMS

2

SQL queries: SELECT, WHERE, ORDER BY

3

Joins (INNER, LEFT, RIGHT, FULL)

4

Aggregate functions (SUM, AVG, COUNT)

5

Subqueries & views

6

Indexes & constraints

7

SQL for data analysis and reporting

1

Tableau interface & data connection

2

Data blending & joins

3

Filters, parameters & actions

4

Charts, maps & dashboards

5

Storytelling with data

6

Publishing dashboards

1

Introduction to MIS

2

Types of MIS reports

3

Data collection & processing

4

Reporting tools & dashboards

5

Decision-making using MIS

6

Data governance & security

1

Introduction to Power BI

2

Data Sources and Data Loading

3

Data Transformation (Power Query)

4

Data Modeling

5

DAX (Data Analysis Expressions)

6

Data Visualization

7

Reports and Dashboards

8

Power BI Service

9

Security and Performance

10

Power BI Deployment and Use Cases

1

Excel Basics Revision

2

Advanced Formulas & Functions

3

Data Analysis Tools

4

Pivot Tables & Pivot Charts

5

Data Management

6

Macros & VBA Basics

7

Advanced Excel Applications

1

Introduction to R & Applications and Features

2

Installing R & RStudio

3

Basic Syntax & Operators

4

Data Types , Type Conversion

5

Data Structures

6

Control Statements & Loops

7

Functions in R and Data Handling

8

Data Analysis

1

Pandas

2

Numpy

3

Matplotlib