Re:The pivot table, the spreadsheet's most powerful tool (2020)
by breadwinner on Monday October 09, 2023 @09:55PM
(#37827752)
Where does Power Pivot fit into all this? The word "Pivot" in the name seems to indicate that it has Pivot Table-like functionality.
[ Parent
| on HN ]
Re:The pivot table, the spreadsheet's most powerful tool (2020)
by kyllo on Tuesday October 10, 2023 @12:44AM
(#37828578)
Power Pivot is the name for the tabular data modeling feature in Excel. It works similarly to Power BI or SQL Server Analysis Services, sharing the underlying database technology. You can load data from queries and files, transform it, add relationships, hierarchies, and calculated measures, and connect pivot tables to it.