HOME
 

Microsoft Power BI

STL
Course summary
Length: 2 days
Language: English
Location: Nationwide
Provider: STL plus
Course type: Company-Specific / In-House

Microsoft Power BI



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... 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. Gain these new skills by training Power BI.

Suitability - Who should attend?



This Microsoft Power BI Desktop training course is aimed at anyone looking to use this powerful, flexible, and highly accessible business intelligence tool to connect with and shape the world of data, build robust models, and craft well-structured reports, which can then be seamlessly shared through Microsoft Power BI Service with users.

And how about a soft skills training?

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 DAX

Custom calculation and the Data Model
Calculated Columns and Measures
Evaluation Context
CountRows and DistinctCount Functions

Power BI Desktop and Advanced DAX 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

Google Analytics
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

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 from £3000 (Guideline pricing). Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Microsoft Power BI.

  Contact the provider

  Get more information

  Register your interest

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.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Microsoft Power BI course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here