Live Online Training & E-Learning Selbststudium

Business Intelligence Bootcamp with AI

Certified Business Intelligence Analyst (AI) incl. "MS PL-300"

Become a certified Business Intelligence Analyst with our Certified Business Intelligence Analyst (AI) training program. Learn online through a combination of live classes with industry experts and flexible self-study. Build skills in business intelligence as well as MySQL and SQL, database management system MySQL and creation of interactive dashboards using Power BI and Tableau. Secure a lucrative job with an attractive salary and earn a state-recognized certificate of completion.

100% free with a Bildungsgutschein from the Arbeitsagentur
Community
Join a community of more than 10K successful graduates
Business Intelligence Bootcamp with AI

Start

Regelmäßiger, zeitnaher Start

Format

Live Online Training &
E-Learning Selbststudium

Duration

Full-time: 3,5 months
Part-time: 7 months

Scope

Full-time: 35 h / week
Part-time: 17,5 h / week

Unterricht

Montag - Freitag
09:00-16:00

Learning Level

Beginner & Intermediate

Languages

English
German

Certificate

State-recognized certificate

Get started. Take off. Toward your dream job

Start your new career in business intelligence analysis now! 100% free

Learn in this business intelligence 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, Power BI, Tableau, data modeling, and visualization. Learn with first-class, experienced trainers supported by personal study advisors and our career coaches. Get up to speed in business intelligence analysis and secure a future-proof job as a Business Intelligence Analyst.

Tools, techniques & methods
MySQL MySQL SQL SQL MS Office MS Office Teams Teams Excel Excel Power BI Power BI Google Docs Google Docs Google Sheets Google Sheets Tableau Tableau Data Analysis Data Analysis Business Intelligence (BI) Business Intelligence (BI) Visualization Visualization Dashboarding Dashboarding Reporting Reporting Storytelling Storytelling AI-Tools AI-Tools
Content, Skills & Learning Outcomes

  • Business Intelligence (BI)
  • SQL database language and MySQL database management system
  • Advanced SQL for business intelligence and data analysis
  • Basics of Microsoft Power BI for Business Intelligence
  • Power BI-for advanced users
  • Best practice examples and use cases with Power BI
  • Dashboarding and reporting with Tableau
  • Capstone project
  • Confident preparation for the Microsoft PL-300 certification exam (Microsoft Power BI Data Analyst)

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.

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.

More XDi training courses that may interest you

Discover more bootcamps and combine them with just one Bildungsgutschein!

Certified Data Analyst (AI)

Data analytics, databases, data storytelling and visualization in practice – Data Analysis Class with Bildungsgutschein and AZAV certificate

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

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

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 Business Intelligence Analyst

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

€ 59.000

150-200

+7%

Top 10

Average annual salary (entry-level salary)
Average monthly job offers
Estimated employment growth by 2030
Fastest-growing jobs

€ 59.000

Average annual salary (entry-level salary)

150-200

Average monthly job offers

+7%

Estimated employment growth by 2030

Top 10

Fastest-growing jobs
Target Audience

Who Are Our Training Programs For?

This Certified Business Intelligence Analyst (AI) training program is ideal for beginners and those with some experience who wish to expand their knowledge of business intelligence 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 business intelligence 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 business intelligence 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 business intelligence 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 Business Intelligence Analyst with XDi. Get started now and sign up, or let us advise you. We’re happy to help.

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 Business Intelligence Analyst.

Career changers and professionals switching fields

You are a working professional from outside the industry and would like to become a Business Intelligence 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 Business Intelligence Analyst

You are a Business Intelligence Analyst and would like to expand your knowledge in the field of business intelligence 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 business intelligence analysis and want to learn the practical, real-world application of data analysis tools for personal or professional purposes.

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 business intelligence 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 business intelligence 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 business intelligence analysis course, you will acquire the most important business intelligence analysis skills based on a curriculum designed by industry experts. The Certified Business Intelligence 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.

1

Introduction to the world of Business Intelligence (BI)

2

Databases and Database Management Systems: MySQL and SQL

3

Advanced SQL for Business Intelligence and Data Analysis

4

Microsoft Power BI for Business Intelligence - The Fundamentals

5

Power BI for Advanced Users

6

Power BI – Best Practice Examples and Use Cases

7

Dashboarding and Reporting with Tableau

8

Capstone Project - Business Intelligence Project from A-Z

9

Bonus: AI Training

Summary

In this module, you will delve into the world of business intelligence. You will learn how data is collected, processed and analysed – from classic ETL processes to data warehouses and modern self-service tools. You will get a feel for typical BI architectures, data sources and reporting methods and understand how companies make data-driven decisions. Current trends such as artificial intelligence, machine learning, and automated analyses are also on the agenda – and will show you where business intelligence is heading in the future. Numerous examples and tasks will help you to apply the concepts directly.

Learning Outcomes

You will learn to:

  • explain key BI tools, technologies and data structures and classify their role in modern organizations
  • understand the architecture of typical BI systems – including data sources, ETL processes, data warehouses and analysis tools
  • identify best practices for data visualization and reporting and apply them in a targeted manner
  • understand and critically reflect on current BI trends such as artificial intelligence, machine learning and natural language processing
  • recognize typical challenges in the introduction of BI solutions and formulate suitable solutions
Content
  • Business intelligence: introduction, key concepts, and principles
  • Business intelligence tools, technologies, and data structures
  • Business intelligence architecture, data visualization and reporting techniques
  • Business intelligence – trends and challenges
Core Skills
BI architecture Data analysis Data structures Data sources Data warehouses ETL Artificial intelligence (AI) Machine Learning Natural Language Processing (NLP)
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 your own databases and tables in MySQL Workbench, fill them with data and develop structured queries. Step by step, you will work with important SQL commands – from filtering and sorting to aggregations, groupings, JOINs and foreign keys. Practical tasks will give you a solid foundation for the professional use of databases.

Learning Outcomes

You will learn to:

  • understand relational databases and the concept of tables, keys and relationships
  • create and configure your own database with MySQL Workbench
  • insert, edit and specifically query data with SQL
  • use conditions with the WHERE clause and JOINs to link several tables
  • perform simple analyses with aggregate functions, grouping and sorting
Content
  • Introduction: the relational database model 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 retrieval Data manipulation JOIN operations Aggregations Database tools
Summary

In this module, you will expand your knowledge of SQL and learn how to design complex data queries for business intelligence purposes. You will work with conditions, wildcards and CASE statements, use date and time functions and understand how tables are linked together in a meaningful way. You will learn how to use transactions, user rights and views – and how virtual tables help you to design queries more efficiently. A particular highlight are window functions such as RANK, LAG or LEAD, which you can use to analyze trends and time sequences in a targeted manner. You will also practise how to securely integrate external data – for example, from CSV files – into your database.

Learning Outcomes

You will learn to:

  • use the HAVING clause specifically to filter grouped data and gain deeper insights into key figures
  • use wildcards, REGEXP and RLIKE to perform flexible queries and recognize patterns in text data
  • use CASE statements to integrate conditional logic into SQL queries and classify data specifically
  • create foreign key relationships and build normalized data models to ensure data integrity
  • format and customize SQL queries so that results can be presented in a clearly structured and business-relevant way
Content
  • Introduction: more Advanced SQL commands for BI
  • Defining conditions with the HAVING clause
  • Working with Wildcards
  • CASE: linking actions to conditions
  • Relationships between tables with Foreign Keys
  • Advanced options for data output
  • Working with date and time values
  • Managing database access rights
  • Transactions for more secure data processing
  • Key advanced SQL queries for BI
  • Importing CSV files
Core Skills
Advanced SQL Aggregations and filter logic Pattern queries CASE logic Relational data models Table relationships Query design for business intelligence
Summary

In this module, you will be introduced to Microsoft Power BI from the ground up – from the user interface to data modelling and visualization. You will learn how to import, transform and model data and gain an understanding of the architecture behind Power BI. The focus is on creating meaningful visualizations and interactive dashboards that support data-based decisions. You will develop reports that are not only convincing but can also be shared within the team or the company in a targeted manner.

Learning Outcomes

You will learn to:

  • understand the data model and architecture of Power BI and classify it in the BI context
  • import, transform and link data from different sources in Power BI
  • create interactive visualizations and dashboards that facilitate data-based decisions
  • design initial reports with Power BI Desktop and transform raw data into meaningful analyses
