What will I learn?

Learn about important key principles of DAX and the filter context which under-pin the creation of more dynamic and complex reports.

Learn how to use a broad range of DAX functions and apply these to build more complex and dynamic business reports.

To attend you should have completed our Power BI Introduction and should also have a sound understanding of the data model. We recommend that you also attend the More on Data Sources, the Query Editor and Data Modelling sprint.

  • DAX
    • Understand the difference between a measure and a calculated column and when to use one over the other
    • Learn about DAX object naming & syntax
    • Why the data model is important for creating DAX formulas
    • Understand how filtering affects your DAX measures
    • Learn how to use a range of the key DAX functions to solve day-to-day reporting needs
Meet the trainer

Paul Watson

Paul brings a wealth of understanding and knowledge, specialising in technical training and development in Excel, Power BI and Access.

Paul is enthusiastic about realising what “software can do for people” and has excellent, communication, presentation and organisational skills. His knowledge with IT systems has been gained both academically and through more than 20 years practical experience in the industry. His strengths are demonstrated as both an IT trainer and as a developer – designing solutions for clients within popular commercial applications, and often training users on these applications.

As well as capabilities to advanced level in all the Microsoft Office Applications, Paul is very experienced in tailoring bespoke programming courses, for example in Excel or Power BI, to suit the needs of specific classes. Experience ranges from public scheduled courses to closed corporate training sessions for major financial institutions, digital marketing, e-commerce, social media.

Paul often works on application development projects developing essential systems in marketing, finance, forecasting and financial planning. These practical projects give Paul crucial practical experience for the training room.

Outside of work Paul likes to make best use of all the good things London has to offer – theatre, art galleries, eating out (especially), bars, clubs and the occasional visit to the opera. When he manages to escape out of London, Paul likes country/coastal walks (sounds healthy but there’s usually a pub visit along the way!)

Some of our clients

What’s Included in Our Sprints?

We pride ourselves on delivering first class training that meets your staff’s needs. Here’s what to expect:

  • Your own booking specialist to help you choose the best training for your needs.
  • A choice of online or face to face training, delivered by our friendly and highly experienced trainers.
  • Free pre-course IT skills assessments to help establish which level of training is required.
  • Lots of interaction and practical examples to keep everyone focused and to embed learning.
  • Post-training support from certificates, user guides, workbooks and a summary of the delegate feedback.

Why Choose To Learn With TrainingU?

We’ve helped hundreds of mid-level and blue chips train all their team members since 2006. Got questions? Speak to one of our team now on 0333 344 6630.

Trusted Pair of Hands

Established over a decade ago, we are a team of knowledgable training and software rollout experts.

We Love What We Do

We are passionate about delivering excellent training and software rollout support that makes a real difference to you and your teams. We strive to exceed your expectations in all that we do.

Personal & Bespoke Service

We pride ourselves on listening and offering a personal and reliable service to each and every client that we work with. We seek to build a strong and lasting relationship and to become your go-to training partner.

Experts in our Field

Our trainers are experts in their subject matter, bring a wealth of experience and have a natural ability to make everyone feel comfortable and to bring out the best in learners.

To discuss your requirements
in more detail

Get in Touch

Or call us on 0333 344 6630