Price: £375 per person
Time: 9:00am-2:00pm
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 insights into your business operations. On this course, you will learn the basics of Power BI, including how to connect to data sources, transform and model data, create visualisations, and share your reports with others.
Throughout the course, you will have the opportunity to work with real-world data sets and practice using Power BI's many features and tools. You will also learn how to create interactive dashboards and reports that can help you make informed business decisions. By the end of this course, you will have a solid foundation in Power BI and be able to use this powerful tool to turn data into insights that can help you grow your business. So, let's get started.
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 suitable for both complete beginners to Power BI or those with limited experience.
Price: £375 per person
Time: 9:00am-2:00pm
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.
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: £375 per person
Time: 9:00am-2:00pm
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.
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.
Our training approach focuses on small groups led by friendly trainers, ensuring a non-judgemental and comfortable environment where everyone feels supported.
Effortlessly upskill your teams with on-site expert training, saving time and promoting a comfortable learning environment.
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
Some of our courses can be delivered online with a live trainer. Checkout our guidance on online learning.
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.