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?

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 Solutions Partner

As a Microsoft Solutions Partner, our 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 the creation of reports and dashboards that drive decision-making from insights in your data, using Data Storytelling principles.

It will enable attendees to gather reporting requirements, 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 import, combine, and transform data from a variety of sources, solve common data model problems, and various other features in Power BI used to enhance data models so you can build reports that meet your business needs with great performance.

After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, and create a data model that follows best practice.

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

Register your interest in Power BI Training

  • Tick all that you wish to book onto
  • We’re committed to your privacy. By completing this form, you are agreeing to receive other communications from Simpson Associates. You may unsubscribe from these communications at any time.
    For more information, check out our Privacy Policy.

  • This field is for validation purposes and should be left unchanged.