• Learning Format Self-Paced Learning

Why Join this Program

IITG Advantage

Earn an Executive Alumni Status and campus immersion at IIT Guwahati upon program completion

IBM's Industry Prowess

Earn industry-recognized certificates for IBM courses and attend masterclasses by experts from IBM

Applied Learning Approach

Gain practical experience with hands-on projects and 15+ tools with access to integrated labs

Leverage Career Assistance

Build your professional profile with resume assistance and highlight your profile to recruiters.

FOR ENTERPRISE

Looking to enroll your employees into this program ?

Generative AI Data Analytics Overview

Amidst data abundance, businesses today are leveraging analytics and AI for operational efficiency and innovation. This Generative AI and Data Analytics program equips learners with in-demand skills in data analytics and generative AI. It covers key tools and concepts like Excel, SQL, Python, exploratory data analysis, ETL, Tableau, and more.

Key Features

  • Certificate of program completion from the E&ICT Academy at IIT Guwahati
  • Curriculum delivered in live online classes by experienced industry veterans
  • Best-in-class training on GenAI and its diverse applications in the analytics domain
  • Exposure to ChatGPT, Claude, Gemini, and other prominent GenAI tools
  • Academic masterclasses delivered by IIT Guwahati faculty
  • Opportunity to earn an 'Executive Alumni Status' from E&ICT Academy, IIT Guwahati
  • Eligibility for a campus immersion program organized at IIT Guwahati
  • Exclusive hackathons and “ask-me-anything” sessions by IBM
  • Certificates for IBM courses and industry masterclasses by IBM experts
  • Practical learning through 20 hands-on projects and 3 capstone projects

Generative AI Data Analytics Advantage

This program leverages the academic prowess of the E&ICT Academy at IIT Guwahati in data and AI. Achieve expertise in data analytics and generative AI to propel your career forward.

  • Program Certificate

    E&ICT Academy, IIT Guwahati

    • E&ICT Academy, IIT Guwahati, will issue the program certificate directly within 90 days of program completion
    • Academic masterclasses conducted by distinguished faculty from IIT Guwahati
    • Become eligible for a campus immersion program at IIT Guwahati
  • IBM Certificate

    A Game-Changing IBM Collaboration

    • Industry-recognized certificates for IBM courses
    • Industry masterclasses by IBM experts
    • Ask Me Anything sessions and Hackathons

Generative AI Data Analytics Details

The Professional Certificate Program in Data Analytics and Generative AI offers a comprehensive curriculum covering in-demand topics like Excel, SQL, ETL, Python, Tableau, PowerBI, Generative AI, and data ethics. Acquire real-world skills and boost your analytics career.

