Further training

Business Intelligence Analyst

Professional data analysis and data reports with SQL and Power BI - the online training course with certificate of completion

This continuing education is held in German.
Companies of all sizes rely on data-driven insights to gain a competitive edge, optimize processes and make strategic decisions. As a business intelligence analyst, you play a crucial role in this. This online course offers you a comprehensive introduction and in-depth insights into the world of business intelligence. You will begin your learning journey with a comprehensive introduction to relational databases and SQL, engage in practical exercises in Power BI, deepen your knowledge of statistical methods and learn how business intelligence can be enhanced with machine learning techniques. This online course is designed so that you can learn flexibly and at your own pace. You can expect videos, interactive graphics, texts and many practical exercises that you can carry out yourself in SQL databases provided online and with Power BI. At the end of the course, you will complete a final project. Experienced BI experts are on hand as mentors to answer any questions you may have.

Contents

1. introduction to relational databases

  • Introduction to the topic of databases
  • Structure of relational databases
  • Writing SQL queries and reading relational databases
  • Extract company-relevant information
  • Filter data with Boolean logic

2. deepening in SQL

  • Grouping and sorting data
  • Connecting queries with different joins
  • Use subqueries and extended filter options

3. specialization in database design

  • Structures of relational databases
  • Database design and normalization rules
  • Create or change tables and data
  • Practical project: Designing and implementing a database

4. SQL in practice

  • Own practical project from exploration to query
  • Common Table Expressions (CTEs)
  • Maintain an overview of complex queries
  • Create ranking lists and calculate running totals over longer periods of time
  • Tools for SQL practice

5. introduction to Power BI

  • Workflow of classic data analyses
  • Basic functions of Microsoft Power BI
  • Data, model and report views
  • Use filter functions
  • Creation of a data model for an initial report

6. data preparation and visualization

  • Best practices in data visualization
  • Change and format visualizations
  • Use visualizations in reports and dashboards
  • Typical mistakes and how to avoid them
  • Guidelines for comprehensible graphics
  • Use of the Power Query Editor
  • Linking different data sources

7. dashboards and DAX code

  • Arrange reports and analyses in dashboards
  • Applying the principles of data storytelling
  • Advanced BI skills
  • Basics of Data Analysis Expressions (DAX language)
  • Integration of DAX in reports
  • Write complex DAX code for calculations
  • Generate columns, key figures and tables with DAX code

8. advanced topics

  • Basic concepts of statistics
  • Best practices for statistical data analysis
  • Using machine learning in the BI process
  • Perform cross-page drilldown
  • Carry out influencing factor analyses

9. final project

  • Analyzing air traffic unpunctuality at a major hub using real data sets
  • Independent implementation of a complete data project with SQL and Power BI
  • Presentation of results and 1:1 feedback meeting with mentoring team
  • Obtaining the certificate for Data Analyst with Python

How do you learn in the course?

This online course offers you a particularly practice-oriented learning concept with comprehensive self-study units and a team of mentors who are available to you at all times. A new chapter is activated for you every week. With a time budget of around 6 hours per week, you are sure to reach your goal in 12 weeks. This is how you learn in the course:

Placement test: In an onboarding meeting at the start of the course, you and the mentoring team will determine what knowledge you already have and which parts of the course you should pay particular attention to. This will prepare you optimally for learning in the self-study units.

Data Lab: In the learning environment of the course, you can expect videos, interactive graphics, text and, above all, many practical exercises with comprehensive datasets. You can run these directly in the browser or import them into Power BI.

Mentor team: Your learning coaches are available to answer any questions you may have. They are experienced data analysts who will be happy to help you - via chat, audio or video call.

Webinars: Once a week, you have the opportunity to take part in webinars and immerse yourself in selected special topics of data analysis.

Career coaching: What professional goals are you pursuing with your further training and how can you achieve them? A team of mentors is available to help you achieve your career goals.

Final project: In your own data project, you will independently go through the entire business intelligence process and answer typical questions. At the end, you will present your project in a 1-to-1 feedback meeting with your mentoring team.

Certificate: After the final project, you will receive your official Business Intelligence Analyst certificate.

This online training is provided by our partner StackFuel GmbH. StackFuel specializes in training courses on data literacy, data science and AI.

Your benefit

In this practice-oriented training course, you will learn how to tackle data projects independently and carry out data analyses with large data sets.

You will learn how to use SQL and Power BI competently and how to carry out comprehensive data analyses, visualize them and present them convincingly.

You will learn how to clean, prepare and structure data for analyses.

You will gain comprehensive advanced knowledge of views, CTEs, subqueries and window functions.

You will learn how to use machine learning and algorithms to analyze data and calculate forecasts.

After the training, you will be able to visualize company data in a meaningful way and make it interactively accessible in dashboards.

You not only learn theory, but also apply the methods and techniques in many practical exercises and consolidate your knowledge quickly and sustainably.

Recommended for

The Business Intelligence Analyst online training course is suitable for anyone looking for comprehensive training on the topics of data analysis, relational databases and Power BI. No prior knowledge is required.

The training is suitable for career changers and offers the ideal introduction to Business Intelligence for the career goal of Power BI Analyst or Developer or Business Intelligence Analyst or Consultant.

Further recommendations for "Business Intelligence Analyst"

Digital learning for individuals
Booking number
34046
€ 4.500,- plus VAT
4 months (8h ...
Online
6 Events
German
Start dates

Future Jobs Classes

Qualification for the jobs of the future such as data analyst.

In cooperation with

Start dates and details

  Select time period
0 events
23.06.2025
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
21.07.2025
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
18.08.2025
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
15.09.2025
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
13.10.2025
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
10.11.2025
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
Sufficient places are still free.
Don't wait too long to book.
Fully booked.
Training is guaranteed to take place
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
Booking number: 34046
€ 4.500,- plus VAT.
€ 5.355,- incl. VAT.
Details
4 months (8 hours per week)
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

About us – The Haufe Akademie

Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.

Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.

A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.

Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.

2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email

Do you have any questions?

We are there for you Mon - Fri 8 a.m. - 5:00 p.m.

Stephanie Göpfert

Head of Customer Service

*Mandatory fields
FAQs

Questions & Answers

In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.