All Courses
×
iHUB IIT R

Executive Post Graduate Certification in Data Analytics

7,102 Ratings

Learn from IIT Faculty & Industry Experts with Guaranteed Job Interviews
  • MasterModern Python, Excel, SQL, Power BI & Cloud Analytics
  • Learn Predictive Analytics, Generative AI & Agentic AI
  • 2-Day Campus Immersion at iHUB, IIT Roorkee
  • Secure up to ₹50 Lakhs in Funding & Incubation Support
  • Earn Prestigious Certification from iHUB IIT Roorkee & Microsoft
Apply Now Download Brochure
course intro video image
Course Introduction

Watch

Course Preview

Learning Format

Online Bootcamp

Live Classes

11 Months

Certification by

iHub IIT Roorkee

Campus Immersion at

iHUB, IIT Roorkee

Hiring Partners

3100+

EMI Starts

at ₹5500/month*

Google-Reviews 3109
sitejabber 1493
mouthshut 24542

About Program

This program, offered by iHUB DivyaSampark at IIT Roorkee, builds job-ready skills across business analytics, cloud data, predictive modeling, Generative AI, and Agentic AI.

Key Highlights

620 Hrs of Applied Learning
90+ Live Sessions Over 11 Months
218 Hrs of Self-Paced Learning
Learn from IIT Faculty & Industry Practitioners
50+ Industry Projects & Case Studies
iHub IIT Roorkee Certification
2-Day Campus Immersion at iHUB, IIT Roorkee
One-on-One Sessions with Industry Mentors
AI Powered LMS for quick doubt resolution
24*7 Support
Dedicated Learning Management Team
Designed for Working Professionals & Freshers
1:1 Mock Interview Preparation
3 Guaranteed Interviews upon movement to Placement Pool
Up to ₹50 Lakh in Startup Funding and Incubation Support*

About iHub Divya Sampark

iHUB DivyaSampark at IIT Roorkee, established under the National Mission on Interdisciplinary Cyber-Physical Systems (NM-ICPS) by the Department of Science and Technology (DST), focuses on fostering innovation in advanced technologies such as AI, ML, and more. The hub plays a pivotal role in technology development, incubation, and startups, particularly in areas like Healthcare,Read More..

Upon the completion of this program, you will:

  • Receive a certificate from iHUB DivyaSampark, IIT Roorkee
Executive Post Graduate Certification in Data Analytics Click to Zoom

Program in Collaboration with Microsoft

Benefits for students from Microsoft:

  • Free Voucher for Exam AZ-900: Microsoft Azure Fundamentals worth $99
  • Industry-recognized certification from Microsoft
  • real-world projects and exercises
PowerBI Click to Zoom

Career Transition

55% Average Salary Hike

$127,000 Highest Salary

45 LPA Highest Salary

800+ Career Transitions

3100+ Hiring Partners

Career Transition Handbook

*Past record is no guarantee of future job prospects

Who Can Apply for the Course?

  • Individuals with a bachelor’s degree and a strong interest in learning Data Analytics
  • IT professionals transitioning into Data Analyst, BI Analyst, Business Analyst, or Analytics Engineer roles
  • Professionals looking to advance in their careers in IT
  • Business Intelligence, reporting, and analytics professionals
  • Recent graduates & entry-level professionals building careers in data and business analytics
who can apply

What Career Roles Can Learners Pursue?

Data Analyst

Clean, analyze, and visualize data using Excel, SQL, Python, and Power BI to support business decisions.

Business Analyst

Translate stakeholder requirements into analytical questions, KPIs, reports, and actionable recommendations.

Business Intelligence Analyst

Build governed semantic models, DAX measures, executive dashboards, and self-service reporting solutions.

Product and Marketing Analyst

Analyze funnels, campaigns, customer behavior, activation, retention, and conversion to improve growth.

Analytics Engineer

Prepare reliable, AI-ready datasets across databases, cloud warehouses, Python workflows, and BI platforms.

Predictive Analytics Analyst

Build practical models for propensity, churn, risk, segmentation, and demand forecasting, and explain their limitations.

View More

Skills to Master

Advanced Excel

SQL

Data Wrangling

Power BI

