Live Online Training & E-Learning Selbststudium

Data Analysis Class with AI

Certified Data Analyst (AI)

Join our data analysis class with a Bildungsgutschein to become a Certified Data Analyst. Study online at your own pace with mentor support, and develop expertise in database management, exploratory data analysis and dashboarding. Kick-start your career with a well-paid, rewarding job and graduate with an AZAV certificate.

100% free with a Bildungsgutschein from the Arbeitsagentur

Course offer

Join a community of more than 10K successful graduates

Start

Regelmäßiger, zeitnaher Start

Format

Live Online Training &
E-Learning Selbststudium

Duration

Full-time: 3,5 months
Part-time: 7 months
On-the-job: 12 months

Scope

Full-time: 35 h / week
Part-time: 17,5 h / week
On-the-job: 2-4 h / week

Unterricht

Montag - Freitag
09:00-16:00

Learning Level

Beginner & Intermediate

Languages

English
German

Certificate

State-recognized certificate

Advice Course offer

Get started. Take off. Toward your dream job

Start your new career in data analysis now! 100% free

Learn in this data analysis continuing education program online through daily live training sessions combined with self-study and plenty of hands-on practice. Shape your learning journey to fit your needs in a way that suits your lifestyle.

Gain in-demand, practical skills in SQL, Excel, Python and Power BI. Learn with first-class, experienced trainers supported by personal study advisors and our career coaches. Get up to speed in data analysis and secure a future-proof job as a Data Analyst.

Tools, techniques & methods

SQL

MySQL

Python

Pandas

NumPY

Matplotlib

Seaborn

Power BI

Excel

Dashboarding

Reporting

Visualization

Best Practices

AI-Tools

Content, Skills & Learning Outcomes

Data analysis and data analytics
SQL database language and MySQL database management system
MS Excel
Basic statistics for data analysis
Data analysis with Python: From zero to pandas
Exploratory data analysis, data storytelling and visualization: 10 hands-on use cases
Dashboarding and reporting with Power BI

Interactive live training sessions with industry experts

You participate in interactive live training program with industry experts – this way, you learn directly from the experts and achieve lasting learning outcomes.

Self-study with multimedia content

You benefit from interactive, university-level content! We bring knowledge to life through articles, videos, quizzes and practical exercises.

Practical, job-ready experience in genuine projects

Learn through real-life, industry-specific scenarios and acquire practical skills that you can put to immediate use in your job.

Career services to help you find your new job

With job application training, career advice sessions and our active job placement service, you can count on us to help you on your way to your new job.

Learn anytime, anywhere

Tailor your training program to suit your lifestyle. Learn online anytime, anywhere. All you need is a laptop and an internet connection.

Internationally recognised certificate

Upon successful completion of the training program, you will receive a certificate that will ensure you have excellent career prospects and very good earning potential.

Advice

These companies are training their workforce with us and recruiting our students.

Request a course offer for your Bildungsgutschein!

Would you like to fund your further training with a Bildungsgutschein from the Jobcenter? If so, request a no-binding course quote now. Completely free of charge and obligations.

Request a course offer

More information

More XDi training courses that may interest you

Discover more bootcamps and combine them with just one Bildungsgutschein!

Database Management and Data Analysis with MySQL & SQL

Relational databases, MySQL, SQL Queries, data management, Business Intelligence, Structured Query Language, data analysis. Database management & data analysis with MySQL/SQL – database training & SQL course with Bildungsgutschein and AZAV certificate

All Info

Business Intelligence with Power BI & Tableau

Business Intelligence (BI), Power BI, Tableau, data analysis, dashboards, data visualization, reporting, data modeling – Business Intelligence with Power BI & Tableau – Power BI Course with Bildungsgutschein and AZAV certificate

All Info

What you read is what you get

The perfect blend for your learning success

You benefit from a perfect blend of live training sessions with experienced trainers, high-quality e-learning content at university level, and a community for exchange and collaboration.

Live Trainings

Daily live classes
6 hours per day
09:00 - 16:00

E-Learning

Multimedia content
Self-directed learning
Anytime and anywhere

Career Services

Application training
Career coaching
Job placement

Community

Unlimited access
Peer-to-peer learning
Contact & collaboration

Invest in yourself and your career

Secure the best prospects for a job as Data Analyst

Secure a job in one of the fastest-growing professions in the technology industry. Acquire in-depth knowledge in SQL, Excel, Python and Power BI. Develop exactly the skills you need for a career as a Data Analyst. Secure an attractive, well-paid job with a future in the IT industry.

€ 56.500

200 +8-10%

Top 10

Average annual salary (entry-level salary)

Average monthly job offers

Estimated employment growth by 2030

Fastest-growing jobs

€ 56.500

Average annual salary (entry-level salary)

200

Average monthly job offers

+8-10%

Estimated employment growth by 2030

Top 10

Fastest-growing jobs

Target Audience

Who Are Our Training Programs For?

This Certified Data Analyst (AI) training program is ideal for beginners and those with some experience who wish to expand their knowledge of data analysis.

You only need a standard computer (laptop/PC) with an internet connection and:

a Windows operating system (recommended to use Power BI Desktop optimally) or
Mac/Linux with a virtual Windows system (e.g., VirtualBox, VMware Fusion, or the UTM app)

No prior knowledge of financial data analysis is required. We’ll start with the basics and then move on to more advanced topics step by step.

Have this training course funded with a Bildungsgutschein from the Arbeitsagentur and the Jobcenter. If you are registered as unemployed or seeking work, you can apply for a Bildungsgutschein for this data analysis course. We have created an application guide for this purpose. To apply for a Bildungsgutschein, you will need a course offer.

Are you an employee of a company and want to develop skills in data analysis while working? Are you at risk of redundancy, or is your company affected by structural change? If so, your employer can make use of the Qualifizierungschanzengesetzt to have up to 100%of the training costs funded and receive a reimbursement of up to 75% of your salary costs.

There are many good reasons to become a Data Analyst with XDi. Get started now and sign up, or let us advise you. We’re happy to help.

Advice

Unemployed people or jobseekers

You are unemployed or looking for work, are eligible for a Bildungsgutschein, and want to use this time to gain the qualifications needed for a new job as a Data Analyst.

Career changers and professionals switching fields

You are a working professional from outside the industry and would like to become a Data Analyst in pursuit of a career change, develop professionally and take advantage of new opportunities.

Employees at risk of unemployment

You are an employee at a company affected by structural change, your job is at risk, and you need training to secure your position.

Professionals and specialists

You are a specialist in your field, looking to expand your expertise, earn a certification, or optimally prepare for a certification exam.

Aspiring Data Analyst

You are a Data Analyst and would like to expand your knowledge in the field of data analysis and advance your career.

Graduates and students

You have recently graduated or are still studying and want to enhance your academic qualifications with practical, industry-relevant skills.

Interested individuals

You are interested in data analysis and want to learn the practical, real-world application of data analysis tools for personal or professional purposes.

Advice

It’s Your Path!

Learn in a Way That Fits Your Life

You decide how, when, and where you learn. Whether you want to study full-time in an intensive format, part-time with flexibility, or alongside your job. Our courses adapt to your lifestyle.

Full-Time

You want to fully immerse yourself in data analysis In this case, our full-time intensive program is the right choice for you.

Graduate in 3,5 months
Full-Time Online Study
35 hours per week

Teilzeit

Do you have a part-time job, children, or other commitments? Then complete the data analysis course on a part-time basis.

Graduate in 7 months
Part-Time Online Study
17,5 hours per week

While Working

Do you have a full-time job and little time to study? Then study whilst working, with funding provided under the Qualifizierungschancengesetz.

Online learning alongside work
Flexible weekly workload
Completion at your own pace

CURRICULUM

What you will learn

In this data analysis course, you will acquire the most important data analysis skills based on a curriculum designed by industry experts. The Certified Data Analyst (AI) training includes industry-validated, interactive content at a university level and extensive hands-on experience in real projects. You will build a portfolio and complete the program with a capstone project.

Introduction to the world of Data Analysis and Data Analytics

Databases and Database Management Systems: MySQL and SQL

From Zero to Hero with MS Excel

Basic Statistics for Data Analysis

Data Analysis with Python: From Zero to pandas

Exploratory Data Analysis, Data Storytelling and Visualization: 10 Hands-on Use Cases

Dashboarding and Reporting with Power BI

Capstone Project - Data Analysis Project from A-Z

Bonus: AI Training

Summary

In this module, you will gain an in-depth overview of key data analysis tools – including SQL, Python, pandas, Excel, and Power BI Desktop. You will learn about the most important steps in the analysis process and find out how to plan projects in a targeted manner, use resources wisely and minimize risks. You will use analysis tools to visualize data and identify factors influencing target figures. Finally, you will learn how to prepare and present even complex analysis results clearly and convincingly for stakeholders and decision-makers.

Learning Outcomes

You will learn:

how to use central data analysis tools such as SQL, Excel, and Python
to understand the steps in a data analysis process
to undertake a practice-based example project with survey data and interpret initial findings

Content

Welcome to the world of data analysis and data analytics
Data analysis: tools, data sources, project planning, and process steps
An exemplary data analysis project: survey responses from StackOverflow

Core Skills

Data analysis Analysis processes Data types Data sources Data structuring Data understanding Analysis tools Interpretation of analysis results

Summary

In this module, you will be introduced to the basics of relational databases and familiarize yourself with the SQL query language. You will create databases and tables in MySQL Workbench, insert data, and develop structured queries. Step by step, you will work with central SQL concepts such as data manipulation, filtering, foreign keys, JOINs as well as aggregations, groupings and sorting – and apply them directly in practice.

Learning Outcomes

You will learn to:

understand relational databases and the concept of tables, keys, and relationships
create and configure their own database with MySQL Workbench
insert, edit, and query data with SQL
use conditions with the WHERE clause and JOINs to link multiple tables
perform simple analyses with aggregate functions, grouping and sorting

Content

Introduction to databases and database management systems: MySQL and SQL
Installation and first steps with MySQL Workbench
First steps: creating a database and tables
Inserting, editing, and querying values
Additional options for using the WHERE clause
Using foreign keys in the database
Joining queries for multiple tables
The JOIN command: using data from multiple tables
Counting entries, summing values and other arithmetic operations
Grouping and sorting data

Core Skills

Relational databases SQL Data queries Data manipulation Database structures SQL commands (SELECT, WHERE, JOIN, GROUP BY) MySQL Workbench Query languages for structured data

Summary

This module explains how to use Microsoft Excel specifically for data analysis. You will create structured tables, prepare data efficiently and clean it up for further analysis. The focus is on PivotTables and PivotCharts – from the basics to calculated fields, filters and customized visualizations. All exercises are based on realistic business data and will make you fit for the confident use of Excel in everyday analysis.

Learning Outcomes

You will learn to:

create and format structured Excel tables for data analysis
sort, filter, clean and prepare data in a targeted manner
create and edit PivotTables and use them to analyze large amounts of data
apply PivotTable formulas and integrate calculated fields
use and design PivotCharts to visualize analysis results

Content

Introduction: from beginner to expert: MS Excel
Excel spreadsheet basics
Preparation, manipulation and cleansing of data
PivotTables: basics
PivotTables: advanced
Creating and using PivotTable formulas
Using PivotCharts

Core Skills

MS Excel Data cleansing Data structuring PivotTables PivotCharts Business data analysis Data visualization Dealing with large data sets

Summary

In this module, you will be introduced to key statistical principles that you need for data-based decisions and sound analyses. You will work with location and dispersion measures, use statistical functions in Excel and apply methods of descriptive and mathematical statistics – including probability distributions, inference, and regression analysis. You will also get to know the Excel Solver for numerical optimization. Practical exercises with real data sets and tools such as the Excel Data Analysis Toolpak will help you to apply statistics directly.

Learning Outcomes

You will learn to:

use Excel’s database functions to efficiently manage and analyze data sets
calculate and interpret descriptive statistics to gain insights from data
use Excel’s statistical database functions to perform more complex statistical calculations
apply concepts of mathematical statistics such as probability, distributions and hypothesis testing in the context of Excel
use numerical optimization techniques to solve practical problems and make data-based decisions

Content

Introduction: fundamentals of statistics
Using Excel’s database functions for statistical data analysis
Statistical database functions of Excel: deepening
Descriptive statistics
Mathematical statistics
Numerical optimization

Core Skills

Descriptive statistics Mathematical statistics Probability distributions Hypothesis tests Statistical analysis with Excel Database functions Numerical methods Data-based problem solving

Summary

This module introduces you to the Python programming language in a practical way – with a focus on data analysis and typical business applications. You will work step by step with basic programming concepts such as variables, loops and functions and make targeted use of libraries such as pandas, NumPy and Matplotlib. The focus is on using pandas for data manipulation and exploratory analysis. You will also work with external data sources such as APIs or SQL and visualize your results directly in Jupyter Notebook – for clear, meaningful analyses.

Learning Outcomes

You will learn to:

apply basic programming concepts in Python – including conditions, loops and functions
clean, analyze, and prepare data with pandas
perform numerical calculations with NumPy
integrate external data sources such as APIs or SQL databases into Python
visualize analysis results with Matplotlib in Jupyter Notebook in an understandable way

Content

Introduction: the wonderful world of Python, pandas, NumPy and Matplotlib
Installation of Anaconda and Jupyter Notebook
First steps with Python and Jupyter Notebook
Variables and data types
Branching and loops
Functions and scope
Numerical calculations with NumPy
Data analysis with pandas
External data (API) and internal data (SQL)
Data visualization with Matplotlib

Core Skills

Python programming NumPy pandas Matplotlib Data import Data manipulation Data automation Analysis workflows Visualization Jupyter Notebook

Summary

In this module, the focus is on the practical application of Exploratory Data Analysis (EDA). Using ten realistic use cases – from developer surveys and medical data sets to Netflix, FIFA and Pokémon – you will prepare and analyze data and present it visually. You will learn how to use clear questions, appropriate visualizations and effective data storytelling to gain meaningful insights and present them convincingly.

Learning Outcomes

You will learn to:

apply the approach and objectives of Exploratory Data Analysis (EDA) in practice
clean, analyze and examine real data sets with pandas and NumPy
recognize and interpret patterns, trends and outliers in data
use visualizations with Matplotlib and Seaborn specifically to display results
present analysis results in an understandable and convincing way using data storytelling

Content

Use Case 1 – StackOverflow
Use Case 2 – Lending Club
Use Case 3 – Heart Failure
Use Case 4 – FIFA 21
Use Case 5 – Cardiac patients
Use Case 6 – Netflix movies and TV shows
Use Case 7 – Formula 1
Use Case 8 – National happiness
Use Case 9 – Video game sales
Use Case 10 – Pokémon with statistics

Core Skills

Exploratory Data Analysis (EDA) pandas NumPy Matplotlib Seaborn Feature identification Data visualization Data interpretation Analytical thinking Decision support

Summary

This module covers the complete workflow for creating compelling reports and interactive dashboards with Power BI. You will import data, model and process it and create meaningful visualizations. You will not only work with the basic functions, but also make targeted use of advanced calculations with DAX. Finally, you will learn how to publish your dashboards via Power BI Online and share them with your team – for professional BI use in practice.

Learning Outcomes

You will learn to:

use Power BI Desktop safely and connect data sources
model, calculate and analyze data with DAX
present complex information visually and comprehensibly
design interactive dashboards for dynamic analyses
publish reports via Power BI Online and share them with the team

Content

Introduction: Power BI
First steps with Power BI Desktop
Creating data sources in Power BI
Creating visualizations
Aggregations, calculations and parameters
Calculations with DAX expressions
Interactive dashboards
Sharing reports with Power BI Online