Content
  • Introduction to Microsoft Power BI
  • Getting started with Microsoft Power BI: the data model and architecture
  • The Power BI desktop client
  • From beginner to pro: creating your first Power BI report
  • Importing data into Power BI
  • Processing the imported data
  • Creating relationships between data sets
  • Data visualizations with Power BI
  • Dashboards in Power BI
Core Skills
Power BI fundamentals Power BI architecture Data modeling Data import Data cleansing Visualizations Dashboards Reporting
Summary

In this module, you will take your Power BI skills to the next level. You will work with user-defined visualizations, become familiar with complex DAX functions, and utilize advanced features such as bookmarks, forecasts, and clustering. You will also dive into the M-language of Power Query to transform data in a targeted manner and prepare it for your analyses. In this way, you will use Power BI in all its depth – for interactive reports that map even complex issues and optimally support data-based decisions.

Learning Outcomes

You will learn to:

  • use customized visualizations and interactive reporting elements in a targeted manner
  • use complex DAX functions to calculate and analyse KPIs
  • use advanced Power BI features such as bookmarks, forecasts and clustering
  • transform data efficiently with the M language in Power Query
  • use Power BI to create advanced, decision-relevant dashboards
Content
  • Introduction – in-depth insights into Power BI
  • Custom visualizations
  • Advanced reporting concepts
  • An introduction to DAX
  • An in-depth look at DAX
  • An introduction to M
Core Skills
Custom visualizations Interactive reports DAX Data modeling Power query M Language ETL processes KPI analysis
Summary

In this module, you will learn how to professionally model, analyse and visualize data in Power BI – in a practical way and with a view to real business applications. You will develop stable data models, make targeted use of DAX functions and create interactive dashboards that impress. Topics such as storytelling, usability, KPIs and data-based decision-making play just as important a role as the analysis of patterns, trends and anomalies. The module ideally prepares you for the MS PL-300 certification exam.

Learning Outcomes

You will learn to:

  • design and implement a structured and performant data model in Power BI
  • apply advanced DAX calculations including time intelligence and filter logic
  • design interactive reports and dashboards with clear visualization and data-based storytelling
  • to use optimization techniques to increase model performance in a targeted manner
  • to recognize patterns, trends and anomalies in data and derive business-relevant insights from them
Content
  • Preparation for the Microsoft certification PL-300
  • Designing a data model
  • Developing a data model
  • Creating model calculations with DAX
  • Creating reports
  • Creating dashboards
  • Optimizing reports: usability and storytelling
  • Identifying patterns and trends
Core Skills
Data modeling DAX Dashboard design Reporting Performance optimization Data analysis Decision support
Summary

In this module, you will discover how to effectively visualize data and create interactive reports with Tableau. You will connect and prepare data, create clear dashboards and make targeted use of visualization techniques. Using realistic scenarios, you will learn how to use Tableau to gain data-based insights and support well-founded business decisions. A practical introduction to one of the leading business intelligence tools.

Learning Outcomes

You will learn to:

  • navigate safely through the Tableau Desktop user interface and connect data sources
  • select suitable chart types and use them specifically for different analysis purposes
  • use sorting, grouping and calculations to evaluate data sets in a structured way
  • incorporate geographical data into map visualizations and support visual storytelling
  • design interactive dashboards with multiple views and implement best practices for clear data presentation
Content
  • Introduction to Tableau: data visualization and business intelligence
  • Getting started with Tableau Desktop
  • Basics of chart visualizations
  • Sorting, grouping and calculations
  • Working with maps and customizing the view
  • Dashboards – combining views
Core Skills
Tableau Desktop Visualization Analytical functions Geodata analysis Dashboard design Business intelligence reporting
Summary

In the capstone project, you will apply the knowledge you have acquired in the course in practice and work on your own business intelligence question – from data analysis to visualization. You will create an interactive dashboard with Power BI and document your results professionally. At the end, you will present your solution to your mentor – the final step on your way to becoming a certified Business Intelligence Analyst.

Learning Outcomes

You will learn to:

  • analyze a BI question in a structured way and answer it based on data
  • identify and prepare suitable data sources and integrate them into Power BI
  • develop data models, key figures and visualizations in a targeted manner
  • design and publish interactive dashboards with Power BI
  • present analysis results in a comprehensible, target group-oriented and visually convincing way
Content

Hands-on project to implement a business intelligence solution with Power BI – from data preparation to presentation of results.

