Qualification for the Job Role of a Business Intelligence Analyst

BI Analyst – Focus Power BI

Course description

The certified online course to become a BI Analyst – Focus Power BI allows you to get started in (self-service) Business Intelligence. You will build up practice-oriented expert knowledge of SQL and relational databases. We will teach you how to get the most out of relational databases and avoid common pitfalls with the latest SQL best practices. You will learn the most important basics for BI with Microsoft Power BI. Using the best practices of the Power Query Editor as well as advanced use cases, you will create meaningful visualizations, which you will prepare to target group-oriented dashboards and present in an easy-to-understand way with the help of data storytelling. You will complete the online course with a company-relevant final project on flight delays at the Los Angeles International Airport and, on successful completion of the career path, you will qualify for a role as a (Junior) BI Analyst, Business Analyst, or analytical role in a specialist department as a Reporting Analyst.

In this  course you will learn:  

  • Using SQL to create data overviews quickly and practically, to write and execute basic and advanced SQL queries
  • Using SQL to create data overviews quickly and practically, to write and execute basic and advanced SQL queries
  • Basics of business intelligence and basic functions of Power BI
  • Best practices for data visualization and processing in Power BI
  • Best practices in data storytelling
  • Basics of KPI calculation with DAX language and statistics
  • Target Audience  

    The beginner’s course 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 enthusiasm for logical thinking and the visual preparation of results. This further training is suitable for career changers and is the ideal introduction to business intelligence to become a Power BI Analyst or Developer or a Business Intelligence Analyst or Consultant.

    Prerequisites for participation 

    No prior knowledge or programming skills are requested for the course.
    Online course
    72 hours (4 months)
    3 modules + 1 final project
    Entry level
    German
    Certificate of completion
    €4,790.00 incl. VAT
    31.10.2022
    What to Expect

    Course Overview

    Power BI skills

    Mircosoft Power BI is the #1 business intelligence tool and relatively easy to learn, even for beginners.

    Real-world exercises

    Apply your knowledge in two interactive real-world projects and consolidate it for later use in day-to-day life.

    Final project

    In your final project, you will apply the techniques you have learned to consolidate your BI skills.

    Power BI skills

    Mircosoft Power BI is the #1 business intelligence tool and relatively easy to learn, even for beginners.

    Real-world exercises

    Apply your knowledge in two interactive real-world projects and consolidate it for later use in day-to-day life.

    Final project

    In your final project, you will apply the techniques you have learned to consolidate your BI skills.

    Modules

    Chapter 1: 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 delve deeper into ER diagrams(Entity Relationship Model) and learn how to read them. You will build your knowledge around the most important SQL terms and locate SQL as the language to communicate with relational databases. You will get an overview of how this interaction works and what SQL can do.

    Chapter 2: Basic SQL
    In the second chapter, you will learn how to write SQL queries and read relational databases in order to extract company-relevant information. You will distinguish between data formats and learn about Boolean logic and filter tables with Boolean operators. In the first practical project, you will apply the previous learning content and build a toolkit to filter, group, sort and join data.

    Chapter 3: Advanced SQL
    In the third chapter, you will focus on advanced SQL concepts and techniques and how to use them to overcome the limitations of basic SQL queries. This includes 4 concepts for reusing query results: subqueries, views, Common Table Expressions (CTEs) and table creation. In multiple use cases, you will learn advanced filtering and joining methods using nested SQL queries. In addition, you will learn how to accelerate your queries (indexes) and apply all the learning content taught so far in the second practical project.

    Chapter 4: Analytical Functions and Excercise Project
    The final chapter focuses on the practical project. You will analyze a completely new database independently – from the first exploration to the last query. For this, we teach you two more important concepts that often come up in everyday work with SQL: you will learn how to optimally use arithmetic with SQL and how to calculate with SELECT. You also build up in-depth knowledge of analytical functions in order to create ranking lists or calculate running totals over longer periods of time. To do so, you determine statistical parameters such as correlations, standard deviations and medians, create window functions and learn to control various SQL dialects.
    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 Visualization

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

    Start Dates

    22.08.2022
    Duration: 4 months

    Download the curriculum now.

    LEARNING ENVIRONMENT

    Train online in your browser in our interactive learning platform.   

    StackFuel provides an innovative learning environment to develop your data skills in the most effective way – interactively and with real-world exercises. Learn to code in our Data Lab and develop algorithms and automate things with real industry datasets. Learn more now and benefit from 80% practical content in our courses. 
    WHY STACKFUEL 

    We are your strategic learning partner - including mentoring & support.   

    Whether you are an employee, a manager, or looking for a job – we will help you become a data expert with our certified and fundable upskilling and reskilling courses, which are suitable for every specialist department and every career level. We’ll ensure you learn successfully with our dedicated mentoring team to keep an eye on your progress. Our practical tasks and projects will prepare you for dealing with the latest technologies and applications.  

    Künstliche Intelligenz in Unternehmen: AI Literacy hilft Dir dabei, den Einsatz von KI in Unternehmen besser zu verstehen und Du bekommst die nötigen Kernkompetenzen, um bestehende und neue KI-Anwendungen anhand verschiedener Szenarien aus dem Business-Alltag sicher zu verstehen, für Dein Unternehmen erfolgreich zu übertragen und mit ihnen zu interagieren.
    Feedback
    What our graduates have to say. 

    Check out our other courses.

    BI Analyst – Focus Power BI
    Qualification for the Job Role of a Business Intelligence Analyst
    Type:
    Online course
    Duration:
    72 hours (4 months)
    Analytics & Reporting – Focus Power BI
    Guide to Effective Dashboards in Power BI
    Type:
    Online course
    Duration:
    32 hours (4 weeks)
    Python – Focus Object-Oriented Programming
    Design Principles for Software Development with Object-Oriented Programming
    Type:
    Online course
    Duration:
    32 hours

    Check out our learning platform now!

    Find out why more and more leading companies are using StackFuel to train their employees online. In our a call with us, you’ll learn how your company can build data skills and make your workforce transformation a smooth success.