Online PGP in AI-Powered Business Analytics
Become a job-ready analyst with our most comprehensive analytics program - master SQL, Python, Tableau, statistics, and applied ML, with a live capstone on brands like Zepto, Nykaa & CRED
Learning Mode Online
Course Duration 10 Months
Time Commitment 10 Hrs/Week
enrollment-avatars

4.2K+ students have already registered

What Makes This Different

Learn the Exact Stack Companies Use Today

Vishlesan i-Hub, IIT Patna Certification

Vishlesan i-Hub, IIT Patna Certification

(Minimum 65% attendance and 30% cumulative evaluation score)

Analyst-Grade Curriculum

Analyst-Grade Curriculum

SQL, Python, statistics, Tableau, applied ML & forecasting, built around real Indian-brand cases.

AI-Augmented Analytics

AI-Augmented Analytics

Work with ChatGPT, Claude, and Power BI / Excel Copilot the way modern analyst teams do.

Live Brand Capstone

Live Brand Capstone

Solve and defend a real diagnostic on Zepto, Nykaa, CRED, Razorpay, or Mamaearth before an expert panel.

Placement Opportunities

Placement Opportunities

Placement assistance, resume reviews, and coaching.

(Eligibility: 7+ CGPA and 65% attendance)

Learn from Industry Mentors

Learn from Industry Mentors

Analysts and data scientists from Amazon, Adobe & Google.

What will you learn?

The most comprehensive PGP in AI-Powered Business Analytics program we offer. Every module is a full deep-dive - you will not just learn these topics, you will master them, deploy them, and know how to defend every decision you make.

Tool 1
Tool 2
Tool 3
Tool 4
Tool 5
Tool 6
Tool 7
Tool 8
Tool 9
Tool 10
Tool 11
Tool 12
Tool 13
Tool 14
Tool 15
Tool 16
Tool 17

Meet our Instructor Team

Sharon Suresh

Sharon Suresh

Engineering Analyst, Google

icon
Sharon Suresh is a Growth & Partnerships professional with experience in business analysis and data-driven roles, having worked across companies like Porter, Airmeet and Google.
Megna Roy

Megna Roy

Data Scientist, Google

icon
Megna Roy is a data analytics specialist and mentor known for transforming complex data into actionable insights and guiding professionals in their data careers, with experience at companies like Uber.
Rituraj Singh Gour

Rituraj Singh Gour

Data Science, Adobe Ex-BIE, Amazon

icon
Rituraj is a Business Analyst at Amazon, where they generate actionable insights and drive strategic decision-making through data analysis, visualization, and machine learning. Working closely with cross-functional teams, they translate complex data into clear recommendations for stakeholders and consistently deliver high-impact results.
Sankalp Sidhanth Misra

Sankalp Sidhanth Misra

Business Analyst & Program Manager

icon
Business Analyst working across analytics, growth, and Gen AI. Builds data-driven systems that improve user experience and drive measurable outcomes — and has mentored 150+ students in STEM and coding.
Abhinava Tripathi

Abhinava Tripathi

Professor of Finance

icon
Professor of Finance with strong expertise in quant finance, data science, and capital markets, associated with IIT Kanpur and IIM Lucknow.
Kumari Pritee

Kumari Pritee

Assistant Professor

icon
Assistant Professor at IIM Sambalpur with expertise in Geo-AI, machine learning, deep learning, and spatial data mining, backed by a PhD from IIT Roorkee.

*Note: Instructors teaching your batch may change based on specific module expertise, or circumstances such as personal emergencies, unavailability etc.

Course Details

Foundation

Levels the floor for mixed-background cohorts and builds the foundation for analytics work. Ready for data and analytics intern, MIS executive, BI associate, and junior analytics support roles. First portfolio artifacts shipped on real Indian-brand cases by end of Month 3.

Module wise curriculum

module 1

Business & Data Literacy Primer

Business vocabulary, P&L logic, KPI thinking, and sector literacy across Indian D2C, SaaS, fintech, and BFSI - plus spreadsheet foundations to handle data from day one.

revenue vs profit P&L KPI logic

module 2

Computational Logic & AI Co-pilots

Build the computational thinking floor every analyst needs - variables, loops, conditionals, problem decomposition - and onboard ChatGPT and Claude as learning partners from day one.

Computational thinking Variables & loops AI co-pilots

module 3

Business Foundations & Analyst Mindset

P&L and KPI logic, sector literacy across D2C, SaaS, fintech, quick-commerce, and BFSI, hypothesis trees, stakeholder mapping. AI tools introduced with the prompt-then-verify discipline.

KPI trees Sector literacy Hypothesis framing

module 4

Python Foundations

Python in Google Colab from scratch - data types, structures (lists, tuples, dicts, sets), control flow, functions, file I/O, basic exception handling. The analyst-grade programming floor.

Python basics Data structures Functions

module 5

Spreadsheets for Analysts

Excel and Google Sheets together - formulas, lookups (XLOOKUP, INDEXMATCH), dynamic arrays, pivot tables, Power Query for imports and transforms. Cross-tool fluency that survives any workplace stack.

Formulas & lookups Pivot tables Power Query

module 6

Data & AI Literacy

Data thinking - types, schemas, ETL intuition - plus visualization principles and AI co-pilot fluency for analyst tasks. The conceptual bridge between business questions and the technical toolkit.

Data thinking ETL intuition Visualization principles

module 7

Your First Portfolio Artifacts

Tie everything together. Weekly small artifacts graded for clarity, plus integrated mini-projects across the Foundation toolkit. Output: business diagnostic memo, Python data-processing script, and stakeholder-ready spreadsheet dashboard.

Portfolio building Mini-projects Integrated learning

tools acquired

Python Google Colab Microsoft Excel Google Sheets Power Query ChatGPT Claude Notion

Roles unlocked

Data & Analytics Intern MIS Executive BI Associate Junior Analytics Support
Core Expertise

Ready for Business Analyst, Data Analyst, Junior BI Analyst, Marketing Analyst (Junior), and Product Analyst (Junior) roles at GCCs, IT services, D2C brands, and Indian product startups. The core skills behind 73-81% of analyst job listings on the Indian market.

Module wise curriculum

module 1

SQL Mastery

Four weeks from SELECT to window functions. Query fundamentals, aggregates and all join types, subqueries and CTEs and window functions, schema design, and performance literacy.

Query fundamentals Joins & CTEs Window functions

module 2

Python Libraries for Exploratory Data Analysis

Pandas, NumPy, matplotlib, and seaborn for analyst-grade EDA. DataFrames and indexing, groupby and merge, pivot and melt, date and time handling, data cleaning discipline, and visualization essentials.

Pandas & NumPy Data visualization Exploratory analysis

module 3

Statistics & A/B Testing

Descriptive stats in practice, probability distributions, sampling and CLT intuition, hypothesis testing, confidence intervals, A/B testing framework, plus regression and logistic regression interpretation.

Hypothesis testing A/B framework Statistical reasoning

module 4

Dashboarding with Tableau

Tableau Public end-to-end - data connections, calculated fields, LOD expressions, parameters, visualization principles, and dashboard UX - with brief Power BI exposure for workplace coverage.

Tableau Public Dashboard design Visualization principles

module 5

Marketing & Product Analytics

Marketing analytics covering customer segmentation (RFM), CAC and LTV unit economics, marketing funnel analysis, campaign analytics. Then product analytics covering HEART and AARRR frameworks, North Star Metric thinking, product funnels, retention curves.

RFM segmentation Funnel analysis Retention curves

module 6

Cross-Module Integration

End of Month 7. Tie SQL, Python EDA, statistics, dashboarding, and marketing-product analytics into one fresh deliverable on a single Indian-brand case. Output: cross-module analyst case with SQL query stack, Python EDA notebook, Tableau dashboard, and insight memo.

SQL-led analysis Python + Tableau Portfolio project

tools acquired

PostgreSQL MySQL Python pandas NumPy matplotlib seaborn Tableau Public Power BI Google Sheets Microsoft Excel ChatGPT Claude

Roles unlocked

Business Analyst (Junior) Data Analyst BI Analyst / Junior Marketing Analyst (Junior) Product Analyst (Junior)
Industry Specialization

Stronger candidacy for Senior Data Analyst, Product Analyst (Standard), Marketing Analyst (Standard), and Analytics Consultant (Junior) roles, with stretch candidacy for Junior Data Scientist roles backed by a portfolio-grade capstone defended live.

Module wise curriculum

module 1

Applied Machine Learning for Analysts

Applied ML with scikit-learn and statsmodels - regression family, classification, ensemble methods and gradient boosting, clustering and dimensionality reduction, feature engineering, cross-validation discipline, and basic deployment intuition with Streamlit.

Regression & classification Ensembles Feature engineering

module 2

Forecasting & Time Series Analytics

Time series for analysts. Components and decomposition, moving averages, exponential smoothing, ARIMA basics, Prophet, accuracy metrics, and business forecasting context for retail, BFSI, and supply chain.

ARIMA & Prophet Decomposition Accuracy metrics

module 3

AI-Augmented Analyst Workflows

Prompt engineering for analyst tasks, Power BI Copilot and Excel Copilot in workflows, Tableau's AI features, 'chat with your data' basics, AI hallucination patterns, and the verification discipline.

Prompt engineering Copilot tools Hallucination patterns

module 4

End-to-End Analyst Case on a Named Indian Brand

Pick one named-brand brief from the curated capstone shortlist, or propose a brand of your choice. Go from SQL diagnosis through Python EDA, statistical analysis, dashboard, and applied ML model to an insight memo and stakeholder-ready review deck. Defended live to a panel of analytics leaders and IIT faculty. Options: ZEPTO Operations diagnostic, MAMAEARTH Growth audit, RAZORPAY Merchant analytics, CRED Retention analysis, NYKAA Funnel diagnostic, or YOUR CHOICE.

Full pipeline project Stakeholder presentation Live defense

tools acquired

scikit-learn statsmodels Prophet Streamlit Python pandas NumPy ChatGPT Claude Power BI Copilot Excel Copilot Tableau

Roles unlocked

Senior Data Analyst Product Analyst (Standard) Marketing Analyst (Standard) Analytics Consultant (Junior) Junior Data Scientist Decision Analyst Risk Analyst (Junior)