DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
[Link] TOPICS
I Data Analytics Foundations
Tools (Excel, SQL, Python, BI Tools)
1
What is Data Analytics
2
Types of Analytics (Descriptive, Diagnostic, Predictive, Prescriptive)
3
Data Analyst Roles and Responsibilities
4
Data Analytics Lifecycle
5
Business Understanding and Problem Framing
6
Real-World Applications of Data Analytics
7
Overview of Data Analytics Tools
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
II Excel for Data Analytics
Tools Microsoft Excel
8 Excel Interface and Navigation
9 Data Types and Formatting
10
Sorting and Filtering Data
11
Data Validation
12
Logical Functions (IF, AND, OR)
13
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
14
Text Functions
15
Date and Time Functions
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
16
Mathematical and Statistical Functions
17
Pivot Tables
18
Pivot Charts
19
Conditional Formatting
20
Data Cleaning Techniques
21
What-If Analysis
22
Importing Data (CSV, TXT)
23
Excel Dashboards
III SQL for Data Analytics
MySQL / PostgreSQL / SQL Server
Tools
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
Introduction to Databases
24
Relational Databases and RDBMS
25
SQL Syntax and Data Types
26
DDL Commands
27
DML Commands
28
SELECT Statements
29
Filtering Data using WHERE
30
Sorting Results using ORDER BY
31
Aggregate Functions
32
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
GROUP BY Clause
33
HAVING Clause
34
Joins (Inner, Left, Right, Full)
35
Subqueries
36
Views
37
Indexes
38
Window Functions (Basics)
39
CASE Statements
40
IV Python Programming Fundamentals
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
Python,IDLE, Jupyter Notebook, VS Code
Tools
Python Installation and Environment Setup
41
Working with Jupyter Notebook
42
Python Syntax and Basic Structure
43
Variables and Data Types
44
Operators in Python
45
Conditional Statements
46
Loops in Python
47
Python Functions
48
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
Modules and Packages
49
Strings in Python
50
Lists in Python
51
Tuples, Sets, Dictionaries
52
File Handling
53
Exception Handling
54
V Data Analysis with NumPy and Pandas
Tools Python, NumPy, Pandas, Jupyter Notebook
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
Introduction to NumPy
56
NumPy Arrays
57
Mathematical Operations with NumPy
58
Vectorized Calculations
59
Introduction to Pandas
60
Pandas Series
61
Pandas DataFrames
62
Importing Data (CSV, Excel, JSON, SQL)
63
Data Inspection
64
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
Handling Missing Values
65
Removing Duplicate Data
66
Data Formatting
67
Filtering Data
68
Sorting and Indexing
69
Renaming Columns
70
Data Transformation
71
Aggregation Functions
72
GroupBy Operations
73
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
Data Merging and Joining
74
Concatenation
75
Feature Engineering Basics
76
Exploratory Data Analysis (EDA)
77
VI Data Visualization with Python
Tools Matplotlib, Seaborn, Python
78 Introduction to Data Visualization
79 Visualization Principles
80 Choosing the Right Chart
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
81 Introduction to Matplotlib
82 Line Charts
83 Bar Charts
84 Histograms
85 Introduction to Seaborn
86 Heatmaps
87 Boxplots
88 Distribution Plots
89 Customizing Charts
90 Visualization Best Practices
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
91 Dashboard Concepts
92 Storytelling with Data
93 Creating Insightful Reports
VII Machine Learning for Data Analytics
Tools Python, Scikit-learn
94 Introduction to Machine Learning
95 Role of Machine Learning in Data Analytics
96 Supervised Learning
97 Unsupervised Learning
98 Machine Learning Workflow
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
99 Data Preparation for Models
100 Train-Test Split
101 Data Scaling
107 Model Evaluation Metrics
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
VIII AI Tools for Modern Data Analytics
ChatGPT, GitHub Copilot, Python AI Libraries
Tool
112 AI in Modern Data Analytics
113 Generative AI for Data Analysis(ChatGPT)
114 Prompt-Based Data Insights(GitHub Copilot)
115 AI-Assisted Python Coding
116 Automated Data Visualization
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
117 AI-Generated Data Summaries
118 AI-Driven Insight Generation
119 Building Smart Data Reports
IX Business Analytics and Case Studies
Tools Excel, SQL, Python
120 KPI and Business Metrics
121 Business Problem Solving with Data
122 Sales Analytics
123 Marketing Analytics
124 Finance Analytics
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
125 Customer Analytics
126 Product Analytics
X Capstone Project
Tools Python, Pandas, Scikit-learn, Excel, SQL
127 Project Planning and Problem Definition
128 Data Collection and Data Cleaning
129 Exploratory Data Analysis
130 Predictive Model Development
131 Visualization and Dashboard Creation
132 AI-Generated Insight Report
DATA ANALYTICS USING PYTHON-DAYWISE SYLLABUS
Duration-200 Hours
133 Project Presentation