Power BI Desktop

Visually explore your data through a free-form drag-and-drop canvas, a broad range of modern data visualisations
Overview

Microsoft Power BI is a powerful business analytics service that can be used to transform data from multiple sources into interactive, visual reports that can be viewed on any device. With Data Analysis and Business Intelligence being vital to business success, this course will give you an introduction to the Power BI Desktop application and hands-on experience of how to connect to data sources, create accurate data models, and build visual reports upon which you can make informed decisions for your organisation.
 

Course Code
Q3ClaTech223
Duration
3 Days
Delivery Style
Classroom
Course Type
Public or Private
Max Delegates
12
Available as Nutshell
No

Book your virtual training

  • Date
  • Venue
  • Cost
  • More info

Book your place

You will learn how to
  • Understand fundamental data analysis concepts
  • Connect to common data sources such as Excel workbooks and SQL Server databases
  • Shape data from multiple sources and prepare the data for analysis
  • Understand and create data models with calculated columns and measures
  • Create engaging and interactive reports using data visualisations
  • Implement a consistent theme for reports using templates and best practices

Introduction to Power BI

  • What is Power BI?
  • Power BI within the data analysis toolkit
  • Introduction to the Power BI Desktop interface

Data Analysis Concepts

  • Facts, dimensions, and measures
  • Data types
  • Data models and Relationships

Data Sources

  • Connecting to data with Power BI Desktop
  • Excel workbooks and databases

Shaping Data

  • Preparing data for analysis
  • Setting data types
  • Exclude unnecessary columns
  • Create custom columns

Modelling Data

  • Create and edit relationships
  • Identify and create measures
  • Build hierarchies of data

Introduction to Data Analysis Expressions (DAX)

  • Time intelligence functions and date tables
  • Calculate(), Filter(), All()

Creating Reports

  • Visualisations
  • Charts, gauges, and KPIs
  • Tables, matrices, and cards
  • Filters and slicers

Working with Reports

  • Interactions
  • Drilldown, drill-through, and slicers
  • Bookmarks and Selections
  • Adding report objects – text, buttons etc.

About the Lead Trainer

Matthew Woodman

Matt started life at Quanta working in tech dungeon in IT Support & Systems Admin, he still gets dragged into those things now and again but is mostly focused on development work now for the business. This can range from SharePoint to Visual Management to this very website you are reading now!