• Program Duration

    8 months

  • Learning Format

    Live, Online, Interactive

Why Join this Program

  • icons
    IHFC, TIH of IITD Certificate

    Earn certification and attend exclusive masterclasses led by IHFC, TIH of IITD faculty.

    Earn certification and attend exclusive masterclasses led by IHFC, TIH of IITD faculty.

  • icons
    Hands-On Project Learning

    Build job-ready skills through 40+ exercises, 15+ projects, and a mentor-led capstone.

  • icons
    Data & AI Tools Mastery

    Learn Excel, SQL, Python, Power BI, R, Azure, and GenAI tools like ChatGPT and Claude.

  • icons
    Job Assist Plus Advantage

    Resume reviews, profile optimization, and mock interviews via Job Assist Plus.

Corporate Training

Enroll your employees into this program, NOW!

Program Overview

Master AI-powered analytics using Excel, SQL, Python, R, Power BI, and Azure. Gain hands-on experience through projects and masterclasses in Generative AI, Agentic AI, and Adaptive Systems. Build real-world skills to design and deploy intelligent data solutions.

Key Features

  • Earn a certificate from IHFC, Technology Innovation Hub of IIT Delhi
  • Attend a 2-day campus immersion at IIT-Delhi
  • Access 180+ hours of structured learning through live classes and hands-on projects.
  • Use GenAI tools like ChatGPT and Gemini for analytics tasks such as forecasting and summarization.
  • Gain end-to-end analytics capabilities including data prep, modeling, visualization, GenAI, and adaptive systems.
  • Apply statistical techniques like regression and clustering using R programming and visualizations.
  • Learn to design autonomous workflows in a dedicated industry-led masterclass on Agentic AI.
  • Build job-ready skills with Excel, SQL, Python, R, Tableau, Power BI, AWS Glue, Microsoft Azure, and more.

Post Graduate Program Advantage

Build expertise in data analytics and GenAI. This structured learning path blends core tools with emerging AI skills, preparing you to solve real-world problems with confidence and industry relevance.

  • University Certificate

    Program Certificate

    • Receive a completion certificate from the IHFC, TIH of IIT Delhi
    • Masterclasses from IHFC-associated faculty, researchers, and startup leaders from IHFC’s Co-Innovation Centers
    • 2-day immersive campus experience at IIT Delhi
  • Microsoft Certificate

    Microsoft Certificate

    • Get the official badge of completion for MS Azure Data Fundamentals on the Microsoft Learn Portal
    • Acquire an official Microsoft learning path completion transcript

Program Details

Master Excel, SQL, Python, ETL, and Tableau. Advance to Generative AI, Agentic AI, and Adaptive Systems. Build real-world skills to lead in the evolving Data and AI landscape.

Learning Path

  • IHFC DA - Program Induction

    Get started with this Data Analytics, GenAI and Adaptive Systems program in partnership with IHFC – TIH of IIT Delhi.

  • IHFC DA - Business Analytics with Excel
    • Introduction to Business Analytics 
    • Excel in Business Analytics
    • Conditional Formatting and Essential Functions
    • Statistical Data Analysis
    • Analysis With Pivot Tables
    • Dashboard Creation
    • Power BI
  • IHFC DA - Data Acquisition and Manipulation using SQL
    • Fundamental SQL Statements 
    • Database Restoration and Back-Up
    • Filtering With Selection Commands 
    • Ordering in Selection Commands
    • Understanding Joins
    • Execution of Subqueries
    • Usage of Views & Indexes
  • IHFC DA - Extract, Transform, and Load (ETL)
    • ETL Fundamentals 
    • Data Extraction
    • Data Transformation 
    • Data Mapping and Conversion
    • ETL Tools and Technologies 
    • Data Loading
    • Batch and Real-Time ETL 
    • Error Handling and Logging
    • Performance Optimization 
    • Automation
    • Monitoring and Maintenance
  • IHFC DA - Data Visualization using Tableau
    • Introduction to Data Visualization
    • Data Organization in Tableau
    • Creating Charts and Dashboards
    • Working with Filters, Parameters, and Sets
    • Heat Maps, Treemaps, and Pareto Charts
    • Designing Interactive Dashboards
  • IHFC DA - Fundamentals of Python Programming
    • Programming Fundamentals 
    • Python Data Types and Operators
    • Conditional Statements and Loops in Python
    • Introduction to Python
    • Python Functions
  • IHFC DA - Data Analytics with Python
    • Python Packages for Data Analytics 
    • Categorical Data and Working With Text Data
    • Hypothesis Testing Mechanism 
    • Statistical Functions
    • Explorative Data Analysis (EDA) 
    • Data Visualization
  • IHFC DA - GenAI Literacy
    • Machine Learning and Generative AI Basics
    • Types of Machine Learning: Supervised, Unsupervised and Reinforcement Learning
    • Generative AI Algorithms: Neural Networks, GANs, Transformers
    • Large Language Models and Chatbots
    • Image Generation: GANs, Diffusion Models, VAEs & Hands-on Tools 
    • Video Generation: Architectures & Hands-On Tools
    • Open-Source AI Model Landscape: Hugging Face and AI Marketplaces
    • Prompt Engineering: Chatbot Prompts, OpenAI Playground, Image Generation Prompts
  • IHFC DA - Applications of Generative AI in Data Analytics
    • Overview of Generative AI in Data Analytics 
    • Data Augmentation Using Generative AI
    • Generative AI for Tailored Data Visualization 
    • Generative AI in Data Exploration
    • AI-Optimized ETL Processes 
    • Generative AI in Data Modeling and Forecasting
    • Challenges in Integrating Generative AI 
    • Future Directions in Generative AI
  • IHFC DA - Data Ethics
    • Introduction to Data Ethics
    • Legal and Regulatory Frameworks
    • Data Privacy and Security Protocols
    • Bias in Data and Algorithms
    • Ethical Decision-Making in Analytics
    • Responsible Data Visualization
    • Societal Implications of Data Analytics
  • IHFC DA - Capstone Project

    After completing the DA and GenAI courses, you undertake a capstone project to put your new skills into action. With mentor support, you utilize Excel, Python, SQL, Tableau, and other tools to address real-world data challenges. This culminating project represents the pinnacle of your training and offers a chance to demonstrate your expertise to potential employers in a practical context.

Electives:
  • IHFC DA - Academic Masterclass by IHFC on Adaptive Systems Applications and Robotics

    Led by IHFC - TIH of IIT Delhi associated faculty, this masterclass explores how adaptive systems respond to changing environments and uncertainty. Through a mix of theory and hands-on sessions, you’ll learn control strategies, software adaptation, and real-world applications in aerospace, robotics, and industrial systems, equipping you to design and deploy robust, adaptive solutions.

  • IHFC DA - Industry Masterclass on Agentic AI Systems for Analytics

    This masterclass explores agentic AI systems in analytics, focusing on designing autonomous agents that gather, process, and act on data. Learn to automate tasks like data prep, feature selection, anomaly detection, and real-time insights. With hands-on demos and case studies, you'll build ethical agentic solutions for predictive modeling and self-driving analytics, while staying updated on trends in autonomous decision-making.

  • IHFC DA - Data Storytelling using Power BI

    This course equips you with the skills to perform advanced data analysis and create interactive dashboards using Power BI. You'll learn to address business challenges by building responsive dashboards, leveraging Quick Insights, and utilizing natural language Q&A for actionable visualizations. The program also covers best practices in report design, setting up data alerts, and resolving common issues, enabling you to optimize workflows and deliver impactful, data-driven narratives.

  • IHFC DA - Data Analytics with R programming

    ChatGPT said: This course introduces R, a key language in data science and analytics. Learn to set up R, RStudio, and essential packages while building skills in programming, data wrangling, and visualization. Master core statistical concepts, hypothesis testing, regression models, and clustering techniques to unlock R’s full potential for actionable insights.

  • IHFC DA - Microsoft Azure Data Fundamentals

    This course covers key data concepts and Microsoft Azure’s data services, including relational/non-relational databases, big data, and analytics. You'll explore Azure’s storage solutions, Cosmos DB, data warehousing, real-time analytics, and visualization—gaining the skills to manage and analyze data efficiently on the Azure platform.

Contact Us

1-844-532-7688

(Toll Free)

14+ Skills Covered

  • Generative AI
  • Data Ethics
  • Data Analytics
  • Data Storytelling
  • SQL
  • Python
  • ETL
  • Statistical Analysis
  • Data Visualization
  • Data Analytics Using Python
  • Prompt Engineering
  • Data Transformation
  • Agentic AI
  • Adaptive Systems

13+ Tools Covered

Microsoft ExcelNumPypythonSQLpandasMatPlotlibRtableauPowerBIJUPYTERAWSHugging FaceChatGPT

Industry Projects

  • Project 1

    SQL Based Employee Performance Mapping Solution

    Create a SQL-based system to map employee performance, run queries, and track productivity for HR insights.

  • Project 2

    Air Cargo Analysis with SQL

    Use SQL to optimize routes, identify loyal customers, and analyze ticket sales for an aviation company.

  • Project 3

    Personal Expense Tracker App Development Using Python

    Build a Python app to log, categorize, and track daily expenses against budget with save/load functionality.

  • Project 4

    Data Manipulation and Reporting with Power BI

    Create an interactive Power BI dashboard to analyze Zomato’s restaurant data, ratings, and performance.

  • Project 5

    Analyzing Crime Trends Using Tableau

    Design Tableau dashboards to map crime data, detect trends, and support law enforcement decisions.

  • Project 6

    Regional Sales Analysis Using Tableau

    Build interactive Tableau dashboards to visualize and compare sales data from two business regions.

  • Project 7

    Designing a Sales Dashboard in Excel

    Use Excel to analyze store performance and present insights through charts, KPIs, and dashboards.

  • Project 8

    Predicting Restaurant Tips

    Apply regression techniques to predict tip amounts using customer and meal data in a real dataset.

  • Project 9

    Project Sales Analysis

    Transform business data into actionable sales insights using analytics and visualization techniques.

  • Project 10

    Marketing Campaigns

    Use EDA and hypothesis testing to understand how the marketing mix influences customer acquisition.

  • Project 11

    Retail Data Management

    Use AWS Glue to extract and transform retail data, build ETL workflows, and derive product insights.

  • Project 12

    Social Media Data Integration and Analysis Using AWS Glue

    Streamline and analyze Twitter and blog data using AWS Glue to uncover sentiment and trend insights.

  • Project 13

    Anomaly Detection in Credit Card Transactions

    Build a fraud detection system to flag suspicious transactions using behavior and pattern analysis.

  • Project 14

    Patient Readmission Prediction

    Analyze patient data to identify high-risk cases and support proactive readmission prevention.

Disclaimer - The projects have been built leveraging real publicly available datasets from organizations.

prevNext

An Immersive Learning Experience

Peer to Peer engagement

Get the real classroom experience. Interact with learners and engage with mentors in real-time via Slack.

Flexi Learn

Missed a class? Access recordings to always maintain learning progress and keep up with your cohort.

Mentoring session(s)

Expert guidance sessions from mentors for doubt clarifications, project assistance, and learning support.

Learning Support

Get a dedicated Cohort Manager for all your queries and help you succeed at every learning step.

Peer to Peer engagement
Get the real classroom experience. Interact with learners and engage with mentors in real-time via Slack.
Flexi Learn
Mentoring session(s)
Learning Support

Program Advisors and Trainers

Program Advisors

  • Prof. Sayan Ranu

    Prof. Sayan Ranu

    Department of Computer Science and Eng, IIT Delhi

    Prof. Sayan Ranu holds the position of Nick McKeown Chair Professor in CSE and Yardi School of AI. His research interests span the areas of machine learning for graphs and spatio-temporal data analytics.

  • Mr. Ashutosh Dutt Sharma

    Mr. Ashutosh Dutt Sharma

    CEO, IHFC, TIH of IIT Delhi

    Ashutosh is the CEO of IHFC, the TIH of IIT Delhi, building an ecosystem for Collaborative Robotics in India under DST, Govt. of India. With nearly two decades of experience in Electronics, Telecom, Internet, and IT, he has worked with Samsung, Bharti Airtel, and IndiaMart.

  • Prof. Subir Kumar Saha

    Prof. Subir Kumar Saha

    Project Director, IHFC, TIH of IIT Delhi

    Prof. Saha, a renowned robotics expert, is the author of Introduction to Robotics, President of the Association of Machines and Mechanisms since 2023, creator of RoboAnalyzer software, and founder of the Mechatronics Lab, with decades of global teaching and research.

prevNext

Program Trainers

  • Mohammed Sadiq

    Mohammed Sadiq

    20+ years of experience

    Corporate trainer

  • Prashant Nair

    Prashant Nair

    15+ years of experience

    AI Quantum Researcher and Corporate Trainer

  • Shubam Pandey

    Shubam Pandey

    12+ years of experience

    CEO- Learners Galaxy

prevNext

Industry Trends

Businesses are racing to unlock smarter insights, automate decisions, and lead with innovation. The future hence belongs to professionals who can harness data and drive intelligent decision-making.

Job Icon$924.3 bn

Expected Global Big Data Analytics Market Size by 2032

Source: Fortune Business
Job Icon35% CAGR (2025-2030)

Expected market size growth for Data & Gen AI in India

Source: Grand View Research
Job Icon$393.35 bn by 2032

Global data analytics to surpass $393.35 billion by 2032, with a 29.4% CAGR

Source: Precedence Research

Batch Profile

This program caters to working professionals from a variety of industries and backgrounds; the diversity of our students adds richness to class discussions and interactions.

  • Industry
    The class consists of learners from excellent organizations and diverse industries
    Industry
    Information Technology - 35%Software Product - 29%BFSI - 15%E-commerce - 9%Others - 12%
    Companies
    Google
    Amazon
    Deloitte
    Apple
    Accenture
    Bosch
    Unilever
    LinkedIn
    EY
    Deutsche WertpapierService Bank AG

Admission Details

Application Process

The application process consists of three simple steps. An offer of admission will be made to the selected candidates and accepted by the candidates by paying the admission fee.

STEP 1

Submit Application

Briefly outline your education and professional experience

STEP 2

Reserve Your Seat

Complete your payment to reserve your admission

STEP 3

Start Learning

Selected candidates can begin the program as per cohort date

Eligibility Criteria

For admission to this Data Analytics Program, candidates should have:

A bachelor's degree with an average of 50% or higher marks
Are encouraged to have prior work experience, but not mandatory
Don't need prior coding experience or technology know-how

Apply Now

Program Benefits

  • Certificate from the IHFC, TIH of IIT Delhi
  • 2-day on-campus immersion at IIT-Delhi
  • Exposure to ChatGPT, Hugging Face, Jupyter Notebook & others
  • Work on 15+ industry projects and a mentor-guided capstone
  • Attend masterclasses on Adaptive Systems and Agentic AI

Related Programs

  • Acknowledgement
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.