pivottable-wizard

Making the most out of PowerPivot and PivotTables…

Welcome to the site which tries to squeeze the max out of PivotTables, Charts and PowerPivot… basically Business Intelligence BI but on a practical scale, even if the underlying data is millions of records. In fact, that’s why PowerPivot is so useful now – because it can crunch millions of records (not just the 1 Read More

powerpivot-cube

Is PowerPivot any good?

Is PowerPivot a gimmick to sell Excel, or a serious BI tool? We were surprised to find the latter. Although PivotTables and PivotCharts have been around since before even Excel 97 days (when they became more usable), even they were neglected as too “complicated” for busy users to employ. But when they were, did they transform reporting! Read More