Core Skills
End-to-end business intelligence workflow Data modeling with Power BI DAX Interactive dashboards Data analysis and gaining insights Presentation and communication in the BI context
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 Business Intelligence (BI)

Summary

In this module, you will delve into the world of business intelligence. You will learn how data is collected, processed and analysed – from classic ETL processes to data warehouses and modern self-service tools. You will get a feel for typical BI architectures, data sources and reporting methods and understand how companies make data-driven decisions. Current trends such as artificial intelligence, machine learning, and automated analyses are also on the agenda – and will show you where business intelligence is heading in the future. Numerous examples and tasks will help you to apply the concepts directly.

Learning Outcomes

You will learn to:

  • explain key BI tools, technologies and data structures and classify their role in modern organizations
  • understand the architecture of typical BI systems – including data sources, ETL processes, data warehouses and analysis tools
  • identify best practices for data visualization and reporting and apply them in a targeted manner
  • understand and critically reflect on current BI trends such as artificial intelligence, machine learning and natural language processing
  • recognize typical challenges in the introduction of BI solutions and formulate suitable solutions
Content
  • Business intelligence: introduction, key concepts, and principles
  • Business intelligence tools, technologies, and data structures
  • Business intelligence architecture, data visualization and reporting techniques
  • Business intelligence – trends and challenges
Core Skills
BI architecture Data analysis Data structures Data sources Data warehouses ETL Artificial intelligence (AI) Machine Learning Natural Language Processing (NLP)

Databases and Database Management Systems: MySQL and SQL

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 your own databases and tables in MySQL Workbench, fill them with data and develop structured queries. Step by step, you will work with important SQL commands – from filtering and sorting to aggregations, groupings, JOINs and foreign keys. Practical tasks will give you a solid foundation for the professional use of databases.

Learning Outcomes

You will learn to:

  • understand relational databases and the concept of tables, keys and relationships
  • create and configure your own database with MySQL Workbench
  • insert, edit and specifically query data with SQL
  • use conditions with the WHERE clause and JOINs to link several tables
  • perform simple analyses with aggregate functions, grouping and sorting
Content
  • Introduction: the relational database model 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 retrieval Data manipulation JOIN operations Aggregations Database tools

Advanced SQL for Business Intelligence and Data Analysis

Summary

In this module, you will expand your knowledge of SQL and learn how to design complex data queries for business intelligence purposes. You will work with conditions, wildcards and CASE statements, use date and time functions and understand how tables are linked together in a meaningful way. You will learn how to use transactions, user rights and views – and how virtual tables help you to design queries more efficiently. A particular highlight are window functions such as RANK, LAG or LEAD, which you can use to analyze trends and time sequences in a targeted manner. You will also practise how to securely integrate external data – for example, from CSV files – into your database.

Learning Outcomes

You will learn to:

  • use the HAVING clause specifically to filter grouped data and gain deeper insights into key figures
  • use wildcards, REGEXP and RLIKE to perform flexible queries and recognize patterns in text data
  • use CASE statements to integrate conditional logic into SQL queries and classify data specifically
  • create foreign key relationships and build normalized data models to ensure data integrity
  • format and customize SQL queries so that results can be presented in a clearly structured and business-relevant way
Content
  • Introduction: more Advanced SQL commands for BI
  • Defining conditions with the HAVING clause
  • Working with Wildcards
  • CASE: linking actions to conditions
  • Relationships between tables with Foreign Keys
  • Advanced options for data output
  • Working with date and time values
  • Managing database access rights
  • Transactions for more secure data processing
  • Key advanced SQL queries for BI
  • Importing CSV files
Core Skills
Advanced SQL Aggregations and filter logic Pattern queries CASE logic Relational data models Table relationships Query design for business intelligence

Microsoft Power BI for Business Intelligence - The Fundamentals

Summary

In this module, you will be introduced to Microsoft Power BI from the ground up – from the user interface to data modelling and visualization. You will learn how to import, transform and model data and gain an understanding of the architecture behind Power BI. The focus is on creating meaningful visualizations and interactive dashboards that support data-based decisions. You will develop reports that are not only convincing but can also be shared within the team or the company in a targeted manner.

Learning Outcomes

You will learn to:

  • understand the data model and architecture of Power BI and classify it in the BI context
  • import, transform and link data from different sources in Power BI
  • create interactive visualizations and dashboards that facilitate data-based decisions
  • design initial reports with Power BI Desktop and transform raw data into meaningful analyses
Content
  • Introduction to Microsoft Power BI
  • Getting started with Microsoft Power BI: the data model and architecture
  • The Power BI desktop client
  • From beginner to pro: creating your first Power BI report
  • Importing data into Power BI
  • Processing the imported data
  • Creating relationships between data sets
  • Data visualizations with Power BI
  • Dashboards in Power BI
Core Skills
Power BI fundamentals Power BI architecture Data modeling Data import Data cleansing Visualizations Dashboards Reporting

Power BI for Advanced Users

Summary

In this module, you will take your Power BI skills to the next level. You will work with user-defined visualizations, become familiar with complex DAX functions, and utilize advanced features such as bookmarks, forecasts, and clustering. You will also dive into the M-language of Power Query to transform data in a targeted manner and prepare it for your analyses. In this way, you will use Power BI in all its depth – for interactive reports that map even complex issues and optimally support data-based decisions.

Learning Outcomes

You will learn to:

  • use customized visualizations and interactive reporting elements in a targeted manner
  • use complex DAX functions to calculate and analyse KPIs
  • use advanced Power BI features such as bookmarks, forecasts and clustering
  • transform data efficiently with the M language in Power Query
  • use Power BI to create advanced, decision-relevant dashboards
Content
  • Introduction – in-depth insights into Power BI
  • Custom visualizations
  • Advanced reporting concepts
  • An introduction to DAX
  • An in-depth look at DAX
  • An introduction to M
Core Skills
Custom visualizations Interactive reports DAX Data modeling Power query M Language ETL processes KPI analysis

Power BI – Best Practice Examples and Use Cases

Summary

In this module, you will learn how to professionally model, analyse and visualize data in Power BI – in a practical way and with a view to real business applications. You will develop stable data models, make targeted use of DAX functions and create interactive dashboards that impress. Topics such as storytelling, usability, KPIs and data-based decision-making play just as important a role as the analysis of patterns, trends and anomalies. The module ideally prepares you for the MS PL-300 certification exam.

Learning Outcomes

You will learn to:

  • design and implement a structured and performant data model in Power BI
  • apply advanced DAX calculations including time intelligence and filter logic
  • design interactive reports and dashboards with clear visualization and data-based storytelling
  • to use optimization techniques to increase model performance in a targeted manner
  • to recognize patterns, trends and anomalies in data and derive business-relevant insights from them
Content
  • Preparation for the Microsoft certification PL-300
  • Designing a data model
  • Developing a data model
  • Creating model calculations with DAX
  • Creating reports
  • Creating dashboards
  • Optimizing reports: usability and storytelling
  • Identifying patterns and trends
Core Skills
Data modeling DAX Dashboard design Reporting Performance optimization Data analysis Decision support

Dashboarding and Reporting with Tableau

Summary

In this module, you will discover how to effectively visualize data and create interactive reports with Tableau. You will connect and prepare data, create clear dashboards and make targeted use of visualization techniques. Using realistic scenarios, you will learn how to use Tableau to gain data-based insights and support well-founded business decisions. A practical introduction to one of the leading business intelligence tools.

Learning Outcomes

You will learn to:

  • navigate safely through the Tableau Desktop user interface and connect data sources
  • select suitable chart types and use them specifically for different analysis purposes
  • use sorting, grouping and calculations to evaluate data sets in a structured way
  • incorporate geographical data into map visualizations and support visual storytelling
  • design interactive dashboards with multiple views and implement best practices for clear data presentation
Content
  • Introduction to Tableau: data visualization and business intelligence
  • Getting started with Tableau Desktop
  • Basics of chart visualizations
  • Sorting, grouping and calculations
  • Working with maps and customizing the view
  • Dashboards – combining views
Core Skills
Tableau Desktop Visualization Analytical functions Geodata analysis Dashboard design Business intelligence reporting

Capstone Project - Business Intelligence Project from A-Z

Summary

In the capstone project, you will apply the knowledge you have acquired in the course in practice and work on your own business intelligence question – from data analysis to visualization. You will create an interactive dashboard with Power BI and document your results professionally. At the end, you will present your solution to your mentor – the final step on your way to becoming a certified Business Intelligence Analyst.

