Business KPI Dashboard
Month one’s build: a real business dashboard in Power BI with Power Query transformations and DAX measures, reporting the KPIs a manager actually asks for.
- Power BI
- DAX
A six-month, project-driven path you can start straight after school — from Excel and Python fundamentals through machine learning and deep learning to LLMs, RAG, AI agents and a deployed industry capstone.
This is the current edition of the Data Science programme, written for someone starting straight after 12th. Six months, one theme per month, and something you have built at the end of each. What makes it different from an older data science syllabus is that the classical pipeline and the AI stack are taught as one job rather than two courses — you finish able to clean data and train a model, and also to put a working AI assistant in front of a business.
Key Highlights
This is the current edition of the Data Science programme, written for someone starting straight after 12th. Six months, one theme per month, and something you have built at the end of each. What makes it different from an older data science syllabus is that the classical pipeline and the AI stack are taught as one job rather than two courses — you finish able to clean data and train a model, and also to put a working AI assistant in front of a business. Month one is data and programming foundations: advanced Excel, Power Query, Power BI, DAX, business dashboards and KPI reporting; then Python from the ground up with VS Code, the uv package manager, virtual environments, OOP, exception handling, logging, type hinting, pytest, Ruff and Black; Git, GitHub and AI coding tools; and SQL on PostgreSQL with database design, window functions, query optimisation, APIs, JSON, FastAPI basics, JWT authentication and Postman. Month two is data engineering and machine learning — Pandas 2.x, NumPy, Polars, DuckDB and PyArrow, then data cleaning, feature engineering, EDA, interactive visualisation with Plotly and Streamlit, statistics and probability, scikit-learn pipelines and cross validation, and gradient boosting with XGBoost, LightGBM and CatBoost. Month three is deep learning and computer vision: PyTorch, tensors and neural networks, CNNs and transfer learning with OpenCV, YOLO, OCR, image segmentation and Vision Transformers, then Hugging Face, tokenizers and the Model Hub. Months four and five are the AI half. Month four covers LLM fundamentals — tokenization, embeddings, context windows and attention — prompt engineering, the OpenAI, Gemini, Claude and Grok APIs alongside Ollama and LiteLLM, and embeddings with FAISS, ChromaDB, Pinecone, Qdrant and Milvus. Month five turns that into applications: RAG architecture with hybrid search, re-ranking, evaluation and guardrails; LangChain, LangGraph, CrewAI and the Model Context Protocol; AI agents and multi-agent systems; and FastAPI advanced, async, background tasks, WebSockets, Streamlit, Gradio and Chainlit. Month six deploys everything — Docker, Linux, Nginx, AWS, Azure AI and Google Vertex AI, AI security including prompt injection and jailbreak defence, secret management, responsible AI and CI/CD with GitHub Actions — and finishes with a complete industry-level AI SaaS application built on FastAPI, PostgreSQL, RAG pipelines and AI agents, documented and pushed to a professional GitHub repository.
Every module ends in something you have built and a trainer has reviewed, so the list below is work you will have done rather than topics you will have heard about.
Power Query, DAX and Power BI reporting real KPIs
prompt injection and jailbreak defence, secret management, responsible AI
The syllabus is arranged so every module produces an asset rather than a set of notes. You will cover month 1 — data & programming foundations, month 2 — data engineering & machine learning, month 3 — deep learning & computer vision, month 4 — llm fundamentals & vector search, and finish with a live project built on Excel, Power Query & Power BI, Python, uv, Ruff & Black, pytest. Modules run in the order a real project runs: foundations first, then the core skills, then applied work under supervision, then the portfolio and interview preparation that turn all of it into an offer letter.
The working knowledge the job description actually lists.
Month 3 — Deep Learning & Computer Vision
Where deep learning becomes concrete rather than theoretical.
4 weeks · 24 sessions
Topics covered
The toolchain
Everything below is installed on the lab machines and used on live client work, not shown once in a slide and forgotten.
Any stream. Month one starts at Excel and Power BI, which most students have seen before, and ends with Python, Git and SQL — so the ramp is gradual rather than a wall on day one.
Most students run this next to a BCA, B.Sc, BBA or B.Com at a Phagwara college. Six months of evenings or weekends puts a deployed AI application on your CV well before campus placements begin.
Nothing here needs school physics or higher mathematics. Statistics and probability are taught in month two at the depth the modelling actually needs, and the Excel and Power BI work in month one is directly employable on its own.
You do not have to choose. This is a certificate programme with a fixed six-month end date, and what it produces — a GitHub repository, a deployed capstone, a dashboard someone can use — is what a first employer inspects.
A gap or an unrelated background counts for less than work someone can open. The syllabus is identical whoever you are; only the batch timing changes.
If free videos left you with half-finished notebooks, what changes here is a trainer reading your code every week and a capstone month with a deadline attached to it.
Candidates who can demonstrably ship a RAG system or an agent workflow move well beyond the entry band, because far fewer applicants can show one. That gap is the whole argument for this course: there is local demand, there are budgets, and there are very few trained people to hand the work to.

