99.4% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Microsoft Power BI (Business Intelligence) training courses
Power BI Training London
Who is this course for?
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.
An advanced knowledge of MS Excel and access to Office 365.
BenefitsLearn 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. Also, have a look at a full range of our Microsoft training courses.
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
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
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
Using Applied Steps
Power BI Service Publishing
Report publishing to PowerBI.com
Data searching with Q&A
Power BI Service and Importing Cloud-based Data
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
Refreshing data manually
Power BI on Mobile Devices
Meeting different mobile clients' requirements
Windows 10, Ipad, Android and Tablet
Prices & Dates
What you get
Training is held in our modern, comfortable, air-conditioned suites
Modern-spec IT, fully networked with internet access
"What do I get on the day?"
Lunch is provided at a local restaurant or pub. Browse the sample menus:
Breaks and timing
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)
Available throughout the day:
- Hot beverages
- Clean, filtered water
Training formats & Services
Find out the data likely to be used in advance so as not to spend too much time on functionalities that can't be used.
Microsoft Power BI
Excellent trainer with broad knowledge and teaching skills. Only drawback was the projector which was at times a bit blurry and it was difficult to follow the formulas
Microsoft Power BI
Contracting Analytics Specialist
Have power view as a pre-requisite for the course and move directly into Power BI. Spend more time on getting data from other sources especially SQL, maybe some online examples e.g. downloading tables from Wikipedia to demonstrate other capabilities.
Microsoft Power BI
Our Power BI training courses uk are available at our London venues as well across the UK. When you book a course Power BI you get 24 months post training support, and a warm restaurant lunch is provided on our public schedule. You can expect knowledgeable instructors training power bi.
Learning & Development Resources
Training manual sample
Below are some extracts from our Microsoft Power BI manual.
The following is a text version of our Power BI infographic.
Why should you use Power BI for your business?
Power Bl is a suite of business analytics tools that deliver insights through data visualisation. It connects to hundreds of data sources, simplifies data preparation and easily produces beautiful reports. It sounds an attractive prospect, but why should you use data visualisation to present your business information?
Data visualisation takes many forms, but one of the most popular is 'info-graphics'. These combine text and visualised data to present a visual story, and have been shown to be a very effective means of communication:
Infographics help you remember
On average, people remember:
- 80% of what we see
- 20% of what we read
- 10% of what we hear
We are visual creatures, and ingesting content in visual form means it is more likely to be retained.
Visual is the most effective medium
90% of all the information transmitted to the brain is visual, and it is processed 60,000 times faster than text. This makes it by far the most effective means of communication.
Infographics help improve engagement
On average, users read only 28% of words on a page, so two thirds of your message may be missed. Infographics are so much easier to digest that they are 30 times more likely to be read than an article. According to one study, presentation including visual content was 17% more convincing than one without.
Why use Power BI to visualise your data?
Import from almost any data source
Unlike a lot of other data visualisation products on the market, Power Bl has been built by a huge team at Microsoft. One of the main aims, and a feature that almost all others lack, is the integration of outside data sources. As well as an Open Database Connectivity function, it also seamlessly pairs with cloud content like Google Analytics, SalesForce, GitHub, Mail Chimp, SharePoint and hundreds more online software service providers. There are also new (less mainstream) connectors being developed all the time.
A brand-new visualisation engine
As mentioned previously, an enormous team has been at work on Power Bl, and Microsoft has dedicated a lot of resources to it. Amongst the new features is a brand new D3 based, HTML 5 compliant, visualisation engine that is just amazing. For example, you can see a bar chart that shows performance by year, then drill down on the bar chart to see the monthly, weekly or daily breakdown, or chart complex moving visuals in 3D Everything is intuitive and simply works.
Open source and custom visualisations
A big step forward with Power Bl is also the visualisation library. The range of different visualisation techniques and options within them is now vast, but they have also shared the visualisation source code so that developers can create their own, and share them with the community. In turn this leads to an ever-expanding library of open source visualisations, and this is a huge bonus!
Power Bl has mobile apps
One of the benefits of starting from scratch is you have no legacy to carry around. Microsoft has built mobile apps for Apple and Android (and Windows mobile of course), and they work very well!
Integration with Excel and PowerPoint
The truth is that most businesses rely on both Excel and PowerPoint to tell stories. Hence, integration between Power Bl and these other Microsoft cornerstones is highly desirable, PowerPoint compatibility is still rather limited, whilst Excel is much more complete and almost seamless. As Power Bl has been a big success, expect further integration to come in the future.