IIT Kanpur - Professional Certificate Course in Data Analytics and Generative AI 

IITK DG: Program Induction

IITK DG: Business Analytics with Excel
Grasp business analytics importance
Excel functions for analytics
Pivot tables for data analysis
Design impactful dashboards
Statistical data analysis
Vital Power BI skills

IITK DG: Data Acquisition and Manupilation using SQL
Database structures, relationships
Proficient in SQL commands
Transactions, table creation
Complex operations with procedures
SQL fundamentals: filtering, joins
SQL functions: strings, math
User access management

IITK DG: Extract, Transform, and Load (ETL)
ETL basics for analysis
Incremental data extraction
Transformation rule definition
Data loading into repositories
Batch vs. real-time ETL
Real-time processing
Parallel processing optimization
ETL workflow scheduling

IITK DG: Data Visualization using Tableau
Tableau visualization expertise
Data organization for visuals
Interactive dashboards
Combo charts, stories, filters
Practical decision-making

IITK DG: Fundamentals of Python Programming
Procedural and object-oriented Python
Jupyter installation, navigation
Data types, loops, scope
Python's benefits, use cases

IITK DG: Data Analytics with Python
Data acquisition through APIs
SQL and Python for databases
Fundamental statistics
Probability distributions
Advanced statistical analysis
Hypothesis testing
Correlation, regression analysis
Time series analysis

IITK DG: Essentials of Generative AI, Prompt Engineering, and ChatGPT
AI fundamentals, Generative AI
Explainable AI significance
Prompt engineering for control
ChatGPT mechanisms, features
Fine-tuning techniques
Ethical Issues in Generative AI

IITK DG: Applications of Generative AI in Data Analytics
Generative AI in data analytics
Insights, anomalies discovery
AI-enhanced ETL
Trend forecasting, scenario simulation
AI integration challenges
Future trends: Quantum computing

IITK DG: Data Ethics
Data ethics relevance
GDPR, CCPA
Data privacy, security
Transparency, accountability
Bias, fairness in data, algorithms
Ethical decision-making
Ethics in ML, AI development

IITK DG: Capstone Project

Electives:

IITK DG: Academic Masterclass by IIT Kanpur

IITK DG: Data Storytelling using PowerBI
Data analysis using Power BI
Interactive dashboards
Operational efficiency improvement

IITK DG: Data Analytics with R programming
R programming skills
Data import/export in R
Data manipulation, visualization
Regression, classification in R

IITK DG: Microsoft Azure Data Fundamentals
Identify data formats
Store data in files, databases
Normalize data
Execute SQL statements
Utilize relational database objects
Use Azure blob storage
Work with Azure Cosmos DB
Implement data ingestion pipelines
Use Azure Synapse Analytics
Create reporting solutions with Power BI
Understand analytical data modeling
Visualize data effectively