=====================================
DAY 1 – Introduction to Data Analytics
=====================================
THEORY :
• What is Data Analytics? Real-world examples
• Who is a Data Analyst? Required skills
• Types of Data (Structured, Unstructured, Semi-Structured)
• 5 Stages of Data Analysis
1. Understanding business problem
2. Data collection
3. Data cleaning
4. Data analysis
5. Reporting insights
• Industries using analytics
PRACTICAL :
• Explore 3 sample datasets (Excel or CSV)
• Identify column types
• Check missing values
• Identify data quality issues
• Write problem statements for each dataset
ASSESSMENT (2 Hours)
• Write a summary explaining:
1. What is analytics?
2. Where can it be applied?
• Submit dataset exploration notes
Reference Video : What Is Data Analytics? - An Introduction (Full Guide)
=====================================
DAY 2 – Statistics Basics
=====================================
THEORY :
• Data types: Numerical, Categorical
• Central tendency: Mean, Median, Mode
• Dispersion: Variance, Standard Deviation
• How these metrics help in analytics
PRACTICAL (3 Hours)
• Use Excel to calculate mean, median, mode
• Calculate SD, Variance for sample datasets
• Compare datasets based on spread
ASSESSMENT (2 Hours)
• Solve 25 statistical problems
• Submit Excel workbook
Ref Video : Descriptive Statistics: FULL Tutorial - Mean, Median, Mode, Variance & SD
=====================================
DAY 3 – Probability
=====================================
THEORY
• Probability Rules
• Conditional Probability
• Events: Independent, Dependent
• Distributions: Normal, Uniform
PRACTICAL (3 Hours)
• Create probability scenarios
• Plot Normal Distribution using Excel
• Use [Link] function
ASSESSMENT
• Solve 12 probability-based business questions
Ref video : Basic probability: Joint, marginal and conditional probability | Independence
Introduction to Probability Distributions
=====================================
DAY 4 – Percentiles & Outliers
=====================================
THEORY
• Percentiles & Quartiles
• Interquartile Range (IQR)
• Outlier detection rules
• Boxplot interpretation
PRACTICAL
• Calculate percentiles in Excel
• Identify outliers using IQR
• Remove extreme values
ASSESSMENT
• Clean a dataset using outlier detection
Ref Vid – Calculate The Interquartile Range In Excel
Box Plots Explained [Interquartile Range and Outliers]
=====================================
DAY 5 – Mathematics for Analysts
=====================================
THEORY
• Business math basics
• Weighted average with examples
• Cumulative sum, growth %
• Real-world business KPIs
PRACTICAL
• Calculate moving averages
• Compute MoM and YoY growth
• Calculate weighted ratings
ASSESSMENT
• Solve 10 business math case studies
Ref Vid : Business Math & Statistics Using Excel For Data Analysts
=====================================
DAY 6 – SQL Basics (8 Hours)
=====================================
Ref Vid full SQL Module - Complete SQL Course
Full SQL Tutorial
THEORY
• Installing SQL
• SQL Data Types
• CREATE TABLE
• INSERT, UPDATE, DELETE
PRACTICAL
• Create tables: Customers, Orders
• Insert 50 sample records
• Write cleanup queries
ASSESSMENT
• Submit SQL file + screenshots
=====================================
DAY 7 – SQL SELECT & Filtering (8 Hours)
=====================================
THEORY
• SELECT
• WHERE conditions
• LIKE patterns
• ORDER BY, LIMIT
PRACTICAL
• Write 30 filtering queries
• Case-insensitive searches
• Range filtering
ASSESSMENT (2 Hours)
• Solve 10 HackerRank SQL easy problems
=====================================
DAY 8 – SQL Aggregations
=====================================
THEORY
• SUM, AVG, COUNT
• GROUP BY
• HAVING
• Real KPI examples
PRACTICAL
• Create sales summary tables
• Find top-selling products
• Monthly revenue breakdown
ASSESSMENT
• Build KPI report using SQL
=====================================
DAY 9 – SQL Joins (8 Hours)
=====================================
THEORY
• INNER JOIN
• LEFT, RIGHT, FULL JOIN
• SELF JOIN
• Join performance tips
PRACTICAL (3 Hours)
• Create 10 multi-table join queries
• Customer-order-product linked analysis
ASSESSMENT (2 Hours)
• Solve medium join problems
=====================================
DAY 10 – Advanced SQL (8 Hours)
=====================================
THEORY
• Subqueries in SELECT/WHERE
• CTE syntax
• CASE WHEN
• DATE functions
PRACTICAL
• Build multi-layer queries
• Create segmented customer lists
ASSESSMENT
• SQL business case report
=====================================
DAY 11 – Window Functions
=====================================
THEORY
• OVER() clause
• ROW_NUMBER, RANK, DENSE_RANK
• PARTITION BY use cases
PRACTICAL
• Rank customers by spending
• Rank employees by performance
ASSESSMENT - Solve 8 window function queries
=====================================
DAY 12 – Window Functions 2
=====================================
THEORY
• LEAD() / LAG()
• NTILE()
• Cumulative totals
• Moving averages
PRACTICAL
• YoY & MoM analysis in SQL
• Trend analysis
ASSESSMENT
• Write 10 analytical window queries
Ref Vid - SQL Window Function | How to write SQL Query using RANK..
Calculating MOVING AVERAGE using WINDOW function in SQL
=====================================
DAY 13 – SQL Practice Marathon (8 Hours)
=====================================
PRACTICAL
• Solve 30 SQL questions (med-hard)
• Platforms: LeetCode, DataLemur, HackerRank
ASSESSMENT (2 Hours)
• Mock SQL Interview
=====================================
DAY 14 – SQL Project
=====================================
PRACTICAL (6 Hours)
• Build an end-to-end SQL mini project
• Create schema
• Write analytical SQL queries
ASSESSMENT (2 Hours)
• Submit project documentation
=====================================
DAY 15 – Excel Cleaning
=====================================
Ref Vid – Excel Full Course for Data Analysis
Excel Tutorial from Basic to Advanced for Data Analyst
THEORY
• Data validation
• Text-to-columns
• Cleaning techniques
PRACTICAL
• Clean 3 raw datasets
• Submit cleaned files
Ref Vid –
=====================================
DAY 16 – Excel Formulas 1
=====================================
THEORY
• SUM, COUNT, IF
• Logical functions
PRACTICAL
• Solve 30 formula tasks
ASSESSMENT
• Create decision Sheet
=====================================
DAY 17 – Excel Formulas 2
=====================================
THEORY
• VLOOKUP, XLOOKUP
• INDEX-MATCH
• SUMIFS, COUNTIFS
PRACTICAL
• Lookup operations
ASSESSMENT
• Create multi-sheet lookup model
=====================================
DAY 18 – Pivot Tables
=====================================
THEORY (2 Hours)
• Pivot tables
• Pivot charts
• Slicers
PRACTICAL (4 Hours)
• Build 5 pivot reports
ASSESSMENT (2 Hours)
• Submit pivot dashboard
=====================================
DAY 19 – What-If Analysis
=====================================
THEORY
• Goal seek
• Solver
• Scenarios
PRACTICAL
• Build pricing model
ASSESSMENT
• Submit 2 what-if cases
Ref Vid - Microsoft Excel (Goal Seek, Scenarios, Solver)
=====================================
DAY 20 – Excel Dashboard Project
=====================================
PRACTICAL
• End-to-end Excel dashboard
ASSESSMENT
• Upload dashboard file
=====================================
DAY 21 – Python Basic
=====================================
Ref Vid - Python Tutorials
EDA
Python Libraries Guide
THEORY
• Installing Python & IDE (VS Code / PyCharm / Jupyter)
• Understanding Syntax
• Variables and Data Types (int, float, str, bool)
• Input/Output functions
• Type conversion
• Comments & coding standards
PRACTICAL (3 Hours)
Write programs for:
• User input
• Type conversions
• Basic arithmetic
• Create 10 small Python scripts
• Print formatted output
ASSESSMENT (2 Hours)
Write a program to:
• Take user input
• Convert values
• Perform basic operations
• Submit 10 solved beginner exercises
=====================================
DAY 22 – Python Control Statement
=====================================
THEORY (3 Hours)
• If-else statements
• Nested if
• For loops
• While loops
• Break, continue, pass
• Flow control diagrams
PRACTICAL (3 Hours)
• Write programs for:
• Number patterns
• Condition-based calculators
• Loops with lists
• Solve 15 loop-based problems
ASSESSMENT (2 Hours)
• Solve a mini test:
• 10 loop-based coding questions
• Submit .py or file
=====================================
DAY 23 – Python Data Structures
=====================================
THEORY (3 Hours)
• Lists – indexing, slicing, CRUD operations
• Dictionaries – key/value operations
• Sets – uniqueness, set operations
• Tuples – immutability
• List comprehension
• Dictionary comprehension
PRACTICAL (3 Hours)
• Create 5 programs using list & dict
• Manage inventory system using dictionary
• Perform set math operations
• Tuple unpacking tasks
ASSESSMENT (2 Hours)
Build a Python script for:
Simple student record using lists & dictionaries
--------------------------------------------------
DAY 24 – Functions & Error Handling
--------------------------------------------------
THEORY
• Defining functions
• Return values
• Lambda functions
• Try-except blocks
• Raising custom errors
• Importing modules
PRACTICAL
• Create 10 custom functions
• Error-handling based tasks
• Build function-based calculator
• Use math & random modules
ASSESSMENT
• Submit a Python script that:
- Contains functions
- Uses exception handling
--------------------------------------------------
DAY 25 – Python Coding Assessment Day
--------------------------------------------------
THEORY
• How to think algorithmically
• How to break down complex problems
PRACTICAL
• Solve 20 Python coding interview questions
• Practice on loops, lists, strings, dictionaries
ASSESSMENT
• Solve a 15-question Python Test
• Submit `.py` + written explanation
--------------------------------------------------
DAY 26 – NumPy Basics
--------------------------------------------------
THEORY
• Introduction to NumPy
• ndarray vs list
• Creating arrays (zeros, ones, arange, linspace)
• Indexing & slicing
• Array attributes (shape, size, ndim)
PRACTICAL (3 Hours)
• Create different NumPy arrays
• Slice rows & columns
• Reshape arrays
• Combine & split arrays
ASSESSMENT
• Submit 20 NumPy coding exercises
--------------------------------------------------
DAY 27 – NumPy Operations & Statistics
--------------------------------------------------
THEORY
• Vectorized operations
• Broadcasting
• Arithmetic operations
• Mathematical functions
• Statistical operations: mean, median, std
• Dot product, matrix operations
PRACTICAL
• Perform matrix multiplication
• Calculate summary stats
• Perform transformations
ASSESSMENT
• Build a NumPy-based statistical report
--------------------------------------------------
DAY 28 – Pandas Introduction
--------------------------------------------------
THEORY
• Series, DataFrame structures
• Reading CSV, Excel, JSON
• Head, tail, describe
• DataFrame info & datatypes
PRACTICAL
• Import 3 datasets
• Explore all columns
• Perform simple filtering
ASSESSMENT
• Submit EDA summary (10–15 insights)
--------------------------------------------------
DAY 29 – Pandas Data Cleaning
--------------------------------------------------
THEORY
• Handling missing values
• Removing duplicates
• Renaming columns
• Changing datatypes
• String cleaning
• Apply, map, replace
PRACTICAL
• Clean 2 raw datasets
• Fix date formats
• Remove unwanted characters
ASSESSMENT
• Submit cleaned dataset + notes
--------------------------------------------------
DAY 30 – Pandas Data Manipulation
--------------------------------------------------
THEORY
• Filtering
• Selecting rows/columns
• GroupBy
• Aggregations
• Merging & joining
• Pivot tables
• Sorting
PRACTICAL
• Create 20 groupby tasks
• Combine datasets
• Build pivot summaries
ASSESSMENT
• Submit a Pandas Analysis Report
--------------------------------------------------
DAY 31 – Python Data Visualization
--------------------------------------------------
THEORY
• Matplotlib basics
• Line, bar, scatter, pie charts
• Seaborn: boxplot, heatmap
• Chart styling & customization
PRACTICAL
• Plot 10 different charts
• Create trend analysis
• Build correlation heatmap
ASSESSMENT
• Submit a visualization report (PNG images + code)
--------------------------------------------------
DAY 32 – Python Case Studies
--------------------------------------------------
THEORY
• Understanding business analytics cases
• Identifying KPIs
PRACTICAL (5 Hours)
Complete 2 case studies:
✔ Sales data analysis
✔ Retail customer segmentation
✔ HR attrition analysis (choose any two)
ASSESSMENT (2 Hours)
• Create PPT explaining insights
--------------------------------------------------
DAY 33 – Power BI Introduction
--------------------------------------------------
Ref Vid - Powerbi Full Tutorial
Power BI DAX Tutorial | How to use DAX functions with Examples
THEORY
• What is BI?
• Power BI interface
• Importing data
• Relationships
• Visual basics
PRACTICAL (3 Hours)
• Load sample dataset
• Build first report page
• Add visuals + formatting
ASSESSMENT
• Submit basic Power BI report with 5 visuals
--------------------------------------------------
DAY 34 – Power Query
--------------------------------------------------
Ref Vid - Power Query Tutorial for Power BI Desktop
THEORY
• Data cleaning workflow
• Split, merge, append
• Replace values
• Unpivot & pivot columns
PRACTICAL
• Clean dataset end-to-end
• Create correct relationships
ASSESSMENT
• Export M Queries + submit file
--------------------------------------------------
DAY 35 – DAX Basics
--------------------------------------------------
THEORY
• Measures vs Columns
• SUM, COUNT, DISTINCTCOUNT
• CALCULATE()
• FILTER()
• Time intelligence basics
PRACTICAL
• Create KPIs:
- Revenue
- Profit
- YoY growth
ASSESSMENT
• Write 10 DAX measures for a business case
--------------------------------------------------
DAY 36 – Dashboard Design & Storytelling
--------------------------------------------------
THEORY
• Choosing right visuals
• Layout design
• Color theory
• Adding drill-through
• Bookmarks
PRACTICAL
• Build a fully interactive dashboard
ASSESSMENT
• Submit Power BI dashboard + insights
--------------------------------------------------
DAY 37 – End-to-End Power BI Project
--------------------------------------------------
PRACTICAL
• Clean → Model → Visualize → Publish
• Add advanced KPIs
• Build storytelling report
ASSESSMENT
• Submit final PBIX + PDF summary
--------------------------------------------------
DAY 38 – SQL + Power BI Integrated Project
--------------------------------------------------
THEORY
• DirectQuery vs Import
• SQL views for BI
• Data model optimization
PRACTICAL (4 Hours)
• Run SQL queries
• Import into Power BI
• Create SQL-powered visuals
ASSESSMENT
• Submit SQL + BI combined analysis
--------------------------------------------------
DAY 39 – Tableau Basics (Optional Day)
--------------------------------------------------
Ref Vid - Tableau Full Tutorial
THEORY
• Tableau interface
• Sheets, dashboards, stories
PRACTICAL
• Create visuals
• Build a mini dashboard
ASSESSMENT
• Submit Tableau dashboard
--------------------------------------------------
DAY 40 – Python + SQL + Power BI Combined Pipeline
--------------------------------------------------
THEORY
• Real-world data flow
• ETL concepts
PRACTICAL
• Clean in Python
• Process in SQL
• Visualize in Power BI
ASSESSMENT
• Submit end-to-end workflow
--------------------------------------------------
DAY 41 – Final Project Planning
--------------------------------------------------
THEORY
• Understanding requirements
• KPI selection
PRACTICAL
Choose 1 project:
✔ Sales Dashboard
✔ HR Analytics
✔ E-commerce Insights
✔ Finance Dashboard
ASSESSMENT
• Submit project proposal
--------------------------------------------------
DAY 42 – Final Project Development
--------------------------------------------------
PRACTICAL
• Data cleaning
• SQL analysis
• Python/Pandas analysis
ASSESSMENT
• Submit mid-project review
--------------------------------------------------
DAY 43 – Final Dashboard & Insights
--------------------------------------------------
PRACTICAL
• Build dashboard
• Add KPIs
• Write insights
ASSESSMENT
• Submit final project dashboard
--------------------------------------------------
DAY 44 - 45 Revision
--------------------------------------------------
• 30 SQL, 20 Python, 20 Excel questions
• Dashboard explanation practice
• Final Theory + Practical Test
• Training Completion Evaluation