ADVANCED DATA ANALYTICS & VISUALIZATION
9-Week Course Schedule
Total Duration: 45 Hours | Weekly Commitment: 5 Hours (2 sessions × 2.5 hours each)
Schedule Options
Option A: Monday & Thursday (2.5 hours each)
Option B: Tuesday & Friday (2.5 hours each)
Option C: Wednesday & Saturday (2.5 hours each)
WEEK 1: FOUNDATIONS OF DATA ANALYTICS - Part 1
Module 1 Hours: 4.5/9 Hours
Session 1 (2.5 Hours)
Day 1 Content - Introduction to Data Analytics
Session 1.1: Overview of Data Analytics (1.5 Hours)
o Opening Activity: "Data in Daily Life" discussion (15 min)
o Lecture: What is Data Analytics, Types, Industry applications (60 min)
o Interactive Activity: Local industry applications (15 min)
Session 1.2: Data Types and Sources (1 Hour)
o Lecture: Structured vs Unstructured data, Data sources (45 min)
o Brief hands-on activity introduction (15 min)
Session 2 (2.5 Hours)
Day 1 Content Completion + Day 2 Start
Session 1.2 Completion: Data Types and Sources (0.5 Hours)
o Hands-on Activity: Examine sample datasets (30 min)
Session 2.1: Data Import and Basic Operations (1.5 Hours)
o Demo: Excel data import and navigation (30 min)
o Hands-on Practice: Import retail sales dataset (45 min)
o Troubleshooting: Common issues (15 min)
Session 2.2 Start: Data Cleaning Fundamentals (0.5 Hours)
o Lecture: Identifying data quality issues (30 min)
WEEK 2: FOUNDATIONS OF DATA ANALYTICS - Part 2
Module 1 Hours: 4.5/9 Hours (Total: 9/9 Hours)
Session 1 (2.5 Hours)
Day 2 Completion + Day 3 Start
• Session 2.2 Completion: Data Cleaning Fundamentals (1 Hour)
o Demo: Excel cleaning tools (15 min)
o Practical Exercise: Clean messy customer dataset (30 min)
o Assessment Activity: Competency check (15 min)
• Session 3.1: Formulas and Functions (1.5 Hours)
o Demo: Essential functions VLOOKUP, statistical functions (30 min)
o Hands-on Practice: Create calculated fields (45 min)
o Challenge Exercise: Complex formulas (15 min)
Session 2 (2.5 Hours)
Day 3 Completion + Module 1 Assessment
• Session 3.2: Pivot Tables and Visualization (1.5 Hours)
o Demo: Creating pivot tables (30 min)
o Practical Exercise: Sales analysis with pivot tables (45 min)
o Wrap-up Activity: Present findings (15 min)
• Module 1 Assessment: (30 minutes)
o Practical assessment: Clean and analyze dataset
• Review and Preparation: (30 minutes)
o Module 1 review and Module 2 preparation
WEEK 3: SQL FOR DATA EXTRACTION - Part 1
Module 2 Hours: 5/9 Hours
Session 1 (2.5 Hours)
Day 4 Content - SQL Fundamentals
• Session 4.1: Introduction to Databases and SQL (1.5 Hours)
o Lecture: Database concepts, RDBMS, SQL syntax (45 min)
o Demo and Setup: Install MySQL/PostgreSQL (30 min)
o First Queries: Basic SELECT statements (15 min)
• Session 4.2: Basic Query Operations (1 Hour)
o Demo: SELECT, WHERE, ORDER BY operations (30 min)
o Hands-on Practice: E-commerce database queries (30 min)
Session 2 (2.5 Hours)
Day 4 Completion + Day 5 Start
• Session 4.2 Completion: Basic Query Operations (0.5 Hours)
o Continued hands-on practice (15 min)
o Exercise Review: Share queries and best practices (15 min)
• Session 5.1: Data Filtering and Sorting (1.5 Hours)
o Lecture and Demo: Advanced WHERE conditions, LIKE, IN operators (45
min)
o Practical Exercise: Complex filtering scenarios (30 min)
o Problem-Solving Session: Collaborative query building (15 min)
• Session 5.2 Start: Joins and Relationships (0.5 Hours)
o Demo: Understanding table relationships (30 min)
WEEK 4: SQL FOR DATA EXTRACTION - Part 2
Module 2 Hours: 4/9 Hours (Total: 9/9 Hours)
Session 1 (2.5 Hours)
Day 5 Completion + Day 6 Start
• Session 5.2 Completion: Joins and Relationships (1 Hour)
o Demo: INNER JOIN, LEFT/RIGHT JOINs (15 min)
o Hands-on Practice: Join customer and order tables (30 min)
o Advanced Exercise: Complex join scenarios (15 min)
• Session 6.1: Aggregate Functions (1.5 Hours)
o Lecture and Demo: COUNT, SUM, AVG, GROUP BY (30 min)
o Practical Exercise: Sales analysis with aggregates (45 min)
o Challenge Problems: Complex aggregation scenarios (15 min)
Session 2 (2.5 Hours)
Day 6 Completion + Module 2 Assessment
• Session 6.2: Subqueries and Advanced Techniques (1.5 Hours)
o Demo: Subquery concepts, CTEs (30 min)
o Advanced Practice: Customer lifetime value calculations (45 min)
o Module Review: Best practices and optimization (15 min)
• Module 2 Assessment: (30 minutes)
o Practical SQL assessment with business scenarios
• Review and Preparation: (30 minutes)
o Module 2 review and Module 3 preparation
WEEK 5: PANDAS LIBRARY BASICS - Part 1
Module 3 Hours: 5/9 Hours
Session 1 (2.5 Hours)
Day 7 Content - Python and Pandas Introduction
• Session 7.1: Python Environment Setup (1.5 Hours)
o Setup: Anaconda installation verification (30 min)
o Python Basics Review: Data types, structures, operations (45 min)
o First Pandas Steps: Create first DataFrame (15 min)
• Session 7.2: DataFrame Creation and Exploration (1 Hour)
o Demo: Creating DataFrames from various sources (45 min)
o Hands-on Practice: Load sales dataset (15 min)
Session 2 (2.5 Hours)
Day 7 Completion + Day 8 Start
• Session 7.2 Completion: DataFrame Creation and Exploration (0.5 Hours)
o Continued hands-on practice (15 min)
o Exploration Exercise: Data profiling (15 min)
• Session 8.1: Data Selection and Filtering (1.5 Hours)
o Lecture and Demo: Boolean indexing, loc/iloc (45 min)
o Practical Exercise: Filter sales data by criteria (30 min)
o Advanced Filtering: Complex queries (15 min)
• Session 8.2 Start: Data Transformation Techniques (0.5 Hours)
o Demo: Adding columns, mathematical operations (30 min)
WEEK 6: PANDAS LIBRARY BASICS - Part 2
Module 3 Hours: 4/9 Hours (Total: 9/9 Hours)
Session 1 (2.5 Hours)
Day 8 Completion + Day 9 Start
• Session 8.2 Completion: Data Transformation Techniques (1 Hour)
o Continued demo: String operations, date manipulation (15 min)
o Hands-on Practice: Create calculated fields (45 min)
• Session 9.1: Data Reshaping and Merging (1.5 Hours)
o Lecture and Demo: Pivot tables, melting, merging (45 min)
o Practical Exercise: Reshape and merge sales data (30 min)
o Advanced Operations: Multi-index operations (15 min)
Session 2 (2.5 Hours)
Day 9 Completion + Module 3 Assessment
• Session 9.2: Data Visualization with Matplotlib and Seaborn (1.5 Hours)
o Demo: Matplotlib basics, Seaborn introduction (45 min)
o Hands-on Practice: Create visualizations from sales data (30 min)
o Visualization Challenge: Creative exercise (15 min)
• Module 3 Assessment: (30 minutes)
o Comprehensive Pandas exercise with visualization
• Review and Preparation: (30 minutes)
o Module 3 review and Module 4 preparation
WEEK 7: ADVANCED VISUALIZATION TECHNIQUES - Part 1
Module 4 Hours: 5/9 Hours
Session 1 (2.5 Hours)
Day 10 Content - Advanced Plotting with Seaborn
• Session 10.1: Multi-variable Visualizations (1.5 Hours)
o Demo: Pair plots, correlation matrices, faceted plots (45 min)
o Hands-on Practice: Create comprehensive EDA visualizations (30 min)
o Design Principles: Color theory, accessibility (15 min)
• Session 10.2: Statistical Visualizations (1 Hour)
o Lecture and Demo: Box plots, violin plots, regression plots (45 min)
o Practical Exercise: Statistical analysis visualization (15 min)
Session 2 (2.5 Hours)
Day 10 Completion + Day 11 Start
• Session 10.2 Completion: Statistical Visualizations (0.5 Hours)
o Continued practical exercise (15 min)
o Interpretation Exercise: Reading statistical plots (15 min)
• Session 11.1: Dashboard Design Principles (1.5 Hours)
o Lecture: Dashboard design principles, UX considerations (45 min)
o Design Workshop: Wireframe dashboard layouts (30 min)
o Review and Critique: Peer review of designs (15 min)
• Session 11.2 Start: Creating Interactive Elements (0.5 Hours)
o Demo: Interactive plots with Plotly (30 min)
WEEK 8: ADVANCED VISUALIZATION TECHNIQUES - Part 2
Module 4 Hours: 4/9 Hours (Total: 9/9 Hours)
Session 1 (2.5 Hours)
Day 11 Completion + Day 12 Start
• Session 11.2 Completion: Creating Interactive Elements (1 Hour)
o Continued demo: Adding filters and controls (15 min)
o Hands-on Development: Build interactive dashboard (45 min)
• Session 12.1: Introduction to Causal Reasoning (1.5 Hours)
o Lecture: Correlation vs Causation, causal inference (45 min)
o Case Study Analysis: Marketing campaign effectiveness (30 min)
o Practical Exercise: Create causal diagrams (15 min)
Session 2 (2.5 Hours)
Day 12 Completion + Module 4 Assessment
• Session 12.2: Building Causal Models (1.5 Hours)
o Demo: Causal graph construction (45 min)
o Project Work: Build causal model for customer retention (30 min)
o Presentation Preparation: Develop narratives (15 min)
• Module 4 Assessment: (30 minutes)
o Create advanced visualization with causal reasoning
• Review and Preparation: (30 minutes)
o Module 4 review and Module 5 preparation
WEEK 9: RECOMMENDATION MODELS - Complete Module
Module 5 Hours: 5/9 Hours
Session 1 (2.5 Hours)
Day 13 Content - Introduction to Predictive Modeling
• Session 13.1: Predictive Analytics Fundamentals (1.5 Hours)
o Lecture: Types of predictive models, supervised vs unsupervised (45 min)
o Case Study Analysis: Successful predictive projects (30 min)
o Conceptual Exercise: Identify prediction opportunities (15 min)
• Session 13.2: Simple Recommendation Systems (1 Hour)
o Demo: Collaborative filtering, content-based filtering (45 min)
o Hands-on Practice: Build simple recommendation system (15 min)
Session 2 (2.5 Hours)
Day 13 Completion + Final Project
• Session 13.2 Completion: Simple Recommendation Systems (0.5 Hours)
o Continued hands-on practice (15 min)
o Optimization Exercise: Improve recommendation accuracy (15 min)
• Compressed Days 14-15: Multi-source Integration & Model Building (1.5 Hours)
o Key concepts: Data integration, ETL processes (20 min)
o Integration exercise: Combine multiple data sources (40 min)
o Model building: Complete recommendation system (30 min)
• Module 5 Assessment & Final Presentation: (30 minutes)
o Present complete recommendation system with business justification
Weekly Time Breakdown
• Weeks 1-8: 5 hours each (40 hours total)
• Week 9: 5 hours (compressed final module)
• Total Course Duration: 45 hours
Recommended Schedule Format
Choose one of these weekly patterns:
• Pattern A: Monday (2.5 hrs) + Thursday (2.5 hrs)
• Pattern B: Tuesday (2.5 hrs) + Friday (2.5 hrs)
• Pattern C: Wednesday (2.5 hrs) + Saturday (2.5 hrs)
Tips
1. Preparation: Review previous session materials before each class
2. Practice: Complete exercises during gaps between sessions
3. Projects: Start working on assessments early
4. Resources: Keep datasets and tools ready for each session
5. Engagement: Participate actively in group exercises and discussions
