So, you want to start using Power BI. You have a couple of data sources that you want to bring in. How do you go about bringing in this data? How do you build a data model out of this data?

This can be a daunting task and one we will tackle from the beginning. First, we will look at using Power Query to bring in the data. Then we will examine how to best create the data model.

We will cover some of the best practices when developing the data model so that it scales well. One of the benefits of having a well-designed model is the DAX code can be easier to understand.