Build skills that hold up beyond the classroom.
What separates this from a playlist of tutorials is supervision on real work. From the second half of the course you build on live client projects with a trainer beside you, make decisions that have consequences, and correct them the following week. That loop is the skill. No employer in Phagwara will take your word for it without work they can inspect.
Be realistic about the money. A fresher who finishes with a working portfolio starts near the bottom of the band and moves quickly; someone who finishes with a certificate and nothing to show does not. The difference is entirely what you built.
The alternative is what most people try first: free videos, a cheap online course, six months of drifting, and knowledge you cannot demonstrate. A structured programme with live projects, a mentor who corrects you, an internship letter and a placement cell that actually calls employers is the difference between knowing the subject and being hired to do it.
Students reach the Phagwara centre from Banga, Nakodar, Kartarpur and the university belt, and the weekend batch exists so a job or a degree does not have to be paused to attend.
Advanced Excel, Power Query, DAX, business dashboards and KPI reporting in month one — the half of the syllabus that is employable before the rest of it finishes.
Modern Python with uv, virtual environments, OOP, type hinting, pytest and Ruff, plus PostgreSQL with window functions, query optimisation and FastAPI basics with JWT.
scikit-learn pipelines and cross validation, XGBoost, LightGBM and CatBoost, then PyTorch, CNNs, transfer learning, YOLO, OCR and Hugging Face.
Tokenization, embeddings and attention; the OpenAI, Gemini, Claude and Grok APIs; five vector databases; RAG with hybrid search and guardrails; LangChain, LangGraph, CrewAI and MCP.
Docker, Nginx, AWS, Azure AI and Google Vertex AI with GitHub Actions CI/CD — plus prompt injection and jailbreak defence, secret management and responsible AI.
A full month on one end-to-end AI SaaS application with FastAPI, PostgreSQL, RAG and agents, delivered with documentation, code review and a managed GitHub repository.

Complete the course with a portfolio of live projects and receive an industry-recognised certificate, plus a documented internship letter accepted by Punjab universities.
Recognised by employers across Punjab and beyond
Based on real client work, not a simulation
Live work you can show in any interview
CV review, mock interviews and hiring drives
Two certificates on completion — the course certificate and a separate capstone project certificate.
The roles this opens, what they pay in Punjab and beyond, and who is hiring for them — drawn from published job-market listings, not a brochure number.
Straight after 12th the realistic first step, and the Power BI, SQL and Python work of months one and two is what gets you there.
The other realistic first step — building software with models inside it, on FastAPI behind a Streamlit or Chainlit interface.
Closer to the model than the product: scikit-learn pipelines, gradient boosting and PyTorch. Opens as the portfolio grows.
Owning the model layer — tokenization, embeddings, context windows, multi-provider routing and the cost decisions that follow.
Systems that act rather than answer — LangGraph, CrewAI, MCP and multi-agent design. Currently one of the hardest AI roles to fill.
Salary outlook — Data Analyst / AI Engineer
Builds pipelines, trains models and ships the applications that put them in front of a business. Two years of delivery experience usually doubles the starting figure.
Indicative ranges compiled from public job-market listings. Actual offers vary by employer, skillset and interview performance.
Month one’s build: a real business dashboard in Power BI with Power Query transformations and DAX measures, reporting the KPIs a manager actually asks for.
A designed PostgreSQL schema with window functions and optimised queries, exposed through a JWT-authenticated FastAPI endpoint and tested in Postman.
A messy real dataset cleaned and engineered in Pandas and Polars, explored with Plotly, then modelled through a scikit-learn pipeline and beaten with XGBoost, LightGBM and CatBoost — with the evaluation to prove it.
A PyTorch CNN with transfer learning, extended into object detection and OCR with YOLO and OpenCV — the project that makes deep learning concrete rather than theoretical.
Embeddings in a vector database with hybrid search, re-ranking and guardrails, answered by an LLM API and evaluated for hallucination — then wrapped in a Streamlit or Chainlit interface.
The whole of month six on one application: FastAPI and PostgreSQL, RAG pipelines and AI agents, containerised with Docker, secured against prompt injection, deployed with GitHub Actions and documented for review. This is the one interviewers ask about.
Every project moves through the same loop: understand the brief, build with guidance, then explain the decisions behind your work.
Take a real requirement apart before touching a tool — what is being asked, what it needs, and which part to build first.
Business KPI Dashboard
Work hands-on with your trainer watching the screen, so a wrong turn is caught in the same session rather than three weeks later.
SQL Data Service with FastAPI
Walk through what you built and why you built it that way. This is the interview rehearsal, run against every project rather than once at the end.
End-to-End ML Pipeline
There are many places to learn this in Phagwara and the brochure syllabus looks similar at all of them. What differs is who teaches, whether you ever touch real work, and whether anyone picks up the phone after you have paid. techcadd has trained students across Punjab since 2007 on the same model: small batches, working practitioners as trainers, client projects as coursework.
Your trainer is not a full-time lecturer. They deliver data and AI work for techcadd’s services arm, so the examples in class are current rather than a case study from five years ago.
Month one begins at Excel and Python fundamentals. Nothing is assumed, and nothing is skipped on the assumption that a degree will fill the gap later.
Gradient boosting and vector databases, scikit-learn pipelines and LangGraph agents, taught in the same six months by the same trainer — because that is how the job is now advertised.
uv, Ruff, Black and pytest from month one; Polars and DuckDB alongside Pandas; PyTorch and Hugging Face for deep learning. You learn the stack a modern team actually runs.
OpenAI, Gemini, Claude and Grok through real API calls, plus Ollama and LiteLLM for local and routed models — with cost, context limits and failure handling met head on rather than skipped.
Resume and portfolio guidance built into the programme, mock interviews and CV reviews, and repeated drives with hiring partners across Phagwara, Jalandhar and Ludhiana.
Find answers to the questions students ask before enrolling.
Six months, one theme per month: data and programming foundations, data engineering and machine learning, deep learning and computer vision, LLM fundamentals and vector search, RAG and AI agents, then deployment and the industry capstone. Weekday, evening and weekend batches cover the same syllabus, and 1-on-1 training is available. Every class runs for 2 hours.

Send your question and a counsellor will call you back about batch timings, fees, EMI options, placement record, or whether this course fits your degree.
One call with a counsellor is usually enough to find out. Book a free demo class and see the lab before you decide.