Category Archives: Hierarchies

Excel Pivot Tables or Power BI Matrix ? – Use Both With XLPublish

Posted on March 6, 2018 by Biggus Dickus

  Let’s start by just looking at these two “Tables”: Excel Pivot Table: Power BI Matrix Visualization   The Same? Look pretty much the same, eh? Well to the Viewer they are, but for the person distributing this report there … Continue reading →

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Hierarchies, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Self-Service BI, Spreadsheets, the Cloud, Uncategorized, VBA, XLPublish, XLPublish.com | Leave a comment

The Case For Hierarchies in PowerPivot

Posted on October 8, 2013 by Biggus Dickus

It’s interesting to me how the definition of “Business Intelligence” (BI) seems to have evolved over the last few years as the various providers of data analytical technologies try to differentiate themselves from their competition. I think some companies have … Continue reading →

Posted in Analysis Services, Business Intelligence, Excel, Excel 2013, Hierarchies, Microsoft Excel 2013, OLAP, PowerPivot, Snowflake Schema, Spreadsheets, Star Schema | 1 Comment