£354

Microsoft Power BI Desktop Training Course £295 exVAT

Event Information

Share this event

Date and Time

Location

Location

Eident Glasgow Training Centre

151 West George Street

Glasgow

G2 2JJ

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Friends Who Are Going
Event description

Description

Microsoft Power BI Desktop Training Course

Power BI

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources. Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.

Target audience

Anyone who needs to work with data in order to connect to, process, analyse in order to produce suitable output at all levels within an organisation. It is assumed that attendees on the course are already working with data, are familiar with charts and PivotTable concepts. You will be either an Experienced IT or non-IT business user, perhaps with some query writing skills or a data analysis role

Note: This course does not cover Microsoft’s Power BI accessed via Office 365 or SharePoint Services or the Power BI Pro edition.

Objectives

Attendees will learn about

  • Power BI Desktop concepts and main features
  • Connecting to data with Power BI Desktop
  • Data visualisations
  • Applying common query tasks to shape data in Power BI Desktop
  • Create and publish reports

Course Content

Getting Started with Power BI Desktop

  • Power BI Concepts and Overview
  • Introduction to Main Features
  • Imports
  • Visualisations
  • Filters and Queries
  • Reports

Connecting to Data Sources with Power BI Desktop

  • Data Sources Power BI Desktop will connect to
  • Data Types and Properties in Power BI Desktop
  • Import and Enter Data
  • Get Data and Query Editor
  • Introducing the Query Editor
  • Using the Query Editor to Connect to Data
  • Combining Data Sources as a Mash Up
  • Working with Relationships in Data

Data Visualisations

  • Overview of Data Visualisations
  • Tables and Matrix Views
  • Charts
  • Interactive Slicers
  • Data Categorisation, Geo-Data and Maps

Querying and Shaping the Data

  • Using Date Fields to Drill Data Visualisations
  • Common Activities using Query Editor
  • Shaping Data
  • Creating Custom Calculated Columns
  • Introduction to DAX Expressions
  • Histograms

Reports and Output Options

  • Report Elements and Options
  • Working with Pages
  • Adding Graphics
  • Visual and Filter Settings
  • Introducing the Query Editor
  • Using the Query Editor to Connect to Data
  • Combining Data Sources as a Mash Up
  • Working with Relationships in Data
Share with friends

Date and Time

Location

Eident Glasgow Training Centre

151 West George Street

Glasgow

G2 2JJ

United Kingdom

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved