StackFuel Friends - Recommend StackFuel and receive €250!
EN
Monday to Friday from 9:00 am to 6:00 pm
Qualification for the job role as Business Intelligence Analyst
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.
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.
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.
Find your training program with us and start your data career! Book a non-binding consultation now.
Our training courses are developed and produced by our own team of data scientists and subject matter experts, who provide you as a participant with personal mentoring during the course. We not only focus on realistic and practical content, but also ensure that all your questions are answered in a personal exchange and thus guarantee your learning success.
Thanks to our "learning-by-doing" principle, you will learn in our interactive learning environment with realistic data sets and real business cases from the industry, preparing you perfectly for a successful career start in a data job.
With StackFuel, you can rely on a market leader with Germany's most innovative learning platform to develop your data skills in a practical way. In certified training programs, you learn online, flexibly and with 80 % of practical content.
This will enable you to make a lateral entry as a data analyst or data scientist and learn how to use data and the basics of artificial intelligence professionally. Your new data career starts with your online training at StackFuel.
Data has become an integral part of our (professional) lives. In almost all areas, data helps you to better understand facts and make more precise decisions. Data skills are the key to being able to use and interpret data correctly. Even though you may not realize it, you work with, interact with and generate data every day.
This data is becoming increasingly important for companies and is the basis for decisions and business models, which makes data professionals incredibly important for companies.
English 
German