In the previous two chapters, you saw how to hone your dataset so that you defined only the rows and columns of data that you really need. Then you learned how to cleanse and complete the data that they contain. In this chapter, you will learn how to build on these foundations to deliver data that is ready to be molded into a structured and useable data model.
The generic term for this kind of data preparation in Power BI Desktop is
data mashup
. It covers the following:
- Joining datasets (or queries, if you prefer): This involves taking two queries and linking them so that you display the ...