©  Adam Aspin 2020
A. AspinPro Power BI Desktophttps://doi.org/10.1007/978-1-4842-5763-0_9

9. Restructuring Data

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

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 usable data model.

The generic term for this kind of data preparation in Power BI Desktop is restructuring data. It covers the following:
  • Joining queries: This involves taking two queries and linking them so that you display the data from both sources ...

Get Pro Power BI Desktop: Self-Service Analytics and Data Visualization for the Power User 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.