StackFuel Friends - Recommend StackFuel and receive €250!
EN
Monday to Friday from 9:00 am to 6:00 pm
Train the core competencies of self-service business intelligence with SQL, Power BI and data storytelling.
In the certified BI Analytics module, you will learn the basics of (self-service) business intelligence. You will build up practice-oriented expert knowledge of SQL and relational databases and learn how to work competently with relational databases and avoid common mistakes using SQL best practices. You will learn the most important basics of Microsoft Power BI and practise gaining logical insights from various data sources and preparing them in a visually appealing way.
You will learn how to merge and clean data with PowerQuery in order to create meaningful visualizations. You will practise preparing these in target group-oriented dashboards and learn how to present them in an easily understandable way using data storytelling. You will complete the BI Analytics module with a practical final project on flight delays at Los Angeles International Airport. By successfully completing the module, you will acquire the most relevant skills to be successful as a BI Analyst, Business Analyst, Reporting Analyst or analytical (junior) roles in specialist departments.
The first chapter introduces you to the topic of databases. You will learn what databases are and where they are used and why. You will understand how relational databases are structured and know their advantages and disadvantages.
You will learn how to independently write SQL queries to read relational databases and extract company-relevant information. In the first practical project, you will apply the previous learning content and filter the data with the help of Boolean logic.
In the second chapter, you will refine both your theoretical and practical knowledge. You will learn how to group, sort and join data with different joins using your queries. You will also learn about subqueries, which open up new filter options. You can consolidate everything again in the second practical project.
In the third chapter, you will focus on the structure of relational databases. To better understand their structure, you will dive into database design yourself and learn about the normalization rules. So that you can put your knowledge into practice, you will learn how to create or change tables and data. In the third intermediate project, you will design a database yourself and put your design into practice.
The final chapter focuses on the final project. You will analyze a completely new database independently - from the first exploration to the last query. To do this, we teach you two other important concepts that often come up in everyday work with SQL:
You will learn how to use Common Table Expressions (CTEs) to keep track of even complex queries. You will also build up in-depth knowledge of analytical functions to create ranking lists or running totals 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.
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.
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.
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.
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. At the end, you will be able to use drillthrough a cross-page drilldown and perform an influence factor analysis.
In the final project, you will apply your previous learning content and go through the entire process of data analysis - from importing and cleansing data to analysis and data storytelling. You will deepen your newly acquired BI skills by analyzing air traffic unpunctuality at a major hub using real data sets. You will use SQL and MS Power BI together to investigate and visualize flight delays at Los Angeles International Airport. You will then create a presentation of the results.
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 % 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