Archives

  • Effectivity Sats and Second Level Stages

    Effectivity Sats and Second Level Stages

    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

    Read More >>

  • Understanding Late Arriving Data

    Understanding Late Arriving Data

    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

    Read More >>

  • Technical Tip: Clustered Hash Keys – Don’t Do it!

    Technical Tip: Clustered Hash Keys – Don’t Do it!

    This is a short tip for everyone out there implementing Data Vaults. We’ve heard throughout the years about people trying to CLUSTER the Hash Keys in Data Vault on SQLServer and other databases that support clustering.   This is a bad idea and should be avoided at all costs. What is a Clustered Key? Generally a

    Read More >>

  • Data Vault 2.0 Suggested Object Naming Conventions

    Data Vault 2.0 Suggested Object Naming Conventions

    Hello everyone,  We have a list of suggested naming conventions that are essentially best practices.  There are a few standards documented here (rules that must be adhered to), but the naming conventions themselves are best practices (suggestions for you to execute if you choose). The Data Vault 2.0 Standards for Naming Objects Objects in the

    Read More >>

  • How To:Test an Idea for Data Vault Standards

    How To:Test an Idea for Data Vault Standards

    Hi Everyone! We want to encourage you to engage in helping evolve the Data Vault Standards.  While this is not a democratic process (as we don’t believe in voting for standards), this must be an evolutionary process.  In that light, we want community suggestions.  However, the proper rigor must be applied to the new standards

    Read More >>

  • Navigating AI and Data Science with Data Vault

    Navigating AI and Data Science with Data Vault

    Navigating Your AI and Data Science Initiatives to Success with Data Vault Artificial Intelligence can be complex and difficult for businesses to adopt and implement successfully. Business leaders can be nervous about going into the breach with AI. Business executives may even float plans to implement AI while privately leaving it to the next CTO

    Read More >>

  • What is Data Fabric?

    What is Data Fabric?

    Data Fabric is one of the latest buzzwords associated with another buzzword, Digital Transformation. In this post, let’s untangle the concept of Data Fabric and unsnarl it from marketing entanglements. Then, we can look at Data Fabric in the context of Data Vault, how the approaches complement each other, and how taking a Data Vault

    Read More >>

  • Building a Snowflake Data Vault

    In this day and age, with the ever-increasing availability and volume of data from many types of sources such as IoT, mobile devices, and weblogs, there is a growing need, and yes, demand, to go from batch load processes to streaming or “real-time” (RT) loading of data. Businesses are changing at an alarming rate and

    Read More >>

  • Data Vault New Powerful Weaponry In Your Data Science Toolkit

    Data Vault New Powerful Weaponry In Your Data Science Toolkit

    Picnic is an online grocery, where we aim to bring grocery shopping and the traditional Milkman model into the 21st century. Easy and frictionless ordering, a focus on personal service, home delivery with electric vehicles, and an efficient, highly optimized just-in-time supply chain. In short, we are tech’s answer to groceries. We do not just

    Read More >>

  • 7 Reasons For Adopting Data Vault 2.0

    7 Reasons For Adopting Data Vault 2.0

    Data Vault Alliance (DVA) recently hosted a webinar where we discussed 7 Reasons For Adopting Data Vault 2.0. We invited Neil Strange, Founder and CEO of Business Thinking, to be our guest speaker and he took the time to explain why he thinks Data Vault 2.0’s time has come. Data Vault 2.0 adoption is accelerating

    Read More >>

Browse Categories