Core Skills

Power BI Desktop Data modeling Data visualization DAX Interactive dashboards Cloud-based collaboration Report generation Decision support

Summary

In this module, you will apply your knowledge from all previous course modules in an independent analysis project. Working with either a given or a self-selected data set, you will tackle a data-based question – from data preparation and exploratory analysis to the presentation of your results. Your project will be documented in a Jupyter notebook and will also form the first building block of your professional analyst portfolio.

Learning Outcomes

You will learn to:

plan and carry out a data analysis project independently
prepare, analyze and visualize real data sets
derive relevant questions and answer them based on data
use various data analysis tools and techniques in combination (e.g. Python, pandas, Matplotlib, Seaborn)
document analysis results comprehensibly and present them convincingly

Content

Implementation of an independent data analysis project – starting with data selection, EDA and evaluation through to the presentation of results in the Jupyter Notebook.

Core Skills

Analysis workflow Python Jupyter Notebook Exploratory data analysis Statistical analysis Data visualization Hypothesis generation Presentation of results

Summary

Artificial intelligence is now part of everyday working life in many professions. To ensure you are fully prepared for the demands of the modern workplace, you will receive a free AI training course that teaches you the key fundamentals and practical applications of AI.

This AI training course provides you with a solid introduction to the world of artificial intelligence. In this course, you will learn the key terms in AI, understand how language models (Large Language Models, LLMs) work, and prepare data in a targeted manner. You’ll also use practical AI tools for text, images and presentations, develop your own prompts and create AI workflows. Furthermore, you’ll gain an overview of the legal framework – including the GDPR, the EU AI Act and compliance – as well as the future of working with artificial intelligence. This will enable you to use AI in your day-to-day work confidently, efficiently and in full compliance with the regulations.

Learning Outcomes

You will learn:

to confidently identify and explain the key AI terminology
to understand how AI makes decisions, why models sometimes ‘hallucinate’ and what you should look out for
to recognise common AI applications in everyday life and assess how they can be useful in your profession
to identify key data quality criteria and understand their relevance for AI systems
to independently clean and structure simple datasets and make them usable for AI applications
to critically reflect on the impact of data quality and presentation on efficiency, decision-making and automation
to apply practical AI tools in the areas of text, images and presentations
to generate texts, images and presentations quickly and evaluate the results using simple quality criteria
to understand how language models work and the effect of different prompting techniques
Develop, test and optimise prompts in a targeted manner
Design their own AI assistants and automated workflows using prompt engineering
Confidently navigate the key legal frameworks governing the use of AI (GDPR, EU AI Act, copyright and liability)
Understand the implications of these regulations for businesses and AI projects
Realistically assess the opportunities and risks of artificial intelligence in everyday working life
Understand the changes brought about by AI in work processes, job profiles and skill requirements

Content

What is Artificial Intelligence (AI)?
From science fiction to everyday life – The history of AI
Understanding key AI concepts
Language models – How LLMs work
Understanding data as the foundation of AI
Data quality as a key factor in the success of AI systems
Preparing data for AI applications
Text AI basics – Writing, analysing, summarising
Image AI Basics – From idea to illustration
Presentation AI Basics – Designing slides and narratives with AI
Fundamentals of Prompting – Structure and organisation
Data protection, copyright and liability in the context of AI
The EU AI Act – Rules, obligations and implications
Societal impacts of AI and the future of work with AI

Core Skills

Basic understanding of AI Historical context in terms of technology Understanding of concepts and models Critical reflection Data literacy Analysis & Processing Data analysis Text generation using AI Image generation using AI Presentations and visualisations using AI Evaluation of AI-generated content Prompting techniques GDPR awareness Compliance: EU AI Act Future analysis

Introduction to the world of Data Analysis and Data Analytics

Summary

Learning Outcomes

You will learn:

how to use central data analysis tools such as SQL, Excel, and Python
to understand the steps in a data analysis process
to undertake a practice-based example project with survey data and interpret initial findings

Content

Welcome to the world of data analysis and data analytics
Data analysis: tools, data sources, project planning, and process steps
An exemplary data analysis project: survey responses from StackOverflow

Core Skills

Data analysis Analysis processes Data types Data sources Data structuring Data understanding Analysis tools Interpretation of analysis results

Databases and Database Management Systems: MySQL and SQL

Summary

Learning Outcomes

You will learn to:

understand relational databases and the concept of tables, keys, and relationships
create and configure their own database with MySQL Workbench
insert, edit, and query data with SQL
use conditions with the WHERE clause and JOINs to link multiple tables
perform simple analyses with aggregate functions, grouping and sorting

Content

Introduction to databases and database management systems: MySQL and SQL
Installation and first steps with MySQL Workbench
First steps: creating a database and tables
Inserting, editing, and querying values
Additional options for using the WHERE clause
Using foreign keys in the database
Joining queries for multiple tables
The JOIN command: using data from multiple tables
Counting entries, summing values and other arithmetic operations
Grouping and sorting data

Core Skills

Relational databases SQL Data queries Data manipulation Database structures SQL commands (SELECT, WHERE, JOIN, GROUP BY) MySQL Workbench Query languages for structured data

From Zero to Hero with MS Excel

Summary

Learning Outcomes

You will learn to:

