Blended learning

Data analysis and data visualization with Excel and Power BI

Using data competently - the practical course for data analysis with on-board tools

This blended learning is held in German.
Many companies generate countless amounts of data. But how can it be used to create analyses, make predictions and take data-based decisions? This course shows you how to carry out ad-hoc analyses using simple techniques in Excel and Power BI - without in-depth software knowledge. The trainers use many examples from everyday business life to illustrate how you can use Microsoft tools to import, structure and cleanse data and carry out exploratory analyses using various techniques. The second focus of the course is on the interpretation of results, visualization and data storytelling. You can learn flexibly and from your own desk with didactically high-quality self-study modules, practical exercises and live webinars with your trainers.
Module 1: Webinar
120 min.
Kick-off and introduction to the characteristics of data-driven organizations
Kick-off and introduction to the characteristics of data-driven organizations
  • Overview of the basics of data science and digital transformation
  • Presentation of the advantages and prerequisites of data-driven companies
  • Introduction to data literacy
  • Criteria for the correct presentation of analyses and for data communication
Module 2: Self-study phase
240 min.
Exploratory data analysis and visual analysis techniques
Exploratory data analysis and visual analysis techniques
  • Basics of exploratory data analysis for checking data quality
  • Familiarization with the common forms of representation for analyzing the position, scattering and correlation of properties in a data set for simple analysis tools
Module 3: Self-study phase
60 min.
Transfer task: Deriving insights from a "Grand Tour"
Transfer task: Deriving insights from a "Grand Tour"
  • Exercise: Derive targeted insights using a predefined "Grand Tour" dashboard
  • Guiding questions lead the participants through the transfer task
  • Joint discussion of the forms of presentation with the course participants
Module 4: Webinar
120 min.
Interactive exchange on the topics of data visualization and interpretation
Interactive exchange on the topics of data visualization and interpretation
  • Clarification of potential questions that arose during the self-study phase and transfer task (modules 2 and 3)
  • Basics for creating meaningful data dashboards
  • Basic principles of data-driven storytelling and how to apply them
Module 5: Self-study phase
210 min.
Prepare and evaluate data
Prepare and evaluate data
  • Getting to know typical problem types in a data set (e.g. invalid and incorrect data)
  • Introduction to methodologies for successfully cleansing data in Microsoft Excel or Power BI
  • Preparation measures for forecast analyses in Microsoft Excel or Power BI
  • Presentation of tools for assessing a regression analysis
Module 6: Self-study phase
60 min.
Transfer task: Analyzing data quality - finding outliers
Transfer task: Analyzing data quality - finding outliers
  • Exercise: Examining the data quality of a given data set
  • With the help of suitable visualizations, the course participants recognize outliers and can suggest specific recommendations on how to deal with the incorrect data points (removal of data vs. methodical data correction)
  • Guiding questions lead the participants through the transfer task
Module 7: Webinar
120 min.
Interactive exchange on the topics of data cleansing and evaluation + Seminar conclusion
Interactive exchange on the topics of data cleansing and evaluation + Seminar conclusion
  • Clarification of questions that arose during the self-study phase and transfer task (modules 5 and 6)
  • Discussion of a case study on the topic of forecasting and joint evaluation of the analysis model
  • Presentation of best practices for automated data cleansing in Microsoft Power BI
  • Joint conclusion and room for questions

Contents

1. understand data

  • Introduction to data science
  • Introduction to exploratory data analysis
  • Data visualization and data analysis
  • Understanding position, dispersion and context

2. visualize data

  • Presentation of comparisons
  • Presentation of relationships and connections
  • Representation of rankings
  • Representation of compositions

3rd "Grand Tour" team challenge

  • Practical exercises with the presentation types from the previous modules

4. prepare data

  • Problem identification and problem types
  • Exploration and cleansing of data
  • Special features of forecasting analyses

5. assess data

  • Regression models explained in detail
  • Coefficient of determination for the assessment of regression models
  • Key figures for deviations
  • Mean absolute error (MAE)
  • Mean square error (MSE)

6th Team Challenge "Data cleansing"

  • Practical exercises to determine and optimize data quality in data sets

How do you learn in the course?

This online course offers you a digital blended concept that has been specially developed for part-time learning. With a time budget of at least 3-4 hours per week, you are sure to reach your goal. Alternatively, you can schedule the learning units flexibly. This is how you learn in the course:

  • Self-study phases: Learn independently, at your own pace and whenever you want. Our courses offer you didactically high-quality learning material with videos, articles, interactive exercises, quizzes and learning checks.
  • Live webinars: In regular online seminars, you will meet your trainers in person. You will receive answers to your questions, specific assistance and instructions on how to deepen your knowledge and apply the skills you have acquired in practical exercises.
  • Practical assignments: To learn the skills in practice, you will be given access to data projects that allow you to apply the techniques and methods you have learned to real-world problems. Through these exercises, you will gain a deep understanding of working with data and develop methods and techniques that you can apply in your everyday work.
  • Learning community: A digital learning community is available to you throughout the course. Exchange ideas with other participants and the trainers and ask questions.
  • Certificate of attendance and Open Badge: As a graduate of the course, you will receive a certificate and an Open Badge that you can easily share in professional networks (e.g. LinkedIn).
  • Future Jobs Club: Booking this online course gives you access to the Future Jobs Club with exclusive information, offers and networking opportunities.

In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.

Your benefit

  • Learn how to cleanse and analyze company data in a structured way - using Microsoft Excel and Power BI.
  • Gain sound assessment skills in order to derive and communicate the right findings from data analyses.
  • Receive concrete tips and examples for the optimal visualization of data analyses.
  • Learn all about typical pitfalls and how to critically scrutinize your ad hoc analyses.
  • Not only will you learn the necessary tools first-hand from your trainers, you will also apply the knowledge directly in exercises with the data sets provided in two comprehensive practical blocks.

Take an active part in our online community and work with your own questions - this is how you will benefit most from this course. This will allow you to apply the content both in self-study and in practical exercises.

Methods

Well-founded trainer, presentations, practical exercises, self-reflection, discussions, work aids, group work on real projects of the participants and exchange of experience in the learning community.

Recommended for

This introductory course is aimed at specialists from all sectors and anyone interested in learning how typical data analyses are carried out and how common tools such as Microsoft Excel or Power BI are used for this purpose.

Open Badges - Show what you can do digitally too.

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Read more

Further recommendations for "Data analysis and data visualization with Excel and Power BI"

Seminar evaluation for "Data analysis and data visualization with Excel and Power BI"

4.6 from 5
with 20 ratings
training content:
4.4
Content comprehensibility:
4.6
Practical relevance:
3.9
Trainer expertise:
5
Participant orientation:
4.8
Method variety:
4.6
Joint online training
Booking number
34159
€ 1.190,- plus VAT
16 hours practice ...
Online
3 Events
German
Events
Train several employees internally
Pricing upon request
  • Customized training courses according to your needs
  • Directly at your premises or online
  • Cost advantage from 5 participants
  • We contact you within 24 hours (Mon-Fri)
16 hours over 2 weeks
In-person or Online

Future Jobs Classes

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

Start dates and details

  Select time period
0 events
11.09.2025
Live online
Booking number: 34159
€ 1.190,- plus VAT.
€ 1,416.10 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Modules
16 hours over 2 weeks
Limited number of participants
Webinar
Kick-off and introduction to the characteristics of data-driven organizations
Date
11.09.2025
Course
zoom
Schedule
Start 15:30, end approx. 17:30
Webinar
Interactive exchange on the topics of data visualization and interpretation
Date
25.09.2025
Course
zoom
Schedule
Start 15:30, end approx. 17:30
Webinar
Interactive exchange on the topics of data cleansing and evaluation + Seminar conclusion
Date
07.10.2025
Course
zoom
Schedule
Start 15:30, end approx. 17:30
21.11.2025
Live online
Booking number: 34159
€ 1.190,- plus VAT.
€ 1,416.10 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Modules
16 hours over 2 weeks
Limited number of participants
Webinar
Kick-off and introduction to the characteristics of data-driven organizations
Date
21.11.2025
Course
zoom
Schedule
Start 10:30 am, end approx. 12:30 pm
Webinar
Interactive exchange on the topics of data visualization and interpretation
Date
28.11.2025
Course
zoom
Schedule
Start 10:30 am, end approx. 12:30 pm
Webinar
Interactive exchange on the topics of data cleansing and evaluation + Seminar conclusion
Date
12.12.2025
Course
zoom
Schedule
Start 08:00 am, end approx. 10:00 am
02.03.2026
Live online
Booking number: 34159
€ 1.190,- plus VAT.
€ 1,416.10 incl. VAT.
Course
zoom
zoom
Technical notes
We use various software to conduct our online events.
Modules
16 hours over 2 weeks
Limited number of participants
Webinar
Kick-off and introduction to the characteristics of data-driven organizations
Date
02.03.2026
Course
zoom
Schedule
Start 13:00, end approx. 15:00
Webinar
Interactive exchange on the topics of data visualization and interpretation
Date
09.03.2026
Course
zoom
Schedule
Start 13:00, end approx. 15:00
Webinar
Interactive exchange on the topics of data cleansing and evaluation + Seminar conclusion
Date
16.03.2026
Course
zoom
Schedule
Start 13:00, end approx. 15:00
Sufficient places are still free.
Don't wait too long to book.
Fully booked.
Training is guaranteed to take place
Booking number: 34159
€ 1.190,- plus VAT.
€ 1,416.10 incl. VAT.
Details
16 hours over 2 weeks
Limited number of participants
Booking number: 34159
€ 1.190,- plus VAT.
€ 1,416.10 incl. VAT.
Details
16 hours over 2 weeks
Limited number of participants
Book later
You are welcome to make a non-binding advance reservation.
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
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.