Data Science with Analytics Course
6-Month Program | 100 Hours Structured Learning
📊 Course Overview & Statistics
Parameter Details
Total Duration 6 Months
Total Training Hours 100 Hours
Weekly Commitment ~4 Hours/Week
Projects & Case Studies 15+ Industry Projects
Languages & Tools 10+ Technologies
Training Mode Classroom & Online
Practical Training 80% Hands-on
Batch Size Maximum 20 Students
📚 6-Month Curriculum - 100 Hours Breakdown
MONTH 1: Data Foundations (20 Hours)
Week 1-2: Excel Essentials (6 Hours)
Topics:
Formula and Functions (Logical, Reference)
Data Validation & Conditional Formatting
Pivot Tables & Data Visualization
Named Ranges & Table Management
Project: Dmart Sales Analysis Dashboard
Week 3-4: SQL Database Management (8 Hours)
Topics:
Database Creation (DDL) & Data Manipulation (DML)
Complex Queries & Joins
Built-in Functions
Data Aggregation & Filtering
Projects: FoodHub Database System, Cab Booking Analytics
Week 5: Python Basics - Part 1 (6 Hours)
Topics:
Python Introduction & Setup
Data Types, Variables & Operators
Conditional Statements & Loops
MONTH 2: Visualization & Python (20 Hours)
Week 6-7: Power BI (10 Hours)
Topics:
Power BI Desktop & Power Query
Data Modeling & Relationships
DAX Fundamentals
Interactive Dashboards & Reports
Power BI Service
Project: EcomLens Business Intelligence Dashboard
Week 8: Tableau (6 Hours)
Topics:
Data Connections & Preparation
Custom Charts & Visualizations
Dashboard Creation
Performance Optimization
Project: Interactive Sales Analytics Dashboard
Week 9: Python Basics - Part 2 (4 Hours)
Topics:
Functions & Modules
File Handling
Regular Expressions
Project Setup: QuizMaster Application
MONTH 3: Python for Data Science (20 Hours)
Week 10-11: Advanced Python & Web Scraping (6 Hours)
Topics:
Object-Oriented Programming
Web Scraping with BeautifulSoup
Exception Handling
Working with APIs
Project: Web Scraping Application
Week 12-13: NumPy & Statistics (6 Hours)
Topics:
NumPy Arrays & Operations
Multi-dimensional Arrays
Descriptive Statistics
Inferential Statistics Basics
Probability Distributions
Week 14-15: Pandas & Data Visualization (8 Hours)
Topics:
Pandas DataFrames & Series
Data Cleaning & Manipulation
Indexing & Filtering
Matplotlib & Seaborn
Data Visualization Best Practices
Project: Automobile Data Analysis & Visualization
MONTH 4: Machine Learning Foundations (20 Hours)
Week 16-17: ML Fundamentals & Supervised Learning (12 Hours)
Topics:
Machine Learning Introduction & Workflow
Exploratory Data Analysis (EDA)
Linear Regression
Logistic Regression
Decision Trees & Random Forests
Support Vector Machines (SVM)
K-Nearest Neighbors (KNN)
Model Evaluation Metrics
Projects:
House Price Prediction
Customer Churn Analysis
Week 18-19: Unsupervised Learning & Optimization (8 Hours)
Topics:
K-Means Clustering
Hierarchical Clustering
Principal Component Analysis (PCA)
Model Hyperparameter Tuning
Cross-Validation
Projects:
Customer Segmentation
Email Spam Detection
MONTH 5: Artificial Intelligence & Deep Learning (20 Hours)
Week 20-21: Deep Learning & Neural Networks (10 Hours)
Topics:
Deep Learning Fundamentals
Artificial Neural Networks (ANN)
Activation Functions & Backpropagation
Convolutional Neural Networks (CNN)
Computer Vision with OpenCV
Transfer Learning
Project: Image Classification using CNN
Week 22-23: NLP & Advanced AI (10 Hours)
Topics:
Natural Language Processing Basics
Text Preprocessing & Tokenization
Recurrent Neural Networks (RNN)
LSTM Networks
Time Series Analysis (ARIMA)
Sentiment Analysis
Building Chatbots
Projects:
Sentiment Analysis on Amazon Reviews
Weather Forecasting using ARIMA
AI Chatbot Development
MONTH 6: Capstone & Career Preparation (6 Hours + Projects)
Week 24: End-to-End Project Development (4 Hours)
Focus:
Capstone Project Planning
Data Pipeline Creation
Model Deployment Basics
Documentation & Presentation
Capstone: Complete Industry-Level Project
Week 25-26: Career Readiness (6 Hours)
Focus:
Portfolio Building & GitHub Setup
Resume Optimization
LinkedIn Profile Enhancement
Technical Interview Preparation
Mock Interviews & Coding Practice
Soft Skills for Data Roles
📅 Detailed 6-Month Schedule
Month Focus Area Hours Projects
Month 1 Data Foundations 20 Excel Dashboard, SQL Database
Month 2 Visualization & Python 20 Power BI, Tableau Dashboards
Month 3 Python Data Science 20 Web Scraping, Data Analysis
Month 4 Machine Learning 20 Prediction & Classification Models
Month 5 AI & Deep Learning 20 CNN, NLP, Time Series
Month 6 Capstone & Career 20 Portfolio, Interview Prep
TOTAL Complete Program 100 15+ Projects
🎯 Weekly Learning Pattern (6 Months)
Flexible Schedule Options:
Option A: Weekday Batch
2 sessions per week
2 hours per session
Monday & Wednesday OR Tuesday & Thursday
Evening slots: 6:30 PM - 8:30 PM
Option B: Weekend Batch
1 session per week
4 hours per session
Saturday OR Sunday
Slots: 10:00 AM - 2:00 PM OR 2:00 PM - 6:00 PM
Option C: Mixed Mode
Flexible combination of weekday/weekend
Customized to student availability
Recorded sessions for missed classes
Tools & Technologies (Month-wise)
Month Tools Introduced Proficiency Level
1 Excel, SQL, Python Beginner
2 Power BI, Tableau, Python Intermediate
3 NumPy, Pandas, Matplotlib, Seaborn Intermediate
4 Scikit-learn, ML Algorithms Advanced
5 TensorFlow, Keras, OpenCV, NLTK Expert
6 GitHub, Portfolio Tools Professional
📊 Hour Distribution by Category
Category Topics Hours % of Total
Foundation Tools Excel, SQL 14 14%
Visualization Power BI, Tableau 16 16%
Programming Python (Complete) 16 16%
Data Science NumPy, Pandas, Stats 14 14%
Machine Learning Supervised & Unsupervised 20 20%
AI & Deep Learning Neural Networks, NLP 20 20%
TOTAL All Topics 100 100%
💼 Project Portfolio (15+ Projects Over 6 Months)
Month Project Name Domain Tools
1 Dmart Sales Analysis Retail Analytics Excel
1 FoodHub Database System Food Tech SQL
1 Cab Booking Analytics Transportation SQL
2 EcomLens Dashboard E-Commerce Power BI
2 Interactive Sales Analytics Business Intelligence Tableau
2 QuizMaster App Gaming/Education Python
3 Web Scraping Tool Data Collection Python, BeautifulSoup
3 Automobile Data Analysis Automotive Pandas, Matplotlib
4 House Price Prediction Real Estate Machine Learning
4 Customer Churn Analysis Banking/Telecom Machine Learning
4 Customer Segmentation Marketing Clustering
4 Email Spam Detection Cybersecurity ML Classification
5 Image Classification Computer Vision CNN, OpenCV
5 Sentiment Analysis Social Media NLP
5 Weather Forecasting Environmental Time Series
5 AI Chatbot Conversational AI RNN, NLP
6 Capstone Project Custom Domain Full Stack DS/AI
🎓 Learning Methodology (6-Month Format)
Monthly Structure:
✅ Week 1-3: New Concepts & Theory (30%)
✅ Week 3-4: Hands-on Practice (70%)
✅ End of Month: Mini Project Submission
✅ Continuous: Doubt Clearing Sessions
Assessment Pattern:
Weekly Assignments: Practice problems
Monthly Projects: Graded submissions
Mid-Term Assessment: After Month 3
Final Capstone: Month 6
Mock Interviews: Month 5-6
📈 Learning Outcomes by Month
Month 1: Foundation
✅ Analyze business data with Excel
✅ Query databases using SQL
✅ Understand Python basics
Month 2: Visualization
✅ Create interactive dashboards
✅ Master data storytelling
✅ Build Python applications
Month 3: Data Science
✅ Manipulate data with Pandas
✅ Apply statistical methods
✅ Visualize insights effectively
Month 4: Machine Learning
✅ Build predictive models
✅ Perform customer segmentation
✅ Evaluate model performance
Month 5: AI & Deep Learning
✅ Develop computer vision apps
✅ Build NLP solutions
✅ Create AI-powered tools
Month 6: Career Ready
✅ Complete portfolio projects
✅ Interview-ready profile
✅ Industry connections
💼 Career Support (Throughout 6 Months)
Ongoing Support:
✅ Month 1-2: Profile assessment & goal setting
✅ Month 3-4: Resume building & LinkedIn optimization
✅ Month 5: Mock interviews & technical prep
✅ Month 6: Active placement drives
✅ Post-Completion: 6-month job support
Placement Features:
Unlimited interview calls
Multi-domain opportunities
Pan India placements
Dedicated relationship manager
Alumni network access
Corporate visit opportunities
Expected Outcomes:
Job Roles: Data Analyst, BI Analyst, Junior Data Scientist, ML Engineer
Salary Range: ₹3-10 LPA (Freshers)
Hiring Partners: 100+ companies (Accenture, IBM, Infosys, TCS, HCL, etc.)
🎯 Why 6-Month 100-Hour Format?
✨ Balanced Learning: Adequate time to absorb concepts
✨ Work-Life Balance: Only 4 hours/week commitment
✨ Deep Practice: Time for multiple projects per topic
✨ Strong Foundation: No rushed learning
✨ Career Ready: Proper preparation included
✨ Flexible: Suits working professionals & students
📍 Training Locations & Modes
Online Mode:
Live Interactive Classes
Recorded Sessions Available
Virtual Labs & Projects
Online Doubt Resolution
📞 Enrollment Information
Next Batch Details:
Upcoming Batch: Check website for live countdown
Early Bird Discount: Contact for details
🎁 Additional Benefits
✅ Individual desktop provided (classroom mode)
✅ Study materials & digital resources
✅ Access to learner portal
✅ Instant doubt solving sessions
✅ Practice on HackerRank & LeetCode
✅ Integrated internship opportunity
✅ 15 module completion certificates
✅ Alumni network access
✅ Corporate visits
Note: This 6-month, 100-hour program offers a perfect balance between comprehensive
learning and time commitment. The pace allows deep understanding while maintaining work-
life balance. Weekend and weekday batches available based on your schedule.