create and format structured Excel tables for data analysis
sort, filter, clean and prepare data in a targeted manner
create and edit PivotTables and use them to analyze large amounts of data
apply PivotTable formulas and integrate calculated fields
use and design PivotCharts to visualize analysis results

Content

Introduction: from beginner to expert: MS Excel
Excel spreadsheet basics
Preparation, manipulation and cleansing of data
PivotTables: basics
PivotTables: advanced
Creating and using PivotTable formulas
Using PivotCharts

Core Skills

MS Excel Data cleansing Data structuring PivotTables PivotCharts Business data analysis Data visualization Dealing with large data sets

Basic Statistics for Data Analysis

Summary

Learning Outcomes

You will learn to:

use Excel’s database functions to efficiently manage and analyze data sets
calculate and interpret descriptive statistics to gain insights from data
use Excel’s statistical database functions to perform more complex statistical calculations
apply concepts of mathematical statistics such as probability, distributions and hypothesis testing in the context of Excel
use numerical optimization techniques to solve practical problems and make data-based decisions

Content

Introduction: fundamentals of statistics
Using Excel’s database functions for statistical data analysis
Statistical database functions of Excel: deepening
Descriptive statistics
Mathematical statistics
Numerical optimization

Core Skills

Descriptive statistics Mathematical statistics Probability distributions Hypothesis tests Statistical analysis with Excel Database functions Numerical methods Data-based problem solving

Data Analysis with Python: From Zero to pandas

Summary

Learning Outcomes

You will learn to:

apply basic programming concepts in Python – including conditions, loops and functions
clean, analyze, and prepare data with pandas
perform numerical calculations with NumPy
integrate external data sources such as APIs or SQL databases into Python
visualize analysis results with Matplotlib in Jupyter Notebook in an understandable way

Content

Introduction: the wonderful world of Python, pandas, NumPy and Matplotlib
Installation of Anaconda and Jupyter Notebook
First steps with Python and Jupyter Notebook
Variables and data types
Branching and loops
Functions and scope
Numerical calculations with NumPy
Data analysis with pandas
External data (API) and internal data (SQL)
Data visualization with Matplotlib

Core Skills

Python programming NumPy pandas Matplotlib Data import Data manipulation Data automation Analysis workflows Visualization Jupyter Notebook

Exploratory Data Analysis, Data Storytelling and Visualization: 10 Hands-on Use Cases

Summary

Learning Outcomes

You will learn to:

apply the approach and objectives of Exploratory Data Analysis (EDA) in practice
clean, analyze and examine real data sets with pandas and NumPy
recognize and interpret patterns, trends and outliers in data
use visualizations with Matplotlib and Seaborn specifically to display results
present analysis results in an understandable and convincing way using data storytelling

Content

Use Case 1 – StackOverflow
Use Case 2 – Lending Club
Use Case 3 – Heart Failure
Use Case 4 – FIFA 21
Use Case 5 – Cardiac patients
Use Case 6 – Netflix movies and TV shows
Use Case 7 – Formula 1
Use Case 8 – National happiness
Use Case 9 – Video game sales
Use Case 10 – Pokémon with statistics

Core Skills

Exploratory Data Analysis (EDA) pandas NumPy Matplotlib Seaborn Feature identification Data visualization Data interpretation Analytical thinking Decision support

Dashboarding and Reporting with Power BI

Summary

Learning Outcomes

You will learn to:

use Power BI Desktop safely and connect data sources
model, calculate and analyze data with DAX
present complex information visually and comprehensibly
design interactive dashboards for dynamic analyses
publish reports via Power BI Online and share them with the team

Content

Introduction: Power BI
First steps with Power BI Desktop
Creating data sources in Power BI
Creating visualizations
Aggregations, calculations and parameters
Calculations with DAX expressions
Interactive dashboards
Sharing reports with Power BI Online

Core Skills

Power BI Desktop Data modeling Data visualization DAX Interactive dashboards Cloud-based collaboration Report generation Decision support

Capstone Project - Data Analysis Project from A-Z

Summary

Learning Outcomes

You will learn to:

plan and carry out a data analysis project independently
prepare, analyze and visualize real data sets
derive relevant questions and answer them based on data
use various data analysis tools and techniques in combination (e.g. Python, pandas, Matplotlib, Seaborn)
document analysis results comprehensibly and present them convincingly

Content

Implementation of an independent data analysis project – starting with data selection, EDA and evaluation through to the presentation of results in the Jupyter Notebook.

Core Skills

Analysis workflow Python Jupyter Notebook Exploratory data analysis Statistical analysis Data visualization Hypothesis generation Presentation of results

Bonus: AI Training

Summary

Learning Outcomes

You will learn:

to confidently identify and explain the key AI terminology
to understand how AI makes decisions, why models sometimes ‘hallucinate’ and what you should look out for
to recognise common AI applications in everyday life and assess how they can be useful in your profession
to identify key data quality criteria and understand their relevance for AI systems
to independently clean and structure simple datasets and make them usable for AI applications
to critically reflect on the impact of data quality and presentation on efficiency, decision-making and automation
to apply practical AI tools in the areas of text, images and presentations
to generate texts, images and presentations quickly and evaluate the results using simple quality criteria
to understand how language models work and the effect of different prompting techniques
Develop, test and optimise prompts in a targeted manner
Design their own AI assistants and automated workflows using prompt engineering
Confidently navigate the key legal frameworks governing the use of AI (GDPR, EU AI Act, copyright and liability)
Understand the implications of these regulations for businesses and AI projects
Realistically assess the opportunities and risks of artificial intelligence in everyday working life
Understand the changes brought about by AI in work processes, job profiles and skill requirements

