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
I'm in the middle of prepping for my two sessions at Data Modeling Zone 2025 (March 4-6, 2025). Both sessions are very tightly packed with still so much more to say. So I thought I'd write a blog on key takeaways for attendees to read prior to the sessions. One of my sessions is essentially … Continue reading Key Takeaways from My Two Upcoming DMZ 2025 Sessions
The book "Enterprise Intelligence" by Technics Publications, set to release on June 21, 2024, advocates for integrating AI with Business Intelligence to enhance enterprise performance. It emphasizes the importance of critical/creative thinking alongside AI and details a framework for Augmented Enterprise Intelligence. The book explores the merge of BI data and advanced AI to build adaptable and thriving enterprises in a rapidly evolving business landscape.
Squeezing More Value Out of SSAS It's been a bit over ten years since I began software development based on a set of ideas I eventually named Map Rock. Since it was such a big part of my life for a few years, I thought I'd commemorate its 10th anniversary with a blog. That is, … Continue reading Map Rock – 10th Anniversary and Some Data Mesh Talk
The Data Vault Methodology is a natural analytics counterpart to Domain Driven Design.
There is no excerpt because this is a protected post.
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
Prelude If businesses were people, they would lumber about in a vaguely purposeful manner like zombies. That's due to the top-down, military-style hierarchies of modern corporations that result in integration of information only at the top and only to a limited extent below. Imagine Gepetto the CEO (external puppet master) of Pinocchio. Pinocchio is managed through strings from … Continue reading The Magic of the Whole is Greater than the Sum of Its Parts
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 product. This captures a snapshot of the groups of similar customers right now, but it doesn't … Continue reading Cluster Drift
Soft Coded Logic 