Discover the transformative power of mastering conceptual models. Elevate your business strategy and seamlessly integrate IT solutions with our cutting-edge insights on extended ontologies.
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.
“Science can amuse and fascinate us all, but it is engineering that changes the world.” —Isaac Asimov You’re already aware about the Data Vault 2.0 System of Analytics having 3 core pillars which are the Model, the Methodology and the Architecture. Methodology also includes the sub-pillar of implementation. And, it has data engineering baked in.
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
Hi Everyone, Recently I heard about the CDVP2 hands-on materials, and the CDVP2 materials were not representing normalization or denormalization in the right light. I wanted to take a minute to refresh the understanding of what these things truly are, and how they are defined to be. We do use / apply the terms properly,
This week I bring you a few definitions, and some interesting questions and answers that I’ve had over the years. We teach these concepts in our CDVP2 class, but probably not to this level of detail. EFFECTIVITY SATELLITE Effectivity Satellite = is a Satellite structure containing “begin and end dates” or multiple instances of begin
Call it back-dated data, call it real-time feeds, call it old data arriving late, call it what you will. The problem has persisted since day 1 of systems creating, feeding, and sharing data. But the problem is deeper than just systems. The problem lives on whenever business users can and must back-date data. What does
Thanks for reading. Subscribe to get the latest blogs, podcasts and notifications.
Discover the transformative power of mastering conceptual models. Elevate your business strategy and seamlessly integrate IT solutions with our cutting-edge insights on extended ontologies.
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.
“Science can amuse and fascinate us all, but it is engineering that changes the world.” —Isaac Asimov You’re already aware about the Data Vault 2.0 System of Analytics having 3 core pillars which are the Model, the Methodology and the Architecture. Methodology also includes the sub-pillar of implementation. And, it has data engineering baked in….
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…
Hi Everyone, Recently I heard about the CDVP2 hands-on materials, and the CDVP2 materials were not representing normalization or denormalization in the right light. I wanted to take a minute to refresh the understanding of what these things truly are, and how they are defined to be. We do use / apply the terms properly,…
This week I bring you a few definitions, and some interesting questions and answers that I’ve had over the years. We teach these concepts in our CDVP2 class, but probably not to this level of detail. EFFECTIVITY SATELLITE Effectivity Satellite = is a Satellite structure containing “begin and end dates” or multiple instances of begin…
Call it back-dated data, call it real-time feeds, call it old data arriving late, call it what you will. The problem has persisted since day 1 of systems creating, feeding, and sharing data. But the problem is deeper than just systems. The problem lives on whenever business users can and must back-date data. What does…