Course Code: powerbibspk
Duration: 14 hours
Overview:

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
Course Outline:

Getting started, data sources

  • Installing Power BI and other components
  • Data strategies for efficiency
  • On-premises and online data sources
  • Data transformations + M language

Managing Data

  • Querying and aggregating data
  • Importing and transferring data
  • Pivoting and unpivoting data
  • Transposing and joining data tables
  • Tips and tricks on advanced functionalities

Advanced Data Modeling

  • Working with tables and dimensions
  • Defining data granularity
  • Working with relationships and cardinality
  • Creating measures using DAX
  • Optimizing models for performance
  • Fixing common issues in modeling

Advanced Rules and Calculations using DAX

  • Creating tables using a formula
  • Applying conditional functions
  • Filtering multiple tables
  • Working with disconnected tables
  • Working with variables in DAX
  • Calculating and filtering context
  • Working with dynamic measures

Visualizations, Reports

  • Visualization types in Power BI
  • Customizing visual elements
  • Creating Power BI maps visualization
  • Creating Power BI visuals with R
  • Using filters and slicers in reports
  • Enhancing visual elements for reports