Microsoft Power BI - Beginner Course

EnquireEnquire VenueFurther Info

Course Details

Price: £275 per person
Duration: 1 day
Available: Bridgend, South Wales or Online


Microsoft Power BI

Microsoft Power BI Beginner - Course Overview

Power BI is a powerful business intelligence tool developed by Microsoft that enables users to analyse and visualise data from a wide range of sources. With its intuitive interface and robust functionality, Power BI allows you to transform raw data into meaningful insights that support smarter, data-driven decision-making. This beginner-level course is designed to introduce you to the core features of Power BI, including connecting to data sources, cleaning and transforming data, modelling relationships, creating dynamic visualisations, and sharing interactive reports across your organisation.


During this one-day course, you will work hands-on with real-world data sets to apply the skills you’re learning in practical scenarios. You will gain a solid understanding of Power BI's data transformation tools, learn to build calculated columns and measures using DAX (Data Analysis Expressions), and explore best practices for designing clear and insightful dashboards. The course also covers tips for optimising report performance and publishing content securely for collaboration within your team or organisation.


This course is ideal for professionals who are new to Power BI and want to unlock the full potential of their data. Whether you work in finance, operations, sales, or any data-driven role, this course will equip you with the essential skills to start using Power BI effectively and confidently in your day-to-day work.


Microsoft Power BI Beginner - Course Dates 2025

July: 22, 28, 29

August: 4, 11, 12, 18, 19

September: 1, 8, 9, 15, 16, 29, 30

October: 6, 7, 13, 14, 20, 21, 27, 28

November: 3, 4, 10, 11, 17, 18, 24, 25

December: 1, 2, 8, 9, 15, 16



Microsoft Power BI Beginner - Course Content

  • Getting started

  • Connecting to software services

  • Getting data into Power BI

  • Cleaning up and transforming data

  • Data modelling

  • Using DAX

  • Creating reports

  • Creating visualisations

  • Publishing content

  • Creating Power BI mobile content

  • Consuming and customising content

  • Refreshing content


Who is this course for?

This course is ideal for professionals who want to enhance their data analysis and visualisation skills using Microsoft Power BI. It is suitable for business analysts, data analysts, managers, and anyone who works with data and wants to create interactive reports and dashboards. Whether you are new to Power BI or have some experience and want to deepen your knowledge, this course will provide you with practical skills to turn raw data into meaningful insights. No prior experience with Power BI is required, although basic familiarity with Excel and data concepts will be helpful.


Microsoft Power BI - Intermediate Course

EnquireEnquire VenueFurther Info

Course Details

Price: £275 per person
Duration: 1 day
Available: Bridgend, South Wales or Online


Microsoft Power BI

Microsoft Power BI Intermediate - Course Overview

Welcome to our one-day Power BI training course for intermediate users. Power BI, Microsoft's dynamic business intelligence platform, empowers users to analyse, model, and visualise data from a wide variety of sources. Designed for those with a foundational understanding of Power BI, this course takes your skills to the next level by exploring more advanced tools and techniques that drive deeper insight and smarter decision-making.


Throughout the course, you will work hands-on with real-world data sets, developing the confidence to tackle more complex reporting challenges. You will learn to perform advanced data transformations using Power Query, build sophisticated data models, and create custom measures and calculated columns using DAX (Data Analysis Expressions). We will also explore best practices for optimising report performance and designing intuitive, interactive dashboards that communicate data clearly and effectively.


In addition, the course introduces advanced visualisation techniques, such as drill-through pages, conditional formatting, and dynamic tooltips, alongside Power BI's AI features for predictive analytics and anomaly detection. You will also learn how to manage report distribution, set up row-level security, and collaborate more effectively with colleagues using Power BI Service. By the end of the day, you’ll have a strong command of Power BI's intermediate features and be able to build high-impact reports that transform complex data into compelling insights. Whether you work in finance, operations, marketing, or data analysis, this course will equip you with the practical skills to elevate your reporting and contribute strategic value to your organisation.


Microsoft Power BI Intermediate - Course Dates 2025

July: 22, 28, 29

August: 4, 11, 12, 18, 19

September: 1, 8, 9, 15, 16, 29, 30

October: 6, 7, 13, 14, 20, 21, 27, 28

November: 3, 4, 10, 11, 17, 18, 24, 25

December: 1, 2, 8, 9, 15, 16



Microsoft Power BI Intermediate - Course Content

  • Review of Power BI Basics

  • Brief overview of Power BI and its features

  • Advanced Data Transformations

  • Advanced Power Query transformations

  • Working with hierarchical data

  • Creating custom functions

  • Advanced Data Modelling

  • Creating and managing many-to-many relationships

  • Using calculated tables

  • Using date tables and time intelligence functions

  • Advanced DAX Functions

  • Creating custom visuals using the Power BI developer tools

  • Advanced visualisation techniques, including drill-through and drill-down

  • Using custom themes and templates

  • Sharing and collaborating on reports and dashboards

  • Using Power BI workspaces and apps

  • Best practices for sharing and collaboration

  • Power BI Data Security and Governance

  • Understanding Power BI data security and governance features


