• What is Data Analytics
• Common Terms in Data Analytics
• What is Data
• Classification of Data
• Relevance in Industry and Need of the Hour
• Types of Problems and Business Objectives in Various Industries
• How Leading Companies are Harnessing the Power of Analytics
• Critical Success Drivers
• Overview of Data Analytics Tools & Their Popularity
• Data Analytics Methodology & Problem-Solving Framework
• Common Terms in Data Analytics
• What is Data
• Classification of Data
• Relevance in Industry and Need of the Hour
• Types of Problems and Business Objectives in Various Industries
• How Leading Companies are Harnessing the Power of Analytics
• Critical Success Drivers
• Overview of Data Analytics Tools & Their Popularity
• Data Analytics Methodology & Problem-Solving Framework
• Introduction to Python
- Installation and Working with Python
- Understanding Python Variables
- Python Basic Operators
- Understanding Python Blocks
• Python Keywords and Identifiers
- Python Comments & Multiline Comments
- Python Indentation
- Arithmetic Operators
- Relational Operators
- Logical Operators
- Assignment Operators
- Membership Operators
- Identity Operators
• Introduction to Variables
- Variables, Expressions, Conditions and Functions
- Global & Local Variables
- Packing & Unpacking Arguments
- Type Casting
- Byte Objects vs Strings
- Variable Scope
• Python Data Types
- Numeric Data Types
- String Operations
- Non-Numeric Data Types
- Boolean & Casting
- Strings
- Lists
- Tuples
- Dictionaries
- Sets
• Control Structure & Flow
- If, Else, Elif Statements
- Nested IF & Else
- Loops & Control Statements
- Break, Continue & Pass
- Range Function
- Pattern Programs
- Python Iteration Techniques
- Generators
- Nested Loops
• Python Functions, Modules & Packages
- Function Calls & Return Statements
- Function Arguments
- Lambda Functions
- *args and **kwargs
- Recursive Functions
- Modules & Packages
- Map, Filter & Reduce
• List
- List Creation
- Append, Insert, Remove & Delete
- Sorting & Reversing
- Indexing & Slicing
- List Comprehension
- Nested Comprehension
• Tuple
- Tuple Creation
- Accessing Elements
- Tuple Operations
- Tuple Functions
• Dictionary
- Dictionary Creation
- Dictionary Methods
- Accessing & Updating Values
- Dictionary Comprehension
- Ordered & Default Dictionaries
• Sets
- Set Creation
- Add & Remove Elements
- Set Operations
- Frozen Sets
• Strings
- String Creation
- String Operations
- String Manipulation
• Python Exception Handling
- Python Errors & Exceptions
- Try, Except & Finally
- Catching Specific Exceptions
- Raising Exceptions
• Python File Handling
- File Opening & Closing
- File Modes
- Reading & Writing Files
- Directory Management
• Python Database Interaction
- SQL Database Connection
- Creating & Searching Tables
- Database Programming
• Reading Excel using Python
- Excel Read & Write Operations
- Workbook & Sheet Management
- Formatting Excel Data
• OS Module in Python
- File & Directory Operations
- Path Management
- User Profile Information
- File System Organization
• Introduction to Statistics
- Categorical Data
- Numerical Data
- Mean, Median & Mode
- Outliers & Range
- Interquartile Range
- Correlation
- Standard Deviation
- Variance
- Box Plot
• Understanding Statistics
- Descriptive Statistics
- Sample vs Population
- Random Variables
- Probability Distribution Functions
- Expected Value
- Normal Distribution
- Gaussian Distribution
- Z-Score
- Spread & Dispersion
- Correlation & Covariance
• Data Pre-Processing & Data Mining
- Data Preparation
- Feature Engineering
- Feature Scaling
- Datasets
- Dimensionality Reduction
- Anomaly Detection
- Parameter Estimation
- Applications of Data Mining
• Exploratory Data Analysis (EDA)
- Structured EDA Framework
- Data Audit Report
- Missing Data Analysis
- Outlier Detection
• Data Analysis & Visualization using Pandas
- Reading Excel Files
- Data Cleaning
- Data Mapping
- Correlation & Histograms
- Statistical Analysis
- Missing Value Handling
- GroupBy Operations
- Pivot Tables
- Data Joins & Merges
- DataFrame Operations
• Data Analysis & Visualization using NumPy
- NumPy Introduction
- NumPy Arrays
- Array Operations
- 1D & 2D Arrays
- Indexing & Filtering
- Mean, Median, Mode
- Sorting Functions
• Data Analysis & Visualization using Matplotlib
- Bar Charts
- Column Charts
- Pie Charts
- Area Charts
- Scatter Plots
- Histograms
- Chart Customization
- Export Charts as Images
• Data Visualization using Seaborn
- Scatter Plots
- Count Plots
- Pandas with Seaborn
- Hue & Categories
- Relational Plots
- Line Plots
- Box Plots
- Point Plots
- Plot Styling & Themes
- Labels, Titles & Subplots
• SQL Server Fundamentals
- SQL Server Installation
- Authentication Modes
- SQL Server Features
- SSMS Usage
- SQLCMD & Configuration Tools
• SQL Server Database Design
- Database Architecture
- Database Creation
- T-SQL Scripts
- File Groups & Storage
• SQL Tables in MS SQL Server
- Table Creation
- CRUD Operations
- SELECT Queries
- WHERE, IN & BETWEEN
- ORDER BY
- GROUP BY
- HAVING Clause
• Data Validation & Constraints
- Primary Key
- Unique Key
- Check Constraints
- Default Constraints
- Composite Keys
• Views & Row-Level Security
- Views Creation
- Schema Binding
- Metadata Views
- Joins in Views
• Indexes & Query Tuning
- Clustered Indexes
- Non-Clustered Indexes
- Scan & Seek
- Query Optimization
• Stored Procedures
- Procedure Creation
- Input & Output Parameters
- Dynamic SQL
• System Functions
- Scalar Functions
- Table-Valued Functions
- Date & Time Functions
- String Functions
• Triggers & Cursors
- DML Triggers
- Audit Operations
- Cursor Types
- Cursor Lifecycle
• Transaction Management
- ACID Properties
- Explicit Transactions
- Implicit Transactions
• Understanding Concepts of Excel
- Data Entry & Formatting
- Charts & Graphs
- Sorting & Filtering
- Data Validation
- Goal Seek & Scenarios
- Solver & Freeze Panes
• Advanced Excel
- Advanced Sorting
- Lookup, VLOOKUP & HLOOKUP
- Grouping & Subtotals
- Pivot Tables & Slicers
- Advanced Functions
- Financial Functions
- Statistical Functions
• MIS Reporting & Dashboards
- Dashboard Design
- Dashboard Elements
- Interactive Dashboards
- Industry Reporting
• Macros & VBA
- Understanding Macros
- Recording Macros
- VBA Fundamentals
- Writing VBA Code
- Cell Formatting using VBA
- Cell Referencing
- Data Copy & Paste Automation
• Data Preparation using Tableau Prep
- Data Visualization Basics
- BI Tools
- Tableau Architecture
- Tableau Prep Builder
- Data Preparation Techniques
• Data Connection with Tableau Desktop
- Database Connections
- File Connections
- Joins & Unions
- Data Blending
• Basic Visual Analytics
- Bar Charts
- Line Charts
- Pie Charts
- Filtering & Sorting
- Grouping & Sets
• Calculations in Tableau
- Built-in Functions
- Table Calculations
- LOD Expressions
- R Integration
• Advanced Visual Analytics
- Parameters
- Tooltips
- Trend Lines
- Forecasting
- Clustering
• Geographic Visualizations
- Maps
- Spatial Files
- Geocoding
- Polygon Maps
• Advanced Charts
- Box Plot
- Bullet Chart
- Gantt Chart
- Waterfall Chart
- Pareto Chart
- Funnel Chart
- Donut Chart
- Word Cloud
• Dashboards & Stories
- Dashboard Design
- Interactive Dashboards
- Story Points
- Device Optimization
• Tableau Online
- Workbook Publishing
- Content Management
- Scheduling
- Permissions & Security
• Capstone Project
- End-to-End Data Analytics Project
- Data Collection & Cleaning
- Data Analysis & Visualization
- Dashboard Development
- Business Insights Generation
- Final Project Presentation
