Analyze Your Data with Power BI
(3 days)


Prenez des décisions éclairées en vous appuyant sur des analyses de pointe

Nb. days
3
Face-to-face?
Yes
Remote?
Yes
Min. participants
2
Max. participants
8
Place
Toulouse, Paris, etc.
Pricing
1900€ HT
Analyze Your Data with Power BI <br/> (3 days)

In recent 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 add value to your data and help you make strategic decisions.

If you have already used a spreadsheet program (Microsoft Excel, OpenOffice Calc) or if you are already familiar with a BI tool, but 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 parties in complete security.

This training will be a first step in the preparation for the PL-300 certification : Microsoft Power BI Data Analyst

Goals

  • Connect and prepare data with Power Query
  • Create data models using DAX formulas
  • Design interactive reports with Power BI Desktop
  • Master the codes of data visualization to get your message across effectively
  • Publish and share your reports with Power BI Service and Power BI Mobile
Alexia Audevart
To know the dates of the next training sessions,
to adapt this program to your needs
or to obtain additional information,
contact us!

Teaching method

70% hands-on work

Prerequisite

Basic spreadsheet skills (Microsoft Excel) are required.

Targets

  • Data Analyst
  • Developer
  • Data Scientist
  • BI Professional
  • Management Controller
  • Manager

Evaluation

This training does not require a formal assessment of learning

Program

Introduction

  • A few reminders about Business Intelligence (BI)
  • Overview of data analysis
  • Overview of Microsoft's BI offering
  • Power BI Ecosystem

Data Preparation

  • Connection to data from different data sources (Excel, CSV, database, Web)
  • Importing data and/or Direct Query
  • Preparation of data with Power Query
  • Resolution of performance issues

Data Modelisation

  • Design of a data model
  • Development of a data model
  • Creation of formulas with DAX
  • Optimization of model performance

Data Visualisation

  • Introduction à la data visualisation
  • Introduction to data visualization
  • Creating reports
  • Discovering the different visuals
  • Enriching reports
  • Power BI Mobile

Data Analysis

  • Enhanced reporting to highlight information
  • Perform advanced analysis

Power BI service

  • Creating and managing workspaces
  • Navigating a report
  • Sharing and security
  • Dashboard management
  • Setting up dataset management and dataflows
  • Discover the advanced features of Power BI Service

FREN