Power BI Data Modelling

Power BI Data Modelling is a one-day Power BI training course suitable for those needing to learn how to design best-practice Power BI data models.

Please review the Course Outline below to ensure this Power BI Data Modelling training course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

• Overview & Rationale for data modelling in Power BI
• Illustrating the problems encountered with a poor Power BI data model
  • Poor performance
  • Cryptic organisation
  • Lack of flexibility
  • Many to many relationships
  • Bi-directional filters
• Basic dimensional modelling theory as applicable for Power BI
• Exercise to redesign the poor example Power BI data model
• Revisit exercises that illustrated the problems with a poor Power BI data model compared with a pre-prepared best practice Power BI data model

Please review the Course Prerequisites below to ensure this Power BI Modelling training course is right for you. Please contact us if you’re not sure and we’ll be happy to advise you.

• Have the latest version of Power BI Desktop installed.
• Have a base level of Power BI skills equivalent to having attended the Power BI Dashboard in a Day course.
• Have a basic understanding of Power BI reporting concepts such as tables, columns, rows, data types and how tables can be related.
• This course is appropriate for those involved in building or using data models in Power BI.

Private training

• Please contact your local regional office for pricing for private training.
• Private Data Modelling training delivered in the UK, remotely or at your offices.
• 1-day course that can also be delivered as 2 x consecutive half-days.
• Capped at 15 attendees to ensure maximum personal attention.
• Training can be customised to suit your needs.
• We can also provide follow-on consulting to help students develop their first best-practice Power BI reports/dashboards. This can be an effective way to help students successfully transition from the classroom to the real world.

Public training (schedule at bottom of page)

• £400 per person ex. VAT.
• 20% discount when you book 3 or more people on the same course.
• 20% discount when an individual enrols in 3 or more courses.

Based in London, we provide best practice Power BI training courses.

• “Excellent presentation skills and domain knowledge, easy to follow (with some prior knowledge of terminology from Data modelling), Roger was fantastic when answering on-the-spot questions, very insightful and packed with information”
• “Great training session, can recommend!”
• ”Being able to easily follow and create the model in Power BI itself. Everything was clear to follow and well explained”
• “The pacing of the course was good and it was really useful to see the information that was shared in context through the example data.”
• “The instructor was very clear and helpful and happy to explain any queries we had. The course was inclusive even though the group was of differing levels and backgrounds.”
• “Having Ian demonstrate all the work and show us best tips and practices which were then followed up by the practical examples, it was great to cement the knowledge.”
• “Ian’s passion for Power BI shines through every time, and helps to make all the students engaged and excited to be a part of the day.”

We recommend students next attend Power BI Data Wrangling where you will learn how to build best-practice Power BI data models.