Map Rock – 10th Anniversary and Some Data Mesh Talk

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

OLAP is Back as Kyvos Insights

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

Levels of Pain – Refining the “Bad” side of the KPI Status

Everything we do towards achieving goals involves costs - sacrifice, investment (a positive way to look at it). We purposefully put things we already have (time, money, our career) to be consumed or at risk in the hope of achieving a goal. For the sake of this short blog, I'll call that investment "pain". I present this blog … Continue reading Levels of Pain – Refining the “Bad” side of the KPI Status

The Magic of the Whole is Greater than the Sum of Its Parts

Prelude If businesses were people, they would lumber about in a vaguely purposeful manner like zombies. That's due to the top-down, military-style hierarchies of modern corporations that result in integration of information only at the top and only to a limited extent below. Imagine Gepetto the CEO (external puppet master) of Pinocchio. Pinocchio is managed through strings from … Continue reading The Magic of the Whole is Greater than the Sum of Its Parts

The Effect Correlation Score for KPIs

Introduction Everything we do is intended to move us towards achieving some set of goals ranging from just satisfying our immediate hunger to achieving a revolution. These actions are executed within a strategy (or hierarchies of strategies) to varying extents of sensibility and organization. Presumably the effectiveness of our efforts towards those goals and the rhyme and reason behind … Continue reading The Effect Correlation Score for KPIs

Cluster Drift

A deficiency I notice in practically every implementation of clustering (segmentation) is the snapshot mentality. For example, a vendor of a product would segment their customers in an attempt to isolate the ones who would be most likely to buy their product. This captures a snapshot of the groups of similar customers right now, but it doesn't … Continue reading Cluster Drift

Is OLAP Terminally Ill?

Someone told me yesterday that "OLAP is dead". "Everyone is choosing tabular/in-memory." I know it's not dead, maybe at least sick. But did I underestimate the time of the tipping point, the curve in the hockey stick, where the vast majority of users will "sensibly choose" the tabular/in-memory option over OLAP? I realize some, including me, think this … Continue reading Is OLAP Terminally Ill?

Thoughts Around “Aggregate Fact Tables”

I’ve encountered many situations where some set of complications in a cube model were eased by using an aggregation table derived from some base fact table as the fact table. The complications leading to that choice usually include expensive on-the-fly calculations, distinct count measures, or even many to many relationships. The main idea is that … Continue reading Thoughts Around “Aggregate Fact Tables”