Cette formation est proposée sous forme de formation présentielle et à distance. En savoir plus

Description

Objectives

At the end of the training, the participant will be able to:

  • create reports with Power BI Desktop
  • manipulate data in Power Query
  • manipulate a data model in Power Pivot
Programme
Interface
  • What is Power BI?

  • Basic Concepts

  • Components of Power BI Desktop:

    • Power Query

    • Power Pivot

    • Power View

Import data
  • Load data from different sources:

    • Excel files

    • Text files

    • Relational Databases

    • Web Pages

  • Updating Data

Data Model
  • Create relationships in the data model

  • Add measures (aggregate calculations) to a table

  • Unidirectional and bidirectional filters

  • Add a column of data

  • Using date and time data

  • Introduction to DAX (Data Analysis eXpressions)

Visualisations
  • Create a simple report

    • Charts

    • Tables

    • Matrixes

    • Slicers

  • Add visualisations

  • Filter a page

  • Filter a report

  • Explore data from a visualisation (drill down)

Power Query
  • Transform Data:

    • Sort

    • Filter

    • Exclude rows depending on their positions

    • Data types

    • Pivoting data

    • Unpivoting data

    • Group Data

  • Duplicate a query

  • Create a reference to an existing query

  • Add columns:

    • Use the automatic features

    • Use functions

  • Combine queries:

    • Append a query to another query

    • Merge queries

  • Add parameters

  • Create a function

  • Overview of the advanced editor

Online Power BI
  • Share data by using the Microsoft Power BI services

Prerequisites

Knowledge of the Windows work environment

Target audience

Managers, employees, project managers wishing to learn about Power BI


Modalités

Support de cours

Course material will be provided at the beginning of the course.

Certificate

At the end of the course, participants will receive a certificate of attendance issued by the House of Training.  

Lieu
Key Job S.A.
65, Avenue de la Gare
L-1611 Luxembourg
Luxembourg
Calculer l'itinéraire

Sessions et horaires

Télécharger le planning (PDF)

  • mer. 19.10.2022

    09:00 à 16:00

    6H

    Power BI Desktop (UK)

    Key Job S.A.

  • jeu. 20.10.2022

    09:00 à 16:00

    6H

    Power BI Desktop (UK)

    Key Job S.A.