Power BI Desktop

Microsoft Power BI Training Courses

We're experts in delivering Eureka moments with Microsoft Power BI

Power BI Desktop
Training Courses

We're experts in delivering Eureka moments with Microsoft Office

Microsoft Power BI Training Courses

We're experts in delivering Eureka moments with Microsoft Power BI

Microsoft’s Power BI is a cloud-based business analytics service that allows you to collate, shape, analyse and visually explore your data. Create Excel models and dashboards using the Power BI Desktop. Publish and share them via browsers or on mobile devices using PowerBI.com. Anything built in Excel PBI can be converted into PBI Desktop as they use the same engines and languages.

Our team bring the training to you, delivering the workshops at your site, helping you focus on what’s important to you. Get in touch to find out more and see how we can help.

Excel 2016 Power BI: Introduction

Duration: Two days (9:30 - 16:30)

This two day workshop is ideal for business analysts needing to interpret and communicate large quantities of information clearly by summarising it into easy-to-read tables and graphs. To get the most from this workshop you should have a basic knowledge of Excel. Experience of creating and manipulating tables and PivotTables is beneficial but not essential. This foundation course will show show you how to:

Create and publish projects using Power BI Desktop
Use data from various sources to create a data model
Create and use visualisations
Create custom formulae
Use queries
Design and deploying dashboards
Create dashboards for mobile devices

Course Content

Introducing Microsoft Power BI

Power BI environment
Working with the fields and visualisation panes
Using report view and data view

Data model relationships

Understanding the data model
Using relationship view
Creating one-to-many relationships

Visualisations

Adding visualisation to a report canvas
Controlling visualisation interactions
Using drill down and drill through
Creating and using hierarchies

Introduction to DAX

(Data Analysis eXpressions) language

Calculated columns and measures
Evaluation context
CountRows and DistinctCount
SUMX() and CALCULATE()
Time intelligence functions

Using queries

The role of queries in data import activities
Extract, transform and load (ETL)
Exploring some data transformations
Working with applied steps
Creating and using query parameters

Publishing to Power BI Service

Publish your report to PowerBI.com
Creating dashboards
Using quick insights
Using Q&A for interactive data searching

Importing data into Power BI Service

Connecting to a range of cloud-based data sources including: OneDrive; Google Analytics; Azure SQL databases and websites

Using Excel’s Power Pivot data model in Power BI Service

Creating a Power Pivot data model in Excel
Importing a Power Pivot data model into Power BI Service
Creating a variety of visualisations in Power BI Service using Power Pivot data

Sharing dashboards

How to share interactive Power BI dashboards with internal staff and external contacts
Sharing using Power BI, the Web and PowerPoint
Creating and managing content packs
Power BI mobile apps

Data refresh

Manually refreshing data
Installing and using the Personal Gateway and the Enterprise Gateway
Creating a scheduled refresh

To find out more about this course, or to make a booking, please call us on 0118 9789 279 or click here to email us.

Enquire Now

Need 1-2-1 support?

We offer face-to-face and virtual sessions, tailored to your specific needs and designed to: build confidence; help you work more effectively and understand what to do next. Find out more.

DOWNLOAD OUR BROCHURE

We're delighted to announce that our brochure, covering our core services - IT Training, Consultancy & Personal Development - is now available for download.

Click below to request a copy:

Download Brochure

Further details and bookings

To find out more or book a Microsoft Power BI training course, call our team now on 01189 789 279 or complete this enquiry form: