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 touchto 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.
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.