PL-300: Matrix & Treemap Controls in Power BI

Microsoft Power BI    |    Expert
  • 15 videos | 1h 42m 58s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 81 users Rating 4.6 of 81 users (81)
As datasets grow larger and more complex, there is an ever-increasing need to organize data into categories and hierarchies. This is what the matrix and treemap controls in Power BI are designed to do. In this course, learn how to utilize matrices and treemaps to their full potential. Create a matrix widget and add aggregations. Create row and column hierarchies from hierarchical fields. Drill through hierarchical treemaps. And format matrices using color scales, data bars, and icons. Additionally, visualize the composition of a whole using treemaps. Learn how to create and filter data through slicers. And sync slicers across different pages and widgets in a report. Upon course completion, you'll have an advanced ability to use Power BI visualizations, ready to move on to using the Power BI service. This is one of a series of four paths that can be used to prepare for the PL-300: Analyzing Data with Microsoft Power BI exam.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Create and group data using matrices
    Use hierarchies in matrices
    Filter and drill-through matrices
    Format power bi matrices
    Apply conditional formatting to a matrix
    Use icons as conditional formatting
    Visualize the composition of a whole using treemaps
  • Filter, format, and drill through treemaps
    Create hierarchical treemaps
    Sync slicers and use them with treemaps
    Create and sync slicers across multiple pages
    Create slicers for numeric fields and horizontal slicers
    Optimize a report for a mobile phone
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 56s
  • 8m 49s
  • Locked
    3.  Creating Row and Column Hierarchies with Matrices
    8m 45s
  • Locked
    4.  Filtering and Drilling Hierarchical Matrices
    8m 21s
  • Locked
    5.  Formatting and Coloring Matrices in Power BI
    7m 19s
  • Locked
    6.  Adding Color Scales and Data Bars to a Matrix
    6m 14s
  • Locked
    7.  Applying Conditional Formatting on a Matrix
    5m 49s
  • Locked
    8.  Plotting Proportions of Parts Using Treemaps
    9m 33s
  • Locked
    9.  Creating and Formatting a Hierarchical Treemap
    7m 52s
  • Locked
    10.  Using and Drilling through Hierarchical Treemaps
    7m 24s
  • Locked
    11.  Creating Slicers and Filtering Data with Them
    6m 44s
  • Locked
    12.  Syncing Slicers across All Pages in a Report
    8m 51s
  • Locked
    13.  Filtering Numeric Fields Using Slicers
    7m 13s
  • Locked
    14.  Editing the Mobile Layout of a Report
    6m 24s
  • Locked
    15.  Course Summary
    1m 43s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course PL-300: An Overview of Data Modeling in Power BI
Rating 4.6 of 227 users Rating 4.6 of 227 users (227)
Course PL-300: Power BI for Data Analysis
Rating 4.5 of 1379 users Rating 4.5 of 1379 users (1379)
Course Data Loading & Visualization in Power BI: Getting Started
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Rating 4.6 of 1028 users Rating 4.6 of 1028 users (1028)
Course Business Reporting: Leveraging Treemaps, Matrices, & Slicers in Power BI
Rating 4.6 of 269 users Rating 4.6 of 269 users (269)
Course PL-300: Using the Power BI Service
Rating 4.4 of 449 users Rating 4.4 of 449 users (449)