Learning Path

  • Get started with this Data Analytics & Generative AI program and explore everything about this unique learning expedition. In this introductory course, you'll explore the program's structure, curriculum, and learning outcomes. Understand what lies ahead and how this program can propel you toward your professional goals.

    • Grasp the crucial importance of business analytics
    • Harness Excel functions and formatting for analytics
    • Perform data analysis through pivot tables
    • Design impactful dashboards
    • Employ Excel for effective business analytics
    • Excel in statistical data analysis
    • Acquire vital Power BI skills
    • Grasp database structures and relationships
    • Proficient in SQL commands and queries
    • Master transactions, table creation, view management
    • Execute complex operations with stored procedures
    • Expertise in SQL fundamentals: filtering, joins, subqueries
    • Explore SQL functions: strings, math, date/time
    • Manage user access for robust database security
    • Master ETL basics for data analysis
    • Extract structured/unstructured data incrementally
    • Define transformation rules
    • Load data into repositories
    • Differentiate batch vs. real-time ETL
    • Implement real-time processing
    • Optimize using parallel processing
    • Schedule, monitor ETL workflows
    • Attain Tableau visualization expertise
    • Prioritize data organization for insightful visuals
    • Learn combo charts, stories, filters, parameters, sets
    • Master creating interactive dashboards
    • Apply a practical approach to informed decision-making
    • Gain proficiency in procedural and object-oriented Python
    • Install and navigate Jupyter
    • Grasp data types, loops, scope, OOP principles, methods, attributes, threading
    • Understand Python's benefits and use cases
    • Master data acquisition through APIs
    • Handle databases using SQL and Python
    • Learn fundamental statistics
    • Understand probability distributions
    • Explore advanced statistical analysis
    • Perform statistical analysis with Python
    • Execute hypothesis testing techniques
    • Conduct correlation and regression analysis
    • Perform time series analysis
    • Conduct ANOVA & Chi-square tests
    • Master Python for data analysis
    • Import, clean, and prepare datasets
    • Summarize data and create ML models with scikit-learn
    • Construct efficient data pipelines
    • Explore data visualization using Matplotlib, Seaborn, Folium
    • Grasp AI fundamentals and Generative AI models
    • Understand the significance of explainable AI
    • Apply prompt engineering for Generative AI control
    • Comprehend ChatGPT mechanisms, features, limitations
    • Explore ChatGPT applications and use cases
    • Learn ChatGPT fine-tuning techniques
    • Recognize ethical issues in Generative AI and ChatGPT
    • Gain insights into future Generative AI challenges
    • Grasp Generative AI in data analytics
    • Uncover insights and anomalies with Generative AI
    • Enhance ETL with AI for data transformation
    • Forecast trends and simulate scenarios using AI
    • Identify AI integration challenges in data projects
    • Recognize future trends: Quantum computing, ethical AI
    • Understand the core relevance of data ethics
    • Comprehend GDPR and CCPA in legal frameworks
    • Explore data privacy and informed consent
    • Emphasize data security and access prevention
    • Prioritize transparency and accountability
    • Study bias and fairness in data and algorithms
    • Learn ethical decision-making in real-world scenarios
    • Apply ethics in data visualization
    • Examine ethics in ML and AI development
  • The capstone project culminates your immersive learning journey, delving into data preparation, data manipulation, data visualization, ETL, and programming. Apply your new skills in Excel, Python, SQL, Tableau, and more to a real-world project by solving data-related challenges.

Electives:
    • Acquire skills in modeling and solving optimization problems
    • Understand basics: data, decision variables, objective functions, constraints
    • Explore solution types and mathematical programming techniques
    • Master the fundamentals of optimization modeling
    • Analyze data for business insights using Power BI
    • Craft interactive dashboards for informed decisions
    • Improve operational efficiency
    • Develop dashboards from published reports
    • Use Quick Insights for rapid data pattern discovery
    • Apply practical approaches within Power BI
    • Excel in R programming
    • Develop data import/export skills in R
    • Utilize Apply and DPLYR functions for data manipulation
    • Proficient in R graphics for visualization
    • Apply regression and classification in R
    • Learn Apriori and clustering techniques
  • Attend online interactive masterclasses delivered by IIT Guwahati faculty. Gain insights about technological advancements and techniques in the rapidly evolving field of Data Analytics and Generative AI.

  • Attend online interactive masterclasses delivered by industry leaders from IBM. These masterclasses will equip you with the skills to give your organization a competitive advantage in any industry by using data to make decisions, extract business insights, and predict future trends.

Skills Covered

  • Generative AI
  • Prompt Engineering
  • Data Analysis with Python
  • Data Analytics using R
  • Data Visualization with Tableau
  • Data Storytelling with Power BI
  • Extract Transform and Load
  • Statistical Analysis using Excel
  • SQL
  • Building Data Pipelines
  • Regression Analysis
  • Time Series Analysis
  • Supervised Learning
  • Unsupervised Learning

Tools Covered

Microsoft ExcelSQLpythonRScikitLearnNumPypandastableauPowerBIChatGPTJulius.aiGeminiInvideo.aiUizardZapier

Industry Projects

  • Project 1

    Create a Virtual Assistant with Generative AI

    Develop a conversational chatbot that can engage in meaningful dialogues, answer questions, provide recommendations, and assist with tasks based on the documents fed as input.

  • Project 2

    Employee Performance Mapping

    Utilize an SQL database to map employee performance and construct reports for their appraisals.

  • Project 3

    Air Cargo Analysis with SQL

    Leverage SQL to generate reports using historical airline data to enhance services and improve customer experience.

  • Project 4

    Crime Analysis with Tableau Dashboard

    Prepare a dashboard to keep the police department and the city updated on the statistics of crime events. You are required to create a dashboard and a visual story using Tableau.

  • Project 5

    Creation of an Interactive Sales Dashboard

    Create an interactive Sales Dashboard in Tableau for an apparel OEM, which the Sales department can use for ad-hoc analysis and reporting.

  • Project 6

    Develop Ecommerce Application with Python

    Develop an e-commerce app using Python platform that could categorize, add or remove items from the cart and support different payment options.

  • Project 7

    Build an Online Car Rental Platform

    Create an online car rental platform integrating scheduling and billing features, leveraging object-oriented programming techniques

  • Project 8

    Flight Delay Analysis and Visualization

    Analyze and visualize flight delays and their relationship with weather using histograms, scatter plots, box plots, and pie charts and help improve the airport performance.

  • Project 9

    Data Manipulation and Reporting with Power BI

    Create an interactive Power BI report for Zomato to analyze the restaurants’ data globally and drill down by location, service, rating, cost, and cuisine.

  • Project 10

    Sales Analysis using Python

    Analyze sales data to identify top revenue states and create sales programs for underperforming areas. Clean, analyze, and visualize data using Jupyter for data-driven decisions.

  • Project 11

    Sales Dashboard on Product Categories

    Create a sales dashboard to analyze trends by product category. Users can select a category to view detailed trends and product-wise sales data, enhancing data-driven insights.

Disclaimer - The projects have been built leveraging real publicly available data-sets of the mentioned organizations.

prevNext

Program Advisors and Trainers

Program Advisors

  • Dr. Gaurav Trivedi

    Dr. Gaurav Trivedi

    Associate Professor, EEE and Principal Investigator, E&ICT Academy, IIT Guwahati

    With an M.Tech. in Microelectronics and a Ph.D. in Electrical Engineering from IIT Bombay, Dr. Gaurav Trivedi’s research spans circuit simulation, VLSI CAD, electronics system design, computer architecture, IoT, high-performance computing, large-scale optimization, and machine learning.

  • Amitendra Srivastava

    Amitendra Srivastava

    Chief Data Scientist at Intelytica

    Amitendra’s expertise lies in utilizing data analysis and machine learning techniques to solve complex business problems and drive strategic decisions. As Chief Data Scientist, he leverages the power of data to create value and drive innovation.

  • Raghav Goel

    Raghav Goel

    Generative AI & Data Science Consultant

    A passionate and successful corporate trainer who has delivered 150+ training sessions for corporates in India, Middle East, USA, and South East Asia for corporate clients like Publicis Sapient, KPMG, Capgemini, Coforge, ITC, DXC, Huawei, and IBM.

  • Ankit Virmani

    Ankit Virmani

    Data & ML Leader at Google

    Ankit is an ethical AI and data engineering enthusiast with 10+ years of experience at firms like Google, Amazon, and Deloitte. He serves as a member of the Forbes Technology Council, IU's Institute of Business Analytics, and AI 2030.

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

  • Tarun Sachdeva

    Tarun Sachdeva

    8+ years of experience

    Data Analyst and Certified Project Manager

  • Shruti Nigam

    Shruti Nigam

    9+ years of experience

    Consultant and Corporate Trainer

prevNext

Industry Trends

The global big data and data analytics market was valued at $225.3 billion in 2023 and is projected to reach $665.7 billion by 2033, growing at a CAGR of 11.6% from 2024 to 2033.

Job Icon$667.9 bn

Estimated Generative AI Market Size by 2030 Growing at a CAGR Of 47.5%

Source: Fortune Business
Job Icon27.6%

Expected CAGR of the Global Data Analytics Market From 2023 To 2030

Source: Market Research
Job Icon₹9,57,470

Average Annual Salary of a Data Analytics Professional in India

Source: Glassdoor

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.

  • 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
    Netflix
    Wells Fargo
    PricewaterhouseCoopers
    Accenture
    Bosch
    Amazon
    SAP ERP
    Boeing
    Siemens
    Hewlett-Packard
    IBM
    Ernst & Young

Admission Details

Application Process

