• Introduction to Python
- Installation and Working with Python
- Python Variables
- Python Operators
- Python Blocks & Syntax
• Python Keywords & Identifiers
- Comments & Indentation
- Arithmetic Operators
- Relational Operators
- Logical Operators
- Assignment Operators
- Membership Operators
- Identity Operators
• Variables & Data Types
- Global & Local Variables
- Type Casting
- Variable Scope
- Strings
- Lists
- Tuples
- Dictionaries
- Sets
• Control Flow & Loops
- If, Else, Elif
- Nested Conditions
- For & While Loops
- Break, Continue, Pass
- Range Function
- Pattern Programs
- Generators
• Data Structures
- Lists & Comprehensions
- Tuples & Operations
- Dictionaries & Methods
- Sets & Set Operations
• Functions, Modules & Packages
- Functions & Arguments
- Lambda Functions
- Recursive Functions
- Modules & Packages
- Map, Filter & Reduce
• Advanced Python
- Decorators
- Iterators
- Generators
- Exception Handling
• File Handling & OS Module
- File Operations
- Directory Management
- Path Handling
- System Operations
• Database & Excel Integration
- SQL Connectivity
- Database Operations
- Excel Read/Write
- Workbook Management
• AI & LLM Integration
- PandasAI
- OpenAI GPT APIs
- LangChain
- AutoGen & Code Interpreter
• Statistics Fundamentals
- Mean, Median, Mode
- Variance & Standard Deviation
- Correlation
- Outlier Detection
- Box Plots
• Data Analysis with Pandas
- Data Import & Export
- Data Cleaning
- Data Transformation
- GroupBy Operations
- Pivot Tables
- Joins & Merges
- Missing Value Handling
• NumPy Fundamentals
- Arrays & Operations
- Indexing & Slicing
- Conditional Filtering
- Statistical Functions
• Visualization with Matplotlib
- Bar Charts
- Pie Charts
- Scatter Plots
- Histograms
- Chart Customization
• Visualization with Seaborn
- Count Plots
- Scatter Plots
- Line Plots
- Box Plots
- Heatmaps
- Plot Styling
• Introduction to Statistics
- Descriptive Statistics
- Population vs Sample
- Probability Distributions
- Normal Distribution
- Gaussian Distribution
- Z-Score
- Correlation & Covariance
• Exploratory Data Analysis (EDA)
- Data Auditing
- Missing Value Analysis
- Outlier Detection
- Imbalanced Data Handling
• Data Preprocessing & Data Mining
- Data Preparation
- Feature Engineering
- Feature Scaling
- Feature Transformation
- Dimensionality Reduction
- Anomaly Detection
• Predictive Modelling
- Analytics Lifecycle
- Business Problem Mapping
- Modelling Techniques
- Machine Learning Basics
• SQL Fundamentals
- SQL Server Installation
- SSMS Usage
- SQL Architecture
- Database Management
• Database Design
- Database Creation
- T-SQL Scripts
- File Groups & Storage
• SQL Tables & Queries
- CRUD Operations
- SELECT Queries
- WHERE, BETWEEN, IN
- GROUP BY & HAVING
- ORDER BY
• Data Validation & Constraints
- Primary Keys
- Foreign Keys
- Unique Constraints
- Check Constraints
• Views & Security
- Views Creation
- Schema Binding
- Data Security
• Indexing & Query Optimization
- Clustered Indexes
- Non-Clustered Indexes
- Query Tuning
• Stored Procedures & Functions
- Procedures
- Parameters
- Dynamic SQL
- User Defined Functions
• Triggers & Transactions
- DML Triggers
- ACID Properties
- Transaction Management
• AI Integration in SQL
- Natural Language to SQL
- SQL Query Explanation
- Query Optimization with AI
• Excel Fundamentals
- Data Entry & Formatting
- Charts & Graphs
- Sorting & Filtering
- Data Validation
- Goal Seek & Scenarios
• Advanced Excel
- VLOOKUP & HLOOKUP
- Advanced Sorting
- Subtotals & Grouping
- Pivot Tables
- Advanced Functions
• MIS Reporting & Dashboards
- Dashboard Design
- Interactive Dashboards
- KPI Reports
- Business Reporting
• AI Integration in Excel
- Excel Copilot
- AI Formula Generation
- Automated Insights
- Power Automate Integration
• Power BI Fundamentals
- BI Concepts
- Power BI Desktop
- Dashboards & Reports
• Data Transformation
- Power Query
- Data Cleaning
- Star Schema
- Data Modelling
• DAX (Data Analysis Expressions)
- DAX Functions
- Measures
- Calculated Columns
- Time Intelligence
• Visualizations
- Charts & Graphs
- Maps
- KPI Cards
- Custom Visuals
- Drill Down Reports
• Dashboards & Publishing
- Dashboard Creation
- Sharing Reports
- Security & Permissions
- Dataset Refresh
• AI Integration in Power BI
- Smart Narrative
- Q&A Visual
- Decomposition Tree
- Power BI Copilot
- Azure Cognitive Services
• Tableau Fundamentals
- Tableau Architecture
- Tableau Prep Builder
- Data Preparation
• Data Connections
- File & Database Connections
- Joins & Unions
- Data Blending
• Basic Visual Analytics
- Bar Charts
- Line Charts
- Pie Charts
- Filtering & Grouping
• Tableau Calculations
- Built-in Functions
- Table Calculations
- LOD Expressions
• Advanced Analytics
- Parameters
- Forecasting
- Clustering
- Trend Lines
• Geographic Visualizations
- Maps
- Spatial Files
- Geocoding
• Dashboards & Stories
- Interactive Dashboards
- Storytelling with Data
- Device Optimization
• Tableau Online
- Workbook Publishing
- Permissions & Security
- Scheduling
• AI Integration in Tableau
- Ask Data
- Explain Data
- Tableau GPT
- AI Forecasting
- Python & R Integration
• Introduction to Machine Learning
- Machine Learning Concepts
- ML Categories
- ML Workflow
- Industry Use Cases
• Time Series Analysis
- AR Model
- MA Model
- ARMA Model
- ARIMA Model
- Stationarity
- ACF & PACF
• Statistical Foundations
- Exploratory Data Analysis
- Univariate Analysis
- Multivariate Analysis
- Heatmaps
• Text Mining & NLP
- Text Processing
- Natural Language Processing
- Text Analytics
- Sentiment Analysis
- NLP Applications
• Machine Learning Algorithms
- Regression Models
- Classification Models
- Clustering Techniques
- Model Evaluation
• Model Deployment & Projects
- Real-world Case Studies
- End-to-End ML Projects
- Industry Applications
- Best Practices
