Category Archives: Process 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

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

XLPublish Is Almost Here !

    This is a heads-up about the imminent release of the new XLPublish add-in written by myself and David Hoppe. If you go to our Website ( xlpublish.com )  there is an explanation of what this is. We will … Continue reading

Posted in Business Intelligence, Cloud, Excel, Excel 2013, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Spreadsheets, the Cloud, XLPublish, XLPublish.com | 3 Comments

How To Really Publish Excel Data To Power BI … Part Deux

A couple of weeks ago I published a length post detailing the techniques I have developed to successfully export Excel data to Power BI.  I have had some interesting responses and I have since evolved my thinking on this, and … Continue reading

Posted in Business Intelligence, Cloud, Excel, Excel 2013, Office 2013, OLAP, Power BI, Power BI Desktop, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA | 2 Comments

How To Change Data Sources Dynamically In Excel With Power Query

My Crow Eating Exercise This past week I asked on this blog whether anyone out there was using the technique I wrote about years ago for dynamically changing the Source Connections for Power Pivot Tables in Excel.  I have noticed … Continue reading

Posted in Business Intelligence, Excel, Excel 2013, Office 2013, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Process Automation, Spreadsheets, VBA | 12 Comments