PBILAS Logo 2h
The future of Live Interactive Learning: ½ day sessions using Zoom - with the topics you need - just when you need them.
We NEVER cancel a course - even if there's only one attendee!
No scheduled course when you want it? Easy - just schedule one on the dates you prefer!
Maximum class size of 6   +   Short ½ day sessions   =   Better learning outcomes + Less time away from work.
Independent instructors with lower overheads = Better value for money options.
Cancel or reschedule up to 24 hour in advance + Money back guarantee = NO RISK! 
Free and indefinite post-course support from your instructor = We care about and support your learning journey all the way.

Multi-source Data Modelling

Learn how to add a second data source to your Analysis Model and create reports across different software systems.

In this course you will learn:

  • The core Data Modelling best practices when working with the VertiPaq engine.
  • How to perform more advanced column transformations.
  • How to add more advanced calculated columns.
  • The difference between duplicating and referencing queries.
  • How to perform more table transformations: pivot, unpivot and group.
  • How to perform normalisation using Power Query, and why you might need this.
  • How to add a new data source to your model.
  • Working with a new data source at a different level of granularity.
  • Proper use of bi-directional propagation filtering.
  • Basic M formulas and functions.
  • Creating a Date table using M.

Current Scheduled Courses

Click Book New to schedule a course on your preferred dates.
Seats: 6
Book New

Pre-course Requirements

Required knowledge. Before attending this course you must have met the following pre-requisites:

  1. Completion of the Power BI: Kickstarter (Level 1) course AND have some practice using Power Query for basic transformations.
  2. An understanding what a Relational Database is, why they are used, and how a one-to-many relationship works. You can watch this video to refresh your knowledge: Coming Soon.

Useful knowledge. The following skills and knowledge might be useful, but are not essential to have. We cover these topics in the course, but knowing a little about these topics may give you a head start.

  • Some knowledge of Microsoft Excel Formulas and Functions.

Pre-course learning topics. There are some pre-course learning topics to complete in the form of videos with cheat sheets. These are important to watch as they are assumed knowledge for the course and are only covered in revision in the sessions. These will be sent out to the participants after the booking is complete.

Pre-course Setup Checklist. There is a pre-course setup checklist which you must complete before your first session to ensure you have the correct software and hardware installed and configured before you can attend the course. This will also be sent out to the participants after the booking is complete.

Training Resources

The following resources are provided as part of this course:

  • Cheat sheets. Core concepts and some 'how to' guides are provided in cheat sheets to help apply the knowledge and skills back in the workplace.
  • Exercise files. Class exercise files and data sources are provided, which are used during the sessions and which can also be used for further practice after the sessions.
  • PowerPoint Slides. A copy of the PowerPoint slides used throughout the course will be provided so that participants do not need to try and copy slides, or write extensive notes throughout the course.

A link to download the training resources in 'zip file' format will be sent out to students after booking for the course. These files will need to be extracted prior to the first session.

What's next?

The following course follows on from this course and will round out your Data Modelling and Power Query knowledge and skills:

The following courses can also be completed following this course and provide more skills and knowledge in creating DAX Measures and Report Design:

For the full Power BI course offerings and pathways click here.

Course Categories

Product: Microsoft Power BI
Category: Data Modelling
Level: L2 Intermediate

Duration, Participants & Price

Duration: 2 x 3 hour sessions.
Class size: Maximum of 6 participants.

Pricing: is shown below and depends on the number of participants booked.