Difference between PowerPivot, PowerQuery and PowerBI

Question

What is the difference between PowerPivot, PowerQuery and PowerBI? How should one decided which tool should be used and when.

Answer 1

Power Query and Power Pivot are components of Power BI

Power Query: It is a data connection technology that enables us to connect, combine and refine data sources for analysis. These features are also available in Power Bi Desktop and Excel

Power Pivot: It is a memory data modeling component that allows highly-compressed data storage and extremely fast aggregation and calculation. These features are also available in Excel. It can load data itself or can have data loaded into it by Power Query.

Power Bi: It is a cloud-based business analytics service for analyzing and visualizing data. Various processes in Power BI are as follows:

Connecting to our data, Shaping of data, Modeling of data, Data visualization, Publishing data reports