• Exeter, Devon EX2 7AE
  • hello@amesolutions.co.uk
  • Office Hours: Monday - Friday 8:30 AM – 5:00 PM
Thumb
Microsoft Power BI Advanced Training Course

Microsoft Power BI Advanced Overview

This page gives you a full overview of our Microsoft Power BI Advanced Course, what’s included, the key topics we cover, and what you can expect to learn as experienced user.

    Microsoft Power BI Advanced Training Overview

    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.

    SUBJECT AREAS

    • Load Data from Relational Databases
    • Process Multiple Files
    • Storage Modes
    • Load Data from the Internet
    • Connect to a Published Dataset
    • Profile Data
    • Improve Performance with Query Folding
    • Fuzzy Lookups
    • Split a Table into Multiple Tables
    • Structure and Manage Queries
    • View Query Dependencies
    • Getting Acquainted with the M Language
    • Tweak Existing M Language Formulae
    • Create User Defined Functions with M
    • Invoke Custom Functions
    • Create Date and Time Tables with M
    • Best Practices
    • Data Modelling Revisited
    • Fact and Dimension Tables
    • Many-to-Many Relationships
    • Resolving Some Common Data Modelling Issues
    • Getting up to Speed with DAX
    • Calculated Columns and Measures
    • Manipulating the Filter Context
    • Creating Calculated Tables
    • Use Variables
    • Create a Date Table with DAX
    • Time Intelligence Revisited
    • Useful DAX Querying Techniques
    • Organise Content with Display Folders
    • Report Themes
    • Use the Small Multiples Chart Option
    • Sparklines
    • Implement Reports as Tooltips
    • Continuous v Categorical Axis
    • Custom Grouping
    • Use the Analytics Pane
    • Forecasting & Anomaly Detection
    • Visual, Page, and Report Level Filters
    • Synchronise Slicers across Pages
    • Analyse Data with Decomposition Trees
    • Analyse Data with Key Influencers
    • Drillthrough Reports
    • What-If Parameters
    • Field Parameters
    • Implement and Manage Q&A
    • Custom Visuals and Slicers
    • Mobile Report Layout
    • Set up Data Alerts
    • Share Content and Workspaces
    • Create and Distribute Apps
    • Promote & Certify Content
    • Secure Data with Row Level Security (RLS)
    • Object Level Security
    • Refresh Datasets
    • Understand Data Gateways
    • Incremental Refresh
    • Quick Insights
    • Analyse in Excel
    • Export Reports
    Have Questions or Ready to Book?

    For more information, or to book onto our Microsoft Power BI Advanced training course, please get in touch.

    If there’s a Microsoft course you’re interested in that isn’t listed on our website, let us know we can arrange one‑to‑one onsite training with our trainer.

    You can view our full list of training courses here.

    Office Location

    2nd Floor Wear House, Topsham Road,
    Exeter, Devon. EX2 7AE.

    Phone

    01392 824022

    Email

    info@amesolutions.co.uk

    Name