Course Code: bsppowbi
Duration: 7 hours
Prerequisites:
  • An understanding of ___.
  • Experience with ___.
  • ___ programming experience.

Audience

  • ___
  • ___
  • ___
Course Outline:

Power BI Desktop

  • Viewing the variety of data sources available
  • Working with the Fields and Visualisations Panes
  • Using Data View to sort and format data

Creating Visuals

  • Adding visualisations to the Report Canvas
  • Creating column, bar, pie and line chart visuals Controlling interactions between visuals
  • Using the Report Grid and alignment options

Formatting Visuals

  • Usiing the Formatting Pane
  • Looking at a variety of formatting options
  • Using Constant lines on Column and Bar charts
  • Inserting, Maximum and Average Lines
  • Forecasting in a Line Chart

Using Visual, Page & Report Level Filters

  • Applying Visual Level and Page Level Filters
  • How Basic and Advanced Filters differ
  • Looking at the TopN filter

The Slicer Visual

  • Looking at the Slicer Visual to filter data
  • Changing the orientation of slicers
  • Using List and dropdown options
  • Using the Relative Date Slicer
  • Displaying a Search Box

Importing Custom Visualisations

  • Browsing the Office Store for Custom Visuals
  • Working with the InfoGraphic Visual and a variety of other custom Visuals

The Table and Matrix Visuals

  • Understanding the importance of Table Visuals.
  • Understanding Implicit Measures.
  • Controlling summarisation.
  • Working with conditional formatting

Working with Hierarchies

  • Using the automatic Date Hierarchy
  • Creating and using explicit Hierarchies
  • Understaning implicit Hierarchies
  • Using Drill-Down and Drill-Through on visualisations

Working with Geographic Data

  • Exploring how geographic data can be used in visuals
  • Creating the Map and Filled Map Visuals
  • Using ArcGIS Maps

Bookmarks

  • Understanding the use of Bookmarks
  • Creating and editing Bookmarks
  • Using interactive buttons to move to Bookmarks

Dynamic Tooltips

  • Setting up the Tooltip Page
  • How Dynamic Tooltips are used in visuals

Advanced Visualisation Features

  • Using the Gauge, Area Chart, Multi-Row Card and comparing values in a Clusterd Column chart
  • Using Clusters in a Scatter Chart
  • Grouping data and controlling “bins” on numeric data