The Data Warrior

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

Do you want a Data Vault 2.0 Bootcamp in The Woodlands, Texas?

Survey time peeps!

Simple Yes/No question:

Would you like me to hold a DV 2.0 Bootcamp (and private certification) west of the Mississippi?

If I set one up a in “America’s Hometown” (really it is even trademarked), The Woodlands, Texas (20 minutes north of Houston Bush Intercontinental Airport), would you come?

The Woodlands Waterway and our concert venue The Pavillion

The beautiful Woodlands Waterway and our concert venue, The Pavilion. You can take a water taxi to a concert!

Since I am an authorized DV 2.0 Trainer, I figure it is time I actually teach a class. And why not in my hometown in Texas?

So what is in a DV 2.0 Bootcamp class?

Three days of intense training on all things DV (followed by a chance to become a Certified DV 2.0 Practitioner).  NOTE: If you are new to Data Vault, you must read the Super Charge book before attending the class.

This class covers what you need to know as a practitioner in the world of Data Warehousing and Business Intelligence.  This is our foundational course.  This is a 3 day (in person) course that covers end-to-end best practices.  Major topics for this class are:

  • Architecture – Including NoSQL, Big Data, Hybrid Systems and Relational stores
  • Methodology – Including CMMI, Six Sigma, Optimization, Automation, and Generation
  • Implementation – Including Performance and Tuning, Set Logic, ELT vs ETL, Parallelism
  • Modeling – Including replacing of surrogates with Hash Keys, data layout, data co-location

This class takes you through the why/what/how of Data Vault 2.0.  It includes the coverage of the business justifications, then follows with the technical descriptions of the architecture, implementation, methodology, and modeling.  Included in the topics are reaching agility, practicing Six Sigma, measuring and optimizing at CMMI level 5, the KPA’s and KPI’s of Data Warehousing, and more.

We also discuss the use of Hadoop, and NoSQL platforms along side the relational world.  The objective is to enrich your understanding of how and when to apply Big Data Solutions.  The course finishes with descriptions on ETL and ELT design time paradigms, including templates, best practices and working SQL.  This class is a prerequisite for anyone wishing to achieve DV2.0 Certified Practitioner status.

When:

Late summer – early fall (depending on interest) of 2015

Cost:

TBD based on how much the space costs me here!

But will definitely be less than $3,000.

Where:

Someplace nice and central in The Woodlands within walking distance to great food and drink.

Apartments over looking the waterway that flows to Lake Woodlands. A great natural setting. Not the usual suburban wasteland.

Apartments over looking the waterway that flows to Lake Woodlands. A great natural setting. Not the usual suburban wasteland.

So who is in?

Please respond in the comments so I can tell if I should start setting something up.

Thanks.

Kent

The Data Warrior

P.S. Since you know I am into fitness, we have great options here to exercise here too. MIles of running trails and even kayaking on the waterway.

The Riva Boathouse were you can rent single and double kayaks by the hour (look close and you find a picture of my son and & on the sign from when they first opened).

The Riva Boathouse were you can rent single and double kayaks by the hour (look close, when you are here, and you find a picture of my son and & I on the sign from when they first opened).

Surfs Up! #KScope15 Beach Club: Opening Soon!

I know this is last minute but wanted to remind everyone that the Annual ODTUG KScope event starts in less that a week!

As always, I will be there with my ACE Director hat on (literally). I will be giving My Talks at KScope during the week. One on SQL Developer Data Modeler (SDDM), and my fun talk about the Worst Practices in DW Design I have seen. And there will be the Lunch with the ACEs among many other events.

I will also be running Morning Chi Gung on the beach each day to help people stay in shape and stress free.

Just so you know the score, I have captured for you a list of great stuff happening at KScope from the recent attendee email I got. Here it is. Enjoy

Believe it or not, we are only six days away from the opening of the Kscope Beach Club in Hollywood, Florida. This exclusive club is only open to Kscope15 attendees, so consider yourself one of the elite.

This is the third newsletter with content updates, event happenings, and everything you need to know to plan for Kscope15. It’s a long email full of important information to make your week a success, so please read it all.

See you soon!

– Natalie Delemar, Kscope15 Conference Chair

Important Updates

Community Service Day – If you have already signed up to attend Saturday’s Community Service Day, please meet at the Diplomat Conference Center Porte Cochere at 7:00 AM to have breakfast and pick up T-shirts. The activity is within walking distance (.5 mile); however, transportation will be provided to those who need it. Participants will depart the hotel at 8:00 AM. Wear comfortable clothing for both the walk and the activities. If you did not sign up to participate in Community Service Day but you would like to help, show up at the Conference Center Porte Cochere on Saturday morning. Chances are you will be able to join the group on a first-come, first-served basis.

Registration – Kscope15 registration is open on Saturday from 5:00-7:00 PM on the third floor of the Diplomat Conference Center. After that, registration begins at 7:00 AM on Monday and Tuesday; 7:30 AM on Wednesday; and 8:00 AM on Thursday. Check the agenda for daily schedules.

Mobile App – Build your schedule and have all of your devices sync to it with the Kscope15 mobile app. The first time you login you will need to click “create a password” and enter the email address you used for your Kscope15 registration. A password will be emailed to you. Only registered attendees (who have paid) can access the app. Download the app today and get busy building your schedule!

Schedule – Want to see the schedule in a grid format before you receive your printed Schedule at a Glance onsite? Check this out (you will have to log in to http://www.odtug.com to view) – but keep in mind the most up-to-date schedule will be available on the mobile app and the schedule signs outside of the Registration Desk.

Confirm Your Stay – Be sure to double-check your hotel reservations and confirm your arrival and departure dates are correct. Some properties may require a 72-hour cancellation notice.

Say Cheese – Need a new headshot or family pic? We’ve got you covered. Accomplished Kscope photographer Warren Capps is offering free sessions to a select number of Kscope attendees. Find out more here. Space is very limited, so sign up today!

Scavenger Hunt – Are you competitive, driven, and like to be a winner? Then participate in the Kscope15 Scavenger Hunt. Sign up in advance, and stop by the Registration Desk to receive your NFC sticker to fully participate!

Social Media Lounge – Give your brain a break and head over to ODTUG’s Social Media Lounge in the Exhibit Hall. We’ll have giveaways, picture-taking opportunities, and an area where you can sit back and relax. While you’re there, tell us what you think about Kscope in an interview, or watch one while it happens!

Women in Technology Roundtable – Participate in Wednesday’s interactive discussion about issues facing Women in Technology. Men are welcome, too! Ernst & Young is sponsoring the event. To participate in the luncheon, please register here and share your feedback on important issues.

Hands-On Training – If you are planning to participate in any Hands-On Training sessions, please view the mobile app and designated webpage for important prerequisite instructions. Details may be added within the next several days, so check back closer to the classes for updates.

Special Event – The White Party at Nikki Beach comes with a dress code: Plan your all-white outfit to live it up South Beach-style! It’s not required, but we would love as much participation as possible.

Fun for the Little Ones – Sign up any children in your group for Kids Fun Night Out on Wednesday while you are celebrating in South Beach. The cost is $70 per child, which will be charged to your room. Reservations are required; email Natalie.Dotson@diplomatresort.com.

Conference Dress – Casual. We want you to be comfortable! The days and nights will be hot in South Florida, but the conference rooms will be cool, so layers are recommended. Pack your swimsuit and hit the beach or pools in your off-time!

via Kscope Beach Club: Opening Soon!.

Hope to see you next week in Florida.

Kent

The Data Warrior

The Hills were Alive with the Sounds of #DataVault

Yes folks a few weeks back we held the 2nd Annual World Wide Data Vault Consortium (#WWDVC) at the lovely Trapp Family Lodge outside Stowe, Vermont. What a great venue! Beautiful scenery, near perfect weather, great food, and great beer (they have their own brewery). Standing on the hillside it is easy to see why the Von Trapp Family Singers (you know from “The Sound of Music”) decided to settle here to build their new life in America.

What a view!

What a view!

Of course the learning and networking were outstanding again. This year was even better than last year.

Why?

  1. Location, location, location
  2. It was May (so much warmer that last year in St Albans – brrrr.)
  3. Dr. Claudia Imhoff gave the keynote! I love her new concept #XDW – the Extended Data Warehouse.
  4. Scott Ambler talked about Agile DW! It takes a Disciplined approach to be agile.
  5. Dan talked about DV 2.0 and Big Data.
  6. Sanjay showed us how he built a DV 2.0 platform on Hadoop.
  7. Multiple, real world case studies of DV 2.0 working in the wild around the globe.
  8. I gave two talks and showed models and code from one of my recent adventures.
  9. Five members of the Boulder BI Brain Trust (#BBBT) in attendance.
  10. We had multiple 30-minute networking sessions between the talks (who does that?). Plenty of time to ask questions and get to know each other.
  11. Three (count ’em 3!) global software vendors with off the shelf tools that support the automatic generation of DV 2.0 compliant components. Wow!
  12. BBQ dinner hosted by AnalytixDS. Yum!
  13. Crazy shirt day and contest.
  14. And did I mention three days of face-to-face networking with world-renowned experts. (I got to have lunch with Claudia Imhoff AND Scott Amber at the same time – a once in a lifetime opportunity)
  15. Fresh German-style craft beer.
  16. Bavarian pastries from the in house bakery.
  17. Did I mention the food?
  18. The view.
  19. The hiking. (Good to get outside and exercise after all those sessions.)
  20. The mountain biking (after the conference of course).

As if that was not enough, I was privileged to attend an exclusive workshop/mentoring/Q&A session with Dan the day before the event, where he told us about new, as yet unpublished DV 2.0 additions, explained in depth the zero-key concept, the right way to use hash keys, 3 stages of managed self-service BI, and a host of other topics and issues we all wanted feedback on. My brain was tired before the conference even started.

Hint: if you want to get invited to that special session next year, you need to get DV 2.0 certified ASAP. Keep an eye on LearnDataVault for Dan’s teaching and speaking schedule and locations or contact me about setting up a class if you can’t make one of his (I am an authorized DV 2.0 Bootcamp Instructor too).

Bummed out now that you missed all this great learning? Not like I did not warn you!

Well first, you can catch a lot of the action and a bunch of pictures by mining the Twitter stream for #WWDVC. But since I know you are all too busy (or lazy?), here it is for you:

Really wish you were there? Really?

You are in luck because Dan managed to record some of the best session on video! The videos and all the PowerPoint presentations are now available, for sale, on the Data Vault learning site. Just check out this offering WWDVC 2015 Videos. In addition to the videos listed, you get all the other presentation materials from the speakers (including me).

Right now the cost is $499 (yup more than the conference but hey, no travel expense). Since you are a loyal reader of my blog, you can get a 20% discount off that by using the coupon code KENT10S during checkout.

Even without the discount, it is more than worth the money. The video of Claudia’s keynote and Scott Ambler’s talk are worth that much alone.  The videos are high quality and both of them are amazing speakers. (FYI – some of the videos are very long and may take a minute or two to load depending on your internet connection)

So that is my short review of WWDVC 2015. Glad I was able to be a part of this great event!

VonTrappLodge2Keep you eyes on http://wwdvc.com/ for the announcement of the 2016 event and the call for papers (which will open soon).

See you next year? (Somewhere near Stowe again)

Kent

The Data Warrior

P.S. Dan’s newest book that covers Data Vault 2.0 is now available for pre-order on Amazon. Get a preview of Dan’s new DV 2.0 book.

Better Data Modeling: 7 Differentiating Characteristics of Data Vault 2.0

Hard to believe that the 2nd Annual World Wide Data Vault Consortium (WWDVC15) is NEXT WEEK in beautiful Stowe Vermont. It promises to be an excellent event. The speakers include myself, Claudia Imhoff, Dan Linstedt (the inventor of Data Vault), Scott Ambler, Roelant Vos, Dirk Lerner and many more. The focus will be DV 2.0, agile data warehousing, big data, NoSQL, virtualization and automation. Check out the agenda here: http://wwdvc.com/schedule/

So in preparation (and to encourage you to attend), I thought it might be good to review some of the important basics about Data Vault 2.0 and why it is an important evolution for the data warehousing community.

The approach started out as the Common Foundational Warehouse Modeling Architecture as it’s official name. Then it was more commonly known as the “Data Vault” and became a modelling method for Data Warehouses. It also had a methodology with implementation guidelines and worked very, very well on relational platforms for many, many years (over 10 years for those who did not know).

But technology evolved. NoSQL architectures came into the picture primarily as sources. The Apache Hadoop platform started offering a cheaper storage and processing MPP architecture.

Data Vault evolved into Data Vault 2.0 and already has many successful implementations. The original Data Vault is now referred to as Data Vault 1.0 (or DV 1.0) and it primarily has a modelling focus. DV 2.0 on the other hand changes some things, and adds a LOT.

Data Vault 2.0 has the following 7 differing characteristics:

1. DV 2.0 is a complete system of Business Intelligence. It talks about everything from concept to delivery. While DV 1.0 had a major focus on modelling and many of the modelling concepts are similar, DV 2.0 goes a step further and talks about data from source to business user facing constructs with guidelines for implementation, agile, virtualization and more.

2. DV 2.0 can adapt to changes better than pretty much ANY other data warehouse architecture or framework. It can do it even better than DV 1.0 because of the change in design to adapt to NoSQL and MPP platforms, if needed. DV 2.0 has successfully been implemented on MPP RDBMS platforms like Teradata as well (ask Dan for details).

3. DV 2.0 is both “big data” and “NoSQL” ready. In fact, there are implementations where data is sourced in real-time from NoSQL databases with phenomenal success stories. One of these was presented at the WWDVC 2014 where an organization saved lots of money by using this architecture.

A near real-time case study for absorbing data from MongoDB is being presented at WWDVC2015. It’s not to be missed.

4. DV 2.0 takes advantage of MPP style platforms and is designed with MPP in mind. While DV 1.0 also did this to an extent, DV 2.0 takes it to a completely other level with a zero-dependency type architecture. Of course, there are a few caveats you will need to learn.

5. DV 2.0 lets you easily tie structured and multi-structured data together (logically) where you can join data across environments easily. This particular aspect lets you build your Data Warehouse on multiple platforms while using the most appropriate storage platform to the particular data set. It lets you build a truly distributed Data Warehouse.

6. DV 2.0 has a greater focus on agility with principles of Disciplined Agile Delivery (DAD) embedded in the architecture and approach. Again, being agile was certainly possible with DV 1.0, but it wasn’t a part of the methodology. DV 2.0 is not just “agile ready”, it’s completely agile.

7. DV 2.0 has a very strong focus on both automation and virtualization as much as possible. There are already a couple of automation tools in the market that have the Dan’s approval (just ask). Some of them will be at WWDVC15.

It’s real-time ready, cloud ready, NoSQL ready and big data friendly. And practitioners have already had success in all these areas (on real projects not just in the lab).

And, as you’ll notice on the agenda, the focus at WWDVC15 will be Data Vault 2.0 with examples of sourcing it from MongoDB, with examples of virtualization (from me!), with examples of design mods (also one from me), with examples of Hadoop implementations and more. It’s not something you want to miss, and there’s hardly any time or seats left.

If you are coming, I look forward to seeing you and chatting about the world of DW/BI and agile. If you want to attend, grab one of the last seats over at http://wwdvc.com/#tile_registration  (if there are still seats left by the time you get this message).

See you soon!

Kent

The Data Warrior

P.S. After the conference, the next place you’ll hear about DV 2.0 is in Berlin. There is a bootcamp and certification starting on 16th June at Berlin, Germany. The details are here: http://www.doerffler.com/en/data-vault-training/data-vault-2-0-boot-camp-and-certification-berlin/

Quote of the Day: We cannot direct the wind…

We cannot direct the wind…

But we can adjust the sails!

Are you heading where you want to, or letting the wind blow you about?

Talk the helm of your life and set a course.

Happy Monday!

Kent
The Data Warrior

P.S. It is almost time for the 2nd Annual World Wide Data Vault Consortium (WWDVC) in lovely Stowe, Vermont! If you do DV or want to learn more about DV, this is THE place to do it. Cost is CRAZY LOW for the content and contacts you will make. There are only a few seats left so sail on over and register at http://wwdvc.com/ before they sell out.

Post Navigation

Follow

Get every new post delivered to your Inbox.

Join 1,164 other followers

%d bloggers like this: