Squeezing More Value Out of SSAS It's been a bit over ten years since I began software development based on a set of ideas I eventually named Map Rock. Since it was such a big part of my life for a few years, I thought I'd commemorate its 10th anniversary with a blog. That is, … Continue reading Map Rock – 10th Anniversary and Some Data Mesh Talk
Practically every customer over my 20+ years working with SQL Server Analysis Services (SSAS) has told me "MDX is hard to learn". As cliche as this is to say, I think the source of difficulty is mostly that the MDX language is misunderstood. I believe that in large part, it's because SQL and MDX are … Continue reading The Ghost of MDX
The Data Vault Methodology is a natural analytics counterpart to Domain Driven Design.
In 2013 I wrote a blog titled, Is OLAP Terminally Ill? I used the term "Terminally Ill" because I didn't believe that the strategy of managing pre-aggregations was dead. Temporarily unnecessary, maybe, but not dead. To be clear, by "OLAP" (Online Analytical Processing), I meant in both contexts of the software named SQL Server Analysis … Continue reading OLAP is Back as Kyvos Insights