Power BI - The complete Introduction

Learn all you need about Power BI, DAX and Business Intelligence

What you'll learn
- Import data from various sources and transform/prepare it
- Build data models as a star schema
- Create meaningful reports
- Best Practices zu Power BI

Requirements
- No, the course does not require any previous knowledge.

Description
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

Who this course is for:
- Anyone who wants to use Power BI to evaluate their data.
- Controller
More Info