Power BI is a self-service BI tool of Microsoft, mainly based on Excel services. Power BI uses four main components, namely Power Query, PowerPivot, Power Map, and Power View (there is also a Q and A feature recently announced by Microsoft; at the time of writing this book, there is no preview version of that feature to discuss here).

Power Query is a self-service ETL tool that works with lots of data sources, even online search and Big Data; it supports a bunch of transformations. In the first section of this chapter, you learned how to work with Power Query and then with the M language, which is a Power Query formula language.

PowerPivot is a data modeling tool. In Chapter 4, ETL with Integration Services, you learned how to perform tabular modeling. PowerPivot uses the same data modeling engine with a very similar interface. So, if you want to work with PowerPivot or the DAX language, refer to Chapter 4, ETL with Integration Services. PowerPivot is embedded in Excel 2013, so you...