-
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: Analysis Services
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
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
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
Here We Go … REAL JavaScript Macros For Excel ?
I have been completely open and honest (as usual) about my contempt for the useless offerings that Microsoft has tried to pass for “Automation” in Excel using JavaScript. Their concept of “Add-Ins” which do little more than allow you to … Continue reading
Posted in Analysis Services, Cloud, Excel, Office Automation, OLAP, PowerPivot, Process Automation, Spreadsheets, the Cloud, Uncategorized, VBA
7 Comments
Changes In Procurement Practices Are The Death Of Us All …
Just replied to someone on LinkedIn in a conversation about Access work getting really thin lately … Thought my response might be a good blog .. (additions in blue) .. Jeff asked …”Has the market shifted to hiring contract programmers? … Continue reading
Microsoft Excel And Azure RemoteApps … How About A Full-Featured Version Of Excel On Every Device?
I recently posted here about the opportunities for Access Developers in the Azure RemoteApps technology. I know that it will cost your clients a bit more than the free ride they have been on with Access (some of them for … Continue reading
The Microsoft Rapture
Read this link before reading my comments here: http://www.geekwire.com/2014/internal-memo-microsoft-cut-external-staff-18-months-requiring-six-month-break/ I believe that this (even more than the 18000 announced last week – most of whom are at Nokia) will force a HUGE reorg of Microsoft before the end of 2014 … Continue reading
Data Access Is STILL The Problem
Below is a replay of a posting I made here waaaay back in 2011. It discusses an issue that is not only STILL a problem for people trying to help businesses analyze their data but that is now exponentially worse … Continue reading
The Case For Hierarchies in PowerPivot
It’s interesting to me how the definition of “Business Intelligence” (BI) seems to have evolved over the last few years as the various providers of data analytical technologies try to differentiate themselves from their competition. I think some companies have … Continue reading
Dick Moffat's Spreadsheet and BI Blog 