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

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

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

Find and Measure Relationships in Your OLAP Cubes

Huge strides in the value proposition of BI will come by jumping the chasm from simply reporting on data provided by the integrated view of our enterprise to discovering novel and perhaps counter-intuitive relationships hidden in that data. With the discovery of such relationships, we can burst outside of the box with novel strategies for growth and novel resolutions of problems. … Continue reading Find and Measure Relationships in Your OLAP Cubes

Bridging Predictive Analytics and Performance Management

Update note on June 10, 2023: This blog is very old and much has changed since 2010. Performance Point is no longer a thing, Predictive Analytics is now Machine Learning. However, the main message about the importance of the Strategy Map still stands. The notion of a Strategy Map as the primary BI object of … Continue reading Bridging Predictive Analytics and Performance Management