cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DataWiz01
Advocate II
Advocate II

Are Power View and Power Query the same?

Are Power View and Power Query the same?

5 ACCEPTED SOLUTIONS
Sahir_Maharaj
Community Champion
Community Champion

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. 

 

1-1.png

 

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

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


View solution in original post

Sahir_Maharaj
Community Champion
Community Champion

Hope this helps you 🙂

 


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


View solution in original post

Sahir_Maharaj
Community Champion
Community Champion

Power Query, Power BI, and Power Pivot demystified: https://www.youtube.com/watch?v=TNtn-eYpNmQ


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


View solution in original post

Sahir_Maharaj
Community Champion
Community Champion

PowerBI Family: Power Pivot, Power Query, Power View Demo: https://www.youtube.com/watch?v=clIjG9q3iTk


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


View solution in original post

Sahir_Maharaj
Community Champion
Community Champion

Power BI, Using Power Query and Power View: https://www.youtube.com/watch?v=wNWA7HyE_Ic


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


View solution in original post

5 REPLIES 5
Sahir_Maharaj
Community Champion
Community Champion

Power BI, Using Power Query and Power View: https://www.youtube.com/watch?v=wNWA7HyE_Ic


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


Sahir_Maharaj
Community Champion
Community Champion

PowerBI Family: Power Pivot, Power Query, Power View Demo: https://www.youtube.com/watch?v=clIjG9q3iTk


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


Sahir_Maharaj
Community Champion
Community Champion

Power Query, Power BI, and Power Pivot demystified: https://www.youtube.com/watch?v=TNtn-eYpNmQ


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


Sahir_Maharaj
Community Champion
Community Champion

Hope this helps you 🙂

 


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


Sahir_Maharaj
Community Champion
Community Champion

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. 

 

1-1.png

 

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

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj

Data Scientist | Data Engineer | Data Analyst | AI Engineer

➤ Website: https://sahirmaharaj.com

➤ Email: sahir@sahirmaharaj.com

➤ Lets connect on LinkedIn: Join my network of 10K+ professionals

➤ Want me to build your Power BI solution? Lets chat about how I can assist!

➤ Join my Medium community of 30k readers! Sharing my knowledge about data science and artificial intelligence


Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors