06 July B4: Data Science & Analytics (JM Road)

📊 DATA ANALYTICS & DATA SCIENCE MASTER PROGRAM

Detailed Topic-Wise Syllabus

Based on the uploaded syllabus document 

📈 DATA ANALYTICS

🐍 Python Programming

Introduction to Python

• Overview of Python
• Features of Python
• Installation & Setup
• Python Basics
• Running Python Programs

Data Types & Variables

• Variables & Constants
• Data Types
• Type Conversion
• User Input

Operators & Expressions

• Arithmetic Operators
• Relational Operators
• Logical Operators
• Assignment Operators

Control Statements

• Conditional Statements
• if, if-else, Nested if
• Looping Statements
• for Loop
• while Loop
• Loop Control Statements

Strings in Python

• String Basics
• String Operations
• String Functions

Data Structures

• Lists
• Tuples
• Sets
• Dictionaries

Functions

• Function Basics
• Function Arguments
• Scope of Variables
• Anonymous Functions (Lambda)
• Recursion

Modules & Packages

• import Statement
• Built-in Modules
• Custom Modules

File Handling

• Reading Files
• Writing Files
• File Operations

Exception Handling

• try-except-finally
• Custom Exceptions

Object Oriented Programming (OOPs)

• Classes & Objects
• Constructors
• Inheritance
• Polymorphism
• Encapsulation

Advanced Python Concepts

• Iterators & Generators
• Decorators
• Regular Expressions
• Date & Time Module

Working with Data

• NumPy
• Pandas
• Matplotlib

Database Connectivity

• Python with SQL Databases
• CRUD Operations

Mini Projects / Assignments

• Data Cleaning Projects
• Automation Projects
• Analytics Projects

🗄️ SQL

Introduction to Databases

• Database Concepts
• DBMS vs RDBMS
• SQL Overview

SQL Basics

• SQL Syntax
• Data Types
• Creating & Using Databases

Table Operations

• Creating Tables
• Altering Tables
• Dropping Tables

Data Manipulation Language (DML)

• INSERT
• UPDATE
• DELETE

Data Query Language (DQL)

• SELECT Query
• WHERE Clause
• ORDER BY
• LIMIT / TOP

SQL Functions

• Aggregate Functions
• String Functions
• Numeric Functions
• Date Functions

Filtering & Conditions

• AND / OR / NOT
• BETWEEN
• IN
• LIKE
• IS NULL / IS NOT NULL

Joins

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN
• CROSS JOIN
• SELF JOIN

Grouping

• GROUP BY
• HAVING Clause

Constraints

• PRIMARY KEY
• FOREIGN KEY
• UNIQUE
• CHECK
• NOT NULL
• DEFAULT

Subqueries

• Single-row Subqueries
• Multi-row Subqueries
• Nested Subqueries

Views

• Creating Views
• Updating Views
• Dropping Views

Indexes

• Creating Indexes
• Unique Indexes
• Dropping Indexes

Triggers

• Introduction to Triggers
• BEFORE & AFTER Triggers
• INSERT / UPDATE / DELETE Triggers

Window Functions

• ROW_NUMBER
• RANK
• DENSE_RANK
• LEAD & LAG
• FIRST_VALUE & LAST_VALUE
• PARTITION BY

Transactions & ACID Properties

• COMMIT & ROLLBACK
• SAVEPOINT
• Transaction Isolation Levels
• ACID Properties

SQL Projects

• Student Database System
• Library Management System
• Sales Analytics Dashboard
• Employee Management System

📊 Power BI

Introduction to Power BI

• What is Power BI
• Power BI Components
• Installation & Setup
• Power BI Desktop Overview

Getting Data

• Importing Data from Excel/CSV
• Importing Data from Databases
• Connecting Online Sources
• Understanding Data Types

Power Query (Data Cleaning)

• Power Query Editor Basics
• Removing Duplicates & Null Values
• Split & Merge Columns
• Data Transformations
• Append & Merge Queries

Data Modeling

• Relationships
• Star Schema Basics
• Calculated Columns
• Measures
• Introduction to DAX

Data Visualization

• Built-in Visuals
• Bar, Line, Pie Charts
• Table & Matrix Visuals
• Slicers & Filters
• Drill Down & Hierarchy
• Formatting Visuals

Report Design

• Page Layout
• Themes & Colors
• Custom Visuals
• Tooltips & Bookmarks

Power BI Service

• Publishing Reports
• Dashboards
• Sharing & Permissions
• Workspaces

Data Refresh

• Scheduled Refresh
• Refresh Errors & Solutions
• Gateway Basics

