Summary
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 ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide 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.
