Power BI Introduction

Would you like to learn how to use Power BI to effectively prepare and evaluate your data?

Then you've come to the right place!

In the Power BI video course, you will learn how to create appealing reports from data from different systems in the shortest possible time. The aim of the course is to significantly simplify your daily work through the sensible use of Microsoft Power BI.

In the Power BI training, you will first learn how to import your data from different systems and then summarize it into meaningful data models (star schema). Based on this, the reports are then designed with various visual elements (tables, crosstabs, various diagrams, etc.). Learn the benefits of Power BI Cloud if you want to distribute your reports to many users.

In order to consolidate what you have learned even better and to deepen your knowledge even further, there are a total of 25 tasks and a large workshop in this course. You will find a sample solution to all tasks as a video.

The course is based on an end-to-end training example. The data and the finished model are also included in the course.

Detailed content of the Power BI training

1) Introduction

• Overview Power BI

• Basic handling

• Settings and options

2) Import and prepare data

• Import data (Excel, Access, databases, ...)

• Create and edit queries

• Clean and transform data

3) Creating Data Models

• Conception of data models (star schema vs. 3rd normal form)

• Define relationships

4) Create reports and dashboards

• Create reports with data models

• Creating Tables and Crosstabs (Matrix)

• Define and use filters + slicers

• Define Dillup, Drill-Down, and Drillthroughs

• Using Charts

• Create calculations with DAX

• Dashboards

5) Power BI Service

• Power BI Service Overview

• Using Multi-User Models

• Distributing Reports