top of page
Power BI Initiation.png

Microsoft POWER BI

Initiation

Presentation

For the past few years, Power BI, Microsoft's Business Intelligence solution, has become a must-have for exploring, analyzing, and visualizing data. This set of tools allows you to connect to various data sources and create interactive reports that enhance your data and help you make strategic decisions.

If you have already used a spreadsheet or are familiar with a BI tool, and you would like to learn more about the opportunities offered by Power BI, this training is for you.

At the end of this training, you will be able to connect to various data sources. You will be able to create an optimized data model (using the many native features of Power Query) and enrich your models using the DAX language. Then, you will be able to create interactive reports and share them with interested people in complete security.

Description

Teaching method and techniques

  • Projected training support documents

  • Practical case with the use of illustrated and didactic exercises.

  • Theoretical presentations

  • A course support will be given to each participant including slides on theory and exercises. A sign-in sheet for each half-day of attendance is provided at the end of the training as well as a certificate of completion of training if the trainee has attended the entire session.

  • Tool used: Microsoft Power BI Desktop

Accessibility for people with disabilities

For any information, please contact our disability representative using the contact details below: Sophie Lienard

sophie.lienard@abalon.fr

Goals

  • Acquire a methodology for data exploitation

  • Design interactive reports with Power BI Desktop

  • Master the codes of data visualization to effectively get your message across

  • Publish reports to Power BI service and build dashboards

Assessment methods

A synthesis exercise in the form of a case study allows the acquisition of skills to be validated.

Audience

  • Data Analysts

  • Data Scientists

  • Developers

  • BI Professionals

  • Business controllers

  • Managers

No Prerequisites

  • Basic knowledge of Excel is recommended.

  • No prior knowledge of Power BI is required

Satisfaction rate

88% in 2023 (18 participants)

The program

Introduction to Power BI Desktop

Power Query

  • Connect to local sources (Excel or CSV)

  • Introducing the Query Editor

  • Basic functions of transformation

  • Understanding the structure of a query

  • Introduction to the M language

Modeling

  • Simple star model (only 1 to many relationships)

  • Understanding the impact and interest of modeling

  • The different types of relationships

  • The importance of the Calendar table

DAX

  • Create Aggregate Functions

  • Use Quick Measures and CoPilot

  • Create a calculated column

  • Filters/Lines Context and Context Transitions

  • Using CALCULATE

  • Time Intelligence Functions

Data visualization

  • Presentation of the parts of a visual

  • Create your first visual

  • Main standard visuals

  • Interaction of visuals

  • Using Segments

  • Bookmarks, Navigation, Buttons

  • Conditional Formatting

  • Themes

  • Best practices in Datavisualization

Power BI Services Initiation

  • Workspace

  • Publish

Integration with other Microsoft tools

  • power point

  • Usage in Excel (Power Query / Power Pivot)

​

Rates

Intra-Company €4,000 excluding VAT (up to 8 people max)

​

Access terms and conditions

Registration link ( 1 month)

​

bottom of page