Microsoft BI: Introduction to the Power platform

Duration

1 day

Overview

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).

Course Objectives

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.

Prerequisites

  • Prior knowledge of pivot tables and Excel functions is required.

  • 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).

Course Content

  • Overview of the BI ‘Power’ platform

    • Power Pivot

    • Power View

    • Power Query

    • Power Map

    • Power BI Desktop

    • Power BI.com

  • Excel tables en Data Model

  • Power Pivot (+DAX functions)

  • PivotTables with Power Pivot

  • Power View

  • Power Map

  • 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, ...

 

Enroll here


Training cost

Full Price
1.506 EUR (VAT excluded) per person

This training qualifies for the SME portfolio (KMO portefeuille)

Practical details

Classroom
From 9 AM to 5.30 PM

Language

Dutch

Location

Business Faculty
Font St Landry 6
1120 Brussels


In collaboration with