About this Course

Transform data into impactful insights with this practical Power BI course. Learn to connect, clean, and visualise data across Report, Data, Model, and Query Editor views — and share your dashboards using the Power BI online service. Explore powerful M functions and DAX formulas to create dynamic, interactive reports. By the end, you’ll be ready to build professional dashboards and make confident, data-driven decisions.

Prerequisites: No previous Power BI experience is required. Delegates should be confident using Excel, including basic formulas, working with tables and navigating spreadsheets. A general understanding of data, reports or business information would be helpful but is not essential.

Course Outline

During this course, delegates will develop the confidence and practical skills to transform data into meaningful insights, creating interactive dashboards and reports that drive smarter business decisions:

  • Getting Started with Power BI – Explore the Power BI ecosystem and learn the basics of navigating Power BI Desktop, including its four main views and visualisation options.
  • Connecting and Importing Data – Learn how to import data from Excel, CSV, databases, web sources, and folders. Understand Import vs. Direct Query modes and how to manage your data connections.
  • Shaping and Cleaning Data – Master the Query Editor to clean and transform data — manage data types, remove errors, combine tables, and create custom columns for better analysis.
  • Building Data Models – Discover how to build relationships between tables, define key properties, and structure your data model for accurate and efficient reporting.
  • Designing Interactive Reports – Create engaging visuals like charts, maps, tables, and KPIs. Apply formatting, filters, slicers, and themes to build dynamic, user-friendly dashboards.
  • Writing Formulas with M and DAX – Unlock advanced analytics using M functions in the Query Editor and DAX formulas in Report view. Learn to write calculated columns, measures, and logical expressions.
  • Advanced Calculations and Time Intelligence – Dive deeper into DAX with functions like CALCULATE, SUMX, and TOTALYTD. Learn to work with calendar tables, financial years, hierarchies, and grouped data comparisons.
  • Publishing and Sharing Insights – Publish reports to the Power BI service, collaborate online, use Q&A for natural language queries, and export dashboards to PowerPoint or PDF for sharing.

Who Should Attend

Anyone looking to turn data into clear, interactive dashboards and reports using Power BI.

Would Your Team Benefit From Power BI Training?

Find out how we can empower your employees to harness the full potential of their potential.

Contact Us

Learning Outcomes

  • Navigate Power BI and understand the report-building process.
  • Connect and prepare data from multiple sources for analysis.
  • Build effective data models using relationships and structured datasets.
  • Create interactive reports and dashboards with professional visualisations.
  • Apply advanced calculations and share insights using DAX, time intelligence, and the Power BI Service.

Course Reviews

Excel Intermediate

Course was one of the best I have ever attended in professional development and will make me more efficient

Anon
Asmodee UK
June 15, 2026

Excel Intermediate

I was amazed by Tony's knowledge and his ability to convey things concisely and clearly. I really enjoyed the course and am confident in my ability to apply some of the knowledge to my day to day work which is what I wanted to get out of it.

Anon
Crown Agents Bank
June 11, 2026

Excel Introduction

Excel - Gary help me loads with a spreadsheet I had! I’ll book onto the intermediate

Anon
Wessex Water
June 2, 2026

Excel

Gary made the information very attainable, it was good we could do the work alongside him.

Anon
Welwyn Hatfield Borough Council
June 2, 2026

Excel Advanced

Tony Barrett is highly knowledgeable in Excel and was able to explain each concept in a way that made it easy for me to understand how to apply it directly to my role.

Anon
CWG
June 16, 2026

PowerPoint

Great course, Louise, great to learn small everyday skills to help speed up

Anon
Stellantis
June 16, 2026

Related Courses

Corporate IT

Power BI- Intermediate

This one-day Power BI intermediate course helps users master advanced data transformation, DAX, and interactive dashboards for deeper data insights.

Corporate IT

Power BI- Advanced

This two-day Power BI advanced course helps professionals master data modelling, automation, and advanced analytics to build powerful, data-driven dashboards.

Corporate IT

Power BI- Administrator

This one-day Power BI Administrator course helps professionals manage, secure, and optimise the Power BI platform for efficient organisational use.

Corporate IT

Power BI- Data Modelling with DAX

This one-day Power BI data modelling with DAX course helps professionals build advanced calculations, optimise data models, and generate deeper analytical insights.

Check Our FAQs

What types of training courses do you offer?

We offer a wide range of bespoke corporate training solutions across key areas such as leadership, management development, digital skills, workplace communication, customer experience, sales performance, project delivery, team development and professional skills. Each programme can be tailored to your organisation’s objectives, your people and the practical challenges they face at work.

Do you offer public courses?

No. Elliott Training does not currently offer public scheduled courses for individual delegates. We specialise in private corporate training courses delivered exclusively for organisations, teams and groups who require tailored training aligned to their business needs.

Are your courses bespoke?

Yes. Our courses can be tailored to your organisation, team and objectives. We can adapt the course content, examples, exercises, case studies and delivery style to reflect your sector, systems, processes and workplace priorities.

Can you create a bespoke course from scratch?

Yes. If you require a course that is not listed on our website, we can design a bespoke training programme around your specific requirements. This is ideal for internal projects, new systems, company initiatives, role-specific development or specialist skills training.

How long are your training courses?

Course length depends on the subject, objectives and level of detail required. We can deliver bite-size sessions, half-day workshops, full-day courses, multi-day programmes or larger training projects across multiple cohorts.

Struggling find an answer to your question?

Contact Us

Ready for transformation?

Speak to one of our experts and find out how we can take your learning journey to the next level.

"*" indicates required fields