Power BI Advanced

Learn via : Virtual Classroom / Online
Duration : 2 Days
Download PDF
  1. Home
  3. Power BI Advanced

Description

    If you’ve mastered the basics of creating Power BI reports, you may like to find out what else it can do – but you should only consider attending this course if you use Power BI regularly.  Delegates will also learn how to improve the user experience through the use parameter tables, how to customize the data model by including calculated tables; and how to work with advanced visuals and dashboard tiles.

    Learn how to create report themes and templates, find out how to use quick measures and bookmarks, delve further into Query Editor and maps, as well as the use of advanced DAX formulas.

     

    What you will learn

    • Create Advanced Power BI Reports
    • Advanced understanding of the data schemas and extracting data
    • Perform advanced transformations of data or any data schema
    • Utilize time-phased data in the creation of complex analyses
    • Create new measures using DAX
    • Explore Data Visualizations
    • Create and publish Reports

Outline

Introduction

  • What you should know
  • Our project: Creating an advanced Power BI dashboard

Working with Data

  • Importing online data sources
  • Uploading from a folder of data
  • Querying a database
  • Importing and transferring data imported from an Excel, CSV, or TXT file

Query Editor 

  • Introducing Query Editor steps
  • Transposing data tables
  • Splitting fields and columns
  • Formatting data with text formulas
  • Creating conditional formulas
  • Creating calculated formulas

DAX Language              

  • Introducing DAX
  • Introducing DAX measures
  • Understanding DAX measure logic
  • Evaluating DAX measures
  • Leveraging the CALCULATE functionality
  • Understand how filters work in CALCULATE function
  • Leveraging the ALL function
  • Understanding the FILTER functionality

Introduction to DAX Formulas               

  • Creating a separate table for measures
  • Creating a table using GENERATESERIES formula
  • Leveraging the POWER function
  • Leveraging the DIVIDE function
  • Utilizing the X factor (SUMX, COUNTX, etc.) for ranges
  • Utilizing quick measures

Advanced DAX Calculations

  • Creating a date table using a formula
  • Filtering between tables
  • Utilizing IF statements with conditional functions
  • Introducing the DATEDIFF measure
  • Working with disconnected tables
  • Leveraging the BLANK function
  • Using variables in formulas
  • DATESBETWEEN and the X functions
  • Introducing the DATEADD date calculations
  • Introducing the MTD, QTD, and YTD date calculations

Publishing and Sharing

  • Publish Reports from Power BI Desktop to the Power BI Service
  • Creating PowerBI dashboards
  • Print and export Power BI dashboards
  • Manually Republish and Refresh Your Data
  • Create a group in Power BI
  • Introducing Power BI Mobile