Week Major Topic Day Course Objective Topic Lesson Plan (What Trainer Covers) Learning Outcomes Data
Lesson Plan (What Trainer Covers) Learning Outcomes Data Analytics Example
Understand continuous
Prepare learners psychologically+ Motivation, Career Learning curve in analytics, Skill–Passion–Market demand learning importance, Identify
Mon Choosing Data Analyst vs BI Analyst
Preparing learners for their career Alignment mapping, personal analytics career
path
What is Data Analytics,
Concept clarity, Career
Analyst Roles, Sales trend analysis, Reporting vs
Course overview & Data Analytics Types of analytics, Data Analyst vs Data Scientist vs BI, Problem → understanding, Structured
Professional Tue Analytics Lifecycle, prediction, Customer churn study, Excel
Fundamentals Data → Insight, Structured/unstructured, Retail, Finance thinking, Data awareness,
Foundation + Data Types, Use vs social media data, Fraud detection
1 Business thinking
Agile + Career Cases
Readiness Personal
Learning SQL errors improves query
Wed Professional discipline Effectiveness, Job Fixed vs Growth mindset, Proactive work, goal setting Time & task prioritization
accuracy
Strategy
Upload Power BI dashboards,
Thu Employability LinkedIn Optimization Profile headline, analytics keywords, portfolio, Resume basics Build recruiter-ready profile
Managing dashboard deadlines
Tech Industry work
Fri Industry awareness Project Management - Agile overview Understand Agile workflow Data sprint planning
Culture
Mon Environment familiarity Linux File system, commands (ls, cd, grep) Navigate data files Access log datasets
Version control
Tue Collaboration Git Clone, commit, push Updating analysis scripts
Industry Tools understanding
2
for Analysts Wed DevOps awareness Jenkins Automation basics Know CI/CD concept Automated data pipeline
Thu Agile workflow Jira Epics, Stories, Tasks Track analytics tasks Dashboard ticket workflow
Fri Process understanding SDLC & Bug Lifecycle Requirement → Testing → Deployment Identify project stages Fix incorrect KPI calculation
Introduce learners to Excel as a
primary data analysis tool used in
Excel Interface, Data Organize datasets, Clean Sales dataset formatting
Mon business environments. Tables, formatting, Remove duplicates, TRIM
Cleaning raw data Customer list cleanup
Build skills in filtering, sorting, and
validating data for analysis.
Develop ability to organize, clean, and
structure datasets efficiently.
Basic Functions, Perform calculations, Monthly revenue
Tue Enable students to perform basic SUM, COUNT, AVERAGE, IF, AND, OR
Logical Functions Conditional analysis Profit/Loss classification
calculations using essential analytical
functions.
Excel for Data Prepare learners to conduct
3
Analytics (Core) Wed preliminary business analysis using Sorting & Filtering Custom filters Dataset exploration Region-wise sales filtering
spreadsheets.
Equip learners with advanced data
manipulation and lookup techniques. Lookup Functions VLOOKUP, XLOOKUP Data merging Match customer IDs
Thu
Develop analytical reporting skills INDEX + MATCH Advanced lookup Flexible querying Product lookup
using Pivot Tables and dashboards.
Enable automation of repetitive
analysis using advanced formulas.
Pivot Tables Aggregation & grouping Summarization skills Sales by region
Fri Teach creation of interactive reports
Conditional Formatting Trend highlighting Insight discovery Highlight low sales
using charts, slicers, and conditional
formatting.
Prepare students for real-world
Mon reporting and MIS analyst Dashboards Charts + slicers Build mini dashboards Executive sales dashboard
responsibilities.
• What is a Macro? • Why automation matters in Data Analytics • Understand how repetitive Example: Automating monthly sales
Understand the concept of automation
Introduction to Excel • Enabling Developer Tab • Recording a Macro data tasks can be automated report formatting (apply table style,
in Excel and how Macros help Data
Tue Macros & Macro • Assigning Macro to Button • Record and run simple currency format, bold headers, autofit
Analysts reduce repetitive manual
Recording • Saving as Macro-Enabled Workbook (.xlsm) macros • Save and manage columns in one click instead of manual
tasks.
• Running and Editing Recorded Macros macro-enabled files formatting each month)
Example: One-click “Monthly
• Looping through rows (For Each loop)
• Automate large dataset Dashboard Refresh” button that:
Apply Macros to automate analytical Advanced Macro • Automating Pivot Table refresh
processing • Build reusable 1. Cleans raw data
Wed workflows like report generation and Automation for • Creating dynamic reports
reporting tools • Create one- 2. Updates Pivot Tables
dashboard refresh. Analysts • Automating data cleaning (remove duplicates, trim spaces)
click report refresh systems 3. Refreshes charts
• Error handling basics • Assigning macros to dashboard buttons
4. Displays confirmation message
• What is Power Query? (ETL in Excel) • Import datasets into Excel
Advanced Understand how Power Query helps • Why Data Analysts use Power Query using Power Query • Example: Import raw monthly sales
Introduction to Power
4 Excel for Thu automate data cleaning and • Importing data from Excel, CSV Understand transformation CSV files and combine into one master
Query & Data Loading
Analysts preparation in Excel. • Understanding Query Editor interface • Applied Steps panel steps • Recognize ETL dataset automatically
• Data preview & transformation workflow workflow in analytics
Part 1 – Quick Recap (15 mins) • What are Macros? When to use
them?
• What is Power Query? ETL concept in Excel • Differentiate clearly
Use Case: Monthly Sales Reporting
• Difference: Automation (Macros) vs Data Transformation (Power between Macros and Power
Automation
Query) Query
Step 1: Power Query cleans raw sales
Reinforce automation and data Part 2 – Hands-on Revision (25 mins) • Reapply automation
files (remove duplicates, fix date format,
transformation concepts using Excel Revision of Excel • Re-record a macro for formatting & report standardization independently
aggregate sales).
Fri Macros and Power Query to improve Macros & Power Query • Review basic macro logic (Run & assign button) • Modify transformation logic
Step 2: Load clean dataset to Excel.
analytical efficiency and reporting for Data Analytics • Open existing Power Query → review applied steps confidently
Step 3: Macro auto-formats report
productivity. • Modify transformation step (e.g., add column, change data type) • Build semi-automated
(apply branding, pivot refresh, highlight
Part 3 – Integrated Use Case (15 mins) reporting workflow
KPIs). Result: One-click professional
• Use Power Query to clean dataset • Load cleaned data to sheet • Improve productivity
monthly dashboard generation.
• Run macro to auto-format dashboard mindset as Data Analyst
Part 4 – Discussion & Q&A (5 mins)
• When to use Macro vs Power Query in real job scenarios
Provide understanding of relational
Mon databases and structured data RDBMS Tables, keys Database understanding Customer table
storage.
Enable learners to retrieve, filter, and
Tue SELECT Queries WHERE, ORDER BY Retrieve data Filter top customers
aggregate data using SQL queries.
Develop skills in joining multiple
SQL for Data Wed Aggregation GROUP BY, HAVING Summarize data Sales per region
5 datasets for analysis.
Analysts
SQL for Data
Week5 Major Topic Day Course Objective Topic Lesson Plan (What Trainer Covers) Learning Outcomes Data Analytics Example
Analysts
Introduce advanced querying
Thu techniques including subqueries and Joins INNER, LEFT JOIN Combine datasets Orders + Customers
window functions.
Prepare students to work with
Fri enterprise databases for business Advanced SQL Subqueries, Window functions Advanced analytics Ranking products
analytics tasks.
Introduce programming fundamentals
Mon Python Intro Variables, types Coding basics Store sales values
required for data analytics.
Develop logical thinking using
Tue variables, conditions, loops, and Conditions if statements Decision logic Profit flag
functions.
Enable automation of repetitive data
6 Python Basics Wed Loops for loops Automation Process rows
processing tasks.
Teach handling of files and datasets
Thu Functions Modular coding Reusability Revenue calculator
programmatically.
Build foundation for advanced
Fri analytical programming using Python File Handling CSV reading Load datasets Import [Link]
libraries.
Enable learners to manipulate
Mon structured datasets using Pandas Python Intro Variables, types Coding basics Store sales values
DataFrames.
Develop skills in data cleaning,
Tue Conditions if statements Decision logic Profit flag
Python Data transformation, and preprocessing.
7 Analysis Teach aggregation, grouping, and
Wed Loops for loops Automation Process rows
(Pandas) merging of datasets.
Introduce numerical analysis using
Thu Functions Modular coding Reusability Revenue calculator
NumPy.
Prepare learners for real-world
Fri File Handling CSV reading Load datasets Import [Link]
exploratory and analytical workflows.
Introduce business intelligence
Mon concepts and data visualization Power BI Intro Interface Tool navigation Import Excel
principles.
Enable learners to connect Power BI
Tue Data Loading Connect sources Integration SQL connection
with multiple data sources.
Power BI Teach data modeling and relationship
8 Wed Modeling Relationships Data modeling Star schema
Fundamentals management.
Develop ability to create interactive
Thu Visualizations Charts Reporting KPI visuals
visual reports.
Build foundational dashboard
Fri development skills for business Filters Slicers Interactive dashboards Regional filtering
reporting.
Develop expertise in DAX calculations
Mon DAX Basics Measures Metrics creation Total sales
and advanced measures.
Teach time intelligence functions for
Tue Time Intelligence YTD, MTD Trend analysis Year comparison
business performance analysis.
Advanced Enable creation of professional, user-
9 Wed Dashboard Design UX principles Professional layout Executive dashboard
Power BI friendly dashboards.
Introduce report publishing and
Thu Publishing Power BI Service Sharing reports Cloud publish
collaboration using Power BI Service.
Prepare learners for enterprise-level
Fri Case Study Business dashboard Real-world simulation Retail analytics
BI reporting roles.
Introduce techniques for exploring
Mon datasets to identify patterns and Matplotlib Charts Visual storytelling Trend lines
trends.
Develop statistical visualization skills
Visualization & Tue Seaborn Statistical plots Pattern discovery Correlation heatmap
using charts and plots.
EDA
10 Enable identification of anomalies,
(Exploratory Wed EDA Process Trends & anomalies Insight thinking Seasonal sales
correlations, and distributions.
Data Analysis)
Teach storytelling using visual
Thu Mini Project Dataset analysis Hands-on practice Retail dataset
analytics.
Prepare learners to derive actionable
Fri Assessment Case study Skill validation Business questions
business insights from raw data.
Provide hands-on experience
Mon executing a complete analytics Project Kickoff Define business problem Agile + Jira Requirement clarity
lifecycle project.
Enable integration of Excel, SQL,
Tue Data Preparation Clean & query Excel + SQL Ready dataset
Capstone Python, and Power BI tools.
11 Project (End-to- Develop problem-solving and
Wed Analysis Python EDA Python Insights
End) analytical thinking skills.
Train learners in collaborative Agile
Thu Dashboard Visualization Power BI Business dashboard
project execution.
Build professional portfolio projects
Fri Presentation Storytelling & evaluation All tools Placement readiness
demonstrating job readiness.
Week Major Topic Day Course Objective Topic Lesson Plan (What Trainer Covers) Learning Outcomes Data Analytics Example
• Portfolio structure
Help learners present • GitHub repository setup Students create recruiter- Upload Capstone dashboard with
Mon Portfolio Building & GitHub Branding
projects professionally • README writing ready analytics portfolio problem statement & insights
• Project documentation standards
• Data Analyst resume format
Resume Engineering for Data Convert skills into • Metrics-driven resume writing “Improved sales insights by 18% using
Tue Build interview-ready resume
Analysts ATS-friendly resumes • Project storytelling Power BI dashboard”
• Keyword optimization
Industry
• SQL interview questions
Readiness &
Prepare learners for • Python scenario questions Confident interview Explain JOIN vs GROUP BY using
12 Data Analyst Wed Mock Interview Preparation
technical & HR rounds • Dashboard explanation practice responses business dataset
Career
• Behavioral questions
Acceleration
• Data storytelling framework
Business Storytelling & Stakeholder Teach insight • Executive summary writing Translate analysis into Present customer churn insights to
Thu
Communication communication skills • Insight vs observation business value management
• Presentation delivery
• Live case study
Placement Simulation & Industry Simulate real job • Team analytics sprint Experience real analyst Analyze retail dataset within 45-minute
Fri
Exposure environment • Standup meeting simulation workflow sprint
• Feedback & evaluation