StackFuel Friends - Recommend StackFuel and receive €500!

> Learn more

100 % eligible with education voucher

100% Promotion possible.

BI Analyst - Focus Power BI

Qualification for the job role as Business Intelligence Analyst

Certificate of completion

(Cross) boarding

Full time/ Part time

German, English

4.990

Course description

With the certified online training to become a BI Analyst - Focus Power BI, you get started in (self-service) Business Intelligence. You will build up practical expert knowledge for SQL and relational databases. We teach you how to get the most out of relational databases and avoid common mistakes with the latest SQL best practices. You get the most important basics for BI with Microsoft Power BI at hand.

Using the best practices of the Power Query Editor as well as advanced use cases, you will create meaningful visualizations, which you will prepare in target group-oriented dashboards and present in an easy-to-understand way with the help of data storytelling. You will finish the online course with a company-relevant final project on flight delays at Los Angeles International Airport and, upon successful completion of the career path, you will qualify for a job role as a (Junior) BI Analyst, Business Analyst or an analytical job role in a specialist department as a Reporting Analyst.

In this training you will learn

SQL Basics

Power BI Basics

Data Storytelling

Create data overviews quickly and practically with SQL in order to
write basic and advanced SQL queries
and execute
Advanced knowledge of views, CTEs, subqueries, and
Window Functions
Basics of Business Intelligence and basic functions
from Power BI
Best practices for data visualization and processing
in Power BI
Data Storytelling Best Practices
Basics of KPI calculation with DAX language and statistics

Target audience

The advanced training BI Analyst - Focus Power BI is suitable for anyone who wants to learn Microsoft Power BI as a business intelligence tool and use it professionally. You should have an enthusiasm for logical thinking and the visual preparation of results. The training is suitable for career changers and the ideal introduction to business intelligence to become a Power BI Analyst or Developer or Business Intelligence Analyst or Consultant.

Requirements for participation

Assessment test
Basic knowledge of mathematics & statistics

Learn more about our training
Introduction to BI and Data Analytics

Table of contents

1
Module 1: SQL & Relational Databases

Chapter 1: Introduction to Relational Databases
The first chapter introduces you to the topic of databases. You will learn what databases are, where they are used, and why. You will understand how relational databases are constructed and familiarize yourself with their advantages and disadvantages. You will learn to write SQL queries independently to extract company-relevant information from relational databases. In the first practical project, you will apply the previous learning content and filter data using Boolean logic.
Chapter 2: Advanced SQL
In the second chapter, you will refine both your theoretical and practical knowledge. You will learn to group, sort, and join data with your queries. Additionally, you will learn about Subqueries, which provide new filtering options. In the second practical project, you can reinforce everything you've learned so far.
Chapter 3: Advanced Database Design
In the third chapter, you will focus on the structure of relational databases. To better understand their construction, you will delve into database design and learn about normalization rules. To put your knowledge into practice, you will learn how to create or modify tables and data. In the third intermediate project, you will design a database and implement your design practically.
Chapter 4: SQL in Practice
The final chapter focuses on the culmination project. Here, you will independently analyze a completely new database - from the initial exploration to the final query. We will introduce you to two more important concepts that frequently arise in everyday SQL work: you will learn how to use Common Table Expressions (CTEs) to maintain clarity in complex queries. You will also deepen your knowledge of analytical functions to create rankings or calculate running totals over extended periods. Additionally, you will gain an overview of how to apply SQL in practice after training and what tools are available for you.

2
Module 2: Analytics & Reporting - Focus Power BI

Chapter 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 learn about the most important basic functions of Microsoft Power BI - including data, model, and report views as well as the filter functions. You will load multiple data sets in the Data View to create a data model and your first report.

Chapter 2: Data Preparation and Data Storytelling
In the second chapter, you will learn about data visualization best practices and how to modify and format visualizations using hands-on exercises. Power BI offers numerous visualizations that you can use in reports and dashboards. You will learn how to avoid typical mistakes and get guidelines on how to format graphics in an understandable way. You‘ll then learn how to use the Power Query Editor with Power BI Desktop to process data and link disparate data sources.

Chapter 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 to relevant target groups in an efficient, easy-to-understand way 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‘ll learn basic concepts and best practices for incorporating DAX into your reports and learn to write complex DAX code for calculations to generate columns, metrics, and tables.

Chapter 4: Advanced Topics
The fourth chapter focuses on basic concepts of statistics. We will provide you with the best practices for valid statistical data analysis. Finally, you‘ll explore advanced business intelligence methods based on statistics and machine learning. At the end, you will be able to use a cross-page drilldown and perform an influence factor analysis with the help of the drillthrough.

3
Module 3: Final project

In the final project, you will apply your previous learning and go through the entire process of data analysis - from importing and cleansing data, to analysis and data storytelling. You‘ll deepen your newly-acquired BI skills by analyzing air traffic tardiness at a major hub using real data sets. You will use SQL and MS Power BI together and investigate and visualize flight delays at the Los Angeles International Airport, preparing a results presentation.

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_0

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_1

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_2

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_3

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.

4.990*

(incl. VAT)

0 € with education voucher

English