Caltech - Professional Certificate in Data Analytics and Generative AI 

PC DA - Induction Session

PC DA: Business Analytics with Excel
Understand the critical need for business analytics
Leverage functions and formatting in Excel
Conduct data analysis with pivot tables
Create effective dashboards
Utilize Excel for business analytics
Learn statistical data analysis
Gain essential Power BI skills

PC DA: Data Acquisition and Manipulation using SQL
Understand database structures and relationships
Gain proficiency in SQL commands and query tools
Learn transactions, table creation, and view management
Execute complex operations with stored procedures
Acquire expertise in SQL fundamentals like filtering, joins, and subqueries
Explore SQL functions: strings, math, date/time, pattern matching
Manage user access control for database security

PC DA: Extract, Transform, and Load (ETL)
Learn ETL fundamentals in data analysis
Extract structured/unstructured data incrementally
Create transformation rules
Use ETL tools: Nifi, Talend, etc.
Load data into repositories
Distinguish between batch vs. real-time ETL
Implement real-time processing
Optimize with parallel processing
Schedule, monitor ETL workflows

PC DA: PL-300 Microsoft Power BI Certification
Analyze data for valuable business insights with Power BI
Create interactive dashboards for effective decision-making
Enhance operational efficiency
Develop dashboards from published reports
Utilize Quick Insights for rapid data pattern discovery
Adopt practical approaches within Power BI

PC DA: Fundamentals of Python Programming
Learn procedural and object-oriented programming 
Install and navigate Jupyter 
Learn data types, loops, scope, OOP principles, methods, attributes, and threading
Understand Python's benefits and use cases
 
PC DA: Data Analytics with Python
Python packages for data analytics?
Statistical functions
Categorical data and working with text data
Explorative Data Analysis (EDA)
Hypothesis testing mechanism
Data visualization

PC DA: Essentials of Generative AI, Prompt Engineering, and ChatGPT
Grasp AI fundamentals and generative AI models
Apply prompt engineering to control the generated output
Comprehend ChatGPT mechanisms, features, and limitations
Explore ChatGPT applications and use cases
Learn refining prompts in ChatGPT
Recognize ethical issues in generative AI and ChatGPT
Gain insights into future generative AI challenges

PC DA: Applications of Generative AI in Data Analytics
Overview of generative AI in data analytics
Data augmentation using generative AI
Generative AI for tailored data visualization
Generative AI in data exploration
AI-optimized ETL processes
Generative AI in data modeling and forecasting
Challenges in integrating generative AI
Future directions in generative AI

PC DA: Capstone Project
Combine your newly acquired Data Analytics skills with hands-on, industry-relevant projects that bring together all course elements into a portfolio-worthy capstone.

Electives:
PC DA: Data Visualization using Tableau
Gain Tableau visualization expertise
Emphasize data organization for insightful visuals
Learn combo charts, stories, filters, parameters, and sets
Learn interactive dashboard creation
Take a practical approach to informed decision-making

PC DA: Data Ethics
Grasp the core relevance of data ethics in analytics
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