…brew your own Business Intelligence

Blog

Tell Me About Your SSAS Environment: Results

This post is a follow up to the survey I created back in late March. Thank you to all of the participants who took the time to fill out they survey – your input is greatly appreciated! Instead of digging into the data and spoon feeding you the results, I’ve […]

Read more

Strategic Prototyping: Power BI Desktop vs Power Pivot

Perhaps one of the most important lessons I’ve learned over the years is that there’s no right-way / one-size-fits-all approach to implementing an Analysis Services solution. All have their pros and cons and being successful is more about leveraging the approach that best fits the client organization. That said, one […]

Read more

Implementing Logical AND on Members From Same Hierarchy

The default behavior when filtering on multiple members from the same attribute hierarchy is a logical OR. In the pivot table above, we have the [Internet Customer Count] measure (which is a distinct count measure) sliced by Product Subcategory and filtered for [Mountain Bikes] and [Tires and Tubes]. This shows […]

Read more

Adding Descriptions for Perspectives in Tabular

Perspectives are great way to improve the experience for users as well as developers. However, there’s a point where having too many perspectives can become a bit confusing for the typical end user. How do they determine which perspective to connect to for their self-service analysis? One option – that I’m a […]

Read more

Tell Me About Your SSAS Environment

As part of an ongoing effort to understand my audience as well as the greater Analysis Services community as a whole, I’ve put together a basic survey and would greatly appreciate you input: Start Survey Results will be compiled and shared on this blog by the end of April are ready: HERE

Read more

Boosting Developer Experience with Analysis Services Perspectives

Perspectives are typically used to simplify and improve the user experience, but a lesser known fact is that they can also simplify/improve the developer experience. Problem Developing tabular models that contain a lot of tables can be a real nightmare. In most enterprise solutions based on a dimensional model, it […]

Read more

Analysis Services Class Libraries

References to these libraries are required when writing .NET applications that interface with Analysis Services. However, as I’m not a serious .NET developer (thank god! /jk /sortof) I don’t use them that much. But when I do, I usually waste the first 10 minutes searching for it in windows explorer before giving up and […]

Read more

Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet

Welcome back! This is the 4th post in a series of posts focusing on performance monitoring for Analysis Services. Performance Monitoring for SSAS – Intro Performance Monitoring for SSAS – Data Collection Performance Monitoring for SSAS – Extended Events Cheat Sheet Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet […]

Read more

Performance Monitoring for SSAS – Extended Events Cheat Sheet

Welcome back! This is the 3rd post in a series of posts focusing on performance monitoring for Analysis Services. Performance Monitoring for SSAS – Intro Performance Monitoring for SSAS – Data Collection Performance Monitoring for SSAS – Extended Events Cheat Sheet Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet […]

Read more

Ever wondered what’s captured in the SSAS Flight Recorder?

During a recent engagement involving an Analysis Services health assessment, one of the things I noted was that the Flight Recorder was enabled. During the post-assessment review with the client, where we walked through the report and recommendations, I quickly explained what the Flight Recorder was, why it should be […]

Read more