
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 allows you to analyse and visualise data from a wide range of sources, making it easier to gain valuable insights into your business operations. With its user-friendly interface and robust capabilities, Power BI enables you to transform raw data into meaningful information, helping you identify trends, monitor performance, and make data-driven decisions. On this course, you will learn the fundamentals of Power BI, including how to connect to various data sources, clean and transform data, model relationships, create compelling visualisations, and share interactive reports with others across your organisation.
Throughout the course, you will have the opportunity to work with real-world data sets and practice using Power BI's extensive range of features and tools. You will explore advanced techniques for transforming and shaping data, building custom measures using DAX (Data Analysis Expressions), and optimising your data models for better performance. Additionally, you will learn how to design and publish interactive dashboards and reports that offer deep insights and help you make informed business decisions in real time. By the end of this course, you will have a comprehensive understanding of Power BI and the skills to confidently use this versatile tool to convert complex data into actionable insights, empowering you to drive business growth and innovation.
May: 6, 12, 13, 19, 20, 27
June: 2, 3, 9, 10, 16, 17, 23, 24, 30
July: 1, 7, 8, 14, 15, 21, 22, 28, 29
August: 4, 5, 11, 12, 18, 19, 26
September: 1, 2, 8, 9, 15, 16, 22, 23, 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 is a powerful business intelligence tool developed by Microsoft that allows you to analyse and visualise data from a wide range of sources. On this course, you will build on your foundational knowledge of Power BI and dive deeper into the advanced features and functionality of the tool.
Throughout the course, you will have the opportunity to work with real-world data sets and practice using Power BI's many advanced features and tools. You will learn how to perform advanced data transformations and modelling, create advanced visualisations, and implement advanced data analytics and machine learning techniques. By the end of this course, you will have an in-depth understanding of the advanced features and functionality of Power BI and be able to use this powerful tool to transform data into insights that can drive your business forward.
May: 6, 12, 13, 19, 20, 27
June: 2, 3, 9, 10, 16, 17, 23, 24, 30
July: 1, 7, 8, 14, 15, 21, 22, 28, 29
August: 4, 5, 11, 12, 18, 19, 26
September: 1, 2, 8, 9, 15, 16, 22, 23, 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 allows you to analyse and visualise data from a wide range of sources. On this course, you will build on your advanced knowledge of Power BI and learn how to use the tool to its full potential.
Throughout the course, you will have the opportunity to work with complex data sets and practice using Power BI's most advanced features and tools. You will learn how to perform advanced data transformations and modelling, create custom visualisations using the Power BI developer tools, and implement machine learning models in Power BI. By the end of this course, you will have a deep understanding of the most advanced features and functionality of Power BI and be able to use this powerful tool to solve complex data problems and gain insights that can drive your business forward.
May: 6, 12, 13, 19, 20, 27
June: 2, 3, 9, 10, 16, 17, 23, 24, 30
July: 1, 7, 8, 14, 15, 21, 22, 28, 29
August: 4, 5, 11, 12, 18, 19, 26
September: 1, 2, 8, 9, 15, 16, 22, 23, 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 4:00pm. Or complete the contact form.
Download our latest training brochure for 2025. Includes our Wellbeing, Core Skills, ICT and Technical courses.