The Data Warrior

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

Archive for the month “March, 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

The price of success

The price of success is hard work, dedication to the job at hand, and the determination that whether we win or lose, we have applied the best of ourselves to the task at hand.

Vince Lombardi

Mindfulness, Meditation, Wellness and Their Connection to Corporate America’s Bottom Line

Saw this great article on LinkedIn last week by Arianna Huffington and just had to repost it. Health and fitness are topics I am always interested in and have written about (here, here, and here). For us to be happy and productive we all need to be at our personal best. This article discusses some recent studies and why employers should pay attention to this as well.

On Tuesday Ill be guest-hosting CNBCs Squawk Box, a program that bills itself as the show that “brings Wall Street to Main Street.” As well as discussing Cyprus and a possible euro-crisis, we are going to discuss the growing trend in corporate America of taking steps — meditation, yoga, mindfulness training — to reduce stress and improve health and creativity.

One of my guests will be Mark Bertolini, CEO of the third-largest health insurer in the country with 30,000 employees insuring 17 million people. In 2010, Aetna partnered with Duke University’s School of Medicine and found that regular yoga substantially decreased stress levels and health care costs. Following this, Bertolini made yoga available to all Aetna employees nationwide and has a much bigger mission: to make sure there is research available to facilitate private as well as state and federal coverage of yoga and mind-body therapies.

Even a quick look at whats happening in the American workplace shows that its a seriously split-screen world. On the one hand, there’s the stressful world of quarterly earnings reports, beating growth expectations, hard-charging CEOs, and focusing on the bottom line — the world that is the usual focus of CNBC and Squawk Box. On the other hand, there’s the world populated by the growing awareness of the costs of stress, not just in the health and well-being of business leaders and employees, but on the bottom line as well.

There is a growing body of scientific evidence that shows that these two worlds are, in fact, very much aligned — or at least that they can, and should, be. And that when we treat them as separate, there is a heavy price to pay — both for individuals and companies. The former in terms of health and happiness, and the latter in terms of dollars and cents. So yes, I do want to talk about maximizing profits and beating expectations — by emphasizing the notion that what’s good for us as individuals is also good for corporate Americas bottom line. To do that, I’ll be featuring guests who have had great success at bringing these two worlds together and putting what at first might seem like abstract or esoteric concepts to very productive use in the workplace.

When we separate these two worlds, the costs come in two forms. First, there are the direct costs due to stress and its associated medical conditions, and, second, there’s the cost of lost creativity and diminished performance and productivity.

According to the World Health Organization, the cost of stress to American businesses is as high as $300 billion. And unless we change course, this will only get worse. Over the last 30 years, self-reported levels of stress have increased 18 percent for women and 25 percent for men.

Check out the rest of the article here: Mindfulness, Meditation, Wellness and Their Connection to Corporate Americas Bottom Line | LinkedIn.

Take care,

Kent

Secret to success? Don’t give up!

Many of life’s failures are people who did not realize how close they were to success when they gave up.

– Thomas A Edison

Moral of the story: perseverance pays off.

Don’t give up or give in.

Follow our dream.

Stay true to your passion.

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

Post Navigation