Summary
In this chapter, you learned about the workflow of the steps that need to be carried out to implement a Power BI report. During its course, you will wear multiple hats: that of a developer and that of a data analyst.
You start by determining where to obtain your data from and look at the right methodology for connecting to and extracting data. You may not have the experience of connecting to every source supported by Power BI. It is not a realistic expectation. However, as a developer, some due diligence is encouraged to conduct research on the probable source systems that the organization uses and be prepared with overall knowledge about connecting to those systems.
You then embark on a journey of cleansing, transforming, and combining the data into an analytical shape. Power Query has many functionalities for this purpose, meaning that you rarely must clean data at the source before bringing them into Power BI. You learned that this is not done ad hoc but that there...