Power BI Business Analytics
This course is designed to equip you with the fundamental skills and knowledge to create interactive dashboards, perform data analysis, and unlock valuable insights for your business using Power BI. Learn the basics of data modelling, data visualisation techniques, and how to make the most of Power BI's business intelligence capabilities.
Whether you're a business professional, analyst, or data enthusiast, this course will give you the skills to use the full potential of Power BI and make informed decisions based on your real-world data.
Understand Power BI concepts and features
Connect to various data sources easily
Create visually appealing and interactive visuals
Query and shape your data for analysis
Generate comprehensive reportsIf attending an online course you must have a licensed copy of any software required and access to a suitable computer.
You'll need to have completed our Excel Intermediate course or have equivalent working knowledge of Excel before joining this class.
Course leader is an experienced industry expert
3 Ways to Learn
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 28-29th Oct 25 | Tue-Wed | London Bridge | Available | £599.00 | £100.00 | £499.00 + VAT | |
| 17-18th Dec 25 | Wed-Thu | London Bridge | Available | £599.00 | £50.00 | £549.00 + VAT | |
| 17-18th Feb 26 | Tue-Wed | London Bridge | Available | £599.00 | £599.00 + VAT | ||
| 15-16th Apr 26 | Wed-Thu | London Bridge | Available | £599.00 | £599.00 + VAT | ||
| 9-10th Jun 26 | Tue-Wed | London Bridge | Available | £599.00 | £599.00 + VAT | ||
| 5-6th Aug 26 | Wed-Thu | London Bridge | Available | £599.00 | £599.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | |
|---|---|---|---|---|---|---|---|
| 27-28th Nov 25 | Thu-Fri | Online | Available | £599.00 | £100.00 | £499.00 + VAT | |
| 20-21st Jan 26 | Tue-Wed | Online | Available | £599.00 | £50.00 | £549.00 + VAT | |
| 19-20th Mar 26 | Thu-Fri | Online | Available | £599.00 | £599.00 + VAT | ||
| 12-13th May 26 | Tue-Wed | Online | Available | £599.00 | £599.00 + VAT | ||
| 9-10th Jul 26 | Thu-Fri | Online | Available | £599.00 | £599.00 + VAT | ||
| 1-2nd Sep 26 | Tue-Wed | Online | Available | £599.00 | £599.00 + VAT |
Understanding the Power BI ecosystem and where Power BI Desktop fits
Navigating the Power BI interface, ribbons, and panes
Creating and saving your first Power BI Desktop report
Best practices for file management (.pbix files) and version control
Importing and connecting to Excel, CSV, and text files
Working with folder connections for batch imports
Introduction to basic database connections (SQL Server, Access, etc.)
Overview of DirectQuery vs Import – when to use each
Using Power Query Editor to clean, merge, and shape data
Understanding data types, properties, and relationships
Applying filters, transforms, pivot, unpivot, and group by
Creating custom and conditional columns
Using data profiling tools (Column Quality, Distribution, and Profile)
Introduction to M language basics in Power Query for automation
Choosing the right chart type for your analysis
Working with tables, matrices, bar, line, pie, and combo charts
Adding cards, KPIs, and gauges for key metrics
Using conditional formatting to highlight insights
Building interactive visuals with slicers, drill-through, and drill-down
Creating simple hierarchies and grouping for summarised views
Designing clear and accessible dashboards in Power BI Desktop
Adding bookmarks and navigation buttons for interactivity
Using the Selection Pane and Sync Slicers
Building Geo-data visualisations with built-in Maps (no cloud dependency)
Enhancing reports with consistent themes, colours, and templates
Tips for storytelling with data and effective layout design
Understanding the difference between calculated columns and measures
Using core DAX functions: SUM, AVERAGE, COUNTROWS, CALCULATE, FILTER
Building simple time-intelligence measures (YTD, MTD, growth rates)
Using RELATED and RELATEDTABLE for relational data
Troubleshooting and managing DAX formula errors
Exporting data and visuals to Excel, PDF, and PowerPoint
Printing and distributing static reports from Power BI Desktop
Understanding options for publishing with a free license
Saving Power BI templates for reuse and consistency
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Upskill your team together. Build your team and develop consistency, and collective confidence.
Define your direction with purpose, aligning your learning journey to personal and career goals.
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.
From £1,198 + VAT
From £599 + VAT
From £199 + VAT
