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

"It was evident that TrainingU worked tirelessly around the clock during the start of the Pandemic to convert all their training to online delivery, which we are extremely grateful for. Nothing is ever too much trouble for them and they always go over and above our expectations. We see TrainingU as our go-to for all training and we look forward to this partnership continuing for many years to come."

Pioneer DJ

"The IT courses run by TrainingU have been extremely well received by all that have attended them. The company has been supportive, flexible and attentive, going the extra mile to ensure that the courses are a success. All trainers and staff have been professional and pleasant, helping the whole process run smoothly. We are very happy with the training we have received and would not hesitate to recommend them to others."

Red Bull Technology

"We have used TrainingU on a number of occasions for various different types of training both in house and offsite.  All staff who attended have been extremely impressed with both the trainers and content.  Everyone at TrainingU have been very helpful, professional and always willing to assist in any way they can.  The trainers make learning fun and easy from the Intermediate to the Expert. I would have no hesitation in recommending TrainingU to anyone and we will continue to use them for our future training requirements"

Call Systems Technology

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.