Indian Institute of Technology Kanpur

Data Analytics

Indian Institute of Technology Kanpur

Data Science & Analytics

Application Deadline Approaching

Last date to apply: November 4, 2026 · Program starts on November 5, 2026

About Programme

Learn Statistics, Excel, SQL, Python, and Data Visualisation for a Career in Data Analytics in 36 Live Sessions

Certification on successful completion of the program.
Live instructor-led sessions with real-time doubt solving and feedback.
Complete data analytics training covering statistics, Excel, SQL, Python, and data visualisation tools in one structured program.
Hands-on assignments and a final project to build a job-ready data analytics portfolio.

What you'll learn

Understand the data analytics lifecycle, types of analytics, career paths, and the tools and technologies used across the industry.
Apply core statistical concepts including mean, median, standard deviation, probability distributions, hypothesis testing, correlation, regression, and A/B testing to real data problems.
Use advanced Excel features including Power Query, Power Pivot, pivot tables, VLOOKUP, and INDEX-MATCH for data cleaning, preparation, and analysis.
Write SQL queries to extract, filter, join, and aggregate data from relational databases and apply window functions and CTEs for advanced data manipulation.
Use Python with NumPy and Pandas to clean, manipulate, and preprocess datasets, work with APIs, perform web scraping, and handle CSV, Excel, and JSON files.
Build compelling data visualisations using Matplotlib, Seaborn, and Plotly, and apply dashboard design principles and data storytelling techniques to communicate insights effectively.

Skills you'll gain

Data Analytics Lifecycle UnderstandingStatistical Analysis and Hypothesis TestingAdvanced Excel and Power QuerySQL and Database ManagementPython for Data AnalysisNumPy and PandasData Visualisation with Matplotlib, Seaborn, and PlotlyDashboard Design and Data StorytellingData Cleaning and PreprocessingAPI Integration and Web Scraping

Programme Content

Topics Covered

  • What is Data Analytics
  • Types of Analytics – Descriptive and Predictive
  • Data Analytics Lifecycle
  • Career Paths and Industry Overview
  • Tools and Technologies Overview

    • Download Full Curriculum

    Topics Covered

  • Mean, Median, Mode, and Standard Deviation
  • Probability and Distributions
  • Hypothesis Testing
  • Correlation and Regression
  • A/B Testing and Statistical Inference

    • Download Full Curriculum

    Topics Covered

  • Data Cleaning and Preparation
  • Advanced Formulas – VLOOKUP, INDEX-MATCH
  • Pivot Tables and Charts
  • Power Query and Power Pivot
  • Advanced Excel Techniques

    • Download Full Curriculum

    Topics Covered

  • SQL Basics – SELECT, WHERE, ORDER BY
  • Joins and Aggregate Functions
  • Subqueries and CTEs
  • Window Functions
  • Database Design and Normalisation

    • Download Full Curriculum

    Topics Covered

  • Python Basics
  • NumPy for Numerical Computing
  • Pandas for Data Manipulation
  • Data Cleaning and Preprocessing
  • Working with APIs and Web Scraping
  • File Handling – CSV, Excel, JSON

    • Download Full Curriculum

    Topics Covered

  • Principles of Data Visualisation
  • Matplotlib and Seaborn in Python
  • Interactive Visualisations with Plotly
  • Dashboard Design Principles
  • Storytelling with Data

    • Download Full Curriculum

    Program Certificate

    Earn a career certificate

    Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

    Other programs in this subject area you might find useful

    Same topic, Similar duration - Broader exploration across all institutes

    Contact us for the further details

    Speak with an Advisor

    1. Pedagogy (case method, experiential learning, coaching, simulations)
    2. Target Audience
    3. Programme Objective
    4. Faculty Information
    5. Testimonials
    6. Programme Benefits
    7. Brochure

    Prashansa Uttam

    Programme Advisor

    +91 9403890085contact@echomind.oneMon – Fri, 9am – 5pm IST

    Indian Institute of Technology Kanpur

    Executive Education Office

    NA
    NA
    NA
    https://www.iitk.ac.in
    Kanpur, India

    Tell us about your program enquiry

    Fill out the form below and our team will get back to you within 24 hours.

    Data Analytics | IIT Kanpur