The Data Warrior

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

Archive for the tag “#datavault”

12 Jun 2013
1 Comment

Free Introduction to Data Warehousing the Data Vault Way

My good friend Dan (@dlinstedt) has put together a sweet set of three videos to introduce everyone to the wonderful world of Data Vault.

When you sign up you will get a set of email messages from Dan discussing the Data Vault Approach to data warehousing. You get access to three videos about the architecture, the methodology, and the modeling technique.

Plus you get free downloads of the first few chapters of the data vault book Super Charge Your Data Warehouse.

So if you have always wanted to learn more about Data Vault, but don’t have the budget for a full on class, this offer will get you headed in the right direction.

Head on over to the Learn Data Vault site now. It is all free.

(NB: this is an affiliate link. If you eventually buy the book or some other training off Dan’s site, I will get a small piece of the action. Not enough to retire mind you, but it might buy lunch.)

The videos are pretty cool. Enjoy.

Kent

Posted in Data Vault, Data Warehouse and tagged , , , , , , , , ,
19 May 2013

Are you certifiable?

Just a quick note to let everyone know that Dan Linstedt, (inventor of the Data Vault Model and Methodology) has announced that he will be teaching a live Data Vault 2.0 Certification Class on July 29th in St Albans, Vermont.

This class will cover all the new DV2.0 standards which incorporate big data, and NoSQL as options for implementation.

So do you have what it takes to become a Certified Data Vault Practitioner – CDVP2?

Check out these details:

Concepts that are covered include the following:

  • Implementation (ETL & SQL) best practices – structured, performance and restartability
  • Data Integration Strategies – real time, big data, and unstructured
  • Overview of Architecture – 3 tier systems architecture
  • Overview of Methodology – agile project planning & delivery
  • Overview of Data Vault Modeling – DV tables, patterns, business vault
  • Foundation of NoSQL & Big Data – where it fits, key structures, parallel loading
  • DV2.0 Methodology (Agility, Roles and Responsibilities, Architecture, CMMI Level 5)
  • DV2.0 Structure Changes
  • Managed Self Service BI
  • Loading Templates (including DV2.0 performance improvements)
  • Business Vault – introduction and overview, application & use

The new course relies heavily on the Super Charge your Data Warehouse book. Students must have completed reading the book before attending class. The class will spend minimal time covering the structural details of the Data Vault itself, and will focus more on the application of the Data Vault, the methodology (or project implementation), and the overall architecture. Including a look at managed self-service BI.

via Data Vault Certification | Class Descriptions.

Get the time, place, costs etc. on the Data Vault Certification site.

Join the elite ranks of certified Data Vault Practitioners.

Get certified!

Take care.

Kent

Posted in Data Modeling, Data Vault, Data Warehouse and tagged , , , , , , , , | Leave a comment
31 Mar 2013

Data Vault Informatica Class is Live!

Just a quick note to let you all know that Dan has finally released the class on how to easily implement a Data Vault using Informatica.

I wrote about the class here.

I have gone through a few of the lessons already and can tell you the instruction is very clear and easy to follow (even for me!) and the audio and video is excellent. The audio seems to come on a bit load so just be sure you have your volume turned down a bit when you start the videos.

And there is a money back guarantee if for some reason you decide the class is not for you.

If you did not get on Dan’s early notice list you can still sign up by going directly here: http://learndatavault.com/kentdvi

And, since you are a reader of my blog, if you sign up in the next few weeks and enter the coupon code DATAWARRIOR13, you can get $100 off !

So if you use Informatica and plan to do a Data Vault, you owe it to yourself to take a look at this course.

Take care.

Kent

Posted in Data Modeling, Data Vault, Data Warehouse and tagged , , , , , | Leave a comment
10 Mar 2013
10 Comments

Data Vault and the Oracle Reference Architecture

Thanks to Mark Rittman and Twitter, I found out just before RMOUG that Oracle had published a new reference architecture.  It used to be called the Data Warehouse Reference Architecture, now it is called the Information Management Reference Architecture.

Oracle Information Management Ref Architecture

Oracle updated the architecture to allow for unstructured and big data to fit into the picture.

In my talks about Data Vault over the last few years I have been referring to the Foundation Layer of the architecture as the place where Data Vault fits. The new version of the architecture actual fits the definition of the Data Vault even better.

Now the Foundation Layer is defined as “Immutable Enterprise Data with Full History”.

If that is not the definition of Data Vault, I don’t know what is!

Immutable – does not change. Data Vault is insert only, no update – ever.

Enterprise Data – well duh! That pretty well fits any real data warehouse architecture. The model covers an enterprise view of the data not just a departmental views (like a data mart).

Full History – tracks data changes over time. That is one of the keys to the data Vault approach. We track all the data change history in Satellites so we can always refer to a view of the data at any point in time  That allows us to build (or re-build) dependent data marts whenever we need or whenever the business changes the rules.

So it is possible to do a Data Vault approach and be compliant with Oracle’s reference architecture.

Guess Dan was just a bit ahead of the game…

Later

Kent

Posted in Data Modeling, Data Vault, Data Warehouse, Oracle and tagged , , , , , , ,
04 Mar 2013
3 Comments

How to Use Informatica to Build a Data Vault

Yes, its true – you will soon be able to get online training on how to build a Data Vault data warehouse using Informatica.

Dan Linstedt has been working hard for several months now to put together some top notch training for all you who use Informatica.

Dan will teach you all his best practices for getting the job done quickly using Informatica for your ETL tool.

If you want in, it’s not too late to get on the VIP early notification (which entitle you some discounts). Get in on the list here.

Here are a few common questions that Dan recently answered:

Q. What are the pre-requisties?
A. You must know Informatica PowerCenter and Data Vault modeling basics. The training works with Informatica PowerCenter v8.x and v9.x, but the mappings will only import to version 9.x or higher.

Q. Do I need access to an Informatica installation?
A. You will, if you want to do any of the hands on portions. We can’t help you with this. They used to provide a limited developer edition with a devnet membership, but that seems to have been discontinued.

Q. Will I learn Informatica PowerCenter?
A. No! This course assumes, you have at least 3 months experience in Informatica and know the difference between mapping, session and workflow objects. If you’ve never worked with Informatica tools, then we recommend that you DO NOT invest in it.

Q. Do I need to know Data Vault Modeling?
A. Yes, and the knowledge in the book “Super Charge your Data Warehouse” is sufficient for the course. It’s better if you have  more hands on experience though.

Q. Would it benefit me if I’ve gone through  the Data Vault Implementation and Best Practices course?
A. Yes.

Want to know more? Check out this video that has more details about the class and what it covers.

That’s it for now.

Later.

Kent

Posted in Data Vault, Data Warehouse and tagged , , , , , ,

Post Navigation

← Older Entries
Newer Entries →