DAX

Predictive Analytics

Forecasting

Agentic AI

Workflow Automation

Power Query

Python Data Analysis

Statistics

A/B Testing

Business Analytics

Product Analytics

Generative AI

RAG

Cloud Data Warehousing

View More

Tools to Master

excel SQL 1 numpy 2 pandas matplotlib Streamlit BigQuery Microsoft 365 Copilot GitHub Copilot Langchain scikit learn 1 git jupyter 3 n8n 1 Power Query editor 1 python 1 Microsoft Fabric DAX plotly Power BI Snowflake RedShift chatgpt OpenAI API RAG Pandera Shap Tool Image GitHub Pydantic CrewAI Dash

Meet Your Mentors

Curriculum

Live Course Industry Expert

Understand how modern analytics teams collect, transform and use data to solve real-world business problems.

  • Data Analytics lifecycle and industry use cases
  • Structured, semi-structured and unstructured data
  • Databases, warehouses, data lakes and lakehouses
  • Data collection and ingestion fundamentals
  • ETL versus ELT workflows
  • Batch and real-time analytics awareness
  • Roles of Data Analysts, BI Analysts and Data Engineers
  • Translating business problems into analytical questions
  • Python, Jupyter Notebook and VS Code setup
  • Git and GitHub fundamentals
  • AI-assisted analytics using ChatGPT and GitHub Copilot
  • Validating AI-generated analysis and code

Hands-on Activity: AI-Assisted Analysis of a Business Dataset

Download Brochure

Automate business reporting and transform raw operational data into refreshable management insights.

  • Excel tables, structured references and named ranges
  • IF, IFS, IFERROR, SUMIFS, COUNTIFS and AVERAGEIFS
  • XLOOKUP, INDEX-MATCH, FILTER, SORT and UNIQUE
  • Date, text and numerical functions
  • Data validation and error identification
  • Pivot Tables and calculated fields
  • Importing and combining business data
  • Power Query transformations
  • Merging, appending and unpivoting datasets
  • Folder-based data consolidation
  • Refreshable reporting workflows
  • KPI cards and MIS reports
  • AI-generated formulas and insight summaries
  • Microsoft Copilot for business reporting

Hands-on Project: Automated Monthly Sales and MIS Performance Report

Download Brochure

Build advanced SQL and cloud-data skills to prepare reliable, well-structured and AI-ready datasets.

  • Relational databases, data modelling, keys and normalization
  • Advanced SQL with joins, CTEs, subqueries and window functions
  • Data cleaning, validation and handling missing or duplicate records
  • Customer, product and revenue analytics with query optimisation
  • Python and Power BI integration with AI-assisted SQL generation

Cloud Data Warehousing

  • Cloud data-warehouse architecture
  • Microsoft Fabric and Azure Synapse
  • Snowflake, Google BigQuery and Amazon Redshift awareness
  • Loading and querying cloud datasets
  • Connecting Power BI to cloud data platforms
  • Access control and secure data sharing
  • Query-performance and cost awareness

AI-Ready Data Preparation

  • Creating data dictionaries
  • Metadata and semantic tagging
  • Business definitions and metric documentation
  • Preparing clean and well-labelled data for AI use cases
  • Data lineage and traceability awareness
  • PII identification and sensitive-data handling

Hands-on Project: E-commerce Customer and Revenue Intelligence using SQL and Cloud Data

Download Brochure

Use modern Python to clean data, automate analytics and build reusable data applications.

  • Python fundamentals, data structures, functions and programming best practices
  • Modern Python 3.11+, type hints and clean modular coding
  • NumPy and Pandas for data manipulation, transformation and analysis
  • Data cleaning, missing values, duplicates and outlier treatment
  • Working with CSV, Excel, JSON, databases, APIs and external sources
  • EDA, data visualisation and interactive apps using Plotly and Streamlit
  • Data validation, debugging, workflow automation and AI-assisted coding

Hands-on Project: Automated Business Data-Cleaning and Analytics Pipeline

Download Brochure

Apply statistical reasoning and experimentation to validate business decisions and discover meaningful patterns.

  • Descriptive statistics, distributions, percentiles and measures of variability
  • Probability, conditional probability and Bayes’ theorem
  • Sampling, Central Limit Theorem and confidence intervals
  • Hypothesis testing using Z-test, T-test, Chi-square and ANOVA
  • Correlation, multivariate analysis, outlier diagnosis and data-leakage detection
  • A/B testing, control groups, sample-size planning and effect-size analysis
  • AI-assisted EDA, automated insights and stakeholder communication

Hands-on Project: Product Conversion and Customer Engagement A/B Test

Download Brochure

Build enterprise-grade dashboards, governed semantic models and AI-powered self-service analytics solutions.

Power Query

  • Connecting to Excel, CSV, databases and web sources
  • Data profiling and transformation
  • Merging and appending datasets
  • Parameterised and refreshable queries
  • Query dependencies
  • Introduction to M language

Data Modelling and Semantic Layers

  • Fact and dimension tables
  • Star-schema design
  • Relationships and cardinality
  • Filter direction
  • Date tables and hierarchies
  • Measures versus calculated columns
  • Semantic-model fundamentals
  • Governed metrics and reusable business definitions
  • Preparing semantic models for AI and Copilot

DAX

  • SUM, COUNT and DISTINCTCOUNT
  • CALCULATE and FILTER
  • ALL and REMOVEFILTERS
  • DIVIDE and iterator functions
  • Variables and context transition
  • Year-to-date and month-to-date calculations
  • Previous-period comparisons
  • Rolling averages
  • Growth, target and variance analysis

Dashboard and Self-Service Analytics

  • KPI cards, tables and matrices
  • Trend and comparison visualisations
  • Slicers, filters and drill-throughs
  • Tooltips, bookmarks and conditional formatting
  • Mobile-friendly dashboard design
  • Executive and self-service reporting

Power BI Service, Fabric and Copilot

  • Publish and manage reports through Power BI workspaces and applications
  • Configure scheduled refresh, gateways, sharing and row-level security
  • Use Microsoft Fabric, usage metrics and collaboration features
  • Create Copilot-assisted DAX, report summaries and validated AI insights

Hands-on Project: Executive Revenue, Customer and Profitability Dashboard

Download Brochure

Translate data into business actions across finance, marketing, product, sales and operations.

Business Problem-Solving

  • Understanding stakeholder objectives
  • Converting requirements into analytical questions
  • KPI and metric-tree design
  • Leading and lagging indicators
  • Root-cause analysis
  • Prioritising analytical workloads
  • Avoiding vanity metrics
  • Turning insights into recommendations

Financial Analytics

  • Revenue, cost and profitability
  • Gross and contribution margin
  • Budget-versus-actual analysis
  • Variance analysis
  • Financial-performance reporting

Marketing and CRM Analytics

  • Leads, contacts, accounts and opportunities
  • CRM data and sales-pipeline stages
  • Lead lifecycle and conversion funnels
  • Impressions, clicks and conversion rates
  • CPL, CPA, CAC and ROAS
  • Channel and campaign performance
  • Attribution awareness
  • CRM data-quality issues

Product and Customer Analytics

  • Activation, engagement and retention
  • Customer churn
  • Cohort analysis
  • Customer lifetime value
  • Feature adoption and user funnels

Operations and Supply-Chain Analytics

  • Inventory turnover and stock-outs
  • Fulfilment and SLA analysis
  • Supplier performance
  • Demand and operational trends

Data Storytelling

  • Selecting the right visual
  • Observation versus interpretation
  • Insight versus recommendation
  • Executive narratives and management summaries
  • Presenting uncertainty and risk
  • AI-assisted insight writing

Hands-on Project: Executive Business Performance Review and Recommendation Deck

Download Brochure

Use practical Machine Learning to predict business outcomes, identify risks and improve decision-making.

  • Predictive analytics workflow, problem framing, training and testing datasets
  • Linear and logistic regression, decision trees and random forests
  • K-means clustering, customer segmentation and propensity modelling
  • Purchase prediction, churn-risk scoring and business risk analysis
  • Trend, seasonality, lag features and sales or demand forecasting
  • Model evaluation using precision, recall, F1-score, MAE, RMSE and R-squared
  • Feature importance, SHAP, overfitting awareness and responsible model interpretation

