The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the tag “Data Warehouse”

Attention #DataVault fans – Check out the all new DVAUnited site

You may have missed it, but Dan Linstedt has evolved the Data Vault System from 2.0 to 2.1 (lots of new stuff in there!). Along with that, he has decommissioned the original Data Vault Alliance site and forums and replaced it with an all new, modern, home for DV 2.1 that he calls DVA United.

Why “united?” Because we finally have access to all things data vault under one roof – just one site for learning, discussing, and connecting. This gives us a central location for community driven learning and support. That includes active engagement, online discussions, and live Q&A sessions with Dan Linstedt himself.

If you are embarking on a new Data Vault 2.x project or already in the middle of one, this is the most economical way to get the coaching and mentoring you need from not only Dan, but other industry experts (like myself occasionally).

As a member (yes, there is a fee for all this goodness), you gain access to in-depth resources, expert-led discussions, and live events designed to help you master the architecture, methodology, and modeling practices that make Data Vault effective. More importantly, you’ll build confidence in your projects by applying techniques supported by a global network of professionals who have been where you are now.

If you are a recruiter or consultancy looking for highly qualified Data Vault practitioners, there is a new Talent Connect feature just for you (seperate fee applies). So why search the internet and LinkedIn, when you can go one place to find folks who are actively looking for new gigs?

For instant access to all this goodness, all you have to do is sign up for Starter Membership (which includes a 10 day trial). With that you get:

  • 1 Quarterly Q&A Webinar
  • Starter Resources
  • Podcasts
  • Tips and Tricks
  • SQL Downloads
  • Articles
  • Data Vault Discussions
  • Hot Topics
  • Fun Data Memes
  • Direct Private Messaging
  • Access to Talent Connect (to add yourself if you are on the hunt)

With the Pro Membership, you get these additional benefits:

  • Monthly Q&A Webinars
  • Quarterly Topic Webinars
  • Access to Past Q&A Webinars
  • Access to WWDVC Videos
  • BI (AI) Prompt Exchange
  • Access to Pro Resources
  • Pro-Specific Courses

If you like what you see and learn (I am sure you will), then you can sign up for either the Starter membership or the Pro membership. As a bonus, because you read my blog, you can use the code KG30YCD to get 30% your quarterly membership fee. Cancel anytime.

So, check the new site out today and take your Data Vault game to new heights.

Happy Data Vaulting!

Kent

The Data Warrior

Why Column-Aware Metadata Is Key to Automating Data Transformation

So it is 2023, and like everyone, I have a few predictions. Check out my thoughts in this post about automating data transformations using column-aware metadata and why it is critical to the success of more collaboration and data sharing..

Data, data, data. It does seem we are not only surrounded by talk about data, but by the actual data itself. We are collecting data from every nook and cranny of the universe (literally!). IoT devices in every industry; geolocation information on our phones, watches, cars, and every other mobile device; every website or app we access—all are collecting data. 

In order to derive value from this avalanche of data, we have to get more agile when it comes to preparing the data for consumption. This process is known as data transformation, and while automation in many areas of the data ecosystem has changed the data industry over the last decade, data transformations have lagged behind. 

That started to change in 2022, and in 2023 I predict we will see an accelerated adoption of platforms that enable data transformation automation. 

Read the rest of the post here – Why Column-Aware Metadata Is Key to Automating Data Transformation

May 2023 be your most agile year yet!

Kent

The Data Warrior

All new Data Vault Alliance Forums are open!

Great news for all fans and followers of #DataVault – Ask DVA forums are up and running!

You can sign up at https://forums.datavaultalliance.com (NB: No longer active, please see my more recent post on the new site.)

These all new forums are the sanctioned voice of DVA (Data Vault Alliance). That means you can expect the answers will be reviewed and in compliance with data vault standards and best practices as taught by Dan Linstedt and all the authorized DV 2.0 CDVP trainers. Hopefully this will help reduce confusion in the market and assist organizations in successfully applying the approach.

Other (important) details:

  • 100% free – to anyone and everyone
  • Anyone that has an account can: reply, or post a new topic.
  • 100% readable by guests – without ever creating an account
  • 100% moderated (by DVA for starters, by a few others that have already agreed to moderate)
  • Members can POST POLLS!!!

And better still, the forums are OPEN to both Business and Technical questions!!

You can expect answers to your toughest data vault questions through examples, best practices, and standards.

So why wait? Hop on now and take a minute to view the forums, sign up / register, and possibly ask or reply to questions.

Enjoy!

Kent

The Data Warrior

How Data Vault 2.0 Supports Your Data Governance Strategy – Part 1

Data Vault 2.0 is way more than just a data modeling approach. In fact it is an entire methodology and architecture for building business intelligence and analytic solutions. This is a post just released that I wrote for Data Rebels on how DV2 actually supports various aspects of data governance. Check it out.

With the growth of volume and diversity of data in recent years, it has become even more critical for organizations to develop an effective and scalable strategy for data governance and its closely aligned sibling discipline – Master Data Management. The importance of ensuring the security and the quality of data has never been more important than now. Add to that the increased pressures for regulatory compliance and privacy concerns, having a solid approach to data governance is no longer an option, it’s a necessity. In this 2-part blog series, I will discuss how the Data Vault 2.0 System of Business Intelligence addresses these concerns and incorporates both Data Governance and Master Data Management. 

Read the entire post here: Data Vault 2.0 and Data Governance – Part 1.

Stay tuned for Part 2!

Kent

The Data Warrior

SqlDBM – Advisor and Speaker

Just a quick note – I just found out SqlDBM has featured me on their new advisors page. Check it out.

Also wanted to remind everyone that I will be giving a webinar next week, August 17th on Data Modeling for Snowflake, Sign up here for that. It will be fun for sure.

Ciao for now!

Kent

The Data Warrior

Post Navigation