The Data Warrior

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

Archive for the category “Data Vault”

KScope13 Day Two: Wine to Water and Other Transformations

So day two in New Orleans at the ODTUG KScope13 event was another big day.

I am gong to start out at the end of the day with the General Session update so if you don’t have time to read the whole post you can read the really important and interesting stuff first.

General Session and Keynote

First the fun part, we got greeted by a live New Orleans Jazz band.

We had a live band in the lobby to great attendees before the general session and keynote.

We had a live band in the lobby to greet attendees before the general session and keynote.

That was great fun. They then led us all into the grand ballroom for the general session and then went out and led in our board of directors and the conference committee all dancing up a storm in true NOLA fashion.

The general session gets opened with the board and conference committee being lead on stage marching/dancing behind a live New Orleans Marching Jazz Band

The general session gets opened with the board and conference committee being led on stage marching/dancing behind a live New Orleans Marching Jazz Band

ODTUG Announcements and Award Winners

Every year ODTUG gives out a number of awards so I want to recognize the winners here:

Editors Choice Award for Best White Paper went to David Schleis.

The Oracle Contributor of the Year (which goes to an Oracle Corp employee) went to my good buddy, Jeff Smith.

The ODTUG Volunteer Award went to Mack McCasland who has been working behind the scenes at our events for over 10 years (and he is retired!),

In addition to these awards, Oracle also announced the promotion of my good friend John King to the status of Oracle ACE Director.

The big announcement: KScope14 will be in Seattle, Washington, USA on June 22-26, 2014. The conference hotel will be the Sheraton in downtown Seattle.

Wine to Water

The big deal for the night was our keynote speaker, Doc Hendley. He is a bartender who decided he wanted to make a much bigger impact on the world and ended up founding an organization that now brings clean water to people in over 15 countries.

The statistics he gave us on how many people in the world do not have clean, safe water to drink (over 1 billion!) were stunning. And that more people die from lack of clean water than those that have died in all the recent wars put together. Another startling fact is that even though it is the biggest killer on the planet, dealing with dirty water for the poor of the world gets less than 20% of the funding when compared with funding for HIV, malaria, and TB.

He has a very moving and passionate story about how he got to that place in his life where he found his real purpose, discovered these facts, and set out to do something about it. His talk (and book) tell the whole story. There were a few teary eyes by the end of his talk. Doc has shown amazing courage and perseverance in the pursuit of making a difference.

He really has proven that one, very ordinary person can have a large impact on the lives of others if you really set your mind to it.

I encourage you to go over to his site and learn about his mission, his story, and his organization Wine to Water.

Maybe you can help him make a difference.

Doc Hendley, Founder of Wine to Water, gives a moving and inspirational address as our keynote speaker.

Doc Hendley, Founder of Wine to Water, gives a moving and inspirational address as our keynote speaker.

The rest of my day

So back to earlier it the day (for those still with me here)…

Started as always with my morning chi gung class. The group grew to about 14 people with a few new folks joining us. We had a few passersby stop to watch and try a few moves as well.

After a healthy breakfast and a shower I did my first talk of the event, Five Ways to Make Data Modeling Fun. There were about 20 folks in the session and we all had a good time trying out my ideas.

Then I headed over to hear my friend Jeff Smith talk about SQL Developer (my 2nd favorite Oracle product).

Oracle Senior Product Manager (and ODTUG Oracle Contributor of the Year) shows us his top tips and trick for SQL Developer.

Oracle Senior Product Manager (and ODTUG Oracle Contributor of the Year) shows us his top tips and tricks for SQL Developer

After that is was another awesome lunch (beet salad and redfish!) then on to Mark Rittman’s session about OBIEE, Endeca, and his take on the overall landscape of Oracle BI and data discovery in the new world of NoSQL and Hadoop.

In Mark Rittman's session he talked a bit abut Oracle's strategy around business analytics.

In Mark Rittman’s session he talked a bit abut Oracle’s strategy around business analytics

Always a good idea to get Mark’s take on things BI.

Lastly (before the general session that is), I did my second presentation along with Stewart Bryson. We introduced folks to the idea of using OBIEE on top of a Data Vault Data Warehouse and showed how it conformed to Oracle’s reference architecture while at the same time enabled an agile approach to BI.

Oracle ACE Stewart Bryson talks about how he used OBIEE to create a virtual data mart on top of a Data Vault style EDW model

Oracle ACE Stewart Bryson talks about how he used OBIEE to create a virtual data mart on top of a Data Vault style EDW model

I can’t thank Stewart enough for taking on the challenge to learn Data Vault and figuring out how to use it effectively in OBIEE. His approach works very well and should really enable organizations to truly leverage their data and create an agile BI/DW framework.

That’s it for today’s report. I should have another report for you tomorrow on activities today!

Cheers.

Kent

P.S. Yes there was eating and drinking around the French Quarter after hours. Even got to have a drink with Doc Hendley and his wife on Bourbon Street. That was a nice treat.

See you at KScope13!

Are you ready?

It is almost time for the annual ODTUG KScope conference in New Orleans. It starts with the Community Service Day on Saturday June 22nd and runs through Thursday June 27th at the Sheraton Hotel right on the edge of the French Quarter.

For my readers that are attending, I will be giving three talks this year, leading morning Chi Gung classes,  as well as sitting on the BI Lunch and Learn Panel.

My talks will be:

Five Ways to Make Data Modeling Fun – Monday at 9:45 AM

Using OBIEE and Data Vault to Virtualize Your BI Environment: An Agile Approach – Monday at 3 PM (with Stewart Bryson)

Top Ten Cool Features in Oracle SQL Developer Data Modeler – Tuesday at 12:15 PM

And on Wednesday at 10:45 AM you will find me in Social Media Lounge getting interviewed about Data Modeling, ODTUG, and KScope.

If you are joining me for Morning Chi Gung, I believe we will meet in the hotel lobby at 6:45 AM so we can walk to the river front park where we will hold our class. It is only a 30 minute class right before breakfast so please give it a try and get energized for a long day of learning and networking! Follow me on twitter @KentGraziano for any updates to the location and meeting time.

Don’t forget to download the new KScope Mobile App so you can keep track of your schedule and not miss any of these sessions.

See you in New Orleans!

Kent

The Oracle Data Warrior

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

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

Get thee to KScope13!

Jeff Smith (@thatjeffsmith) just posted a great little piece about why you can’t afford to miss this year’s ODTUG event in New Orleans: KScope13. As usually I will be speaking there as well and running my now annual Morning Chi Gung classes.

Get thee to KScope13!

See you there.

Kent

Post Navigation