Book Now

Microsoft Power BI - Visualisations

Category: Microsoft Office, Microsoft Power BI, Microsoft Power BI

Overview of Power BI Desktop

Overview of a pbix file and introduction to:

  • Views: Reports (visualisations); Tables and Relationships
  • Visualisations: Treemap; Funnel; Map; Clustered Column Charts
  • Page Tab
  • Focus Mode
  • Tool tips

Creating a Basic report

  • Getting data
  • Basic visualisations
  • Shapes, text boxes and images

Data sources and Query Editor

Connecting to:

  • Access databases
  • Excel / text files
  • Websites and web services
  • Pasting data
  • Filtering rows
  • Manipulating columns
  • Working with data types

Filtering data

  • Slicers
  • Visualisation level filters
  • Hierarchies and re-usable Hierarchies
  • Drill with Dates

Formatting visualisations

  • The formatting panes
  • Conditional formatting

Charts

  • Working with charts
  • Specific chart type issues
  • Grouping and binning

Other types of visualisations

  • Working with matrices
  • Working with cards

Maps

  • Geo Data
  • Data Categorisation and Maps

Dashboard visualisations

  • Gauges
  • KPIs

Advanced Filters and Views

  • Grouping and pivoting
  • Grouping with Bins
  • Filter combinations
  • Creating new columns

Drill-down

  • Interactions
  • "See records" feature

Parameters

  • Creating parameters
  • Filtering by parameter

About SquareOne

SquareOne is among the UK's leading providers of IT training to businesses of all shapes and sizes. Our company pledge is to deliver inspiring, motivational and cost effective training which brings about tangible improvements in productivity. Through our training solutions, individuals are able to gain lifelong skills and realise their full potential whilst clients achieve their corporate goals.

Who Should Attend?

This one-day course is an introduction to the Microsoft power tools within Power BI for those who need to analyse, process and connect to with data in order to produce reports, interactive dashboards and visualisations at all levels within an organisation. It is assumed that attendees on the course are already working with data, are familiar with charts and PivotTable concepts. Delegates will be using Power BI Desktop.

Objectives

At the end of the course delegates will be able to:

  • Connect to a variety of data sources using Query Editor
  • Create Visualisations (Charts, Tables, Gauges, Maps)
  • Create Charts with Interactivity
  • Filter data with various tools
  • Apply advanced formatting and visualisations with conditional formatting, matrices, cards, gauges and KPIs

Course Duration

Duration: 1 Day Classroom Training or Online

Course Contents

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course. All of our courses can be tailored to meet your business needs.

Course Dates 

View our full course schedule here.

Training Locations

Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead, Aberdeen and Ireland.

Closed courses can also be delivered in European countries such as Austria, Belgium, Denmark, Greece, France, Finland, Hungary, Italy, Ireland, Netherlands, Norway, Portugal, Spain, Poland, Sweden, Switzerland and off shore.... Either in English or local languages

Booking

Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

For more information about any of our courses please call +44 (0)151 650 6907,
email enquiries@squareonetraining.com or complete an enquiry form.

Back to top