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.
KPI Status Relationship Graph Revisited with LLMs
Introduction Back in 2006, I developed an ambitious idea that, though ahead of its time, now poses exciting possibilities in our data-driven era. The concept was simple yet potent: to construct a graph mapping various elements (such as database columns and parameters) used in formulas across Key Performance Indicator (KPI) statuses. The aim was to … Continue reading KPI Status Relationship Graph Revisited with LLMs
Embedding a Data Vault in a Data Mesh – Part 2 of 5 – Event Storming to Domain Model
Previously on Embedding a Data Vault in a Data Mesh ... In Part 1, I introduced the notion of using a Data Vault as a domain-spanning "data warehouse layer" in a Data Mesh. Part 1 - Introduction. Overview of the main idea of implementing a Data Vault in a Data Mesh. I also briefly discuss … Continue reading Embedding a Data Vault in a Data Mesh – Part 2 of 5 – Event Storming to Domain Model
Insight Space Graph
______ Oct 2, 2023 - Quick update since the original post date (March 21, 2022) - I wrote a newer version at my Kyvos Insights blog page. It's shorter, a little more LLM-y, Knowledge Graph-y, and focuses more on the benefits of Kyvos' Semantic Layer and the superb query performance: https://www.kyvosinsights.com/blog/knowledge-graph-bi-component-insight-space-graph/ ______ The Insight Space Graph … Continue reading Insight Space Graph
Embedding a Data Vault in a Data Mesh – Part 1 of 5
Introduction Data Mesh is one of many current buzzwordy concepts addressing what is often underwhelming perceived value from Enterprise Data Warehouse (EDW) implementations. Similar current concepts include data fabric, data virtualization, and data marketplace. None of those concepts are mutually exclusive. They all somehow facilitate mapping diverse data from across an enterprise for ready consumption … Continue reading Embedding a Data Vault in a Data Mesh – Part 1 of 5
An MDX Primer
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
Map Rock – 10th Anniversary and Some Data Mesh Talk
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 Ghost of MDX
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
Data Vault Methodology paired with Domain Driven Design
The Data Vault Methodology is a natural analytics counterpart to Domain Driven Design.
OLAP is Back as Kyvos Insights
In 2013 I wrote a blog titled, Is OLAP Terminally Ill? I used the term "Terminally Ill" because I didn't believe that the strategy of managing pre-aggregations was dead. Temporarily unnecessary, maybe, but not dead. To be clear, by "OLAP" (Online Analytical Processing), I meant in both contexts of the software named SQL Server Analysis … Continue reading OLAP is Back as Kyvos Insights
