Power BI for Controllers
A course for those interested in learning more about data and Power BI in combination with financial management.
In this course, you will learn:
This course will give you fundamental understanding of data modelling, data processing and data analytics using Power BI in a Finance context. The aim is to learn you how to build a repeatable data flow and a finance data model fitted for your reporting and controlling processes. By doing so you will free up time for more analytics and business partnering.
Leverage your data
How we use BI, to help us best utilize the data stored in our business systems and optimize the way we work with data.
Design with Power BI
How you design a financial data model for PnL statements, budget and planning processes, cashflow reporting, etc. with Power BI.
Use Excel
How Power BI and Excel complement each other and how you can work with both tools to improve your finance controlling and reporting processes.
Power BI in the company
How BI looks like in an enterprise setup, including key concepts and technologies. With this know- ledge you will be able to collaborate at eye level with BI specialists.
About twoday's Power BI course for controllers
In this course, you will learn:
- How to use Power BI to tackle common finance data challenges, that are often experienced when working with different data sets in Excel.
- How to build a flexible data model using Excel, Power Query, and Power BI.
- Finally you will experience how using the above mentioned tools can help you to automate your workflow and help you free up time to analyze your data.
When you know the fundamentals and advantages of data modelling on your own desktop PC, you will gain insight into the advantages of integrating busi- ness applications with BI tools in a data platform set-up.
Course content
During the day, you will learn about the data value chain, including concepts such as:
- Data warehousing
- Databases
- Data modeling
- Dimension, transaction and master data
- Report vs dashboard and data visualization
We will publish the data model developed in Power BI to the Power BI Service in order to reuse it in Power BI. And learn how to share data with colleagues in the web.
During the course we will also discuss similarities and differences between Power BI and Excel.
The data skills you will gain in this course, will enable you to implement the theory in your daily work, helping you optmize your business processes from day one.
Practical information and registration
twoday's BI course for controllers is aimed at controllers, analyst, finance professionals, and others who want to learn more about BI and how it can optimize their work processes with data and financial controlling.
Format
The course will be a combination of instructor show cases, exercises, and guided solutions. During the course we will teach you Power BI, Power Query and DAX as a foundation to understand and learn data modelling and BI.
Date, place, price and registration
twoday's BI course for controllers is regularly held in Copenhagen, Aarhus and Kolding.
The price is DKK 4,000 ex VAT, including meals and refreshments. Maximum number of participants is 6. Please note that we offer a multiple enrollment discount and individual and company-specific cour- ses can be arranged. Contact twoday kapacity for more information.
Click on the city for which you want to see course dates – and then click on a course to sign up.