Embracing Many-to-Many Relationships in Data Modeling: A Technical Guide PREFACE: there is another false belief out there: Many-to-many (links, pits, bridges) are bad and lead to join hell, and should never be used. WRONG…. want to know why? read on. Note: anyone who claims “LINKS ARE BAD” or “MANY-TO-MANY should never be used” needs to…
With the advent of OpenAI and ChatGPT, it is easier than ever for bad actors to add Poison Data to the public collective. Why should you care?
For those who are familiar with ‘Data Vault’ and are curious about ‘Data Mesh’, you may be asking yourself if any synergy exists between the two. I’m happy to say that there is beautiful symmetry between the two. Data Vault is a proven methodology for building an analytic solution end-to-end from the businesses’ perspective; in…
By Dan Linstedt Where Did The Agile Methodology Come From? Agile methodology and the word “agile” is thrown around boardrooms and scope documents like confetti at a child’s birthday party. Perhaps there is no adjective (or is it a proper noun?) thrown around more actively among data engineers and their managers than the term agile….
From the Desk of Dan: Understanding MetaOps MetaOps is a critical aspect of data management and analytics, especially in large organizations with complex data ecosystems. It helps organizations to better understand their data assets, reduce the risk of data breaches or errors, and improve the efficiency and effectiveness of data-related processes. MetaOps professionals are responsible…
A stored procedure to build and populate KEY_COLUMN_USAGE on Snowflake DB – because the database is currently missing this structure / view within the INFORMATION_SCHEMA.
Come TALK TO ME LIVE! Bring your questions – even if they aren’t about Agile Implementation, this is your chance to talk with me live. The Data Vault 2.0 Agile Implementation Cycle is a key piece and very often misunderstood. Using and leveraging it correctly can make or break your projects. Too many teams get stuck here or do this incorrectly, causing all sorts of issues.
By Dan Linstedt Data Vault Business Value One of my favorite topics to debate and discuss is how easy it is for business people to get access to the data they need, at a pace they need it, when we have the analytics data platform installed as a Data Vault. Naïve pundits will sometimes try…
By Mark Budzinski For an effective Data Vault 2.0 introduction, let’s start by setting some context for a complete data vault introduction. Organizations – whether they be companies, universities, government institutions, or non-profits – all share the need to better understand their operations and find ways to improve. Companies want to increase profits and market…
By Mark Budzinski The simple act of one firm buying the assets or stock of another firm is no longer a boardroom transaction hidden away from public attention. Data mergers and acquisitions are much more transparent these days. We need look no further than the play-by-play storyline reported in the popular press about the Elon…