© Adam Aspin 2016

Adam Aspin, Pro Power BI Desktop, 10.1007/978-1-4842-1805-1_5

5. Data Mashup

Adam Aspin

(1)Stoke-on-Trent, Staffordshire, UK

In the previous two chapters, you saw how to hone your dataset so that you only used the rows and columns of data that you really need and then 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:

  • Extending datasetsby adding further columns. These will nearly always be derived from existing columns of data. You could extract years or months from ...

Get Pro Power BI Desktop now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.