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 were delighted to work with TrainingU during our UK Learning Month. Their ability to offer short, snappy training sessions that were valuable and enjoyable was something we appreciated. The Sprint sessions are a great way to develop skills without being away from your day-to-day work for too long."

Epson EMEA

"Training U have delivered a great customised learning experience for our Finance Graduate and School Leaver population, noted by the copious amount of great feedback I get from the cohort thanking us for putting the training plan in place.  It is extremely important to us that our high potential learners obtain the soft skills vital to their future careers, preparing them for Management positions once they leave the Early Careers Finance Scheme.  I find Training U very easy to deal with, they always keep me informed on progress and feedback, and I would definitely recommend them to other organisations."

Whitbread PLC

"The training provided was pitched just right for our requirements. We look forward to further sessions on different topics and hopefully, budgets allowing, refresher sessions as the software continually evolves to meet customers’ needs. TrainingU bent over backwards to accommodate our requests; the professionalism and expertise of the tutor was amazing, making the sessions enjoyable and easy to follow. We will continue to use TrainingU for future training requirements."

NHS Blood and Transplant

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.