AI & Data Analytics Program

Introduction to NumPy (arrays, operations)

Introduction to Pandas (Series, DataFrame)

Reading Data (CSV, Excel)

Data Inspection & Summary Statistics

Data Cleaning Basics

Data Visualization Principles

Dashboard Basics

Introduction to Tools (Streamlit / Flask basics)

Storytelling with Data

Excel Interface & Data Entry

Functions: SUM, IF, VLOOKUP, COUNT

Data Formatting & Cleaning

Charts & Graphs

Introduction to Power BI

Data Import & Transformation (Power Query)

Data Modeling

Basic Visualizations

DAX Functions (CALCULATE, SUMX, etc.) , KPIs & Metrics ,Filters & Slicers

Advanced Visualizations ,Dashboard Design Principles

Tableau Interface & Concepts , Data Connection

Visualizations (Charts, Maps) , Dashboard Creation

Introduction to MySQL & Relational Databases , Database Creation & Table Management

SQL Commands: SELECT, INSERT, UPDATE, DELETE

Filtering Data using WHERE Clause , Sorting & Limiting Results (ORDER BY, LIMIT)

Grouping Data using GROUP BY

SQL Joins , Subqueries & Nested Queries

Window Functions , Views & Indexing Basics

Introduction to NoSQL Databases , JSON Document Structure

CRUD Operations in MongoDB

Indexing & Performance ,Basics Cloud Database Platforms

📡 Customer Data Storage System

🛒 Product Database Design

💳 Transaction Data Management System