
Price: £275 per person
Duration: 1 day
Available: Bridgend, South Wales or Online
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.
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
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
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.
Price: £275 per person
Duration: 1 day
Available: Bridgend, South Wales or Online
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.
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
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
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.
Price: £275 per person
Duration: 1 day
Available: Bridgend, South Wales or Online
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.
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
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
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.
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
Effortlessly upskill your teams with on-site expert training, saving time and promoting a comfortable learning environment.
Some of our courses can be delivered online with a live trainer. Checkout our guidance on online learning.
Our training approach focuses on small groups led by friendly trainers, ensuring a non-judgemental and comfortable environment where everyone feels supported.
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.
Download our latest training brochure for 2025. Includes our Wellbeing, Core Skills, ICT and Technical courses.