Power BI: The modern business intelligence tool

• Introduction to the individual components of Power BI: The ETL process Power Query, the data model with DAX, visuals and sharing reports via the Power BI Web Service.
• The differences, advantages, and disadvantages of Power BI solutions and Excel solutions.
• Introduction to the basic principles of Power BI using Excel: formatting data as a table and evaluating it with pivot tables including data slices.
• BI terminology such as dimensions, facts, measures, etc. explained in an understandable way.

• Importing data from external sources such as Excel and CSV files, web data, etc..
• The query editor and its advantages.
• Importing more than 1 million records.
• Appending data from multiple tables.

• Visualization of, for example, time series with line and bar charts.
• The "Card" visual for visualizing individual numbers.
• The "Matrix" visual with its various settings.
• Interacting with data (data slice, filter, and cross filter).
• From the big picture to the details using drill-through hierarchies.
• Integration of external visuals.

• The necessity and usefulness of the star schema.
• Combine tables into a data model.

• Setting up workspaces.
• Differences between sharing directly and sharing via an app.

Lerndauer: 2 days

Diese Veranstaltung findet vor Ort statt (aktuelle Hygienekonzepte)!

• You will learn the most important terms and use cases for Power BI Desktop and be able to apply this knowledge in your company.
• You will learn how to use Power BI to create data models and hierarchies and generate dynamic reports.
• You will learn the most important transformation steps of the ETL process within Power BI and how to apply them using an example.
• You will learn the basics of using Power BI.

Controllers and users from other areas who want to import, prepare, analyze, and visualize large amounts of data from different sources.

A good basic knowledge of MS Excel is required for the seminar. The seminar is not suitable for Excel beginners. No prior knowledge of Power BI is necessary.