ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
STUDY PLAN
2
3
DA Batch 25 ( 9 Hrs )Soft SkillsAptitudeGen AI
4
Live Class - Saturday ( 7:00 PM to 10:00 PM )
5
Live Class - Sunday ( 7:00 PM to 10:00 PM )
6
Doubt Discussion Session + Focus - Tue ( 7:-00 PM to 10:00 PM )
7
8
WeekDateDateSession TypeSessionDuration(hrs)Session TitleSession Topics
9
Week 019-September-2026SatFounder's Session
10
20-September-2026SunOrientation SessionLMS Walkthrough
11
26-September-2026SatLive SessionSession 13Introduction to Data Analysis with Excel
Excel Functions (Basic to Intermediate)		Text: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, CONCAT, TEXTJOIN
Sorting & Filtering data Logical: IF, IFS, AND, OR, NOT
Date: TODAY, NOW, DATE, EDATE, DATEDIF, NETWORKDAYS Math/Stat: SUM, AVERAGE, COUNT, COUNTA, ROUND, INT, MOD		Module 1 : Excel : Session 1
12
27-September-2026SunLive SessionSession 23Lookups and Pivot TablesVLOOKUP, HLOOKUP, Xlookup - their comparisons
Creating Pivot Tables from structured data
Row, Column, Filter, Values fields Summarization techniques (Sum, Count, Average)
Grouping (dates, numbers) Sorting and filtering in Pivots Drill-down features		Module 1 : Excel : Session 2
13
29-September-2026TueDC + FocusPractice Set/assignment for supporting Mini Project3Module 1 : Excel : Session 3 ( Doubts Session + FOCUS )
14
Module 2 : SQL ( 33 Hr)
15
WeekSession TypeSessionDuration(hrs)Session TitleSession Topics
16
3-October-2026SatLive SessionSession 33Corss Sheet Lookups - Data Cleaning TechniquesCombining XLOOKUP with Pivot Table summaries
Building cross-sheet dynamic reports		Module 1 : Excel : Session 4
17
1Adda247 APP
18
Using XLOOKUP inside calculated fields
Identifying and removing duplicates Detecting and handling blanks, nulls TRIM, CLEAN, SUBSTITUTE for cleanup Data validation for drop-downs and checks
Text to Columns, Flash Fill
19
4-October-2026SunLive SessionSession 43End To End Excel Project - Dashboard BuildingEnd to End Excel Project - End-to-end project:
Clean raw data Apply transformations
Use lookups Summarize using Pivots
Linking Pivot Charts to Pivot Tables Using Slicers and Timelines, KPI Cards Present with dashboard		Module 1 : Excel : Session 5
20
6-October-2026TueDC + FocusPractice Set/assignment for supporting Mini Project3Module 1 : Excel : Session 6 ( Doubts Session + FOCUS )
21
10-October-2026SatLive SessionMini Project Discussion3Mini Project DiscussionMini Project DiscussionModule 1 : Excel : Session 7
22
Week 411-October-2026SunLive SessionSession 13DBMS ConceptsIntroduction to SQL for Data Analytics SQL Language Categories: DDL, DML, DCL, TCL
Common SQL syntax and structure Creating a database
Creating tables with CREATE TABLE Altering tables using ALTER TABLE Dropping and renaming columns		Module 2 : SQL : Session 8
23
13-October-2026TueDC + FocusDoubt Clarification about Prompt Exercises, One small project Hands on with trainer on Gen AI + Excel (Ideally GPT/Copilot)" + Mini Project Submission3Module 2 : SQL : Session 9 ( Doubts Session + FOCUS )
24
17-October-2026SatLive SessionSession 23Constraints in SQL Dropping, Truncating & Modifying
Tables		NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK
Default values and AUTO_INCREMENT Column-level vs table-level constraint declaration
Modifying constraints Difference between DROP, TRUNCATE,
DELETE
Impact on storage, rollback, and auto-increment counters
Modifying column names, data types Adding/removing columns using ALTER TABLE
Renaming tables
INSERT single and multiple records		Module 2 : SQL : Session 10
25
18-October-2026SunLive SessionSession 33Aggregation and Group bySELECT basics with column filtering WHERE clause and logical operatorsModule 2 : SQL : Session 11
26
27
28
UPDATE and DELETE commands Using DISTINCT, ORDER BY, LIMIT,
Group by
Aggregate functions: COUNT, SUM, AVG, MIN, MAX
GROUP BY and HAVING
29
20-October-2026TueDC + Focus3SQL Lab/Excel LabModule 2 : SQL : Session 12 ( Doubts Session + FOCUS )
30
Week 524-October-2026SatLive SessionSession 43SQL JoinsINNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
Self JOIN, CROSS JOIN
Understanding primary-foreign key relationships
Joining more than two tables NULL handling in joins
Windows Functions - row_number(), rank(), dense_rank(), lag(), lead()
31
27-October-2026TueDC + Focus3
32
Week 631-October-2026SatLive SessionSession 53Windows Functions, Views and Import/Export of DataWindows Functions - row_number(), rank(), dense_rank(), lag(), lead() Views: creation, use cases, and limitations
Connecting SQL databases to Excel / Python / Power BI
Running SQL queries from external tools Exporting and importing data via CSV
33
1-November-2026SunLive SessionSession 63Subqueries,CTEs and EDANested queries and subqueries CASE statements
Common Table Expressions(CTEs) Using simple dashboards to display query results
Use case: exploratory data analysis with SQL
34
3-November-2026TueDC + FocusDC + SQL Scriptwriting Practice3SQL Script Writing Practice Session
35
Week 77-November-2026SatGen AI MasterclassMC 23MC-2: NL-to-SQL + Query Optimization with AIIndustry context and SQL interview expectations
Natural language to structured SQL translation
Identifying joins, filters, aggregations from business questions
Query optimization fundamentals and performance improvement
36
37
38
AI-assisted SQL drafting, refactoring, and validation
39
8-November-2026SunLive SessionMini Project Discussion3MINI PROJECT DISCUSSION
40
10-November-2026TueDC + FocusGen AI Practice + Doubt + Project submission3
41
42
WeekSession TypeSessionDuration(hrs)Session TitleSession Topics
43
Week 814-November-2026SatRecorded SessionsRec- Session 51.5PrerequisiteVideo 1: Intro to Statistics Topics:
What is statistics: Descriptive vs Inferential
Video 2: Types of Data Topics:
Types of data: Qualitative vs Quantitative
Video 3: Scales of measurement Topics:
Scales of measurement: Nominal, Ordinal, Interval, Ratio Population vs Sample
Video 4: Sampling methods Topics:
Sampling methods: Random, Stratified, Cluster, Systematic
Video 5: Data sources Topics:
Surveys, Experiments, Observational studies
Video 6: Biases in data collection
44
Week 815-November-2026SunLive SessionSession 13Measures of Central Tendency and Measures of Dispersion
(using Excel ideally with business problems)		Mean (Arithmetic, Weighted) Median
Mode
When to use which measure Impact of outliers on central tendency Practice with real datasets (e.g., salary,
sales)
Range
Variance & Standard Deviation (sample vs population)
Mean Absolute Deviation Coefficient of Variation
Use of dispersion in comparing datasets
45
21-November-2026SatLive SessionSession 23Descriptive Statistics & Forecasting in Excel (Analysis ToolPak Applications)Using Analysis ToolPak for summary statistics & regression output
46
Data distribution analysis (Histogram & normality check)
Time series forecasting using Excel Forecast tools
Business interpretation of statistical outputs
47
24-November-2026TueDC + Focus3
48
49
50
WeekSession TypeSessionDuration(hrs)Session TitleSession Topics
51
Week 1028-November-2026SatRecorded SessionsRec- Session 61.5PrerequisiteVideo 1: Definition of Business Intelligence
Topics:
Definition of Business Intelligence and its industry applications
Video 2: Types of BI tools Topics:
Types of BI tools and landscape overview
Video 3: Installing Power BI Desktop Video 4: Overview of Power BI interface
Topics:
Overview of Power BI interface: ribbons, panes, canvas
Video 5: Workflow overview Topics:
Workflow overview: data, model, report views
Video 6: PowerBI with Excel Connecting to Excel, CSV, Web, and SQL sources
Import vs Direct Query vs Live connection
52
29-November-2026SunLive SessionSession 13Power Query EditorNavigating the Power Query Editor Transforming data types, trimming, replacing, splitting
Steps applied, query folding and refresh Understanding measures vs dimensions Discrete vs continuous fields
Data shaping: renaming, removing, pivoting, unpivoting columns Transforming data types, trimming,
replacing, splitting
53
Creating relationships, understanding cardinality and cross-filter direction
54
5-December-2026SatLive SessionSession 23DAX Fundamentals, DAX modelling and DAX OperationsStar vs Snowflake schema Role of fact and dimension tables
Introduction to DAX: syntax and use cases
Calculated columns vs measures Basic DAX functions: SUM, AVERAGE, COUNT, DISTINCTCOUNT
Working with filters in DAX: CALCULATE, FILTER, ALL
Logical and text functions in DAX
Conditional expressions using IF and SWITCH
55
8-December-2026TueDC + Focus3
56
Week 1112-December-2026SatLive SessionSession 33DAX Operations Visualizations & InteractionsRow context vs filter context explained Error handling and debugging DAX expressions
Using core visuals: bar, line, pie, scatter, table, matrix
Customizing visuals: formatting, themes, tooltips
Setting up slicers and filters
Drill-through and drill-down navigation
Cross-highlighting and interactivity between visuals
57
13-December-2026SunLive SessionSession 43Advanced Measures & Time Intelligence Reports, Bookmarks, Tooltips & Navigation,Cumulative totals and running totals YOY, MOM comparisons DATEADD, DATESYTD, SAMEPERIODLASTYEAR
Using CALCULATE with time intelligence Date table creation and relationships Creating multi-page reports
Adding bookmarks for storytelling and dynamic views
Using buttons and images for navigation. Custom tooltips and drill-through pages Setting up page navigation and back buttons
58
15-December-2026TueDC + Focus3
59
Week 1219-December-2026SatLive SessionMini Project Discussion3Mini Project Discussion Publishing, Sharing & DeploymentPublishing reports to Power BI Service Creating and managing workspaces Setting refresh schedules and gateway setup
Sharing reports with stakeholders Row-level security and access control
basics		Mini Project Lab
60
20-December-2026SunGen AI MasterclassMC 33MC-3: AI-Enhanced Dashboarding + Automated InsightsUsing AI to design KPI-driven dashboards
Generating DAX measures with AI support
Automating insight summaries from visuals
Identifying trends and anomalies using AI
Improving dashboard storytelling and clarity
61
22-December-2026TueDC + FocusGenai + Doubts3
62
SatRec- Session 61Introduction to TableauIntroduction to Tableau, Installation & Interface Navigation Connecting to Data Sources Building Basic Charts
63
SunRec- Session 71Basic & Advanced Charts & HighlightingBuilding Basic Charts Advanced Chart Types and Highlighting
Techniques
64
SatRec - Session 81Maps, Time Series, DashboardsGeospatial Charts and Time-Series Visuals
Dashboards, Filters and User Interactivity
65
TueRec - Session 91Filters, Joins, Blends, CalculationsFiltering Logic, Joins, Blends and CalculationsNeed to give small dashboard as AssignmentTwo Dashboards in Class + One as Assignmnet (Non Graded)
66
Module 5 : Python (42 hours)
67
WeekSession TypeSessionDuration(hrs)Session TitleSession Topics
68
SatRecorded SessionsRec- Session 61.5PrerequisiteVideo 1: Intro to Programming Languages and Python
Topics:
Definition of Programming Languages Why we need Programming Languages Introduction to Python
Python Syntax Data Types Variables
Video 2: Type Casting, Conversion and I/O Functions		Video 1 - Intro to Python, Datatypes, Variables, Typecasting, input function Video 2 - Fstring, Inbuilt Python Functions, List Functions
69
Topics:
How Python is different from other languages (Dynamically Typed) Type Casting and Type Conversion
Implicit and Explicit Type Conversion Input and Output Functions Overview of Concatenation
Video 3: F-Strings Method (Part 1 & Part 2)
Topics: Introduction to F-Strings
F-Strings Syntax and Examples String Formatting using F-Strings
Video 4: Deep Dive into F-Strings and Code Structure
Topics: Advanced F-String Usage
Creating a Calculator using Python Indentation in Python
Block of Code Concept
Video 5: Inbuilt Functions, Lists and List Functions
Topics:
Common Inbuilt Functions (len, max, min, sum, sorted, round, abs) Introduction to Lists
List Functions (append, extend, insert, remove, pop)
70
Week 1327-December-2026SunLive SessionSession 13Python Intro & Control StructuresIntro to Python Coding Environment with Jupyter Notebooks
How to write effective code in Python if, elif, else statements
Nested conditions
71
2-January-2027SatLive SessionSession 23Python Intro & Control Structures Part 2for loops with range()
while loops and loop control: break, continue, pass
else clause with loops
72
5-January-2027TueDC + Focus3
73
SatRecorded SessionsRec- Session 61.5PrerequisiteVideo 1: File Handling & Types of Files in Python
Topics:
Introduction to File Handling in Python Types of Files (.txt, .csv, .json)
File Modes Read Method Write Method		Video 3 - File Handling Video 4 - Exception Handling
Video 5 - Inbuilt Modules in Python
74
8Adda247 APP
75
Append Method
Video 2: CSV & JSON File Handling
Topics: Working with CSV Files
CSV Functions (writer, writerow, reader)
Working with JSON Files
JSON Functions (dump, load, append)
Video 3: Exception & Error Handling in Python
Topics:
What is Exception Handling Importance of Exception Handling Try Block
Except Block Else Block Finally Block
Types of Errors and Exceptions ValueError
FileNotFoundError Other Common Exceptions
Video 4: Python Inbuilt Modules & Module Functions
Topics: Introduction to Python Modules
Math Module (sqrt, pow, pi, factorial) Random Module (random, randint, uniform, sample, randrange) Datetime Module (now, today, now().date, now().time)
Timezone Module Overview Using dir() Function to Explore Module
Functions
76
Week 1410-January-2027SunLive SessionSession 33Data Structures in PythonCreating, accessing, slicing lists List comprehension
Tuples: declaration, immutability, use cases
Tuple unpacking and zip() basics string methods and tuple methods Creating sets, uniqueness
in keyword and set membership add(), remove(), discard() Use cases in de-duplication
77
16-January-2027Live SessionSession 43Data Structures in Python Part 2Set operations: union(), intersection(), difference(), symmetric_difference() Creating and accessing key-value pairs get(), items(), keys(), values()
Updating and deleting entries in operator, nested dictionaries
Dictionary comprehension (basic intro)
78
79
80
12-January-2027TueDC + Focus3
81
Week 1516-January-2027SatLive SessionSession 53Data Manipulation with Numpy ArraysWhat is NumPy & why use it Creating arrays: array(), zeros(), ones(),
arange(), linspace()
Array properties: shape, ndim, dtype Basic element-wise operations: +, -, *, /
Aggregation: sum(), mean(), std() Creating Series from lists, dictionaries Indexing, slicing, vector-style operations
82
17-January-2027SunLive SessionSession 63Creating and Accessing DataFrame using PandasCreating DataFrames from dict, list of dicts, CSV
head(), tail(), info(), describe() Selecting data: loc[], iloc[] Adding/removing columns Filtering rows with conditions
Renaming columns, updating values Sorting by column(s)
Handling missing data: isnull(), dropna(), fillna()
83
19-January-2027TueDC + Focus3
84
Week 1623-January-2027SatLive SessionSession 73Pandas Groupby and Sortinggroupby() with mean(), sum(), count() Using agg() for multi-aggregation Multi-index results
Pivot tables with pivot_table() Merging/joining DataFrames
Load & explore dataset
Clean missing and inconsistent data Derive new columns
Use groupby(), filtering, sorting Visualize insights using Pandas .plot() Save cleaned & visualized outputs
85
24-January-2027SunLive SessionSession 83Plotting with MatplotlibLine plot, bar chart, histogram, pie chart using Pandas .plot()
Customizing plots: labels, titles, colors Plotting directly from groupby results Intro to matplotlib.pyplot: plot(), bar(), scatter()
Styling and subplot basics
86
26-January-2027TueDC + Focus3
87
Week 1730-January-2027SatLive SessionMini Project Discussion3EDA with Pandas + Numpy +SeabornVisualization using Seaborn library, variety of charts.
Lambda Functions
User Dedfined Functions
88
Reshaping Data Date and Time Handling
Exporting Data EDA Project
89
31-January-2027SunGen AI MasterclassMC 43MC-4 : AI-Assisted Python Code Generation & DebuggingWriting Python scripts using AI assistance
Debugging errors with structured AI prompts
Optimizing data manipulation logic (Pandas/Numpy)
Improving code readability and documentation
Validating AI-generated code outputs		Using Google Collab and with Genai integration
90
2-February-2027TueDC + Focus3
91
Module 6
:Statistics and EDA - 2 (24 hr)
92
WeekSession TypeSessionDuration(hrs)Session TitleSession Topics
93
Week 186-February-2027SatLive SessionSession 13Percentiles, Quartiles, and IQR Univariate AnalysisPercentiles and interpretation (e.g., 90th percentile)
Quartiles: Q1, Q2 (median), Q3 Interquartile Range (IQR) Box plot interpretation Outlier detection using IQR
Histogram, Bar chart, Pie chart Frequency distribution tables
KDE (Kernel Density Estimation) plot
94
7-February-2027SunLive SessionSession 23Understanding Patterns and Relationship using Univariate,Bivariate, Multivariate AnalysisBasic Bivariate analysis Bivariate Analysis Implementation Pearson's correlation & covariance
Rank Correlation Correlation & Causation
95
9-February-2027TueDC + Focus3
96
Week 1913-February-2027SatLive SessionSession 33Probability & DistributionsBasics of probability: Classical, Empirical Complementary, Joint, and Conditional probability
Discrete distributions: Binomial Continuous distributions: Normal distribution
Central Limit Theorem (basic concept)
97
14-February-2027SunLive SessionSession 43Hypothesis Testing – FoundationsPopulation vs sample recap
98
Concept of hypothesis: Null vs Alternative
One-tailed vs Two-tailed test Type I and Type II errors
p-value concept Confidence Intervals (basic interpretation)
t-test: One-sample, Two-sample Z-test basics
Chi-square test (intro) for independence Hands-on: Interpret test results using Python/Excel output
Decision-making from statistical tests
99
16-February-2027TueDC + Focus3
100
Week 2020-February-2027SatGen AI MasterclassMC 53AI-Powered EDA & Statistical StorytellingAI-assisted exploratory data analysis (EDA)
Generating summary statistics and visual insights
Identifying patterns, correlations, and anomalies
Automating statistical interpretation
Converting analysis into structured data stories