Woodthorpe IT Solutions Ltd

powerpivot_01

Advanced Microsoft Power BI Desktop, Power BI Service and DAX (2 days)

Microsoft recently launched the Power BI web based data transformation and dash boarding tool. Power BI Desktop is the starting point for anyone wanting to learn how to use this new technology. Power BI Desktop shares many of the similarities of its cousins Power Query & Power Pivot – the main difference is the ability to create a wide range of dynamic graphical dashboards. By building data visualisations you encourage the user to discover their own stories in the data.

Once you have built your reports and dashboards, you are free to publish them to the Power BI Service – this is the platform where you can share your work with colleagues and others outside of your organisation.

During this 2 day training course you will learn:

  • How to connect Power BI Desktop to a range of data sources; Excel, CSV & Access.
  • How to re-shape report data into rows and columns in preparation for analysis.
  • How to blend data from multiple sources into a single data stream for analysis.
  • How to create basic ‘measures’ and ‘calculated columns’ and use them to manipulate data in the data model.
  • How to build various reports / dashboards using the extensive range of charting tools.
  • How to use some of the most common DAX functions to extend the power of the Power BI data model.
  • How and when to install the Power BI gateways.

North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

×
IFA Practice Manager

No flash installed

×
Production Scheduling Tool

No flash installed

×
Format As Table Part 1

No flash installed

×
Format as a table part 2

No flash installed

×
Subtotalling a list

No flash installed

×
Sorting basics

No flash installed

×
Cell Styles

No flash installed

×
Remove Duplicates In List

No flash installed

×