Who is this course for?

This course is designed for intermediate users of Power BI who already have some experience using the tool and are looking to deepen their knowledge and skills. It is ideal for individuals who have completed a beginner-level Power BI course or who have been using the tool for some time and are looking to expand their capabilities.


Microsoft Power BI - Advanced Course

EnquireEnquire VenueFurther Info

Course Details

Price: £275 per person
Duration: 1 day
Available: Bridgend, South Wales or Online


Microsoft Power BI

Microsoft Power BI Advanced - Course Overview

Power BI is a powerful business intelligence tool developed by Microsoft that enables organisations to extract maximum value from their data. This one-day advanced course is designed for experienced Power BI users who want to take their skills to the highest level and fully leverage the platform’s extensive capabilities. Building on existing knowledge, the course focuses on using Power BI to solve complex data challenges and deliver deep, strategic insights across the business.


During the course, you will work hands-on with complex, multi-source data sets and explore Power BI's most advanced tools and features. You will master intricate data modelling techniques, advanced Power Query transformations, and sophisticated DAX calculations for dynamic analysis. The course will also guide you through creating custom visuals using Power BI developer tools and integrating external data sources through APIs and web services. You will learn techniques to optimise performance for large data models and streamline report design for scalability and responsiveness.


In addition, the course introduces advanced analytics and AI integration in Power BI, including using built-in machine learning models, forecasting, and anomaly detection. You will also explore techniques for embedding Power BI into applications and setting up enterprise-level security features such as row-level and object-level security. By the end of the day, you will have a deep understanding of Power BI's most advanced functionality and the confidence to develop complex, high-impact solutions that support strategic business goals. This course is ideal for data professionals, analysts, and developers seeking to push the boundaries of what Power BI can do within their organisation.


Microsoft Power BI Advanced - Course Dates 2025

July: 22, 28, 29

August: 4, 11, 12, 18, 19

September: 1, 8, 9, 15, 16, 29, 30

October: 6, 7, 13, 14, 20, 21, 27, 28

November: 3, 4, 10, 11, 17, 18, 24, 25

December: 1, 2, 8, 9, 15, 16



Microsoft Power BI Advanced - Course Content

  • Advanced Power Query transformations

  • Working with large data sets and optimising performance

  • Advanced Data Modelling Techniques

  • Advanced modelling techniques for complex data scenarios

  • Implementing advanced data modelling patterns

  • Advanced DAX calculations and functions for complex analysis

  • Using dynamic aggregations for high-cardinality data sets

  • Implementing calculations using Power BI Premium features

  • Using custom themes and templates for advanced visualisations

  • Using advanced analytics features, including clustering and forecasting

  • Implementing machine learning models in Power BI

  • Integrating Power BI with Azure Machine Learning

  • Managing Power BI workspaces, apps, and content packs

  • Advanced data security and governance features

  • Automating deployment and configuration using PowerShell and APIs

  • Identifying and resolving performance bottlenecks in Power BI reports and dashboards

  • Best practices for optimising report performance

  • Implementing performance optimisation features in Power BI Premium


Who is this course for?

This course is designed for advanced users of Power BI who have extensive experience using the tool and are looking to expand their knowledge and skills to an advanced level. It is ideal for individuals who have completed an intermediate-level Power BI course or who have been using the tool for some time and are looking to take their capabilities to the next level.


Our Customers

Client List

Recent Feedback

Feedback plays a pivotal part of our Learning Process, it ensures that we maintain the standards that we have set and continue to make improvements.


"I must say, this was an exceptional learning experience that surpassed my expectations. Things that would have taken hours are now going to take minutes. Really awesome!"

Tokio Marine

"I cannot stress enough how impressed I am with this course. Before I didn't know anything about Microsoft Power BI. It has made complex data analysis feel like a walk in the park. Thank you Dan!"

EcoLab

"Really enjoyed this course, found it very informative and particularly enjoyed learning about the report writing capabilities. I feel like I have learnt so much today that is going to enhance how I work going forward."

EcoLab


In-House training

In-House Training

Effortlessly upskill your teams with on-site expert training, saving time and promoting a comfortable learning environment.


Get QuoteMore Information
Online Training

Online Learning Available

Some of our courses can be delivered online with a live trainer. Checkout our guidance on online learning.


Online TrainingMore Information
Our training principles

Our Approach

Our training approach focuses on small groups led by friendly trainers, ensuring a non-judgemental and comfortable environment where everyone feels supported.


Have a Question?

If you have any questions regarding our training courses then please feel free to call us on 01656 737349 from Monday to Thursday from 9:00am to 3:00pm. Or complete the contact form.


ContactMore Information
Training Brochure 2025

Training Brochure 2025

Download our latest training brochure for 2025. Includes our Wellbeing, Core Skills, ICT and Technical courses.


DownloadMore Information