Content

What is Artificial Intelligence (AI)?
From science fiction to everyday life – The history of AI
Understanding key AI concepts
Language models – How LLMs work
Understanding data as the foundation of AI
Data quality as a key factor in the success of AI systems
Preparing data for AI applications
Text AI basics – Writing, analysing, summarising
Image AI Basics – From idea to illustration
Presentation AI Basics – Designing slides and narratives with AI
Fundamentals of Prompting – Structure and organisation
Data protection, copyright and liability in the context of AI
The EU AI Act – Rules, obligations and implications
Societal impacts of AI and the future of work with AI

Core Skills

Download brochure

Everything at a glance

Flexible self-study on our e-learning platform

You learn with the help of elaborately developed, high-quality, and didactically prepared learning materials – available anytime, from anywhere, and on any device.

Articles

Comprehensive articles
Relevant content
At university level

Video

Numerous videos
High-quality animations
High teaching quality

Praxis

80% practice
Alone and in teams
Professional feedback

Quiz

Numerous quizzes
Multiple questions per quiz
Personal knowledge check

Extras

Plenty of extra material
Further information
Links, literature, and tips

Your Learning Journey at a Glance

Find out more about what your learning journey will look like and how you'll become a Data Analyst step by step.

More information

Your Path to a Future-Proof Profession

Practice-oriented learning in a human-centered online learning environment

Learn with and from the best. Get guidance from your career coaches who prepare you for the job market, and study advisors who are always there for you. Plus, connect with fellow students and alumni in our community to share insights on all aspects of your continuing education.

We’ve got your back!

With our learner-focused approach, you get the support you need and a motivated team by your side.

Daily Live Training sessions

Start anew and learn from experienced industry experts with a lot of practice to optimally prepare you for your professional future.

Career coaches accompany you

Our career coaches will accompany you from day 1 and prepare you optimally for a successful career.

Study advisors at your side

Our student advisors are there to help you with any questions and will help you overcome any challenge that comes your way.

Your Learning Community

Learning is most effective with others. Since learning is not a solitary endeavor, you will receive exclusive access to our community.

Real-World Practice. Capstone Project. Accredited Portfolio

Project-Based Learning with Real-World Skills and Portfolio

The best way to learn data analysis is by gaining hands-on experience in SQL, Excel, Python and Power BI. Work on real projects and tasks to advance your career as a Data Analyst.

Hands-on Experience

Work on a hands-on project during your training and complete tasks just like those you’ll encounter in your future job.

Capstone Projekt

Create a capstone project that highlights your learning achievements and the skills you’ve gained in data analysis.

Industry-Approved Portfolio

Create an impressive portfolio that showcases your skills and opens doors with hiring managers.

4,8/5,0

Customer satisfaction

4,7/5,0

Excellent

4,4/5,0

Highest quality

_anbieter-für-weiterbildung_xdi-experience-design-insti_klein

A unique offer. Lots of benefits

We support you right from day one in finding your dream job

Take advantage of our exclusive career services to prepare yourself as effectively as possible for a successful career in data analysis and to make contacts with interesting employers.

Job application training

You will benefit from free job application training tailored to the requirements of employers.

Career coaching

We offer free career consultation sessions with experienced HR managers to provide you with personalised advice.

Educational guidance

Our student advisers are on hand to help with any questions you may have and will work with you to overcome any challenges that come your way.

Job matching

We work actively with companies to help our students secure new jobs.

Top salary & career opportunities

Secure excellent earning potential in a lucrative job as a future Data Analyst.

Data Analyst

analyses data and creates reports for data-driven decisions

Up to 56.500 €

Data Scientist

develops models, evaluates big data and delivers forecasts

Up to 64.000 €

Data Engineer

builds and maintains data infrastructure for analytics and applications

Up to 65.800 €

Business Analyst

analyses business processes and supports optimisations

Up to 63.000 €

Machine Learning Engineer

develops and implements machine learning models and algorithms

Up to 66.000 €

Do you need help with financing?

Financing made easy

A range of financing options is available for your professional development. Find out more here or consult our customer advisors for individual guidance.

For individuals For companies

Bildungsgutschein

Continue your education free of charge. If you are looking for work or your job is threatened by structural change, then take advantage of the government's Bildungsgutschein.

Free

Bildungsgutschein

100% funded by the Arbeitsagentur & Jobcenter

0 €

One-time Payment

Pay your tuition fees before the start of the training program. The easiest and most affordable way to further your education.

Best Price

One-time Payment

Pay in full and save money

7.500 €

Monthly Payment

Pay conveniently in monthly installments, only for the duration you need to complete your continuing education.

One-time from the beginning 3.150 €
Next two months 2.200 €

Maximum Flexibility

Monthly Payment

Pay in full and save money

1x 3.150 € +
2x 2.200 €

Qualifizierungschancengesetz

Use government funding to cover up to 100% of your course fees and 75% of your salary.

For Companies

Qualifizierungschancengesetz

Secure funding for your training costs and salary support

0,00 €

Bildungsgutschein

