Data Analytics and Generative AI | Ingress Academy
AZRU
Create account & apply
ARTIFICIAL INTELLIGENCE · BEGINNER LEVEL

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.

Beginner20 weeks80 hoursOnline
Create account & apply Explore syllabus ↓
Your selected course will be carried into Ingress Portal.
CONDENSED SYLLABUS

See the structure without reading a textbook.

Modules stay collapsed for quick scanning. Open any module to inspect its topics.

01Module 1: Data Analytics with Excel8 lessons+

Introduction to Data Analytics and Excel Interface

Data Cleaning

Tables and Structured References

Text Functions and Advanced Formulas

PivotTable and PivotChart

Advanced PivotTable and Chart Types

Statistics and Dashboard Architecture

Dashboard Design and Module Review

02Module 2: SQL – Structured Query Language9 lessons+

Introduction to SQL and Basic Syntax

Filtering, Sorting and NULL Handling

SQL Functions: Character, Numeric, Date

Consolidation and Midterm

Practice Lab and GROUP BY

Combined Aggregation and JOIN Types

Advanced JOINs

SET Operators, CTEs and Window Functions

SQL Module Final Examination

03Module 3: Power BI (Business Intelligence)8 lessons+

Introduction to Power BI and Data Connections

Power Query: Merge and Append

Data Modelling and DAX Basics

Advanced Modelling and CALCULATE

CALCULATE Practice and Time Intelligence

Report Design and Visual Types

Interactivity and AI Features

Power BI Final Project

04Module 4: Python for Data Analysis12 lessons+

Introduction to Python and Variables

Strings and Data Collections: List and Tuple

Set, Dictionary and General Collection Operations

Control Flow

Functions and Error Handling

NumPy: Numerical Computing

Pandas: Data Loading and Inspection

Pandas: Cleaning and Transformation

Visualisation: Matplotlib and Seaborn

Kaggle and EDA Project

Descriptive Statistics with Python

Python Module Final Examination

05Module 5: Prompt Engineering3 lessons+

Introduction to Generative AI

Hands-on AI and Prompt Techniques

API Basics and Course Wrap-Up

06Module 5: Prompt Engineering3 lessons+

Introduction to Generative AI

Hands-on AI and Prompt Techniques

API Basics and Course Wrap-Up

UPCOMING GROUPS

Choose the cohort you can actually attend.

Only current, open groups are shown.

STARTS

23 September 2026

Office · Data Analytict and Generative AI 8
Schedule
To be announced
Format
Office
Duration
20 weeks · 80 hours
Instructor
Teaching team below
Join the waitlist
YOUR INSTRUCTOR TEAM

Specialists matched to the modules they teach.

Course delivery is supported by practitioners across engineering, architecture and production backend development.

LR

Laman Rahimli

Data Engineer | Ex-Senior Data AnalystBir Ecocystem
NI

Nemat Ismayilov

Business Intelligence || Data Analyticsİcbari Tibbi Sığorta üzrə Dövlət Agentliyi
NM

Nigar Majidzada

Data AnalystMatanat A Group of Companies
CONTEXTUAL PROOF
“The program helped me connect individual skills into the way real teams design, build and deliver software.”

See real graduate stories from the Ingress community.

Explore graduate results
APPLICATION THROUGH INGRESS PORTAL

Your course stays selected while you create your account.

We use one Portal account for applications, assessments and future learning progress. You will not need to email your details or select the training again.

Questions first? Talk to an advisor
  1. 01

    Create or sign in to your Portal accountYour contact details stay connected to one student profile.

  2. 02

    Confirm your application detailsData Analytics and Generative AI and the 23 September cohort are preselected.

  3. 03

    Submit your applicationThe admissions team receives it immediately and can follow up from the Portal.

SELECTED TRAININGData Analytics and Generative AI23 September 2026 · Online

Continue in Ingress Portal Already registered? The Portal will let you sign in instead.