MS Power BI from A to Z
Microsoft Power BI is a powerful platform that allows you to analyze and visualize data quickly and easily, and to share reports and analyses. It also allows you to work on both your desktop and in the cloud in an intuitive way. Power BI is one of the only Business intelligence software that is also user-friendly, so that any analyst can learn to work with it quickly. During our two-day training, you learn how to work with all components of the Microsoft Power BI suite (Power BI Desktop, Power BI Query, Power BI DAX functions, Power BI .com), so that you can make interesting reports, analyses and visually attractive dashboards.
After this training, you will have a solid knowledge of the different Power BI components:
With Power BI Desktop, you can make your own analyses and reports based on different data sources (databases, websites, Excel-files, …)
With Power Query, you can process imported data from diverse sources (atabases, Excel, internet, text) which allows you to convert your data to useable data.
DAX functions help you to process your data.
Power BI .com allows you to adapt your Power BI Desktop reports, but it also allows you to publish and share these reports with your colleagues in a structured way.
This training is primarily aimed at (financial) analysts and controllers who don’t know Microsoft Power BI suite yet, and want to learn the possibilities (analysing, visualizing and presenting).
Prior knowledge of pivot tables and Excel functions is required, or completion of the training Introduction to the Power Platform.
Introduction: overview of the “Power BI” components
Installation (+ versions)
Power Bi files
Power Query (in Power BI Desktop)
Power BI DAX
Power BI Visuals
Power BI .com
Connect to Data Sources
Functionality differences between data sources
Removing empty rows
Converting text to numbers
Intro tot M language (M macro-taal)
Power BI desktop
The interface of Power BI
Relations between tables in Power BI
DAX column calculations
Dax: the concept “context”
Power BI Visuals: graphs, tables, etc
Power BI custom Visuals
Power BI Previews
Power BI Introductie to R
Power BI Monthly Updates system
Publishing Power BI
Power BI .com: dashboards, reports and tiles
Power BI sharing, user roles
Diverse: links with Excel, templates, …
Informative websites: E-learning, …
1.506 EUR (VAT excluded) per person
This training qualifies for the SME portfolio (KMO portefeuille)
From 9 AM to 5.30 PM
Font St Landry 6
In collaboration with