Power BI Visualisations

A5.png

Learn how to design interactive visualisations to create reports that allow you to interact with your data and find relevant business insights

Description

Microsoft Power BI is a Business Intelligence analytics service that gives you a comprehensive view of your most critical business data.  In Power BI Desktop, you can build reports by creating a wide range of interactive data visualisations.  

What you will learn

Connecting to existing datasets

  • 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.
  • Understanding the “Values” bucket.

Formatting Visuals

  • Using 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 Filters Pane

  • 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
  • Syncing Slicers across pages

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.
  • Understanding Subtotals in the Matrix Visual

Working with Hierarchies

  • Using the automatic Date Hierarchy
  • Creating and using explicit Hierarchies.
  • Understanding 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 Custom Map Visualisations.

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 Comparing values in a Clustered Column chart
  • Using Clusters in a Scatter Chart.
  • Grouping data and controlling “bins” on numeric data.