Course overview

Duration: 2 days (13 hours)

Power BI Desktop is a powerful tool for working with your data.  It enables you to import multiple data sources and create effective visualisations and reports.

This course is an introduction to Power BI to get you started on creating a powerful reporting capability.

You should have a good working knowledge of Excel and managing data before attending.

Objectives 

By the end of the course you will be able to:

• Import data from multiple data sources
• Edit and transform data before importing
• Create reports
• Create different visualisations
• Create data models
• Build data relationships
• Use the drill down features
• Create measures
• Use the Power BI Service
• Build dashboards
• Use the mobile app

Content

Essentials

Importing Data

• Power BI Overview
• Data sources
• Importing data

Transforming Your Data

• Editing your data
• Setting data types
• Removing columns/rows
• Choosing columns to keep
• Setting header rows
• Splitting columns

Creating Reports

• Creating and saving reports
• Adding pages
• Renaming pages
• Interactivity
• Refreshing your data

Adding Columns

• Columns from example
• Custom columns
• Conditional columns

Append Queries

• Importing folders
• Setting up and using append queries

Creating Chart Visualisations

• Adding chart elements
• Choosing chart types
• Setting properties
• Setting values, axis and legends
• Using tooltips
• Visual filters
• Setting page and report filters

Creating Tables, Cards, Gauges and Maps

• Adding table elements
• Adding maps
• Working with cards
• Working with matrices
• KPIs and Gauges

Conditional Formatting

• Setting rules
• Removing conditional formatting

Working with Data Models

Merge Queries

• Setting up and using merge queries
• Merging in columns of data

Creating a Data Model

• The data model
• Multiple data tables
• Connecting tables
• Building relationships
• Relationship types
• Building visuals from multiple tables

Unpivoting Data

• Working with summary data
• Unpivoting data

Using Hierarchies

• Using built in hierarchies
• Drill down
• Drill up
• See next level
• Expand a hierarchy
• Create a new hierarchy

Grouping

• Grouping text fields
• Grouping date and number fields

Creating Measures

• DAX functions
• DAX syntax
• Creating a new measure
• Using quick measures

Using the PowerBI Service

• Shared workspaces
• My workspace
• Dashboards
• Reports
• Datasets
• Drill down in dashboards
• Focus mode
• Using Q&A
• Refreshing data
• Using Quick Insights

Power BI Mobile App

• Using the Power BI Mobile App

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

• Email: [email protected]
• Phone: +44 (0)20 8152 6551

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!