Category: BI Development

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 Effect Correlation Score for KPIs

This content discusses the importance of aligning enterprise efforts with goals through proper performance management and strategies. It introduces the concept of an "Effect Correlation Score" (ECS) to validate the validity of efforts and KPI statuses in a constantly changing, competitive world. The ECS measures the correlation between a cause and its intended effect and is a crucial aspect of Performance Management planning. It warns against blindly pursuing good KPI statuses without considering ongoing changes and correlations, and highlights the complex nature of cause-and-effect relationships within strategies. The post proposes the implementation of ECS in Performance Management to validate relationships and ensure their continued relevance.

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” →

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 →