Corporate Training for Teams

Power BI Modelling, Visualisation and Publishing

STL, Nationwide
Length
2 days
Length
2 days
Leave your details so the provider can get in touch

Power BI Modelling, Visualisation and Publishing

STL courses


  • Learn to use Power BI (Business Intelligence) Desktop to create queries, data connections, and reports that can easily be shared with others.
  • Through Power BI Desktop learn to integrate proven Microsoft technologies such as the Query engine, data modelling, and visualisations.
  • Discover how to harness Power BI Service to share these connections, models and reports in accessible ways for users to view and interact with on all kinds of devices.

What to expect

  • 24 months post training support included .
  • Tailored and bespoke programme options .
  • Our experienced training and logistics team in the last 23 years have assisted 205,500 people .
  • Over 14,089 organisations trained .
  • We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
  • Delivery UK wide and international (75+ countries delivered) .

Suitability - Who should attend?



This two day course is ideal for those looking to grasp the complete Power BI workflow, from sourcing data, modelling the data to creating and sharing data visualisations.

Training Course Content



Introducing the Power BI Ecosystem

Desktop, Service and Mobile
Installing and setting up Power BI
Setting up a MS Power BI account

Getting started with Power BI Desktop

Visualisation and Fields Panes
Create visualisations with Report View
Sort and format data with Data View

Power BI Desktop and Data sources

How to import from various data sources
Connectivity with MS Office apps - Excel, Access
Using other data sources such as databases and CSV Files

Power BI Desktop to create Data Models

Getting to grips with the Data Model
Using the Relationship View
Many-to-one relationships
Filter propagation

Power BI Desktop for Visualisation Workshop

Adding visualisations to Report Canvas
Managing visualisation relationships
Drill Down and Drill through techniques
Use of Hierarchies
Importing and using custom visualisations

Power BI Desktop and Introduction to DAX

Custom calculation and the Data Model
Calculated Columns and Measures
Evaluation Context
CountRows and DistinctCount Functions
SUMX and CALCULATE
Time Intelligence functions

Power BI Desktop and Queries

Data import and the role of Queries
ETL: Extract, Transform and Load
Data transformations
Using Applied Steps
Query Parameters

Power BI Service Publishing

Report publishing to PowerBI.com
Dashboards
Quick Insights
Data searching with QandA

Power BI Service and Importing Cloud-based Data

OneDrive
Azure SQL Websites and Databases

Power BI Service and Excel PowerPivot

Creating a PowerPivot Data Model
Import data from PowerPivot to Power BI Service
Using PowerPivot data to create visualisations in Power BI Service

Sharing Data with Power BI

Share interactive Power BI dashboards
Share through Power BI, PowerPoint, the web and other mediums
Content Packs
Role Level Security

Refreshing Data

Refreshing data manually
Scheduled Refresh
Personal Gateway
Enterprise Gateway

Power BI on Mobile Devices

Meeting different mobile clients' requirements
Windows 10, Ipad, Android and Tablet

Expenses



Prices on application. Contact us for quote.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Power BI Modelling, Visualisation and Publishing.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads