Power BI - Advanced

Inter and intra-company training

Who is the training for?

  • BI Consultant
  • Power BI Consultant
  • Power BI Developers

Level reached

Advanced

Duration

3,00 day(s)

Language(s) of service

EN FR

Prerequisites

  • Advanced knowledge of Microsoft Excel or a similar tool
  • First-level knowledge of Power BI
  • Power BI Pro or Premium license
  • The training could be adjusted if Power BI Premium is already installed

Goals

  • Create advances data models and Power BI reports with BI and Power BI best practices
  • Develop advanced DAX measures and complex calculated columns
  • Understand the Power BI ecosystem: Power BI Service, Power BI Mobile, etc.
  • Monitor Power BI activity from the cloud (Power BI Service)
  • Use and understand Power BI external tools
  • Preparation for Power BI certification

Contents

Day 1

  • Business Intelligence: Quick Reminder
  • Modern BI (Real Time, AI, Cloud)
  • Power BI: Pricing & Architecture
  • Power BI in Power Platform
  • Workspaces & Apps
  • Power BI Security (RLS & OLS)
  • Power Query: advanced
  • DAX Measures: advanced
  • Power BI Service: guided Tour

Day 2

  • Bookmarks: overview & concept
  • Incremental Refresh & Hybrid Tables
  • DataSet vs DataFlow vs DataMart
  • Themes in Power BI
  • Create Bookmarks
  • Charticulator
  • Create and Personalize Themes in Power BI
  • Publish & Share Reports in Power BI Portal

Day 3

  • Data Gouvernance
  • External tools
  • Performance Analyzer
  • Prepare for Microsoft Certification (DA-100 / PL-300)
  • Power BI Administration Portal
  • Metrics Usage & Activity Monitoring
  • Create Power BI Mobile Application

Certificate, diploma

This training focused on practice and interaction, allows you to successfully pass the Power BI certification. A certificate of participation will be sent to the participants.Une attestation de participation sera transmise aux participants.

These courses might interest you

EN
Day
On request
Computer science - Business intelligence - Business Intelligence