Power BI Projects

• Sales Dashboard
• Student Dashboard
• HR Dashboard

📑 Excel

Introduction to Excel

• Excel Interface
• Workbook & Worksheet Basics
• Ribbon & Tabs
• Cell Referencing

Basic Excel Operations

• Entering & Editing Data
• AutoFill & Flash Fill
• Formatting Cells
• Sorting & Filtering

Formulas & Functions

• Mathematical Functions
• Text Functions
• Date & Time Functions
• Logical Functions (IF)

Data Management

• Sorting Data
• Filtering Data
• Removing Duplicates
• Data Validation

Charts & Visualization

• Column Charts
• Bar Charts
• Line Charts
• Pie Charts
• Sparklines

Tables

• Creating Excel Tables
• Table Styles
• Using Filters in Tables

Pivot Tables

• Creating Pivot Tables
• Pivot Table Fields
• Pivot Charts

Working with Multiple Sheets

• Linking Sheets
• Consolidating Data
• Protecting Sheets

Excel Printing

• Page Layout
• Print Area
• Headers & Footers

🤖 DATA SCIENCE

📚 Machine Learning

Feature Engineering

• What is a Feature?
• Why Feature Engineering?
• Feature Extraction
• Feature Selection

Feature Engineering Methods

• Handling Numerical Features
• Handling Categorical Features
• Handling Time-based Features
• Handling Text Features
• Handling Missing Data
• Dimension Reduction

Feature Engineering with Python – Pandas

• Data Import & Export
• Data Selection
• Data Cleaning

Data Visualization

• Line Chart
• Bar Chart
• Pie Chart
• Histograms

Regression

• Simple Regression
• Multiple Regression
• Polynomial Regression

Model Assessment

• Training Error
• Generalized Error
• Testing Error
• Irreducible Error
• Bias-Variance Tradeoff

Advanced Regression

• Ridge Regression
• Lasso Regression
• Feature Selection Algorithms
• Non-Parametric Regression
• K-Nearest Neighbor Regression
• Kernel Regression

Classification

• Linear Classifiers
• Logistic Regression
• Decision Trees
• Decision Tree Learning
• Decision Boundaries

Unsupervised Learning

• Clustering
• K-Means Clustering
• Finding Value of K
• Hierarchical Clustering
• Distance Metrics
• Linkage

Text Analysis

• Text Processing with Python
• String Manipulations
• Regular Expressions

Natural Language Processing (NLP)

• Stemming
• Lemmatization
• Tokenization

Text Classification

• Topic Modeling
• NLP Applications

🧠 Deep Learning

Deep Learning Foundations

• Introduction to Deep Learning
• Deep Learning vs Traditional Machine Learning
• Feature Engineering
• Hardware Dependencies
• Interpretability

Deep Learning Networks

• Fully Connected Neural Networks
• Convolutional Neural Networks (CNN)
• Autoencoders
• Recurrent Neural Networks (RNN)

Application Areas

• Computer Vision
• Audio Signal Processing
• Natural Language Processing
• Deep Reinforcement Learning

Training Deep Learning Networks

• Mini-Batch Gradient Descent
• Adam Optimization Algorithm
• Activation Functions
• Weight Initialization

Initialization Techniques

• Xavier Initialization
• Kaiming (He) Initialization

Regularization Techniques

• Batch Normalization
• Dropout Regularization
• Training Data Augmentation
• Early Stopping

Classification Metrics

• Log Loss
• Cross Entropy Metric

Convolutional Neural Networks (CNNs)

• Convolution & Correlation Operations
• Layers in CNN
• Building CNN Models
• CNN with RGB Images
• ImageNet Architectures
• Training CNN Models

Recurrent Neural Networks (RNNs)

• Vanishing & Exploding Gradients
• Long Short-Term Memory (LSTM)
• Recurrent LSTM Networks
• Deep Recurrent Networks
• Stacked Recurrent LSTM Networks

🔥 LIVE PROJECTS & PRACTICAL TRAINING

Real-Time Projects

• Sales Analytics Dashboard
• HR Analytics Dashboard
• Student Performance Analysis
• Customer Segmentation
• Data Cleaning Projects
• Machine Learning Projects

Tools & Technologies

• Python
• SQL
• Power BI
• Excel
• Machine Learning
• Deep Learning

🎁 COURSE BENEFITS

• Daily Live Classes
• Recorded Lectures Access
• Real-Time Projects
• Notes & Assignments
• Certificate of Completion & 6 Month Internship certificate 
• Dedicated Support
• Resume Building
• Mock Interviews
• Job & Career Assistance
• Industry-Level Training