Leverage the Government-funded training voucher Bildungsgutschein when your business is affected by structural shifts and employees need upskilling to stay employed.

Free

Bildungsgutschein

100% funded by the Arbeitsagentur

0,00 €

One-time Payment

Upskill your employees and let them continue their training in data analysis alongside work.

Flexible

One-time Payment

7.500 €

Team-Kontingent

Make your team strong in data analysis. explore our special offers for groups.

Gruppentarif

Team Quota

Enroll multiple team members and benefit from special rates.

On request

We have helped many enthusiastic people to develop professionally

Thousands of eager learners have successfully completed their training with us – see how we can help you to!

"The training "Certified Data Analyst" was a crucial success factor - I raised my knowledge to a new level in a very short time. The dynamic and focused pace was just right to keep me fully challenged and consistently engaged with the topics. The practice-oriented strategies were particularly valuable, delivering results that could be implemented immediately. The well thought-out questions and ground-breaking impulses not only broadened my thinking, but also highlighted clear areas of action for future success. For me, further training is not a question of if - but when, in order to continue to grow strategically."

Andreas Manietta

"Participating in the "Certified Data Scientist" course was a groundbreaking decision for me. The richness of practical knowledge exceeded my expectations and gave me a deeper understanding of complex data analysis. The challenges in the course not only strengthened my skills but also pushed my motivation to excel. The support from XDi was excellent and I feel well equipped to take on challenging projects in data science. I highly recommend this course to anyone who wants to take their career in this field to the next level!"

Daniel Naesa

"I am glad I decided to take the "Certified Data Scientist" course. The course has provided a tremendous amount of up-to-date knowledge, and has far exceeded my personal expectations. The course is without question challenging, but quickly rewards with a steep and presentable learning curve. I felt optimally supported by XDi at all times."

Denis Sarcevic

"I found the 10 hands-on use cases in the "Certified Data Analyst" course particularly interesting, as they presented various challenges covering the entire Exploratory Data Analysis process—a crucial step for making the best use of data. It was necessary to find solutions and make decisions that directly impacted the final outcome of the analysis. Additionally, I gained valuable experience and improved my critical thinking regarding the use of different tools and visualizations in data analysis. Through the course, I was also able to develop my time management skills, as I completed it full-time with a fixed deadline—quite a challenge! I would also like to highlight that the sessions with my mentor were extremely productive—he was always helpful and highly engaged. My previous knowledge, combined with the skills I acquired during this course, has given me a new perspective, and I am ready to apply them in my next job!"

Dieter Lentini

"I thoroughly enjoyed the Data Science course, especially the opportunity to apply theoretical knowledge to real-world scenarios. The course was well-structured and provided a solid foundation in data analysis with many practical examples to reinforce learning. I gained valuable insights and skills that I look forward to using in future roles."

Duygu Dogan

"The Data Analyst course brought me great joy! My mentor was always by my side, offering valuable professional advice and support, helping me every step of the way. The course was clearly structured and well-organized, enabling me to gain a comprehensive understanding of the role of a data analyst. The clear course design and the valuable support from my mentor were especially helpful in developing solid knowledge. I am happy to recommend this course to friends and acquaintances!"

Liudmyla Rotar

Analyst Engineer

"The Certified Data Analyst course provided me with comprehensive insights into the tasks of a Data Analyst. I was able to practice my skills through many practical examples and could always reach out to my mentor for questions or issues. The final project was enjoyable, and I had the chance to showcase my skills once again"

Louisa Fiedler

"The content of the 'Certified Data Analyst' course and the order in which it is conducted seem very well thought out to me. Additionally, my mentor, Thomas Mählmann, was excellent—very kind, objective, and helpful."

Luis Fernando Martinez Hurtado

"I took the 'Certified Data Analyst' course at XDi. It lasted around three months and covered several modules, including data analysis using Python, SQL, Excel, and Power BI. Each module included frequent assignments and concluded with a Capstone project. The course was well-structured and highly informative, and I would recommend it to anyone aspiring to become a data analyst. The support from the mentor was excellent, and the courses themselves were concise, to the point, and highly relevant to real-world data analysis tasks."

Nitin Nandan Singh

"The Certified Data Analyst training is very well structured and offers a comprehensive first insight into a variety of methods for data analysis and data visualization - from Excel and SQL to Python and Power BI. The focus is on Python/Pandas/Seaborn/Matploplib. The application examples from completely different fields are designed accordingly. I particularly enjoyed analyzing video game and Pokémon statistics, where it almost felt like I was using data to figure out how to become the very best Pokémon trainer. I always felt well looked after by the XDi team and Thomas was always there to mentor me."

Severine Rupp

"I found the Certified Data Analyst training to be a very enriching experience. The content was practical and well-structured, which helped me significantly expand my knowledge in data analysis. I especially enjoyed the hands-on exercises and the capstone project, where I was able to directly apply what I had learned. I can highly recommend the course to anyone looking to further develop their skills in data analysis!"

Seyed Mohammad Hossein

Competent. Experienced. Empathetic

Our Trainers

Our trainers are industry experts with extensive experience in various companies, industries and countries. You will receive exactly the support you need to learn what you want. You will benefit from individuals with in-depth specialist knowledge and teaching skills.

>10 years of experience

Industry experts

Extensive expertise

Pedagogical competence

Real personalities

Manuel Bordasch is CTO of CompAn Labs GmbH, which specializes in AI-based and conventional data analysis. In his day-to-day work, he plays a leading role in the development and support of customer projects. Another focus is the further development of his self-designed and developed data intelligence platform Dashlake®. Over the past 15 years, he has held numerous lectures and seminars in the field of artificial intelligence. This teaching experience is combined with a wide range of professional experience – from start-ups to SMEs and corporations. He manages to make abstract theories vivid and tangible. His goal as a trainer and mentor: maximum knowledge growth for the participants.

Manuel Bordasch

Data scientist, Data Analyst, Data Engineer, AI Specialist

Manuel Bordasch

Data scientist, Data Analyst, Data Engineer, AI Specialist

Sven Ertel works as a freelance data analyst in a wide range of industries and has gained extensive experience in supporting companies, especially their (BI) departments. His expertise includes the design and implementation of reporting systems, data preparation and connection as well as data visualization. Among other things, he has developed global sales monitoring systems for a Bavarian car manufacturer and analyzed and prepared marketing campaign data for a German aviation company.

In his role as a data scientist at the Serviceplan Group, Sven has established a solid, professional foundation in project management for various customer projects. He has also refined and applied his IT skills in various technologies. During this time, he also led training and education on UX/UI-optimized BI reporting, helping to improve the usability and efficiency of BI solutions.

Sven Ertel

Data Scientist, Data Analyst

Sven Ertel

Data Scientist, Data Analyst

Your questions - our answers

Do you still have questions? You can find the answers here. Is your question not answered? Then simply contact us directly.

Get advice

What does Live Online Training & E-Learning Self-Study mean?

Live Online Training & E-Learning Self-Study combines live instruction with independent learning. You attend daily live classes via Microsoft Teams, where you learn together with your trainer and other students in a virtual classroom. During these sessions, you alternate between guided lessons and independent learning phases. Your trainer is available throughout to answer your questions, support you with your tasks, and guide you through the learning process.

Is the course suitable for beginners? What prior knowledge do I need?

What financing options are available to me?

If you are registered as a resident in Germany and are registered as a jobseeker, you can apply for a Bildungsgutschein from the Arbeitsagentur. Here you will find our ‘step-by-step guide’ to the application process.

Employees can benefit from funding under the Qualifizierungschancengesetzt. Up to 100 per cent of the costs of further training may be subsidised. You can find more information on the funding page.

How does the registration process work? What do I need to do?

If you have decided to take part in this course, you can simply register via our website. If you are funding your further training using a Bildugnsgutschein from the JobCenter, please follow these steps:

Request a course quote from us for your further training.
Submit this to your case worker at the JobCenter and apply for your Bildungsgutschein.
Send us the training voucher so that we can complete it and send it back to you. Please let us know your preferred start date.
Submit the training voucher, which we have completed, to your case worker at the JobCenter, signed by you; select the specified start date, register via our website (payment method – BGS) and quote the BGS number when registering.
Once you have booked your place, you will receive a confirmation of enrolment, including a distance learning contract. Please also submit this to the JobCentre.
You will also receive reminder emails and all the necessary login details before your training program begins.

We have also compiled all the essential information for you in our application guide.

Will I be supported by a trainer?

Throughout your training programme, you will be supported by a personal trainer who will provide you with individual support and encouragement. They will be your dedicated point of contact for all technical and subject-related queries regarding the training programme and will be on hand at all times to offer expert guidance should you face any challenges, have any uncertainties or need help with your studies.

Your trainer will help you to successfully understand and apply the course material, provide you with valuable professional insights and offer continuous support as you progress towards successfully completing the course.

What are the lessons like?

Throughout your entire training program, you will participate in virtual Live Classes. During these sessions, you will discuss assignments, solutions, and practical exercises together with your trainer.

The Live Classes take place during the following times:

Full-time: Monday to Friday, between 9:00 AM and 4:00 PM
Part-time: Monday to Friday, between 9:00 AM and 12:00 PM

For every learning unit, a trainer is available online to answer your questions and provide support.

In addition to our strong focus on “learning by doing,” we place great importance on providing professional, state-of-the-art learning content. The theoretical material is presented through a combination of texts, graphics, images, and videos, including animations. All content is carefully designed from an educational perspective and meets high standards of visual quality. Our extensive video material provides an engaging, modern, and high-quality learning experience.

You will put what you have learned into practice immediately through a variety of hands-on, real-world assignments following each theoretical learning unit. You can also check your understanding and track your progress with quizzes specifically tailored to the learning content.

Will you also support me with my job application process?

How and where will I be working on my bootcamp?

How are the lessons structured?

The teaching modules consist of approximately 1/5 theory and approximately 4/5 practical work. The theory component comprises the texts and videos provided, as well as the study of external learning materials and the assessment of learning outcomes via quizzes. The practical component includes hands-on work on a virtual project, your own final project (capstone project), the coaching sessions, and the documentation of your work results.

What happens if I’m ill?

Get in touch

Certified and accredited

Government-approved and 100% eligible for funding. We are AZAV and ZFU certified. Our e-learning courses can be 100% financed with a Bildungsgutschein from the Arbeitsagentur.

Get advice

Certified and accredited

Government-approved and 100% eligible for funding. We are AZAV and ZFU certified. Our e-learning courses can be 100% financed with a Bildungsgutschein from the Arbeitsagentur.

Get advice