Power BI is certainly picking up speed, but the number 1 ad-hoc reporting client in Analysis Services environments continues to be Excel. Not much of a surprise really… Excel is a super popular tool across … Continue reading Connecting to Azure Analysis Services via Excel – Easy Mode
Filtering a Pivot Table by a Large Dimension
A common issue I see on the MSDN forums and at clients is how to reduce the number of members available in a filter to only those with data in the pivot table. This question … Continue reading Filtering a Pivot Table by a Large Dimension
Problems with the Self-Service Paradigm
There’s no denying the substantial benefits of self-service BI – arguably one of the most important paradigm shifts in the past 5 years. And I can’t help but give Microsoft the nod for a job … Continue reading Problems with the Self-Service Paradigm
Robert Frost and Pie Charts
Earlier this year, Microsoft released an incredible self-service reporting and presentation tool called Power View (with SQL Server 2012). It’s highly interactive, has excellent visualizations, and I could go on and on about the value it … Continue reading Robert Frost and Pie Charts