Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Are Power View and Power Query the same?

Are Power View and Power Query the same?

  • No it is not.

     

    Power Query is an ETL (Extract, Transform, Load) self-service tool that works like an Excel add-in.

    • It allows users to extract data from different sources, manipulate the specified data into a form that matches their needs, and load it into Excel. 

     

     

    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 View is an add-in appeared for the first time in Excel 2013 and is designed to “revitalize” your data – the construction of interactive graphs, charts, maps, and tables.

    • Sometimes it uses the terms dashboard (dashboard) or scorecard (scorecard).
    • The point is that you can insert a special sheet without cells into your Excel file – a Power View slide, where you can add text, pictures, and a lot of different types of visualizations from your data from the Power Pivot Data Model

5 Replies

  • No it is not.

     

    Power Query is an ETL (Extract, Transform, Load) self-service tool that works like an Excel add-in.

    • It allows users to extract data from different sources, manipulate the specified data into a form that matches their needs, and load it into Excel. 

     

     

    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 View is an add-in appeared for the first time in Excel 2013 and is designed to “revitalize” your data – the construction of interactive graphs, charts, maps, and tables.

    • Sometimes it uses the terms dashboard (dashboard) or scorecard (scorecard).
    • The point is that you can insert a special sheet without cells into your Excel file – a Power View slide, where you can add text, pictures, and a lot of different types of visualizations from your data from the Power Pivot Data Model