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