IT controlling with Power BI – fast, practical, efficient

In this seminar you will learn about the advantages of key figures for IT applications, infrastructure and organization in the context of IT controlling and how to use them in a practical way with the help of Power BI. Whether in the context of a management cockpit or application in the balanced scorecard, the aim is to demonstrate and apply practical solutions.

Module 1: Basics

In Module 1: Fundamentals, we want to show what we mean by value contribution. We also look at it from different perspectives. This seminar focuses on IT controlling. We show how this complex topic can be applied quickly, practically and efficiently in day-to-day work with regard to IT value contribution. The seminar creates the prerequisites for determining and presenting the IT value contribution.

Topics

• Calculation of important business parameters with the help of benchmarking
• Efficient formulas and functions
• Professional report presentation including dynamic diagram design (Management Cockpit, Balanced Scorecard)
• Optimal integration of Excel tables and charts in PowerPoint
• Tips & tricks in and with Excel for “everyday controlling”

Methods

In order to guarantee you the best possible learning outcome, we combine a range of methods in our seminars. The following are used in this module:

• Key Notes
• Best Practices
• Discussions and exchange of experiences between trainers and participants
• Self-reflection
• Collegial case work

Benefits

Overall, the seminar “IT Controlling – practice-oriented, fast, effective” offers participants a valuable opportunity to expand their Power BI skills in the context of IT controlling and to gain practical knowledge for their everyday work.

Practical application of Power BI: Participants are given the opportunity to use Power BI effectively for IT controlling. They learn practical techniques and functions for calculating key business figures and creating professional reports.

Efficient use of benchmarking: The seminar teaches participants the advantages and methods of benchmarking for IT applications, infrastructure and organization. They will be enabled to use benchmarking as an instrument for increasing performance and improving efficiency.

Professional reporting: The seminar enables participants to create professional reports and presentations that clearly illustrate key business figures. You will learn how to design dynamic diagrams and integrate Power BI graphics optimally into PowerPoint.

Optimization of day-to-day controlling: Participants receive valuable tips and tricks for day-to-day controlling in Power BI. They learn efficient working methods and techniques to optimize their work process and save time.

These topics are of particular interest to the following groups of people:

Target group

• (Partial) project/program manager
• PMO/PO/Project Assistant
• IT Portfolio Manager
• Product Manager
• IT Quality Manager
• IT Controller
• IT Buyer
• Group/team leader

Seminar language:

German (optional: English)

The seminar is part of the IT Value Manager Basic certificate.