Microsoft Power BI

Microsoft Power BI

Audience

Business Analysts, Financial Analysts, Data Scientists and Staff who need to use Power BI for producing reports from Excel, SQL Server and other databases.

Prerequisites

There are no prerequisites for this course.

Duration

2 days. Hands on.

Course Objectives

Verhoef's Microsoft Power BI training course shows attendees how to use the latest collection of on-premise and online tools to enable them to find, clean, model, and visualize data, share discoveries, and collaborate in intuitive new ways.

Power BI is the latest set of Microsoft BI tools for data mash up, data modelling, and data visualisation. The results can be deployed on-premise or in the cloud and can be visualised in browsers, on tablets, and on mobile phones.

This course will take you through the product, demonstrating functionality, with plenty of hands on so that you can learn to use this powerful tool to help you transform your rows of data into a compelling interactive visual story.

Course Content

Power BI Service
Self-service BI
Organisational BI
Portal
Content Items
Datasets
Connecting to Data
Visualizing Data

Reports
Reading View
Editing View
Visualisations and Custom Visualisations
Dashboards

Power BI Mobile
Native Applications (iOS/Android/Windows)
Viewing Content
Sharing & Collaboration
Configuring Alerts

Power BI Desktop
Data Models
Schemas
Relationships
Connectivity
Design Environment
Navigation
Importing Data

Transforming Data
Queries & the Query Editor
Data Previews
Shaping & Cleansing Data
Basic Transformations
Loading Transformed Data
Combining Datasets
Functions
Date Tables

Refining the Model
Tables & Columns
Data View
Exploring Data
Managing Schema & Data Changes
Connections & Tables
Data Refresh
Relating Tables
Rules & Limitations
Auto-Detecting
Relationship View

Calculations
Data Analysis Expressions
Calculated Columns
Measures
DAX Syntax
DAX Functions
Advanced Relationships

Public Courses

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...