…brew your own Business Intelligence

Blog

Load Testing SSAS with PowerShell

Load testing an SSAS database is one of those tasks that everyone should be doing but very VERY few people actually do… and I can only suspect the reason is because it’s hard. Here are the general steps involved: Capture the query workload using an xEvents (basic example, autorestart option) Shred the xEvents […]

Read more

Analysis Services Extended Events – AutoRestart Option

The MSDN documentation and SSMS support for Analysis Services xEvents is severely lacking when compared to the database engine. In fact there wasn’t even a GUI for SSAS xEvents until SQL 2016… which meant anyone who wanted to create an xEvents trace had to craft another cryptic XMLA command. To […]

Read more

Agile Fail: Funny User Story Edition

If you’ve ever worked on an “Agile” project, chances are you’ve come across some hilariously written user stories…perhaps even some that were so ridiculous you started questioning the string of choices and decisions you’d made that ultimately led you to being involved with this project in the first place. Don’t be afraid and don’t […]

Read more

Engaging the Formula Engine Cache with SSAS Tabular

One of the more subtle architectural differences between tabular and multidimensional instances is caching. Multidimensional is a disk-based technology and performance for query workloads (in many cases) depends heavily on cache utilization. Tabular, on the other hand, is a memory-based technology with (nearly) zero dependence on disk IO and is therefore much less […]

Read more

Atlanta Modern Excel User Group

Recently, I was approached by a colleague, Damu Venkatesan (@vdamu), to help manage a new user group: Atlanta Modern Excel User Group. I told him I was flattered but not quite sure how I could contribute other than helping out with the basic administrative responsibilities as I don’t consider myself […]

Read more

PASS Summit 2016 – I’m Speaking!

Totally stoked (and honored) to have one of my sessions selected for the world’s largest gathering of SQL Server and BI professionals!!! This year, on the advice of fellow BI consultant and SSAS-geek Thomas LeBlanc, I decided to mix things up and submit a variety of session types ranging from the standard 75 minute session all […]

Read more

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