So far, we have learned about the basics of the Power BI interface. However, to truly unlock the power of Power BI, we need to expand our data model. In order to do that, we need to learn about the query editor and how to relate multiple tables of data to one another and create a more complex data model. Every good visual report starts with a good data model, so it is imperative that we learn how to properly ingest, transform, and load our data into Power BI.

The following topics will be covered in this chapter:

• Getting data
• Transforming data
• Merging, copying, and appending queries
• Verifying and loading data