Category Archives: PowerPivot

‘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 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

XLPublish Is Here !!!

Today Personal Logic Associates Inc. is proud to ship XLPublish – our new Add-in for Excel that makes publishing your Excel data in Power BI Easy, Reliable and Repeatable. With XLPublish you can make your current Excel Ranges, Tables, Pivot … Continue reading

Posted in Business Intelligence, Excel, Excel 2013, Microsoft Excel 2013, Office 2013, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, PowerPivot, Spreadsheets, XLPublish, XLPublish.com | 1 Comment