Category Archives: Self-Service BI

‘Real-Enough-Time’ Data

Posted on April 2, 2018 by Biggus Dickus

I see and hear a whole lot of noise and effort around the acquisition of “Real-Time” data in their Power BI Reports and Dashboards. I argue here that most times this is simply not necessary nor preferred and that it … Continue reading →

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

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

Self-Service BI Anyone? Your Excel Models with XLPublish and Power BI Offer You That Today !

Posted on February 4, 2018 by Biggus Dickus

Brutal Editorial Honesty: This post is intended to convince you to try the XLPublish Add-In for Excel in your work and in your organization. Please read on … Pre-Apology: Here we go … a loong posting that is effectively a … Continue reading →

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