01 88 88 32 91

X

Power BI

FP-DNS-001-1.5

•

Fundamental

•

4 days

•

28 hours

Discover how to transform your raw data into strategic information and learn how to create dynamic reports that will make all the difference to your decision-making.

Target audience

This course is aimed at all professionals wishing to use Power BI.

Prerequisites

There are no prerequisites, and this course is accessible to beginners.

Objectives

  • Create and manage datasets in accordance with good modelling practice
  • Designe hard-hitting, dynamic reports
  • Use the service for collaboration and distribution

Evaluation methods

Practical work.

Certification

At the end of the course, trainees will be invited to take a skills test, and if they pass, will be awarded the ” Power BI “issued by Hexagone Executive.

Programme

  1. Creating a data model
    • Introduction and the concept of “Self-BI”
    • Discovering the Power Query interface
    • Connecting to data sources
    • Setting up various transformations
    • Defining a star model and its importance
    • Creating a table of dates
    • Starring the data model
    • Cleaning up the data model
    • Introduction to measurements
    • Creating measurements using the DAX language
    • Creating time calculations
  2. Creating reports
    • Connecting to an existing dataset; Adding and formatting visuals for the report
    • Modifying the interaction between visuals
    • Using slicers for filtering
    • Configuring navigation
    • Implementing custom tooltips
    • Managing drillthrough
    • Implementing conditional formatting
  3. Using the Power BI service
    • Publishing the dataset in the Power BI service
    • Understanding what a dashboard is
    • Creating and configuring a dashboard
    • Discovering the “gateway” concept
    • Automating dataset refresh from the service
    • Sharing content within the organisation
    • Setting up RLS (line-level security)

Register to a session

1650,00 € excl. tax

Intra-company

Would you like to organize this training course in your company? Contact us for more information.

I would like to be contacted