Power BI Business Analytics Course

Turn raw data into clear, interactive dashboards and reports with Power BI.

A two-day practical course covering data connections, visualisations, DAX and Power Query.

232

Reviews

9.6

Satisfaction

99.1%

Recommend

See Reviews

Power BI Business Analytics Course

Name: Power BI Business Analytics
Rating: 4.8 (232 reviews)

Turn raw data into clear, interactive dashboards and reports with Power BI on this two-day practical course. You'll learn how to navigate the Power BI interface, connect to and import data from Excel, CSV and other sources, use Power Query to clean and transform data, create calculated measures using DAX, build interactive visualisations including charts, tables and maps, design dashboard layouts with slicers and filters, and share and publish your reports.

Suitable for business professionals, analysts and anyone who works with data.

Two Days

10:00 - 16:30 UK Time

Private Options

Key Learning Points

Key Learning Points
Navigate the Power BI interface and ecosystem
Connect to and import data from multiple sources
Build interactive dashboards and visual reports
Query, shape and transform data with Power Query
Create calculated measures and comprehensive reports

If 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.

Microsoft Excel : Intermediate

Who is this course for?

For business analysts, finance professionals, marketers and managers who need to turn data into interactive dashboards. Requires intermediate Excel knowledge or our Excel Intermediate course.

Expert Trainers

Course leader is an experienced industry expert

Class Size

1 - 10 in person or 1 - 6 online

Support

28 days free helpdesk support with all courses

Cancellation

Cancel before 7 days for 100% refund

Certificate

Earn a certificate of attendance on completion

Volume Discounts

Save money by using our Learning Pots scheme

Course Dates	Days	Location	Places	RRP	Discount	You Pay
18-19th Jun 26	Thu-Fri	Online	Available	£699.00	£100.00	£599.00 + VAT
24-25th Aug 26	Mon-Tue	Online	Available	£699.00		£699.00 + VAT
1-2nd Oct 26	Thu-Fri	Online	Available	£699.00		£699.00 + VAT
17-18th Dec 26	Thu-Fri	Online	Available	£699.00		£699.00 + VAT

No in-person dates available at the moment.

Course Dates	Days	Location	Places	RRP	Discount	You Pay
18-19th Jun 26	Thu-Fri	Online	Available	£699.00	£100.00	£599.00 + VAT
24-25th Aug 26	Mon-Tue	Online	Available	£699.00		£699.00 + VAT
1-2nd Oct 26	Thu-Fri	Online	Available	£699.00		£699.00 + VAT
17-18th Dec 26	Thu-Fri	Online	Available	£699.00		£699.00 + VAT

Course Dates

18-19th Jun 26 (Thu-Fri)

Location:Online

Places: Available

RRP: £699.00

Discount: £100.00

You Pay: £599.00 + VAT

24-25th Aug 26 (Mon-Tue)

Location:Online

Places: Available

RRP: £699.00

Discount:

You Pay: £699.00 + VAT

1-2nd Oct 26 (Thu-Fri)

Location:Online

Places: Available

RRP: £699.00

Discount:

You Pay: £699.00 + VAT

17-18th Dec 26 (Thu-Fri)

Location:Online

Places: Available

RRP: £699.00

Discount:

You Pay: £699.00 + VAT

Course Outline

1. Introduction to Power BI Desktop

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

Trying out Preview features

2. Connecting to Local and File-Based Data Sources

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

3. Preparing and Transforming 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

4. Building Effective Visualisations

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

5. Enhancing and Customising Reports

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

6. Introduction to DAX (Data Analysis Expressions)

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

7. Sharing and Exporting Reports

Exporting data and visuals to Excel, PDF, and PowerPoint

Printing and distributing static reports from Power BI Desktop

Creating user roles and activating Row Level Security

Understanding options for publishing with a free license

Saving Power BI templates for reuse and consistency

Great at interacting with the class/group and keeping things relevant and interesting

The Power BI Business Analytics course was excellently delivered, with consistently engaging and meaningful interaction throughout the sessions

Claire was an excellent trainer, she was very thorough, clear, and patient. She had a lot of knowledge and made the course very engaging and fun.

I cannot fault anything!! It was an amazing course, an amazing venue. Claire is a great instructor and I learnt so much in these 2 days! Cannot wait to practise it all. Huge thank you. I will definitely recommend and also be back myself for a different course.

The course was very useful to understand data visualisation and transformation. Claire was excellent at explaining complex concepts and breaking them down into simple, relatable examples.

Explaining the logic behind the functions.

