DURATION
Two full days: 9:30am – 4:30pm
LOCATIONS
Exeter, Manchester, Liverpool, London, Bristol, Onsite at your premise, Remote Live Session via Teams
For onsite courses we can provide the rental of laptops with the software pre-installed.
SECTORS WE TRAIN
NHS and Healthcare, MOD, Police, Councils, Energy, Water
MICROSOFT POWER BI ADVANCED OVERVIEW AND OBJECTIVES
This Microsoft Power BI advanced 2-day course is intended for anyone who has existing experience working with Power BI and who wants to extend and enhance their knowledge beyond the basics. You will gain deeper insights into the inner workings of Power BI by implementing your own code in Power Query using the M language, further enhance the data model using the DAX expression language, and get a better understanding of your data using advanced capabilities and features in Power BI.
In addition to understanding the technical workings of Power BI, it is also intended to demonstrate best practices and highlight practical solutions to common data analytic scenarios.
Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.
Part one of the course demonstrates how to extract and load data from relational databases and considers the different storage modes supported in Power BI. You will also consider how best to handle the processing of multiple files. Different techniques for profiling imported data is also considered. As the primary goal of Power Query is to prepare your data for loading into a data model, we will consider ways to structure the data to the required output. Sitting behind Power Query is a very powerful coding language known as “M” which is utilised for shaping and transforming your data. We will take a close look at M and see how we can customise code for our own purposes.
Part two of the course takes a deeper look at data modelling concepts and examines various techniques that can be used to resolve common problems encountered in the real world. Then, after a quick refresher on DAX, we will look at how the data model can be further enhanced using the Data Analysis Expressions (DAX) language, considering ways in which the filter context can be modified in the evaluation of expressions, the use of DAX variables, and practical solutions to some common problems. The creation of date tables in DAX will also be covered followed by a closer inspection of time intelligence.
In part three, we will look at more advanced data visualisation techniques to further enhance the user experience. We will also consider the available built-in analytic features in Power BI that can be utilised to gain deeper insights into your data. The ability to drill through from one report page to another is a very useful feature which will be demonstrated, as will the introduction to custom visuals and slicers.
Finally, in part four, we turn our attention to published reports in the Power BI Web Service. Delegates will learn how to: share and promote content, secure data with row level security (RLS), secure tables and columns with object level security, refresh data in published datasets, and handle changing data.
Additionally, with the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.
Upon successful completion of this course, students will be able to:
🔹Load Data from a Database
🔹Process Multiple Files in a Folder
🔹Understand Supported Storage Modes
🔹Match Imported Data to Master Data
🔹Prepare Data for Modelling
🔹Understand M Language Data Types
🔹Enhance Transforms with M
🔹Implement and Optimise a Data Model
🔹Resolve Common Modelling Problems
🔹Review the DAX Expression Language
🔹Address Common Scenarios with DAX
🔹Implement Custom Data Grouping
🔹Use Built-In Analytics Features
🔹Implement Advanced Filters
🔹Implement Drillthrough Reports
🔹Work with the Q&A Feature
🔹Implement Custom Visuals and Slicers
🔹Share Content in the Power BI Service
🔹Secure Data
🔹Secure Objects
🔹Refresh Data
🔹Manage Changing Data
TARGET AUDIENCE
This course is aimed at anyone new to self‑service business intelligence who needs to quickly learn how to analyse and report on data using Power BI.
WHATS INCLUDED
🔹Professional instructor‑led training
🔹Courseware included
🔹Lunch provided
🔹Free on‑site parking at our Exeter training suite
🔹Certificate of completion
COURSE PREREQUISITES
Delegates should have previously attended the 2-day “Power BI Introduction” course, or possess equivalent knowledge and experience of Power BI.
WHY CHOOSE OUR MICROSOFT POWER BI ADVANCED TRAINING?
With years of experience delivering Microsoft Power BI courses to businesses and individuals, we make learning Power BI simple, practical, and enjoyable. The Complete course provides the ideal foundation for building your skills for work, study, and personal use.