100 % eligible with education voucher

100% Promotion possible.

Analytics & Reporting - Focus Power BI

Guide to effective dashboards in Power BI

Certificate of completion

Beginner-friendly

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 audience

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.

Modules

1
Introduction to Power BI

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

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

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

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

Why should I choose a career in data, coding or AI?

The demand for data experts is high. Around 4 million data experts will be needed in Europe by 2025. In Germany alone, 149,000 IT jobs are currently vacant. The demand for data and AI experts in particular continues to grow enormously.

But a decision for a data career is so much more than just a safe decision for the future! As a data expert, you deal with powerful, socially relevant topics, are a tech professional, and are communicative and creative at the same time. The profession is varied, can be combined with most other professions and offers an attractive salary. And most importantly, with us it can be learned unerringly!

Am I qualified to work in this profession after further training as a data analyst and data scientist and can I make a lateral move?

Yes, after successful completion of the training, you will receive a certificate of completion from us that you can show in your job applications. Data Analysts and Data Scientists are desperately sought after in many business sectors. Even without relevant work experience, your chances of finding an entry-level job are good. In addition, there are analysts in almost every industry who have different job titles, but the skills you need are the same as those of a data analyst or data scientist.

Can I really organize my learning time freely?

Yes, our online training courses are designed to offer you the greatest possible flexibility. In general, we recommend that you plan six to eight hours per week for learning. When you want to schedule this time is up to you and is not prescribed by us. In our career paths, the Data Analyst and Data Scientist course, we offer live webinars where you can ask our mentors questions, but you don't have to attend if it doesn't fit into your schedule.

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 course itself was a great experience!

Alexander Gross
Data Analyst at AIC Portaltechnik

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 courses.

Lutz Schneider
Strategic IT Buyer at Axel Springer SE

testemonial_picture_

The content of StackFuel's online course was very practical. There were plenty of good examples and projects. I found that very interesting and educational. Since the course, my day-to-day 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

testemonial_picture_

The user-friendly and flexible Python programming course 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 new things I've learned in my day-to-day work in test automation in more detail and process data more easily and efficiently than before.

Jenny Lindenau
Technical Manager Test Management at Bank Deutsches Kraftfahrzeuggewerbe GmbH

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

English