Change Academy
Training Courses
Training Services Public Training Programme Leadership and Personal Development Systems and Office Applications Project Management
About Contact Podcast
Power BI Advanced Reporting training course hero image – Create interactive reports and advanced data visualisations.

Power BI Advanced Reporting

Expand your Power BI knowledge and take your reports to the next level.

Enquire Now

Course overview

Duration: 1 day (6.5 hours)

This course is aimed at existing users who want to expand their skills to use advanced reporting techniques and use DAX to create calculated columns and measures.

Participants should have either attended our Power BI – Introduction course or have equivalent knowledge. You should be able to import and transform data and create simple reports.

Objectives 

By the end of the course you will be able to:

  • Import and connect data tables
  • Create and use date calendars
  • Create calculated columns
  • Create and use measures
  • Use drill down and drill through
  • Create Tooltip pages
  • Add and customise slicers
  • Add action buttons
  • Streamline your report for use in the Power BI Service

Content

Review of importing and loading data
  • Importing data
  • Transforming data
  • Adding custom columns
  • Creating data models
  • Building visuals
Creating date calendars
  • Building date tables
  • Creating Financial Year information
  • Including Month and Day information
Creating calculated columns 
  • Power Query custom columns vs DAX columns
  • Creating DAX calculated columns
Creating measures
  • Implicit vs Explicit Measures
  • Building measures
  • Using DAX
  • Common DAX functions
Drill Down vs Drill Through
  • Review of drill down
  • Creating drill through pages
  • Using drill through
Creating ToolTips Pages
  • Adding pages to use for Tooltips
  • Linking ToolTip pages to visuals
Using action buttons
  • Adding images
  • Adding buttons
  • Setting actions
Working with slicers
  • Adding slicers
  • Changing slicer settings
  • Syncing slicers between pages
  • Showing what has been sliced
  • Setting slicer interactions
Techniques in the Power BI Service
  • Hiding the navigation bar
  • Stopping users manually filtering

Testimonials

“I would definitely recommend the course. It was a significant step up from the beginners course, especially with the introduction of DAX. I really enjoyed it – well paced with plenty of content, and Susan is an excellent trainer with what seems like unlimited patience! The work on DAX was particularly useful, as I’ll be doing a lot of that soon, and this gave me a solid foundation. A really enjoyable course with an excellent trainer.”

Adam Smith – Telemetry Officer, Natural Resources Wales

“Yes, I would recommend – it was very informative and interesting. The sessions were great, superbly timed, and Susan could answer anything we asked. She was extremely knowledgeable and the optional exercises were excellent for reinforcing learning. The class size was just right, making it easier to ask questions and keep things interactive. A really well-delivered course.”

Julie Rooke – Grants Officer, Natural Resources Wales

“Yes, I would recommend this course to others. It was very helpful for deepening my understanding of Power BI and its advanced features. The session was well-structured and moved at a good pace, with complex topics explained clearly and reinforced through practical exercises. I found the hands-on work and real-world examples particularly valuable. Overall, it was a highly worthwhile course that has significantly boosted my confidence in using Power BI for advanced reporting.”

Anthony Rayfield – Operational Data, MI & Insight Lead, TotalEnergies

Frequently Asked Questions

Get in Touch

Still have questions about this course?

Click Enquire Now and our team will share full details on content, dates, and pricing — and help you decide if it’s the right fit for you or your organisation.

Enquire Now

Related Courses

Power BI – Introduction

Learn how to use this powerful tool to import and clean data and create some amazing visuals.

View the course outline
Power BI - DAX Calculations and Measures

Unlock the power of DAX in Power BI to create dynamic calculations and gain deeper data insights.

View the course outline
Excel Power Query and Power Pivot

Learn how to work with and connect multiple data sets to effectively analyse and report on data.

View the course outline

Explore More Training Options

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check Public Dates

Full Training Catalogue

We deliver a wide range of training across Leadership, Personal Development, Project Management, and IT applications. Many organisations choose us because they can source both technical and people-focused training from one trusted provider.

Courses can be tailored to your organisation’s needs, making it easier to upskill teams consistently across different areas. Whether you want to build management capability, strengthen project delivery, or boost everyday software skills, you’ll find relevant options in our catalogue.

View our Leadership and Personal Development Course Catalogue
View our Systems and Office Applications Course Catalogue
View our Project Management Course Catalogue