Live-Online: Power BI: The modern business intelligence tool: Introduction to data analysis, evaluation and visualization with Power BI

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.

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