The application process consists of three simple steps. The selected candidates will receive an offer of admission, which they may accept by paying the admission fee.

STEP 1

Submit Application

Complete the application and include a brief SOP explaining your interests.

STEP 2

Application Review

A panel will review your application to determine whether you qualify.

STEP 3

Admission

Selected candidates can join the program by paying the admission fee

Eligibility Criteria

For admission into this Data Analytics and Generative AI program, candidates:

Should have a bachelor's degree with an average of 50% or higher marks
Don’t need to have prior work experience
Don’t need prior coding experience or technology know-how

Apply Now

Program Benefits

  • Certificate of completion from E&ICT Academy, IIT Guwahati
  • Eligibility for campus immersion at IIT Guwahati
  • 15+ tools and access to integrated labs
  • IBM certificates for IBM courses completed
  • Live classes delivered by industry experts

Generative AI Data Analytics FAQs

  • Why E&ICT Academy, IIT Guwahati?

    Established on March 26, 2015, by the Ministry of Electronics & Information Technology (MeitY), the Electronics & ICT Academy at IIT Guwahati offers advanced online certification courses in data science, AI, machine learning, big data, cloud computing, full stack development, UI/UX, and VLSI design. It has successfully trained over 2,000 graduates and professionals.

    IIT Guwahati is a top engineering school in India with a strong national and growing international reputation. It has consistently maintained a top 7 ranking in the Engineering category of the NIRF rankings from 2019 to 2023 and is recognized among the world's best universities for the study of Data Science by the QS World University Rankings.

  • What are the eligibility criteria for this Professional Certificate Program in Data Analytics & Generative AI?

    For admission to this Data Analytics & Generative AI program, candidates:

    • Should have a bachelor's degree with an average of 50% or higher marks
    • Are not required to have prior work experience
    • Don’t need prior coding experience or technology know-how

  • Who is this Professional Certificate Program in Data Analytics & Generative AI ideal for?

    This Professional Certificate Program in Data Analytics & Generative AI is ideal for professionals eager to develop expertise in data analytics with the objective of: 

    • Enhancing effectiveness in their current role
    • Transitioning to data analytics roles in their respective organizations
    • Advancing their career in the industry
    • Giving shape to entrepreneurial aspirations

  • What is the admission process for this Data Analytics and Generative AI program?

    The admission process for this GenAI and data analytics program consists of three simple steps:

    • All interested candidates are required to apply through the online application form
    • An admission panel will shortlist the candidates based on their application
    • An offer of admission will be made to the selected candidates and is accepted by the candidates by paying the program fee

  • Is there any financial aid provided?

    To ensure that money is not a barrier to learning, we offer various financing options to help make this program financially manageable. Please refer to our “Admissions Fee and Financing” section for more details.

  • What should I expect from this Data Analytics and Generative AI program?

    • Certificate of completion from E&ICT Academy, IIT Guwahati
    • Opportunity to earn an 'Executive Alumni Status' from E&ICT Academy, IIT Guwahati
    • Eligibility for the campus immersion program at IIT Guwahati
    • Exclusive hackathons and “ask-me-anything” sessions by IBM
    • Certificates for IBM courses and industry masterclasses by IBM experts
    • Practical learning through 20 hands-on projects and 3 capstone projects
    • Simplilearn's JobAssist helps you get noticed by top hiring companies

  • What certificate will I receive?

    Upon completing the Generative AI for Data Analytics program, you will be awarded a certificate of completion from E&ICT Academy, IIT Guwahati.

  • How long does it take to complete this Data Analytics and Generative AI program?

    The Generative AI for Data Analytics program can be completed according to your schedule but the anticipated time to complete the overall material of the program is 11 months.

  • Is this program 100% online? Do I need to attend any classes in person?

    This Generative AI for Data Analytics program is completely online, so attending an in-person classroom is not necessary. You can access your lectures, readings, and assignments anytime and anywhere via the web or mobile.

  • What is covered under the 24/7 support promise?

    We offer 24/7 support through email, chat, and calls. Our dedicated team provides on-demand assistance through our community forum. Moreover, you will have lifetime access to the community forum even after completing your course.

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