Delivery and willingness to expand on detailed questions in areas that may be workplace specific

I believe Claire Squibb is an excellent trainer of excel and powerbi - the 2 days were packed full of knowledge and there was some great methods of teaching - will recommend.

This course felt like a hidden gem. With just Claire and me in the sessions, it became an unexpectedly intimate and tailored learning experience, more like a private lesson than a typical group course. Claire created a relaxed atmosphere where we could explore topics in depth. I left feeling more confident and genuinely inspired. It’s rare to find a course that feels this personal and impactful.

Covering all features, checking knowledge with reconciliation tasks, general knowledge was good

Explaining things clearly and lots of extra trips. Felt like a very relaxed environment which I liked and meant it was easy to ask questions

The trainer (Tom) was incredibly kind. Super knowledgeable, engaging and very supportive. He used relevant examples and was always willing to answer questions.

It all ran smoothly, the course was very good

Very well structured, good examples. Although PowerBI wasn't entirely new to me, I still learned a lot. Thank you!

Time Management, cleanliness, friendly and polite. Trainer (Claire) was exceptional

Organised approach and clear structure to delivery of the training. Friendly and professional welcome and approachable trainer. Claire was excellent.

Trainer was knowledgeable and course was extremely well run

Friendly, professional and experienced trainer.

Claire was fantastic, very knowledgeable, set a good pace but also patient when needed to go back if anyone not quite getting it.

The trainer was very knowledgeable, and went at a good pace, and slowed down when needed. They were able to answer questions, and resolve and problems when I made mistakes.

Very good knowledge and navigation of system

Clear explanations, good examples, good material, knowledgeable and passionate trainer.

Individual examples easy enough to follow, just a lot of depth to take in.

Very clear training style and presentation. Worked examples and case study material very appropraite. Overall, very good. Kept to timing very well too.

Super organised and Claire is so knowledgeable and helpful!

Examples and trainer was extremely prepared

Claire was fantastic! So knowledgeable and really engaging. Would highly recommend this course to anyone else interested in expanding their data skills.

Claire was super helpful and patient and a great teacher!

The trainer Claire was fantastic. Really knowledgeable and very personable. I loved worked on some real work examples.

Helping out when behind in the examples - covering a lot of content Claire was excellent with questions and challenging the thinking

It was a very thorough course with a good mix of theory and practical. The course instructor, Claire, was great and clearly had a lot of knowledge.

Great teacher, explained very well and thoroughly. Good lunch and facilites

I feel like this provided a good foundation of knowledge to get started with

Well run and very informative course, thoroughly enjoyed!

Friendly trainer. Great knowledge, used memorable examples.

Claire is very knowledgeable and delivered the course very professionally

Very good at explaining Power BI basics. It will definitely help with efficiency for my work moving forward.

Helping me understand Business Objects and feel confident with now using the system

Very well structured course with engagin data examples.

Excellent course, Alan checked if everyone was following along throughout the course and gave space for questions which was very useful, thank you

Great environment and desk space to use, Tutor was patient and very knowledgeable

Good explanations, and very helpful teacher

Being able to go through processes at a good pace and being able to ask questions. A lot of useful information that I can use or apply to some of the tasks at work.

Good amount of breaks, adapted according to previous students experience and answered questions

Lovely venue and facilities. Really comprehensive overview /introduction to power bi

Course was well structured and felt comfortable to ask questions. Food and breaks were evenly spaced.

The course was very good and I have learned a lot. Alan was very knowledgeable. His course material were excellent.

The food was great, and I though it was great that it came in reusable packaging. I also thought it was really good that there was no single-use service packaging - all the plates, cups, cutlery was reusable. Really good environmental initiatives. :-) The info before the course, instructions, etc. were really good. Although I gave some constructive feedback on the instructor, I thought it was still useful overall and a good introduction into the functionality of Power BI.

Very engaging, really liked the additional tips

Tom was a brilliant trainer with high energy and very very knowledgeable on the subject. Initially I was sceptical about attending an online course but Tom's knowledge, humour and learning style was perfect. The course set up made you feel very comfortable about asking any question - no matter how basic which enhances the learning experience. The day was structured very well with adequate breaks and diversity of subject material made the day fly by. I am now looking forward to putting into action the skills Tom has equipped me with in my workplace. Would definitely recommend this course to others i. Thank you again Tom.

Answering Qs along the way and going into more depth.

Trainer is positive and very knowledgeable.

Offering diversity training programmes that align with business trends

Very good course. Pacing was tailored well for the group. Good balance of Power Query and design considerations.

