Putting the "I" Back into BI
The phrase “thinking outside the box” traces back to a deceptively simple puzzle: nine dots arranged in a 3×3 grid. The challenge is to draw four straight lines through all the dots without lifting your pencil. Most people fail at first because they instinctively keep their lines inside the square boundary implied by the dots. … Continue reading Outside of the Box AI Reasoning with SVMs
Long ago when scaling database capacity wasn't as easy as upping (or downing) configuration settings through a user-friendly admin Web page (like the "T-shirt size" with Snowflake), highly-skilled DBAs were a luxury at smaller enterprises, and people at work used to go to Happy Hour in droves, a funny thing might happen at pau hana … Continue reading Correlation is a Hint Towards Causation
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
Soft Coded Logic 