Category Archives: Uncategorized

Our “Dog-Eat-Dog” IT World Is A Very Real And Destructive Path With No Good End

This was just posted on LinkedIn … I was struck by the sentiment of this guy and although I feel sorry for him it might make him feel better if you knows that he’s far from alone… Not that there … Continue reading

Posted in Uncategorized | 1 Comment

‘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

How To Really Publish Excel Data To Power BI … Part Deux (amended again)

It has been brought to my attention that  the formatting I chose for my Blog post on this makes for a difficult to copy and paste the code I listed into an Excel module without significant effort (like fixing doub;t-quotes, … Continue reading

Posted in Business Intelligence, Cloud, Excel, Office 2013, Power BI, Power BI Desktop, PowerPivot, Spreadsheets, the Cloud, Uncategorized, VBA | 8 Comments

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

OK .. Let’s go … Part III … !! In this post I will try to explain how (and especially how not) to get your Excel data into Power BI Desktop in a way that will allow you to schedule refreshes … Continue reading

Posted in Analysis Services, Business Intelligence, Cloud, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, the Cloud, Uncategorized, VBA | Tagged , | 4 Comments