Industry Project Options

  • Customer Churn and Retention Prediction
  • Lead-Conversion Propensity Model
  • Customer Segmentation
  • Sales and Demand Forecasting
  • Credit or Operational Risk Analysis
Download Brochure

Use Generative AI to automate analysis, generate business insights and build intelligent analytics applications.

  • Generative AI, LLM fundamentals, tokens, context windows and model limitations
  • Zero-shot, few-shot and structured prompting with reusable analyst templates
  • AI-assisted Excel, SQL, Python and DAX generation with output validation
  • Automated data-quality checks, EDA, root-cause analysis and executive summaries
  • OpenAI API integration, structured JSON outputs and secure API-key management
  • LangChain and basic RAG for citation-backed business-document analysis
  • AI evaluation, hallucination testing, privacy, cost control and Responsible AI

Hands-on Project: AI-Powered Business Analytics Copilot with OpenAI APIs

Download Brochure

Build intelligent analytics agents and automated workflows that can plan, use tools and complete multi-step analytical tasks.

  • AI agents versus chatbots and copilots, including core agent architecture
  • Planning, task decomposition, memory, tools and feedback loops
  • Function calling and API integration for SQL, Python and file-based agents
  • LangChain agents, CrewAI fundamentals and multi-agent system concepts
  • Workflow automation using n8n, triggers and scheduled reporting
  • Human approvals, conditional execution, retries and fallback strategies
  • Agent guardrails, controlled execution, evaluation, tracing and observability

Hands-on Project: Agentic Data Analytics Assistant and Automated Reporting Workflow

Download Brochure
View More
Disclaimer
Intellipaat reserves the right to update the curriculum based on industry and employability needs.

Program Highlights

620 Hrs of Applied Learning
90+ Live Sessions Over 11 Months
218 Hrs of Self-Paced Learning
24*7 Support

Projects

Reviews

(5)

Career Services By Intellipaat

Career Services
guaranteed
3 Guaranteed Interviews upon movement to Placement Pool
job portal
Exclusive access to Intellipaat Job portal
Mock Interview Preparation
1 on 1 Career Mentoring Sessions
resume 1
Career Oriented Sessions
linkedin 1
Resume & LinkedIn Profile Building
View More

Experience Campus Immersion at iHub IIT Roorkee & Build Formidable Networks With Peers & IIT Faculty

Campus Immersion at iHub IIT Roorkee Desktop Image

Our Alumni Works At

Hiring Partners

Admission Details

The application process consists of three simple steps. An offer of admission will be made to selected candidates based on the feedback from the interview panel. The selected candidates will be notified over email and phone, and they can block their seats through the payment of the admission fee.

ad submit

Submit Application

Tell us a bit about yourself and why you want to join this program

ad review

Application Review

An admission panel will shortlist candidates based on their application

ad admission 1

Admission

Selected candidates will be notified within 1–2 weeks

Program Fee

Total Admission Fee

₹ 90,000 (Inclusive of All)

Apply Now

EMI Starts at

₹ 5,500

We partnered with financing companies to provide very competitive finance options at 0% interest rate

Financing Partners

dk-fee-emi-logo

The credit facility is provided by a third-party financing company and any arrangement with such financing companies is outside.

Upcoming Application Deadline 8th Aug 2026

Admissions close once the required number of students is enrolled for the upcoming cohort. Apply early to secure your seat.

Program Cohorts

Next Cohorts

Date Time Batch Type
Program Induction 8th Aug 2026 08:00 PM - 11:00 PM IST Weekend (Sat-Sun)
Regular Classes 8th Aug 2026 10:00 AM - 01:00 PM IST Weekend (Sat-Sun)
Apply Now

Other Cohorts

Others Cohorts

Date Time Batch Type
Program Induction 11th Aug 2026 07:00 AM - 09:00 AM IST Weekday (Tue-Fri)
Apply Now

Frequently Asked Questions

How will I receive my certificate?

After completing the required projects, and quizzes, you will receive a joint certificate from Intellipaat and iHUB DivyaSampark.

