Description

The storage of data, whatever their sources and formats (XML, RDBMS, Big Data, Excel, Text File, Web Services, etc.), in a local or external context (Cloud) can only grow. Also, it is natural that increasingly powerful and sophisticated decision support tools are popping up everywhere, including Power BI, the Business Intelligence solution developed by Microsoft, which is becoming more and more essential. In this Power BI Initiation training you will learn to use the product in a complete way according to a progressive educational scenario which will teach you to aggregate data from multiple sources, to transform them if necessary, to carry out more or less complex calculations in particular with the library of DAX (Data Analysis Expressions) functions and operators, to visualize your results with the rich possibilities offered by Microfoft Power BI, to share them securely and finally to analyze the data thanks to the powerful interactive dashboards that you will have built.

Who is this training for ?

For whom ?

This Power BI Initiation training is for any user who needs to use data in a database and create interactive dashboards that can be distributed.

Prerequisites

It is necessary to have current practice in office automation.

Training objectives

Know how to obtain, model and render data.

Create interactive dashboards.

Publish and securely share these dashboards in Microsoft OneDrive and SharePoint workspaces.

Use Power BI best practices.

Training program

• Get hold of Power BI Desktop and the Power BI Service
  • - General presentation of Power BI
  • - Power BI modules
• Get the data
  • - Connecting to data
  • - Data cleaning and transformation
  • - Processing data with irregular formatting
• Modeling in Power BI
  • - Data model and relationships
  • - Creation of calculated columns
  • - Creation of measures
  • - Case of temporal data
  • - Time Intelligence functions
  • - Creating calculated tables
• Creation of restitutions with Power BI
  • - Creating a simple rendering
  • - Combined graphs
  • - Using segments
  • - Using maps
  • - Tables and matrices
  • - Scatterplots
  • - Advanced graphics
  • - Gauges
  • - Color management
  • - Improve formatting
  • - Creating Interactions between visualizations
  • - Manage missing data
  • - Manage hierarchies and drill-down
• Discover the data
  • - Explore data
  • - Create and configure a dashboard
  • - Ask questions in natural language
  • - Create personalized Q&A
• Publish and share from Power BI Desktop

  - n'as pas encore du programme

• Licensing
  • - Licence gratuite
  • - Power Bi Pro
  • - Power BI Premium
• Introduction to DAX (Data Analysis Expressions)
  • - Types of calculations
  • - DAX functions
  • - Variables in DAX
  • - Table relationships and DAX
  • - DAX tables and filtering
• Our best practices for using Power BI effectively and relevantly
  • - Data model optimization
  • - Build a readable and attractive report
  • - DAX code management
  • - Metadata management
  • - Temporal data
  • - Geolocation