100 % eligible with education voucher
100% Promotion possible.

Analytics & Reporting - Focus Power BI

Guide to effective dashboards in Power BI

Certificate of completion
Beginners
Full time/part time
German, English
1.990
Course description

The training Analytics & Reporting - Focus Power BI provides you with the most important basics for Power BI and the potential of data-driven decisions.

Using Power Query Editor best practices and advanced use cases, you'll create meaningful graphs in MS Power BI that you can drag and drop into audience-appropriate dashboards and present in an easy-to-understand way using data storytelling.

In this training you will learn
Data preparation
Data visualization
Data Storytelling
  • Fundamentals of business intelligence and data-driven decisions
  • Basic functions of Power BI
  • Best Practices for Data Visualization in Power BI
  • Best practices for data processing with Power Query Editor
  • Data Storytelling Best Practices
  • Basics of KPI calculation with DAX language and statistics

Target group

The beginner course is designed for anyone who wants to learn Business Intelligence without complex technological skills in order to prepare data in dashboards. Self-service BI and the use of intuitive tools such as Power BI are sought-after skills in many departments such as Marketing, HR or Finance. The training is also suitable for career changers.

Requirements for participation

No prior or programming knowledge is required for the training.

Learn more about our training
Introduction to BI and Data Analytics

Modules

1
Introduction to Power BI
toggle

In the first chapter, you will learn why data-driven decisions are important and what the workflow of data analyses looks like. You will get to know the most important basic functions of Microsoft Power BI - including data, model and report views as well as the filter functions. You will load several data sets in the data view to create a data model and your first report.

2
Data preparation and visualization
toggle

In the second chapter, you will learn the best practices of data visualization using practical exercises and how you can change and format visualizations. Power BI offers numerous visualizations that you can use in reports and dashboards. You will learn how to avoid typical mistakes and receive guidelines on how to prepare graphics in an understandable way. You will then learn how to use the Power Query Editor with the help of Power BI Desktop for data processing and linking different data sources.

3
Dashboards and Data Storytelling
toggle

In the third chapter, you will learn how to arrange your reports and analyses in dashboards and how to communicate them efficiently and easily to relevant target groups using the most important principles of data storytelling. You will also learn advanced BI skills. You will learn the basics of Data Analysis Expressions (DAX language). You will be provided with basic concepts and best practices for integrating DAX into your reports and learn how to write complex DAX code for calculations to generate columns, key figures and tables.</p

4
Advanced topics
toggle

The fourth chapter focuses on fundamental concepts of statistics. We provide you with best practices for valid statistical data analysis. Finally, you will deal with advanced methods of business intelligence based on statistics and machine learning. Finally, you will be able to use drillthrough to perform a cross-page drilldown and carry out an influencing factor analysis.

FAQ
quotation_marks
testemonial_picture_
The StackFuel Data Lab offers me real added value. Here you can feel the practical relevance particularly well. The tasks were always clearly described and presented. So I always knew what I had to do. The training itself was a great experience!
Alexander Gross
Data Analyst at AIC Portaltechnik
quotation_marks_flipped
quotation_marks
testemonial_picture_
The greatest added value for me is the practical relevance. Thanks to StackFuel, I can quickly implement what I've learned and adapt it for myself. That is the real learning success behind the online trainings.
Lutz Schneider
Strategic IT Buyer at Axel Springer SE
quotation_marks_flipped
quotation_marks
testemonial_picture_
The content of StackFuel's online training was very practical. There were many good examples and projects. I found that very interesting and instructive. Since the training, my everyday professional life has changed significantly: I am now a data analytics specialist in my department.
Jaroslaw Wojciech Sulak
Specialist for data analysis at IAV GmbH
quotation_marks_flipped
quotation_marks
testemonial_picture_
The user-friendly and flexible Python programming training has completely changed my view of complex data structures. Thanks to the sustainable and well thought-out learning concept as well as the seamless application of the learning content in the development environment, I can now implement the newly learned knowledge in my everyday job in test automation in greater depth and process data more easily and efficiently since then.
Jenny Lindenau
Technical Manager Test Management at Bank Deutsches Kraftfahrzeuggewerbe GmbH
quotation_marks_flipped

Let's start with a consultation.

Our consultants will be happy to help you and answer all your questions. Free of charge and without obligation. We look forward to meeting you.
1.990*
(incl. VAT)
0 € with education voucher