Category Archives: Office Automation

‘Real-Enough-Time’ Data

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?

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.

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

  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 !

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

New Feature In XLPublish – Multi Workspace Publish

While XLPublish is already a complete and mature piece of tech at this point, we have added one new feature that you might find useful,  Multi-Workspace Publishing With the introduction of App Workspaces in Power BI (a great way to … Continue reading

Posted in Business Intelligence, Excel, Office Automation, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, XLPublish, XLPublish.com | Leave a comment

Modeloff GTC in New York City – Dec 4-5, 2017

Just a note that I will be in New York on Monday and Tuesday Dec 4 & 5 exhibiting and presenting at: Modeloff GTC New York I will be showing the latest iteration of the XLPublish add-in on exhibit with … Continue reading

Posted in Business Intelligence, Excel, Excel 2013, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, VBA, XLPublish, XLPublish.com | Leave a comment