Professional Certificate Program in Data Analytics and Generative AI 

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