Artificial Intelligence
Data Analytics and Generative AI
This course offers a comprehensive introduction to data analytics using SQL, Python, and Microsoft Power BI. You'll start by learning how to manage and query relational databases using SQL, then explore key statistical concepts and techniques in Python for analyzing and interpreting data. The course also covers data visualization and dashboard creation using Power BI, helping you turn raw data into actionable insights. Designed for beginners, it emphasizes practical skills with hands-on examples and real-world scenarios. By the end, you'll be equipped to work confidently with data across multiple tools and platforms.
About this course
This course offers a comprehensive introduction to data analytics using SQL, Python, and Microsoft Power BI. You'll start by learning how to manage and query relational databases using SQL, then explore key statistical concepts and techniques in Python for analyzing and interpreting data. The course also covers data visualization and dashboard creation using Power BI, helping you turn raw data into actionable insights. Designed for beginners, it emphasizes practical skills with hands-on examples and real-world scenarios. By the end, you'll be equipped to work confidently with data across multiple tools and platforms.
Training program
- 1 Introduction to Data Analytics and Excel Interface
- 2 Data Cleaning
- 3 Tables and Structured References
- 4 Text Functions and Advanced Formulas
- 5 PivotTable and PivotChart
- 6 Advanced PivotTable and Chart Types
- 7 Statistics and Dashboard Architecture
- 8 Dashboard Design and Module Review
- 1 Introduction to SQL and Basic Syntax
- 2 Filtering, Sorting and NULL Handling
- 3 SQL Functions: Character, Numeric, Date
- 4 Consolidation and Midterm
- 5 Practice Lab and GROUP BY
- 6 Combined Aggregation and JOIN Types
- 7 Advanced JOINs
- 8 SET Operators, CTEs and Window Functions
- 9 SQL Module Final Examination
- 1 Introduction to Power BI and Data Connections
- 2 Power Query: Merge and Append
- 3 Data Modelling and DAX Basics
- 4 Advanced Modelling and CALCULATE
- 5 CALCULATE Practice and Time Intelligence
- 6 Report Design and Visual Types
- 7 Interactivity and AI Features
- 8 Power BI Final Project
- 1 Introduction to Python and Variables
- 2 Strings and Data Collections: List and Tuple
- 3 Set, Dictionary and General Collection Operations
- 4 Control Flow
- 5 Functions and Error Handling
- 6 NumPy: Numerical Computing
- 7 Pandas: Data Loading and Inspection
- 8 Pandas: Cleaning and Transformation
- 9 Visualisation: Matplotlib and Seaborn
- 10 Kaggle and EDA Project
- 11 Descriptive Statistics with Python
- 12 Python Module Final Examination
- 1 Introduction to Generative AI
- 2 Hands-on AI and Prompt Techniques
- 3 API Basics and Course Wrap-Up
- 1 Introduction to Generative AI
- 2 Hands-on AI and Prompt Techniques
- 3 API Basics and Course Wrap-Up
