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 training 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 group

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.

Requirements for participation

  • Assessment
  • Basic knowledge of mathematics & statistics
    • Type

      Online course

    • Duration

      4 months

    • Structure

      3 modules + 1 final project

    • Level

      Entry level

    • Languages

      German or English

    • Completion

      Certificate of completion

    That awaits you

    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.

    Modules

    Module 1: SQL & Relational Databases

    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.

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

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

    Download the curriculum now.​

    Learning environment

    Train online in the browser in our interactive learning platform.

    StackFuel offers you an innovative learning environment with which you can develop your data skills in the most effective way – interactively and with real practical tasks. Learn to program in our data lab and develop algorithms and automations with real data sets from the industry. Convince yourself now and benefit from 80% practice in our training courses.
    Why StackFuel

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

    Whether you are an employee, unemployed or a manager – we will develop you into a data talent with our fundable further training and retraining courses that are suitable for every department and every career level. We ensure your learning success with our dedicated mentoring team and always stay on the ball with you. Our practical tasks and projects make you fit for dealing with the latest technologies and applications.
    100% FOR YOU

    Personalize your learning experience.

    Non-binding trial week
    With our non-binding trial week you get an insight into your desired training. Then you have the choice: either you decide on the training or you look for another one that suits you even better.
    Individual course modules
    With us you can put together the modules of your further training tailored to your needs. Whether business intelligence, data analytics, data science or programming: use your time optimally to build up expert knowledge and develop your skills individually.
    Feedback

    Here's what our graduates say.

    Payment options

    Find your suitable financing.

    With an education voucher, you can have your further education financed 100% by the job center or the employment agency if you are currently registered as unemployed or looking for a job.
    If you are employed, you can have your employer partially or fully finance your further training through the Qualification Opportunities Act – regardless of qualification, age and company size.
    If you are currently enrolled at a university or college in Germany, you can complete our courses at a 50% discount.
    Use our installment plan to spread the cost of your training over several months and maintain your financial flexibility.
    Pay safely and easily after your training by having us issue you an invoice.
    Our FAQ

    The most important questions at a glance.

    The need for data experts is high. Around 4 million data experts will be needed in Europe by 2025. And in 2021 alone, more than 80,000 positions for IT specialists were advertised in Germany. Above all, the demand for data and AI experts continues to increase enormously. But a decision for a data career is so much more than just a secure future decision! As a data expert, you deal with strong, socially relevant topics, and at the same time you are a tech professional and communicative and creative. The job is varied, can be combined with most other jobs and offers an attractive salary. And the most important thing: It can be learned with us without fail!
    Yes, after successfully completing the training, you will receive a certificate of completion from us that you can show when you apply. Data Analysts and Data Scientists are desperately needed in many economic sectors. Even without relevant professional experience, your chances of getting an entry-level job are good. In addition, there are analysts in almost every industry, they have different job titles, but the skills you need are the same as those of a data analyst or data scientist.
    No, the training is flexible in terms of time and designed to be part-time. You can pursue your profession without restrictions and can plan your learning times at the time that suits you best. If you suddenly have more time available, you are welcome to contact us by e-mail and we will activate the learning content for the part-time version in your account. In this variant, you can complete the training in just four weeks. If you notice that you need more time, you can still complete the content in the normal time.

    Yes, our online training courses should offer you the greatest possible flexibility. Basically, we recommend planning six to eight hours a week for studying. 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 you live webinars where you can ask our mentors questions, but you don’t have to attend if it doesn’t fit into your schedule.

    (Participants in our funded training courses are an exception. They have to attend a fixed number of hours per week and are obliged to take part in the live webinars.)

    Free Consultation

    Let yourself be free and without obligation advice from us!