Introduction to Power BI

£195 + VAT

A one day course covering the features of Power BI.  You will learn about typical processes and workflows, including how to connect, manipulate, relate, analyse and publish data visualisations in shareable Reports and Dashboards.


Course Outline

The course can use Power BI Desktop or just Power BI Service.  The emphasis is on using Power BI to import, manipulate, upload, visualise and publish data.

Overview of Power BI Desktop, Service and Apps

  • Data Sources
  • Visualisations
  • Tiles, Reports and Dashboards
  • Power BI processes and workflows
  • Working with the Fields and Visualisation Panes
  • Using Report and Data Views

Connecting to Data Sources

  • Using Excel, Access and CSV files as data sources
  • Cloud-based data sources including OneDrive, Google Analytics, Azure SQL Databases and Websites

Data Manipulations and Transformations

  • Editing Queries
  • Custom Calculations
  • Column Operations & Working with Applied Steps
  • Data Model Relationships
  • Loading Data into Power BI Service

Visualisations

  • Adding visualisation to a Report Canvas
  • Interacting with and customising visualisations
  • Using Drill Down and Drill through

Publishing to Power BI Service

  • Publish your Report to   PowerBI.com
  • Creating and Sharing     Dashboards internally and externally
  • Creating and Managing Content Packs
  • Power BI mobile apps

Data Refresh

  • Manual data Refresh    
  • Setting up Scheduled data refresh

Workshop

  • Examining custom Data Sources
  • Custom Data Manipulations
  • Building Custom Visualisations