Power BI Training - SystemsAccountants

Power BI Training

An Introduction to Power BI

This course, designed and delivered by SystemsAccountants and Cygnus, is perfect for anyone looking to boost their Power BI skills, whether it’s for your team or personal development. The program empowers participants to confidently start using Power BI.

Power BI is a leading tool in data visualisation and business intelligence. Our training, conducted by highly experienced consultants from Cygnus, will equip you with the skills needed to harness the full potential of your data. With over a decade of expertise in training multiple systems and pioneering Power BI training for Finance and EPM clients, our consultants have worked with some of the largest organisations in the UK.

  • Price: £400 + VAT per attendee
  • Minimum of 5 attendees per session
  • Remote training: Maximum of 10 attendees per session
  • Discounted price per attendee for bookings of 6 or more

We can also offer in-person training on-site, or at our offices in Liverpool Street, London. Please contact us to discuss this option further.

 

Course Objectives:

Introduction:

  • Understand what Power BI is
  • Navigating Power BI Desktop

Data

  • Connect to and Import Data from multiple sources
  • Organise your data – Clean it, transform it, and model it
  • Build Relationships and use Diagram View
  • Work with Hierarchies
  • Managing Calendars

Building the Output:

  • Build Charts and Visualisations
  • Build and report your KPIs

Course Details:

Data Load, Query and Model

  • Connect to Various Sources
  • Query and Load data from Sources
  • Understand, Manage & Change Data Types
  • Import Files Append or Merge Data
  • Pivot and Unpivot Data
  • Create Calculated or Conditional Columns and add Indexes

Build Relationships

  • Understand the Model View
  • Relationships and Joins
  • Related Tables

Course Details:

Data Tables

  • Setting the Data Table
  • Creating Date Table Rules
  • The Automatic Date Table
  • Using Time Intelligence Formulas

Visulisations

  • Creating Report Tables
  • Conditional Formatting
  • KPIs
  • Charts, Graphs, and other Visualisations
  • Maps – Heat Maps and GeoMapping

The Dashboard

  • How to Use Colours
  • Best Practice for Dashboard Layout
  • Text, Lines, and Shapes
  • Filtering, Slicers, and Top/Bottom 10
  • Drill Through

Timings:

Get in touch

This course, designed and delivered by SystemsAccountants and Cygnus, is perfect for anyone looking to boost their Power BI skills, whether it’s for your team or personal development. Get in touch to find out more.

"*" indicates required fields

Name*
Email*
This field is for validation purposes and should be left unchanged.