Putting the "I" Back into BI
If your entry into the business intelligence (BI) game began after around 2010, it could be difficult to appreciate the value of OLAP cubes (referring mostly to SQL Server Analysis Services MD, ca. 1998-2010), those aggregations, and that MDX query language. In fact, you may have a negative impression of those relics, those "cubes", based … Continue reading The Ghost of OLAP Aggregations – Part 1 – Pre-Aggregation
This is a sneak peek of my upcoming book, Time Molecules: The BI Side of Process Mining and Systems Thinking—to be published in the May-June 2025 timeframe. I’ve long been fascinated by systems thinking, ever since reading The Fifth Discipline, Peter Senge, when it was first released. The idea that complex systems behave in ways … Continue reading Sneak Peek at My New Book—Time Molecules
Previously, on The Ghost of MDX ... This post is Part 2 of my prior post, The Ghost of MDX (Multi Dimensional eXpressions), where I discussed the value of pre-aggregated OLAP, such as SQL Server Analysis Services and Kyvos SmartOLAP, in the modern Cloud world. Before continuing, I need to clarify that by "SQL Server … Continue reading An MDX Primer
Practically every customer over my 20+ years working with SQL Server Analysis Services (SSAS) has told me "MDX is hard to learn". As cliche as this is to say, I think the source of difficulty is mostly that the MDX language is misunderstood. I believe that in large part, it's because SQL and MDX are … Continue reading The Ghost of MDX
Soft Coded Logic 