What will I learn?

Full Course Details

The aim of this course is to delve deeper into each of the steps necessary to create Power BI reports. We take a closer look at connecting to and tidying up your data, data modelling and design, DAX measures, filtering, report visualisations and interactivity, along with the role of workspaces and Apps in the Power BI Service and distributing reports.

On completion of this course delegates will be able to enhance their reports by combining the use of the Query Editor, DAX and using a range of report settings, filtering and formatting.

Delegates should have attended our Microsoft Power BI Foundation course or be comfortable with the Power BI Query Editor and Service screens, along with the stages necessary to create reports, from importing data to publishing.

Book Power BI Intermediate 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
MEET THE TRAINER

Paul Watson

Paul is an experienced Power BI trainer and developer with over 20 years of industry experience. He specialises in helping organisations turn data into meaningful insights through engaging, practical training.

Drawing on extensive real-world experience designing reporting, forecasting and business intelligence solutions, Paul delivers Power BI courses that focus on real business challenges and hands-on skills. His expertise, combined with his clear and approachable training style, enables delegates to confidently create reports, dashboards and data-driven solutions.

Read More

Full Microsoft Power BI Intermediate Training Course Content

Data Modelling & Further DAX

  • Import Data from OneDrive/SharePoint/Teams
  • Design Best Practices
  • Further Transformations using the Query Editor
  • Merge and Append Imported Data
  • Multiple Lines, Comments and Variables in DAX Expressions
  • More on CALCULATE
  • IF Function
  • Calendar Functions
  • Create a Measures Table

Enhanced Visualizations

  • Visual Calculations
  • Drill Down
  • Drill Through
  • Conditional Formatting
  • Dynamic Measure Formatting
  • Edit Interactive Filtering
  • Grouping
  • Hierarchies
  • Performance Considerations

Enhancing Reports

  • Custom Tooltips
  • Themes
  • Bookmarks
  • Buttons
  • Navigation Bars

Data Governance, Publishing & Sharing

  • Create Workspaces
  • Dashboards
  • Create and Share Apps
  • Collaboration
  • Permissions
  • Row-level Security
  • Integration with other tools – Excel, SharePoint, Teams and PowerPoint
Enquire & Book
Excel Training Business benefits

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

People Development

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

Excel Training Business benefits

Flexible Training Courses

  • Online or face-to-face in-house training
  • Individual delegates or group training
  • Flexible dates to fit schedules
BOOK YOUR 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 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...

I really enjoyed our Power BI training. The pace of training was excellent and we had enough time to be hands on. Complex concepts were also explained so simply, so that everyone was able to understand.

Tokio Marine Kiln Insurance Services Ltd

The trainer was excellent at explaining steps and tasks, great pace to the whole Power BI session.  The materials provided were of really high quality and will allow us to continue developing after the training session.

South Lanarkshire University Health and Social Care Partnership

Enquire About Our Power BI Intermediate Training

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