Intellipaat offers career services that include 3 guaranteed interviews for all learners enrolled in this course upon movement to the placement pool. Learners will be moved to the placement pool once they clear the PRT (Placement Readiness Test).

The Executive Post Graduate Certification in Data Analytics from iHUB DivyaSampark and Intellipaat is taught by Industry experts & IIT faculty. Its AI-first curriculum covers Advanced Excel, SQL, Python, Power BI, cloud data warehousing, statistics, business analytics, predictive modeling, Generative AI, RAG, Agentic AI, and workflow automation through hands-on projects.

The program combines live learning, real-world projects, career support, and campus immersion. Top performers may receive a monthly stipend, while eligible startup ideas may be considered for incubation and funding by iHUB DivyaSampark.

All candidates applying for this course are eligible for equity-based seed funding and incubation support from iHUB DivyaSampark, IIT Roorkee, for their startup ideas. Eligible learners may pitch their startup ideas. Selected proposals may receive equity-based funding of up to ₹50 lakh, subject to iHUB DivyaSampark’s evaluation and terms.

Additionally, candidates who are currently enrolled in a degree program and have their startup idea approved may also receive a monthly fellowship/scholarship of ₹8,000 during the early phase of their project to encourage and support innovation.

If you are unable to attend one of the live lectures, you will receive a copy of the recorded session within the next 12 hours. If you have any further questions beyond that, you can contact our course advisors or ask them in our community.

To be included in the placement pool, the learner must complete the course and submit all projects and assignments. He/she must then pass the PRT (Placement Readiness Test) to be accepted into the placement pool and gain access to our job portal and career mentoring sessions.

You will undergo the following sessions:

  • Job search strategy sessions
  • Creation of a resume
  • Creation of a LinkedIn profile
  • Preparation for interviews by industry experts
  • Mock interviews
  • Placement opportunities with more than 3100+ hiring partners after passing the employment test.

Please note that the course fee is non-refundable and we will be at every step with you for your upskilling and professional growth needs.

Yes, Intellipaat certification is highly recognized in the industry. Our alumni work in more than 10,000 corporations and startups, which is a testament that our programs are industry-aligned and well-recognized. Additionally, the Intellipaat program is in partnership with the National Skill Development Corporation (NSDC), which further validates its credibility. Learners will get an NSDC certificate along with Intellipaat certificate for the programs they enroll in.

The total duration of the program is 11 months and out of which 2 months will be for project work.

  • Non-biased career guidance
  • Counselling based on your skills and preference
  • No repetitive calls, only as per convenience
  • AI-first curriculum designed by industry experts
  • Complete this program while you work

AI-assisted coding helps data analysts work more efficiently by generating SQL queries, Python scripts, Excel formulas, Power BI DAX measures, and data visualizations faster. In this program, you’ll learn how to use tools like ChatGPT, GitHub Copilot, and Microsoft Copilot while validating AI-generated outputs using industry best practices.

Yes. Along with core Data Analytics concepts, you’ll learn Generative AI, Retrieval-Augmented Generation (RAG), OpenAI APIs, LangChain, AI-powered analytics assistants, and Agentic AI workflows. You’ll also build intelligent analytics solutions that automate reporting, data analysis, and business decision-making.

AI enables Data Analysts to automate repetitive tasks, generate insights faster, build predictive models, create intelligent dashboards, and answer business questions using natural language. By combining analytics skills with AI, professionals can solve complex business problems more efficiently and deliver greater business value.

Yes. The curriculum includes 50+ industry projects and case studies, where you’ll build AI-powered business analytics solutions using Python, SQL, Power BI, OpenAI APIs, LangChain, RAG, and Agentic AI workflows across domains such as e-commerce, finance, CRM, marketing, and operations.

After completing this program, you can pursue roles such as Data Analyst, Business Analyst, Business Intelligence Analyst, Analytics Engineer, Product Analyst, Marketing Analyst, and Predictive Analytics Analyst. The addition of Generative AI and Agentic AI skills also prepares you for emerging AI-enabled analytics roles.

View More

What is included in this course?

  • Non-biased career guidance
  • Counselling based on your skills and preference
  • No repetitive calls, only as per convenience
  • Rigorous curriculum designed by industry experts
  • Complete this program while you work