powerpvt vs powerQry
Hello All,
What is the basic difference between PowerPivot and power query – I am pulling data from multiple sources (huge csv files and other formats) and then i would need to join them and then manipulating them and putting them in one sheet of excel. Which one will be better in this case? Power pivot or power query
What is the basic difference between PowerPivot and power query – I am pulling data from multiple sources (huge csv files and other formats) and then i would need to join them and then manipulating them and putting them in one sheet of excel. Which one will be better in this case? Power pivot or power query
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Power Query - Connect to every friggin' data source under the sun. Warning: The data is saved in Excel, so querying large data sets can result in large Excel files.
Power Pivot - Build a data model with above data sets, then display a UI in a cosmetically pleasing manner, to include creating calculated fields, custom values (key performance indicators) that allows users to click buttons and watch the resulting data set change.
Power Pivot - Build a data model with above data sets, then display a UI in a cosmetically pleasing manner, to include creating calculated fields, custom values (key performance indicators) that allows users to click buttons and watch the resulting data set change.
putting them in one sheet of excel
In what form? If it's not a pivot table, you're probably better off with PQ.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial