-
Archives
- April 2018
- March 2018
- February 2018
- January 2018
- November 2017
- September 2017
- June 2017
- November 2016
- October 2016
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- September 2015
- July 2015
- June 2015
- May 2015
- April 2015
- February 2015
- August 2014
- July 2014
- May 2014
- April 2014
- February 2014
- January 2014
- December 2013
- October 2013
- September 2013
- August 2013
- October 2012
- December 2011
- October 2011
- September 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
-
Meta
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
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
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
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
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
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
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
How To Change Connection Type In Power Pivot
Every day, day in and day out, the most popular posting I have here is this one: How You Can Change To Another Connection Type In PowerPivot and this one: Building a Flexible and Efficient Client-Side PowerPivot Solution in Excel 2013 I … Continue reading
Is Power BI For Real ?
Thought of the day … I have been messing around with Power BI for a while now and while it “looks” great and does “good demo” I’m finding it almost impossible to build anything that I can rely on .. … Continue reading
Dick Moffat's Spreadsheet and BI Blog 