Power BI: The fundamentals

Référence : BI-001

Training

This training course is designed for users wishing to master the fundamentals of POWER BI, the Business Intelligence suite of analytical tools, that enables them to create reports easily, collaborate on dashboards and share insights. With this training course, master the basics of this tool and discover all its specific features with the assistance of our expert trainers.

Level : Beginner
Duration : 2 days 
Location : Distance learning
Language : French | English
Price : 1900 € excl. tax
Share :
Organize a dedicated session for members of your organization
Level : Beginner
Duration : 2 days 
Langue : French | English
Share :
Customize this course
Would you like to tailor this training course to your needs? We will be happy to design a customized program for you.
Customized
Share :

View the other levels

01

WHAT YOU WILL LEARN IN OUR POWER BI TRAINING: THE FUNDAMENTALS TRAINING COURSE

  • Connect, query and combine heterogeneous data sources
  • Design measures using the DAX language
  • Discover Power BI Online services
  • Model and prepare data
  • Create and format reports with Power BI Desktop
02

TRAIN WITH POWER BI CONSULTANTS AND EXPERTS

All our training courses are led by experienced consultant-trainers recognized by their peers. Our trainers are certified in each of their areas of expertise, and share their consulting experience through the training sessions.

03

WHO IS IT
FOR ?

Profil

  • Business users
  • Beginner or intermediate technical users

PREREQUISITES

  • Fluent use of spreadsheet software
  • Knowledge of databases is desirable
04

TO MASTER THE FUNDAMENTALS OF POWER BI DESIGNED AND TAUGHT BY OUR SAP EXPERTS

Training methods

50% of the course is dedicated to case studies.

Provision of a learner account on our e-learning platform.

Access to an account on our e-learning platform.

Digital educational documentation provided during the training.

A sign-off sheet is signed upon completion of the course.

Assessment and Monitoring Methods

Competence is assessed throughout the course through practical exercises.

At the end of the day, a multiple-choice test will be carried out to validate the skills acquired during the course.

An assessment of learner satisfaction at the end of the course and a follow up assessment 3 months after its completion.

Training certificate issued to the learner

05

PROGRAM DETAILS FOR OUR TRAINING PROGRAM POWER BI LEVEL 1

Introduction to Power BI

– Presentation of the Microsoft BI offering.

– Introduction to the Power Query editor.

– Extract, transform and load data.

– Use flat files, Excel, relational databases, SSAS and Web sources.

– Choose columns, select rows, filter, sort and delete duplicates.

Getting started with Power BI

– Clean and complete data.

– Split, format and define data types, assemble and merge tables.

– Create calculated columns.

– Stack and merge queries.

– Use Diagram View, design measurements with statistical functions.

– DAX functions for elaborate measurements.

– Use DAX Time Intelligence functions

Visualize your data with Power BI

– Create reports, pages, dashboards.

– Display data: Table, Matrix, Map.

– Use data and formatting parameters.

– Insert visual elements.

– Import visual elements (.pbviz).

– Add filtering tools, segments, KPIs.

– Layout for screen or smartphone.

NEED HELP FINDING THE RIGHT COURSE?