…brew your own Business Intelligence

Posts Tagged ‘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 […]

Read more

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 […]

Read more

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, […]

Read more

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 […]

Read more