Microsoft Power BI Introduction

Anyone wanting to create powerful interactive dashboards, chart and a range of visualisations to display data in a user friendly way from a range of sources.

1 day course
What you will learn:
  • Gain insight into business intelligence and how to navigate Power BI
  • Data modelling in Power BI including creating calculated tables and working with time based data
  • Create a range of visualisation including a range of charts, tables, matrixes and maps
  • Create and modify an interactive dashboard
  • How to publish and share your data
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Course prerequisites

Participants will need to be familiar with Excel to an intermediate level including a basic understanding of charts and pivot tables. No previous experience with Power BI is required, however it is recommended you try it out before you attend.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

 

Topics covered in this training course
  • Introducing Power BI
  • Using Power BI
  • The building blocks of Power BI
  • Overview Power BI Service, Desktop, Mobile
  • Getting started with Power BI Desktop
  • Introduction to using Excel data in Power BI
  • Upload Excel data to Power BI
  • Creating a Report
  • Navigating a Report
  • Publish a Report
  • View a Published Report in Power BI Service
  • Connect to data sources in Power BI Desktop
  • Clean and transform your data with the Query Editor
  • More advanced data sources and transformation
  • Cleaning irregularly formatted data
  • Introduction to modelling your data
  • How to manage your data relationships
  • Create calculated columns
  • Optimising data models
  • Create calculated measures with introductory DAX
  • Create calculated tables
  • Working with time-based data
  • Create a Bar chart
  • Create a Pie chart
  • Create Table visualisations with drag and drop
  • Create a Treemap
  • Create Combination charts
  • Slicers
  • Map visualisations
  • Matrixes and tables
  • Create a gauge visualisation
  • Modify colours in charts and visuals
  • Adding shapes, text boxes, and images
  • Page layout and formatting
  • Group interactions among visualisations
  • Duplicate a report page
  • Show categories with no data
  • Summarisation and category options
  • Z-order of visualisations
  • Visual hierarchies and drill-down
  • Introduction to the Power BI service
  • Pin visualisations to a dashboard
  • Create and configure a dashboard
  • Share dashboards with your organisation
  • Display visuals and tiles full-screen
  • Edit tile details and add widgets
  • Display dashboard in full screen
  • Publish Power BI Desktop reports
  • Print and export dashboards and reports
  • Manually republish and refresh your data
    Reset options
- +
Need your training approved? Get a quote