Monthly Archives: March 2018

Do You Really Need/Want All That Detailed Data In Your Power BI or Tableau Or Other DataSets?

Posted on March 26, 2018 by Biggus Dickus

Huh ? I remember some years ago standing next to an IT guy at the biggest Brewing company in Canada of the time.  He proudly showed me a new product he had created that allowed the President (down the hall) … Continue reading →

Posted in Business Intelligence, Excel, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Self-Service BI, Spreadsheets, Uncategorized, XLPublish, XLPublish.com | 1 Comment

Excel Client Is Not Going Away … Business Reporting Needs It.

Posted on March 23, 2018 by Biggus Dickus

Business Reporting For Today I am always thinking a lot about the entire Business Reporting environment.  In fact I have done this constantly now for about 40 years, actually.  While I started as a “Real” person” in a “Real” industry … Continue reading →

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

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