Learning Outcomes

You will learn to:

  • analyze a BI question in a structured way and answer it based on data
  • identify and prepare suitable data sources and integrate them into Power BI
  • develop data models, key figures and visualizations in a targeted manner
  • design and publish interactive dashboards with Power BI
  • present analysis results in a comprehensible, target group-oriented and visually convincing way
Content

Hands-on project to implement a business intelligence solution with Power BI – from data preparation to presentation of results.

Core Skills
End-to-end business intelligence workflow Data modeling with Power BI DAX Interactive dashboards Data analysis and gaining insights Presentation and communication in the BI context

Bonus: AI Training

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
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 Business Intelligence Analyst step by step.

White_Rocket_Vektor
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 business intelligence analysis is by gaining hands-on experience in SQL, Power BI, Tableau, data modeling, and visualization. Work on real projects and tasks to advance your career as a Business Intelligence 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 business intelligence analysis.

Industry-Approved Portfolio

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

5_Sterne_Bewertung
4,8/5,0

Customer satisfaction

5_Sterne_Bewertung
4,7/5,0

Excellent

5_Sterne_Bewertung
4,4/5,0

Highest quality

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 business intelligence 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 Business Intelligence Analyst.

Business Analyst

analyses business processes and supports optimisations

Up to   63.000 €

Data Analyst

analyses data and creates reports for data-driven decisions

Up to   56.500 €

Data Engineer

builds and maintains data infrastructure for analytics and applications

Up to   65.800 €

Data Scientist

develops models, evaluates big data and delivers forecasts

Up to   64.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.

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.

info icon 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.

info icon Best Price

One-time Payment

Pay in full and save money

8.700 €

Monthly Payment

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

One-time from the beginning 3.500 €
Next two months 2.500 €

info icon Maximum Flexibility

Monthly Payment

Pay in full and save money

1x 3.500 € +
2x 2.500 €

Qualifizierungschancengesetz

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

info icon 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.

info icon Free

Bildungsgutschein

100% funded by the Arbeitsagentur

0,00 €

One-time Payment

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

info icon Flexible

One-time Payment

Register now and select your payment option.

8.700 €

Team-Kontingent

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

info icon 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 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 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
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.

info icon >10 years of experience info icon Industry experts info icon Extensive expertise info icon Pedagogical competence info icon Real personalities

Thomas teaches at the Faculty of Economics at the KU Eichstätt-Ingolstadt and holds a professorship for financing and banking at this university. In addition to research and teaching, Thomas is successfully active in consulting and professional development. He has over 20 years of experience as a data scientist, both in research and in the project business. Today, he implements all projects in research and for external clients in Python and the corresponding Python libraries. As a mentor and trainer, Thomas stands for lively, interactive teaching that is characterised by variety between content transfer and independent work. Thomas is convinced that anyone can learn to use programming languages such as Python to solve practical problems.

Prof. Dr. Thomas Mählmann

Data Scientist and Python Coach

Prof. Dr. Thomas Mählmann

Data Scientist and Python Coach

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.

FAQ_Ansprechpartnerinnen

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.

Certqua_Siegel
ZFU-Logo_schwarz

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.

Certqua_Siegel
ZFU-Logo_schwarz

Get in touch with us

Send us a message. We will get back to you within 24 hours.

Your concern

Select a salutation*
  • Ms.
  • Mr.
  • Ms. Dr.
  • Mr. Dr.
  • Ms. Prof.
  • Mr. Prof.
How did you hear about us? Where did you hear about us?
  • meinNow
  • Arbeitsagentur
  • Jobcenter
  • Private educational consultants
  • Trade fair / event
  • Google
  • Kursfinder
  • LinkedIn
  • Facebook
  • Instagram
  • Bing
  • Artificial intelligence
  • X
  • YouTube
  • Newsletter
  • Personal recommendation
  • HR-Manager / HR-Department
  • Other
*Mandatory fields

Your direct contact to us

We look forward to hearing from you and will get back to you soon.
  • Do you want to further your education and get started?
  • Would you like to find out more about us?
  • Do you have questions and need advice?

Any questions?

We are happy to help. You can reach us Monday to Friday from 8:00 to 17:00.
Valentina Caronia

Valentina Caronia

Account manager & Community manager