Power BI: The modern business intelligence tool

The basics of the Business Intelligence (BI) tool "Power BI"

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

The ETL process within Power BI: extracting and transforming data from different sources

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

Data visualization with Power BI using practical examples

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

Significance of the data model

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

Share reports in the Power BI (Web) Service

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

Please bring your own laptop to the seminar. You can find more detailed installation instructions under Methods.