Our trainer was very knowledgeable and relatable, happy to stop and help and tailor the instruction to suit our needs.

In-depth explanations to all points discussed in an easy to follow manner

Excellent training facility, clean friendly and wonderful food. Very knowledgeable and approachable instructor. She was able to answer and help with all queries and questions. I really enjoyed the course and it has made me look forward to working with Power BI.

Excellent course with good examples and a friendly leader. Would recommend.

Good pace of learning/teaching, explanations and open to questions with in depth answers and examples. Very personal training and very impressed, clear training and Tom made sure what was being taught was understood. Thank you

Tom was excellent. I really enjoyed his teaching and he was very knowledgeable. I will definitely be using Power BI again as Tom demonstrated the programme very well which I feel I can transfer to my own work.

Everything was well run and very organised.

Tom was very good at explaining things and making me think of using things in different ways.

Tom knew a bit about our business which was helpful. I also found the examples were really good ones which is not always the case. I learnt a lot and feel very confident now in Power BI and keen to try out more.

Really friendly trainer, went the extra mile to answer additional questions not covered by the course examples but were relevant to my day job.

Excellent interaction, good examples and an excellent instructor with excellent knowledge

Fast moving, but with only 4 people plenty of time for everyone to get attention. (Previously been on-line course with 50+ people and that didn't work well)

Excellent Training. Knowledgeable Trainer. Can take away real life tips to use at work.

Very friendly environment and trainer, all questions very welcome and made me feel very at ease.

Organization and trainer's good knowledge of the product

Every lesson taught by Tom is incredibly valuable as being directly actionable and straight to the point. His impressive knowledge on the topic and the nuggets he is sliding here and there makes it a truly enjoyable experience !

Very clear and simple from the start with difficulty increasing throughout. Good process and easy to ask questions or to clarify something.

Great pace / interaction - Tom was excellent

Making the training course clear, even though it was a virtual course.

Good prepared examples sent out ahead of the course and well set up online under the Covid circumstances!

Giving examples, being very personable and genuinely caring about individuals.

Really good at seeing the instructor do the tasks in front of them and then learning by mimicking which is fantastic. Enjoyed the trainer who was really approachable and happyy to take questions

Tom was really enthusiastic, which made the session much more enjoyable.

Customer service. good trainer. good pace and autonomy on my private course

Majority of the course was hands on so working through examples on our own laptops, which is preferred to watching examples

Again, I couldn't recommend Tom enough. He's fab!

Tailored to our company needs. Gave examples on how we could use it in our companies

Very well structured course and layout of the days with regular breaks Knowledgeable trainer very approachable and helpful at all times Catering facilities exceeded expectation

Overall knowledge was excellent. Useful tips throughout and kept relevant to my work.

Flexible and responsive to our learning needs

It was a great course with nice people and knowledgeable.

The environment and site were excellent. Also dealing with the fact the course was meant to be 2 instead of 3 days..

Friendly trainer and lovely food! good selection of drinks and biscuits throughout the day

Having the chance to experiment with the tools was great. The food and the centre are exceptional, I would be very happy to use for training in the future.

The course itself is good and Tom was very good interacting with us all.

Friendly, nice small groups, un-rushed, great building.

Tom was very approachable and was able to tailor the course to my jobs requirement

Tom is a great trainer, very approachable and easy to ask questions to, even if they are basic questions he is happy to help explain for all levels

Very good coverage of PowerBI, and the related functions in excel. Made relevant to actual work - trainer helped using examples of things we are already working on and solved a couple of problems we'd had for a while.

Extra information.....it was useful to see the excel powerpivot and excel Dax and how this was applied in PBI

Good speed of learning, across all learning speeds, friendly, interactive.

Great knowledge and very friendly. Always happy to answer questions we had and didn't make us feel silly for asking questions.

The whole process very efficient through out the day

Well run and Very Organised. Trainer had very good subject knowledge. polite and friendly staff.

Who attends?

Career Progressives

Professionals who wish to develop skills for their current role and companies who believe in developing their talent.

Explore Careers

Career Changers

People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.

Explore Careers

Graduates

Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.

Explore Careers

Learn Your Way

Face To Face

Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.

Explore Courses

Live Online

Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.

Explore Courses

Team Training

Upskill your team together. Build your team and develop consistency, and collective confidence.

Explore Team Training

Three Steps To Success

Identify Your Path

Define your direction with purpose, aligning your learning journey to personal and career goals.

Learn With Experts

Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.

Earn Certification

Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.

Power BI Business Analytics Course