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,00
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 group

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

Modules

1
Module 1: SQL & Relational Databases
toggle

Chapter 1: Relational databases

The first chapter introduces you to the topic of databases. You learn what Databases are and where they are used and why. You understand how relational databases are built and know their Advantages and disadvantages. You dive deeper into ER diagrams (Entity Relationship Model) and learn to read them. You build your knowledge around the most important SQL terms and locate SQL as the language to communicate with relational databases. You get an overview of how these Interaction works and what SQL can do.

Chapter 2: Basic SQL
In the second chapter you will learn independently SQL queries and to read relational databases in order to extract company-relevant information. Thereby you distinguish Data formats from each other, learn the Boolean logic and filter tables with Boolean operators. In the first Practice project apply previous learning and build a toolkit to filter, group, sort, and connect data (Join).

Chapter 3: Advanced SQL
In the third chapter you will concentrate on advanced SQL concepts and techniques and how to use them to overcome limitations of basic SQL queries. This includes four concepts for reusing query results: Subqueries, Views, Common Table Expressions (CTEs) as well as the Table creation. In several use cases you will learn advanced filtering and joining methods using nested SQL queries. You'll also learn how to speed up your queries (Indexes) and apply in the second Practice project all the learning content taught so far.

Chapter 4: SQL in practice
In the last chapter the Final project in focus. You will analyze a completely new database independently - from the first exploration to the last query. For this purpose, we teach you two other important concepts that often come up in everyday work with SQL: You learn how to work with Common Table Expressions (CTEs) maintain an overview even with complex queries. You will also build up in-depth knowledge of analytical functions in order to Rankings create or running sums over longer periods of time. In addition, you will get an overview of how you can use SQL in practice after the training and which tools are available to you for this purpose.

2
Module 2: Analytics & Reporting - Focus Power BI
toggle

Chapter 1: Introduction to Power BI
In the first chapter you will learn why data-driven decisions are important and how the workflow of Data Analytics looks like. You learn the most important Basic functions of Microsoft Power BI including data, model, and report views, as well as the filter functions. You load multiple records in the Data view to create a Data model and your first Report to create.

Chapter 2: Data preparation and visualization
In the second chapter you will learn by means of practical exercises the Data visualization best practices and how you can change and format visualizations. Power BI offers numerous visualizations that you can use in reports and dashboards. You'll learn how to avoid typical mistakes and get guidelines on how to format graphics in an understandable way. After that, you'll learn how to use the Power Query Editor with the help of Power BI Desktop for the Data processing and linking different data sources.

Chapter 3: Dashboards and Data Storytelling
In the third chapter you will learn how to write your reports and analyses in Dashboards and with the help of the most important principles of the Data Storytelling efficiently and in an easy-to-understand way to relevant target groups. You'll also learn advanced BI skills. For this you will learn the Basics of Data Analysis Expressions (DAX Language) Get to know. You'll learn basic concepts and best practices for including DAX in your reports and how to write complex DAX code for calculations to generate columns, metrics, and tables.

Chapter 4: Advanced topics
In the fourth chapter basic concepts of statistics in focus. We provide you with the best practices for valid statistical data analysis. Finally, you will deal with advanced methods of Business Intelligencebased on statistics and machine learning. At the end you can use the Drillthrough a cross-page Drilldown use and a Influencing factor analysis perform.

3
Module 3: Final project
toggle

At Final project you will apply your previous learning contents and go through the entire process of data analysis - From ingesting and cleansing data, to analysis and data storytelling. You'll deepen your newly acquired BI skills by learning the Air traffic unpunctuality at a major hub using real data sets. You use SQL and MS Power BI together and investigate and visualize Flight delays at Los Angeles International Airportwhich you prepare a presentation of the results.

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.
4.990,00*
(incl. VAT)
0 € with education voucher