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:
-
09:15 - 09:30 – Log on and set up
-
09:30 - 11:00 - Intro and Connect/Load Data
-
11:00 - 11:15 – Coffee Break
-
11:15 - 12:45 - The Data Model - Manage and Transform Data
-
12:45 - 13:45 - Lunch
-
13:45 - 15:15 - Creating Visuals - Interactive tiles, Maps and Filtering
-
15:15 - 15:30 - Coffee Break
-
15:30 - 16:15 - Creating a High Impact Dashboard
-
16:15 - 16:30 - Q&A and Wrap Up
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