Instructor led Microsoft Power BI Training – Advanced Courses

We can enhance your business user skills in Power BI to help you to achieve success

Register InterestView Brochure

What is Power BI?

Microsoft Power BI is a highly popular data visualisation tool created by Microsoft. The tool is used to empower businesses, offering a new way for users at all levels to be self-sufficient and self-serving. Power BI puts forward a new opportunity for your team to create reports and dashboards suited to your business, and effortlessly share discovered insights with the rest of the organisation, enabling a near-live, 360-degree view of your whole business with a single, stunning interactive dashboard.

Power BI Training Courses delivered by a Microsoft Gold Partner

As a Microsoft Gold Partner, our Microsoft Power BI training courses provide users of all levels with the capabilities to create their own reports and dashboards in Microsoft Power BI. We can show users how to analyse data faster, deeper and more effectively than ever before. Giving you the ability to create incredible interactive visualisations and immersive data insights that can be used to drive business success.

“I recently attended a virtual version of the ‘Advanced Modelling with Power BI’ training course run by Simpson Associates – it was a great course and really hit the spot. I learned lots that I will be taking away and looking to apply on our projects going forwards. The instructor was highly knowledgeable in his field and responded comprehensively to delegate questions. Looking forward to the next course.”

Jonathan Holman, BI Developer / Senior Operational Research Analyst (GORS), Department for Education.

These Power BI training courses are for up to 6 delegates and can be delivered either virtually or in-person.


Advanced Visualisation with Power BI Training Course

This 1-day course will cover Power BI report layouts and
structure whilst using an agile process to create Power BI
data visualisations. It will enable attendees to understand the art behind visualisations, implications behind choosing the right charts, the impact of colour, shape and size, and finally the use of Power BI custom visuals.

The course includes various design patterns of dashboards
and reports and best practices to authoring great reports and dashboards for business users.

Duration: 1 day


Advanced Data Modelling &
Shaping with Power BI

This 1-day course will cover using Power BI Desktop to
import and shape data from a variety of sources. It will also
walk through Power BI capabilities you can use to enhance
the data model for your business users. The course covers
key aspects of how to create a great data model to meet
your business needs, various features in Power BI used
to enhance data models so you can build great reports,
and an introduction to DAX to create calculations.

After completing this training, the attendees should
be able to import data from a variety of data sources
into Power BI, shape the data, create the data model,
and write DAX functions to the Power BI model.

Duration: 1 day


Power BI DAX

This 1-day course introduces Data Analysis Expressions
(DAX) and provides you with foundational skills
required to enhance data models with calculations.

It describes how you can write DAX formulas and the different types of model calculations, including calculated tables and columns, and measures. Evaluation contexts are introduced, and how to write DAX formulas that modify filter context.

Duration: 1 day


Power BI Administrator

This 1-day course will walk attendees through the Microsoft Power BI administration and the management of a Power BI tenant, including the configuration of tenant settings, usage monitoring, and provisioning of licenses, as well as other organisational resources.

It covers the typical admin tasks and tools, such as Power BI admin portal and Office 365 admin center, and how to automate them by using administrative APIs and PowerShell cmdlets. Specific hands-on labs will focus on using Premium capacity in Power BI, safely sharing Power BI assets, and using the Power BI audit log to optimize Power BI usage.

Duration: 1 day


Power BI Paginated Reports

This 1-day course will walk attendees through the
technical knowledge required to create, publish,
and distribute Power BI paginated reports.

The course covers these topics:


• Design report layouts.
• Connect to data sources to retrieve report data.
• Work with parameters.
• Visualize report data.
• Add interactive features.
• Publish, consume, deliver, and embed paginated reports.


Power BI Developer

This 1-day course will empower attendees with the technical
knowledge required to embed Power BI content. This course
is designed specifically for experienced app developers and being familiar with front-end coding is an advantage. The course covers these topics:


• Acquire access using Azure Active Directory (Azure AD) apps and tokens.
• Work with the Power BI REST API.
• Embed Power BI content in your apps.
• Integrate Power BI content in your apps using the Power BI JavaScript API.
• Enforce row-level security (RLS) to ensure app users see the right data.
• Choose the right license to suit your requirements.


Modern Excel Analyst

This 1-day workshop is designed for analysts. It demonstrates the advanced capabilities available in Excel, explores how Excel and Power BI are best used together, and shows how to successfully work with them in Microsoft Teams and SharePoint online.

At the end of the day, attendees will better understand:


• Analytics in Excel.
• Mapping analytics in Excel to Power BI—
Compare Excel and Power BI desktop.
• Power BI additional capabilities.
• Power BI and Excel better together.
• Power BI and Microsoft Teams.


Please enquire for further information regarding dates and costs: info@simpson-associates.co.uk

Covid 19 update

At Simpson Associates, we offer a range of Power BI training courses for Beginner and advanced users. Typically we deliver our training course in London or a destination of your choice. But to Covid 19, we are monitoring the situation closely and following government recommendations and guidance.

As many of our clients are equally putting in measures to reduce travel and basing staff at home, alongside the remote collaboration tools we already had in place, we have invested in additional remote working, collaboration, video conference and remote training tools to provide instructor-led Power BI online courses.

We ensure you that all of our Power BI online courses provide all of the benefits of our classroom training sessions and are just as hands-on and interactive.

Register your interest in Power BI Training

  • Tick all that you wish to book onto
  • This field is for validation purposes and should be left unchanged.