Category Archives: BI Development

Exploring a Sea of Data with Massive Numbers of RegEx – And Maybe Even the Automata Processor

Overview This blog explores taking the lid off RegEx (regular expressions) and its less powerful cousin, the LIKE keyword in SQL. By “taking the lid off”, I mean looking for more than one pattern at a time. Indeed thousands, tens of … Continue reading

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

Planning a 1-Day Symposium in Boise on the Utilization of Graph-Centric Data Technologies in Business Intelligence

Introduction I’m currently working with the organizers of the Boise BI User Group and a few heavy hitters from various Boise-based technology communities on a 1-day symposium introducing graph-based technologies to those in the Boise Business Intelligence community. (To clarify, by “graphs”, I’m referring … Continue reading

Posted in BI Development, Cutting-Edge Business Intelligence, Data Mining and Predictive Analytics | Tagged , , , | Leave a comment

Protected: Embracing Complexity – Pt 2 of 6 – Data Prep and Pattern Recognition

There is no excerpt because this is a protected post.

Posted in BI Development, Cutting-Edge Business Intelligence, Data Mining and Predictive Analytics | Tagged , , , ,

Embracing Complexity – Pt 1 of 6 – Non-Deterministic Finite Automata

Introduction to this Series “Big Data” and “Machine Learning” are two technologies/buzzwords making significant headway into the mainstream enterprise. Drawing analogies between these two technologies to those at the start of the Internet era twenty-something years ago: Big Data is analogous to a Web … Continue reading

Posted in BI Development, Cutting-Edge Business Intelligence, Map Rock | Tagged , , , , , , , , , | Leave a comment

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

Posted in BI Development, Cutting-Edge Business Intelligence, Data Mining and Predictive Analytics, Map Rock | Tagged , | Leave a comment

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

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