Power Pivot is an in-memory data modeling component that provides highly compressed data storage and extremely fast aggregation and calculation. It is also available as part of Excel and can be used to create a data model in an Excel workbook. Power Pivot can load data by itself or can load data into Power Query. It is very similar to the SSAS (SQL Server Analysis Services) tabular model, which is similar to the server version of Power Pivot.Power View is an interactive visualization tool that provides users with a drag and drop interface that allows them to quickly and easily create data visualization in their Excel workbooks (using the Power Pivot data model).Power Pivot is also an add-in for Microsoft Excel but intended a bit for other tasks. If Power Query is focused on importing and processing, then Power Pivot is needed mainly for complex analysis of large amounts of data. In the first approximation, you can think of the Power Pivot as pumped pivot tables.The general principles for working in Power Pivot are as follows:First, you load data into Power Pivot — 15 different sources are supported: common databases (SQL, Oracle, Access …), Excel files, text files, data feeds. Besides, you can use Power Query as a data source, which makes analysis almost omnivorous. The links are configured between the loaded tables or, as they say, the Data Model is created. This will allow in the future to build reports on any fields from the existing tables as if it was a single table. If necessary, additional calculations are added to the Data Model with the help of calculated columns (an analog of a column with formulas in a smart table) and measures (an analog of a calculated field in summary). All this is written in a special internal Power Pivot language called DAX (Data Analysis eXpressions). The reports of interest to us in the form of pivot tables and charts are built on the Excel sheet of the Data Model. Power Pivot has several features that make it a unique tool for some tasks:In Power Pivot, there is no limit on the number of lines (as in Excel). You can load tables of any size and work with them calmly. Power Pivot is very good at compressing data when loading it into the Model. A 50 MB source text file can easily turn into 3-5 MB after downloading.