Who is this course for?
Students, freshers, working professionals and MIS / Excel / BI professionals switching to Data Scientist or AI roles.
Modules covered
- Excel + AI & SQL for data science
- Python, NumPy & Pandas
- Statistics & EDA
- Power BI + Tableau
- Machine Learning & Deep Learning
- NLP, Generative AI & LLMs
- RAG & Agentic AI
- Deployment, MLOps & GitHub portfolio
Job roles after this course
- Data Scientist (entry)
- ML Engineer (entry)
- AI / GenAI Developer (entry)
- Data Analyst
- BI + AI Analyst
Detailed syllabus
01Data Science & AI Foundation (10 hrs)4 topics
- Data analyst vs data scientist vs ML engineer
- AI vs ML vs deep learning vs GenAI
- Data science lifecycle & CRISP-DM
- Turning a business problem into a data science problem
02Advanced Excel + AI for Analytics (20 hrs)5 topics
- XLOOKUP, INDEX-MATCH, SUMIFS, dynamic arrays
- Power Query, Pivot Tables, Power Pivot, Solver
- Regression & forecasting in Excel
- Copilot / GenAI workflows; generating VBA with AI
- Project: sales & profitability dashboard
03SQL + Database + AI (35 hrs)5 topics
- Joins, CASE, subqueries, views
- CTEs, recursive CTEs, window functions, LEAD / LAG
- Running totals, moving averages, cohort analysis
- AI-generated SQL & natural language → SQL
- Project: e-commerce customer & sales analytics
04Python Programming (35 hrs)3 topics
- Core Python, OOP, modules & virtual environments
- APIs, JSON, regex, web data collection
- Jupyter, Google Colab, VS Code
05Python for Data Analysis (30 hrs)4 topics
- NumPy vectorisation & broadcasting
- Pandas GroupBy, merge, pivot, apply
- Matplotlib, Seaborn, Plotly
- Project: customer sales & marketing analysis
06Statistics & Probability (30 hrs)4 topics
- Descriptive statistics, IQR, z-score, correlation
- Probability, Bayes theorem & distributions
- Sampling, confidence intervals, hypothesis tests (t, z, chi-square, ANOVA)
- A/B testing & campaign analysis
07Data Visualisation — Power BI + Tableau (20 hrs)3 topics
- Power BI modelling, DAX, RLS, storytelling
- Tableau calculated fields, parameters & stories
- Project: management BI dashboard
08Exploratory Data Analysis (20 hrs)4 topics
- Missing values, outliers, duplicates
- Univariate, bivariate & multivariate analysis
- Feature creation & data leakage
- Project: loan applicant analysis
09Machine Learning (55 hrs)4 topics
- Supervised vs unsupervised; train / test, cross-validation, bias / variance
- Linear, ridge, lasso & elastic-net regression
- Logistic regression, KNN, Naive Bayes, decision tree, random forest, SVM
- Bagging & boosting: XGBoost, LightGBM, CatBoost
10Advanced ML & Model Evaluation (25 hrs)4 topics
- K-Means, hierarchical clustering, DBSCAN, PCA, anomaly detection
- MAE, RMSE, R², MAPE; precision, recall, F1, ROC-AUC
- Hyperparameter tuning, feature selection, explainability
- Project: customer segmentation
11Time Series & Forecasting (15 hrs)3 topics
- Trend, seasonality, stationarity
- Moving average, exponential smoothing, ARIMA, SARIMA, Prophet
- Projects: sales & inventory demand forecasting
12NLP (20 hrs)3 topics
- Tokenisation, stemming, lemmatisation, TF-IDF
- Word embeddings, transformers, Hugging Face, BERT
- Project: customer review sentiment analysis
13Deep Learning (30 hrs)4 topics
- Neural networks, backpropagation, optimisers
- TensorFlow, Keras, PyTorch
- CNNs, transfer learning, RNN, LSTM, GRU
- Project: image classification or churn neural network
14Generative AI & LLMs (30 hrs)3 topics
- LLM concepts, tokens, context window, embeddings
- OpenAI API & Hugging Face
- Prompt engineering: zero / few-shot, chain-of-thought, structured output
15RAG Applications (20 hrs)4 topics
- Chunking, embeddings, vector databases
- Retrieval, context injection, evaluation
- LangChain, FAISS / Chroma
- Project: institute knowledge assistant
16Agentic AI (20 hrs)3 topics
- Agents, tools & function calling
- Memory, planning, multi-agent systems, human-in-the-loop
- AI sales, resume-screening & MIS reporting agents
17Deployment & MLOps (25 hrs)3 topics
- Streamlit, Flask / FastAPI, Gradio
- Docker basics
- Model versioning, experiment tracking, MLflow, monitoring
18Cloud & Big Data Basics (15 hrs)2 topics
- AWS / Azure / GCP concepts
- Spark, PySpark, ETL & data pipelines
19Git / GitHub + Portfolio (10 hrs)3 topics
- Git, branches, commits, pull requests
- README & project documentation
- A GitHub portfolio of 10–15 projects
20Capstone Projects (40 hrs)3 topics
- Business data science: SQL + Python + statistics + ML + Power BI
- AI / ML: churn prediction platform with explainability & Streamlit
- GenAI: enterprise RAG + AI agent web application
21Interview & Placement Preparation (20 hrs)3 topics
- SQL, Python, statistics, ML & Power BI question banks
- Case studies & mock interviews (technical, HR, managerial)
- ATS resume, LinkedIn, GitHub & Kaggle profile
⬇ Download Data Science & AI syllabus PDFFull syllabus page
What's included
- Practice exercises and module-level assignments
- Capstone and portfolio projects
- Online test portal login with topic-wise tests
- Doubt-clearing sessions and email support
- Industry-recognised certificate
Frequently asked questions
Is the course offered online or offline?
Both. You can join classroom batches at our Dwarka, Uttam Nagar or Janakpuri branch, or attend live online classes. Corporate training is also available.
What are the course fees?
Basic MIS & Analytics is ₹10,000 (3–4 months), Advance MIS & Analytics is ₹20,000 (4–6 months) and Professional MIS & Analytics + Job Placement is ₹30,000 (6–8 months). Easy instalments are available.
Do I get a certificate?
Yes. You receive a certificate after completing at least 90% of the content, assignments and attendance, and submitting one medium-level project.
Do you provide placement support?
Yes. We provide placement assistance including aptitude training, resume building, mock interviews, LinkedIn profile building and interview referrals.
Are there any prerequisites?
No. 12th pass with basic English is enough. The course starts from fundamentals, so students from any background can join.
Available at
Data Science course in Dwarka · Data Science course in Uttam Nagar · Data Science course in Janakpuri · Live online