Microsoft BI: Introduction to the Power platform
This training qualifies for the SME e-wallet (KMO-portefeuille).
Most of our classroom training courses take place in Belgium (Edegem) or The Netherlands (Breda). Please click the button with the desired date to check the exact location of the training.
Starting from version 2013, Excel contains sveral BI possibilities and help programs that you can use to collect, visualize and analyze data. This is a real “self service Bi solution”.
On the one hand, there are a number of powerful BI tools within Excel that allow you to convert raw data into a integrated, analytical report. On the other hand, you have the Power BI applications that you can use to create online dashboards ( with KPI’s, graphic variance analyses, …) that you can share with other users. These are one by one user-frienly applications that are used standalone or that are integrated in other Office Packages.
During this one-day training, you will learn how to work with the components of the Microsoft Power platform (Power Query, PowerPivot, DAX, Powerview, PowerMap, Insights, power BI Desktop, Power BI publisher for Excel, Power BI .com).
This training is mainly for those who frequently use spreadsheets and don’t know the Microsoft Power BI tools yet, and want to explore the possibilities (analyzing, visualizing and presenting).
After this training, you will have basic insights in the different Power tools from Microsoft BI. You will also be able to select the best tool to analyze and present your database:
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.
With Power Pivot (Excel), you can adapt tables with millions of rows thanks to a range of (DAX) functions. You can also connect tables and build complex pivot tables.
Power Map in Excel is an animation and presentation tool to highlight your geographical Excel Pivot tables via geo-3D visualisations.
Power view in Excel is a reporting tool that you can use to make interactive dashboards, based on pivot tables (this is similar to Power BI Desktop).
Insights (in Excel or Power BI) study your data and show all possible connections and correlations between your data.
The Power BI Publisher tab (Excel) allows you to pin Excel graphs and overview tables directly to the Power BI-dashboards.
Prior knowledge of pivot tables and Excel functions is required.
Overview of the BI ‘Power’ platform
Power BI Desktop
Excel tables en Data Model
Power Pivot (+DAX functions)
PivotTables with Power Pivot
Power Query (with e.g. Unpivot)
Power BI Desktop
What is Power BI? (Power BI versus Excel, installation, ...)
Power BI interface
Query in Power BI
Power BI Dashboard: graphs, tables, DAX …
Publishing Power BI
Power BI en Excel: interaction
‘After-Course’: Informatieve websites, E-learning, ...