Course
PBICGL
Microsoft Power BI in Controlling («PBICGL»)
In this one-day controlling course, you will learn how to connect and transform various data sources with Power BI and then transfer them into a dynamic dashboard or standard reports, as well as how to assign roles and authorisations.
Vendor code
PBICGL
Duration
1 day
Price
990.–
Course documents
Digital Digicomp courseware
Course facts
- Understanding the BI framework in the context of controlling
- Creating your own simple reports and dashboards with Power BI
- Getting to know the Power platform
- Getting to know (an overview of) other automation techniques
1 Classification in the Power Platform
2 The Power BI environment (desktop, cloud, mobile)
3 The BI framework with a focus on controlling
- ETL: connecting, transforming and loading data
- Data modelling: combining facts and dimensions
- Visualisation: creating dynamic dashboards and reports, best practices
4 A complete controlling case
5 Roles and authorisations
6 Comparison with other automation technologies (Power Query, VBA, RPA, other BI tools)
Component of the following courses
This course can be taken as either a one-day course or two half-day courses. Please refer to the timetable for more information.
- Specialists and managers from the fields of accounting, controlling and general management, who are responsible for controlling and business administration
- Administrators who share responsibility for a company's financial matters
This is not a beginner's course. You should have a good knowledge of Excel, especially formulas and functions. You must also have the desktop version of the Power BI app installed. A virtual learning environment can be provided free of charge.
The course builds on the knowledge of the following course: