Microsoft Power BI Desktop

Course

In London-City

£ 599 + VAT

Description

  • Type

    Course

  • Location

    London-city

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. With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor, you can create reports and visualisations or dashboards within Power BI Desktop. Reports can then be published. This course covers the use of Power BI Desktop to connect to data, create visualisations, query the data and publish reports. Target student 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 Please Note: This course does not cover Microsoft's Power BI accessed via Office 365 or SharePoint Services. Learning Objectives Delegates will learn how to Power BI Desktop concepts and main featuresData sources compatible with Power BI DesktopConnecting to data with Power BI DesktopExplore data visualisationsApply common query tasks to shape data in Power BI DesktopCreate and publish reports

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

Please note that this course is not suitable for new Excel or database usersAn understanding of basic data conceptsAbility to create and format chart outputsBe able to create formulas using standard aggregate functionsAttendance on Microsoft Excel 2013 Data Analysis and Power Tools part 1/part 2 or equivalent knowledge is a prerequisite for this course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Lesson 1: Getting Started with Power BI Desktop

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

Lesson 2: 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

Lesson 3: Data Visualisations

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

Lesson 4: 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

Lesson 5: 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

Microsoft Power BI Desktop

£ 599 + VAT