What will I learn?

Full Course Details

The aim of this course is to provide delegates with the ability to create and manage advanced reporting features within Power BI.

On completion of this course delegates will be able to describe and apply Time Based Reporting, Time Intelligence, Metrics and Scorecards.

Delegates should have attended our Microsoft Power BI Foundation course or have equivalent experience including Power BI basics, Data Sources, Calculated Columns, Measures, Visuals and Slicers.

Book Power BI Advanced Training

For companies who need to train groups of staff either remotely or in-person.

  • One day course
  • Up to 10 delegates
  • Flexible in-house training dates
  • Face-to-face training
  • In-house or a venue of choice
  • Virtual training option
Enquire & Book
MEET THE TRAINER

Duncan Dickinson

With over two decades of experience in training and consultancy, Duncan has supported a wide range of organisations in harnessing the full potential of Microsoft 365 applications. His specialist knowledge in Power BI, alongside Power Automate, SharePoint, Power Apps, and Project Online, equips him to deliver practical insights into how these tools can drive efficiency and process improvement. Duncan’s blended approach—combining technical know-how with real-world application—offers organisations a clear, strategic perspective on how to transform their workflows using Microsoft technologies.

Read More

Full Microsoft Power BI Advanced Training Course Content

Time Based Reporting

  • Date and Time Formatting
  • Adding Time Intelligence to a Data Model
  • Creating a Date Table
  • Date Table Techniques
  • Adding Date Table to Data Model
  • Difference between Two Dates

Time Intelligence

  • YearToDate, QuarterToDate, MonthToDate
  • Ratio Over Time
  • Comparison with Previous Time Periods
  • Comparison with Parallel Period of Time
  • Rolling Aggregations over a Period of Time

Metrics

  • The Metrics Hud
  • What are Scorecards
  • What are Metrics

Scorecards

  • What is a Scorecard
  • Creating a Scorecard
  • Create a Metric
  • Create a Sub-Metric
  • Linked Metrics
  • Metric Statuses
  • Status Rules
Enquire & Book
Excel Training Business benefits

Power BI Advanced – Business Benefits

By investing in people, you can give your team all the necessary skills they need to help support your organisation’s goals.

Excel Training Business benefits

Power BI Training - People Development

Completing our Power BI training course will give you additional skills you need to help support your career development.

Excel Training Business benefits

Flexible Power BI Training Courses

  • Online or face-to-face in-house training
  • Individual delegates or group training
  • Flexible dates to fit schedules
BOOK YOUR POWER BI TRAINING

Why choose TrainingU?

Excel Training Business benefits

Passionate

Established in 2008 by a team of knowledgeable training experts, we are passionate about delivering excellent training that makes a real difference.

Excel Training Business benefits

Experienced

All our trainers are qualified and experienced Power BI trainers that will deliver the highest level of training to you and your team.

Excel Training Business benefits

Collaborative

Working together with our clients, understanding their needs and desired learning outcomes, to deliver a personalised learning solution.

Our Clients

International SOS Pioneer DJ

What Our Clients Say...

"We wanted to work with a training partner who would co-create programmes with our IT and Talent and Development teams, and then have the confidence and capability to deliver remote training across all of our global community. If you’re looking for a technology training partner, you couldn’t do any better than TrainingU. They are responsive, professional, adaptable, customer centric and very up-to-date."

International SOS

"TrainingU were very easy to book through, great at communicating and really organised. Having the pre-work to do ahead of the training was really helpful too."

Bauer Technologies Ltd

"Anritsu have worked with TrainingU for over 10 years, helping us to deliver a variety of courses to our employees across Europe. Our Employee feedback is very positive and we look forward to working with TrainingU in the future."

Anritsu Ltd

Enquire About Our Power BI Advanced Training

Simply fill out the contact form or call 0333 344 6630 to make an enquiry, book your Power BI training or assess your staff Power BI training levels.