IIT Guwahati - Professional Certificate in Applied AI and Machine Learning 

IG DA: Program Induction

IG DA: Business Analytics with Excel
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

IG DA: Data Acquisition and Manipulation using SQL
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

IG DA: Extract, Transform, and Load (ETL)
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

IG DA: Data Visualization using Tableau
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

IG DA : Fundamentals of Python Programming
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

IG DA: Data Analytics with Python
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

IG DA: Data Analysis and Visualization with Python (IBM)
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

IG DA: Essentials of Generative AI, Prompt Engineering, and ChatGPT
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

IG DA: Applications of Generative AI in Data Analytics
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

IG DA: Data Ethics
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

IG DA: Capstone Project

Electives:
IG DA: Mathematical Optimization for Business Problems (IBM)
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

IG DA: Data Storytelling using PowerBI
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

IG DA: Data Analytics with R programming
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

IG DA: Academic Master Class

IG DA: Industry Master Class