SharePoint Training Scotland

Power Bi Training in York

The Power BI training course is designed to take a user with a basic understanding of excel and office 365 and introduce them to the opportunities provided for the manipulation and visualisation of data.

To find out more about our SharePoint and Office 365 services get in touch today. call +44 (0) 7739 870 670 or Email us at: contact@solutionsdeveloped.co.uk

Duration: 2 Days Course Style: Instructor Led
Audience: Intermediate
Experience with MS o365 required
The Power BI Training course covers the skills a user will be expected to use to create and maintain Power BI dashboards with visualisation.

Module 1 – Power Bi Introduction

  • Power BI Programs
  • Licensing
  • Limitations

  • Module 2 – Creation a Data Set for a Report

  • The difference between a Data set and a Data Source
  • Connecting to Data Sources
  • Using Multiple Data Sources
  • Editing the Data Queries
  • Linking Multiple Data Sources

  • Module 3 – Visualizations

  • Stacked Bar Charts and Stacked Column Charts
  • Clustered Bar Charts and Clustered Column Charts
  • 100% Stacked Bar and Column Charts
  • Line Chart, Area Chart and Stacked Area Chart and Ribbon charts
  • Line and stacked columns, Line and Clustered columns charts
  • Waterfall Chart
  • Scatter Chart
  • Pie Charts and Donut Charts
  • Treemap
  • Map, Filled Map and ArcGIS Maps for Power BI
  • Funnel
  • Gauge
  • Slicers, Cards and Multi Row Cards
  • KPI
  • Tables and Matrices
  • Customising the Visualization
  • Module 4 – Multiple Pages

  • Filtering
  • When would you Filter

  • Module 5 – Publishing a Report and Sharing It

  • Publishing
  • Sharing the Report
  • Scheduling Refreshes
  • Embedding a Report

  • Module 6 – Creating a Dashboard

  • Adding Tiles to a dashboard
  • Sharing a Dashboard

  • Module 7 – DAX (Data Analysis Expressions)

  • What is DAX
  • What are calculated columns
  • What are measures
  • When to use a calculated column
  • When to use a measure
  • Using DAX in dynamic reports
  • Advanced DAX features
  • All courses are available either online though our Train from you Desk program or our Classroom in a Box program at facilities in York

    To find out more about our SharePoint and Office 365 services get in touch today. call +44 (0) 7739 870 670 or Email us at: contact@solutionsdeveloped.co.uk