Tag Archive For "Excel 2013"
Connecting to Azure Analysis Services via Excel – Easy Mode
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 a wide-variety of users. Once you train someone how to use a pivot table, there’s no going back! In fact, …
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 often originates from users wanting to filter the results of a pivot table by a dimension attribute containing a lot …
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 well done on that front. The whole suite of “power tools” (e.g. Power Pivot, Power View, Power Query, Power Maps, Power …
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 adds to businesses currently leveraging the Microsoft BI stack. Instead, I’d like to point out the huge statement Microsoft made …