Author Archives: Eugene

About Eugene

Business Intelligence and Predictive Analytics on the Microsoft BI Stack.

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. … Continue reading

Posted in BI Development | Tagged , , , , | Leave a comment

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 … Continue reading

Posted in Cutting-Edge Business Intelligence, Data Mining and Predictive Analytics | Tagged , , , | 1 Comment

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 … Continue reading

Posted in SQL Server Analysis Services | Tagged | 12 Comments

Map Rock Problem Statement – Part 5 of 5

This is Part 5 of 5, the last of the Map Rock Problem Statement series. Part 4 closed with a discussion on the limitations of logic, in particular how the quality of our decisions are limited to whatever information we have available to us. No matter … Continue reading

Posted in Map Rock | Leave a comment

Map Rock Problem Statement – Part 4 of 5

This is Part 4 of 5 of the Map Rock Problem Statement. Strategy, complexity, competition, and the limitations of logic make up the soup that lead to humans being as smart as we are the way that we are. We’ve obviously done very … Continue reading

Posted in Map Rock | Tagged , , , | Leave a comment

Polynomial Regression MDX

About a year and a half ago I posted a blog on the value of correlations and the CORRELATION MDX function titled, Find and Measure Relationships in Your OLAP Cubes. However, the CORRELATION function calculates only linear relationships, which means that … Continue reading

Posted in BI Development, SQL Server Analysis Services | Tagged , , , , , | Leave a comment