Preloader spinner

Microsoft Power BI Desktop Intermediate

Image of laptop displaying an image containing the words Microsoft Power BI

Course Aims:

This Microsoft Power BI Desktop Intermediate training course is aimed at anyone looking to use this powerful, flexible, and accessible business intelligence tool to connect with and shape / transform data, build models, use DAX functions, and craft structured report visuals,which can then be shared with users.

Course Pre-requisites

Delegates should have attended the Introduction course or have previously use Power Bi and created and formatted Report Visuals.

Course Objectives:

On completion of this course, delegates will be able to:

  • Import data into Power BI using Excel and CSV files
  • Transform Data in Power Query Editor
  • Working with themes
  • Create relationships between the tables
  • Create Formulas using DAX Functions
  • Build Report Visuals

Course Content:

Importing Data Sources

  • Excel and CSV

 

Power BI Query Editor (PQE)

  • Explain the PQE Interface
  • Extract and Load data
  • Shape and Transform Data e.g. Rename, Reorder and Remove columns
  • Change Data Types
  • Remove and Filter Rows
  • Merge Columns
  • Replacing values
  • Formatting text e.g. Uppercase,Lowercase and First letter Capital
  • Remove and replace top row
  • Applied Steps (Delete)

 

Data Modelling

  • Creating, editing  and detecting relationships
  • One to Many relationships

 

Themes

  • What is a Theme?
  • How to edit and save themes
  • How to reuse saved themes

Power BI Visualisations

  • Adding visuals to Report Canvas e.g.,Slicer, Multi Card, KPI, Matrix, Gauge, Map, Q&A
  • Use Small Multiples on Visuals
  • Use of Hierarchies
  • Adding further analysis to the Visual

Introducing Data Analysis Expressions (DAX)

  • Create Formulas using Calculated columns and Measures e.g.
  • Aggregation and iteration Functions (SUM, COUNT, MIN, MAX, AVERAGE, COUNTROWS, DISTINCTCOUNT)
  • Text Functions (LEFT, UPPER, LOWER, CONCATENATE)
  • Logical Functions (IF, NESTED IFS)
  • Filter Functions (CALCULATE)
  • Math and Trig Functions (DIVIDE, FORMAT)
  • Date Functions (TODAY, WEEKDAY)
  • Zoom in / out of calculations
  • Adding comments to calculations
  • Indenting calculations

 

Advanced Conditional Formatting

  • Applying and Editing Conditional Formatting rules to visuals
  • Applying and removing Data bars

 Working with Report Pages

  • Working with buttons and Page Navigation

Hints and Tips

  • Working with Bookmarks
  • Applying Data Category properties to columns
  • Synchronize Slicers

Related Courses

Download PDF Outline

Public Schedule

RRP:  
£495 per delegate
Our price:  
£450 per delegate

Virtual Private Training

Contact us for pricing

Onsite Training

Contact us for pricing

Note

All prices exclude VAT at 20%.

VAT registration number: 450 4347 14

You may like...

Microsoft Project Advanced

Excel in project management with our 1-day Advanced Microsoft Project course. Master complex scheduling, reporting, and customisation to lead successful projects.

An icon of a person

N/A

An icon of a clock

1 day

Microsoft Project Intermediate

Take your Microsoft Project skills to the next level with our 1-day Intermediate course. Dive deeper into advanced tools and techniques to manage projects efficiently.

An icon of a person

N/A

An icon of a clock

1 day

Microsoft Project Introduction

Master the basics of Microsoft Project in our 1-day introductory course. Learn to plan, manage, and optimise your projects effectively.

An icon of a person

N/A

An icon of a clock

1 day

Enquire about this course

Microsoft Power BI Desktop Intermediate
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Join our mailing list

Receive details on our new courses and special offers

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.