Power BI Advanced ~ Reports Training

2 days (10:00 AM - 5:00 PM Eastern)

$750.00

Register for a live online class.

Details

Subjects Covered

Prerequisites

Setup Requirements

Details

Course Details

If you have mastered the basics of creating Power BI reports, this course focuses on what else they can do. Among other things, you will learn:

  • How to use all those extra visuals in the visualizations pane
  • New ways to analyze your data using smart narratives, Q&A visuals, and analytics
  • How to make your reports easier to use using tooltips and bookmark ideas

Subjects Covered

  • Advanced tables
    • Showing URLs as icons
    • Images in tables
    • Sorting multiple columns
    • Preventing data grouping
  • Conditional formatting
    • Gradients and rules
    • Based on a field value
    • Icons and data bars
  • Dynamic display
    • Format properties as expressions
    • Examples of dynamic formatting
  • Analytics
    • Adding constant lines
    • Adding trendlines
    • Showing anomalies
  • Decomposition tree
    • How it works
    • Formatting the parts
    • Locking levels
  • Other visuals
    • Key influencers
    • Ribbon charts
    • Waterfall charts
  • Q & A visuals
    • Setting synonyms
    • Adding FAQs
    • Training Q&A visuals
  • Tooltips
    • Tooltip backgrounds
    • Dynamic report tooltips
    • Visual header tooltips
  • Bookmarks
    • Data and display properties
    • Spotlighting and hiding visuals
    • Bookmark navigators
    • Some design case studies
  • Quick measures
    • Comparison against single items
    • Line chart averages
    • Listing selected items
    • Running totals
  • Narratives
    • The smart narrative visual
    • Text boxes and values
    • Analyzing differences
  • Dynamic page navigation
    • Page navigators
    • Page navigation buttons
    • Controlling with slicers
    • Drill-through with slicers
  • Advanced drill-through
    • Category vs summarized explained
    • Drill-through between reports
    • Disabling drill-through
    • Mouse buttons/action buttons
  • Custom visuals
    • Ways to import
    • Pinning custom visuals
    • Infographics (picture charts)
  • More custom visuals (*)
    • The play axis visual
    • Synoptic panels
    • Chiclet slicer

Prerequisites

Before Taking this Class

Power BI Fundamentals or equivalent.

Setup Requirements

Software/Setup For this Class

Power BI Desktop

Onsite Training

Do you have five (5) or more people needing this class and want us to deliver it at your location?