The Data Warrior

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

Archive for the tag “data warehouse design”

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 12 Steps to Faster Data Warehouse Success

Announcement!

I have exciting news!

With the help of my good friend Dan Linstedt (of LearnDataVault.com fame), we have just launched my first online training video based on my very popular white paper and talk: Agile Methods and Data Warehousing: How to Deliver Faster.

Most of you will agree that data warehousing and business intelligence projects take too long to deliver tangible results. I am sure all you project and program managers wish it was not true.

Often by the time a solution is in place, the business needs have changed.

With all the talk about Agile development methods, including SCRUM and Extreme Programming, the question arises as to how these approaches can be used to deliver data warehouse and business intelligence projects faster. This new online course will look at the 12 principles behind the Agile Manifesto and see how they can be applied in the context of a data warehouse project. Then I will talk about some of the specific agile techniques I have used with great success on my projects over the last 15 years. The goal is to determine a method or methods to get a more rapid (2-4 week) delivery of portions of an enterprise data warehouse architecture.

The last time I gave this talk, in Helsinki, Finland at Harmony 2014, I had standing room only and ended up being rated the 2nd best speaker at the event (pretty cool!). It was so popular that the UK Oracle Users Group asked me to write an article on the same topic for their international newsletter.

Since many of you don’t get the chance to travel to events like this (or may have missed my session), you can now see my talk online, at your convenience, for much less than the cost of a conference fee (and the airfare to get there!). We just filmed it last week, after I completed my most recent agile data warehouse engagement, so it contains some new insights and stories that even the folks in Helsinki did not get to hear.

As a bonus, once you have finished the course, you will be able to download a free copy of the detailed article I wrote for UKOUG.

If you have questions during or after the course, you can post them right there in the training portal where I will answer them. So in addition to the training course and the white paper, you also get interactive access to me!

How do I sign up?

So how do you sign up for this new class and how much does it cost?

Well, the full price for course will be $199, but for those of  you who read my blog, I have a special Valentines Day Special offer: if you are one of the first 50 people to purchase the class between now and midnight February 15, 2015, you get a full 50% off the retail price.

So that is $99.50 for over an hour of valuable content PLUS a copy of my white paper (and access to ask me your burning questions).

Use the coupon code: GRAZIANO50

You can buy it now by going to the all new Learn Data Vault training portal now.

On the site you see the class description, outline, and my introductory video, along with the “Buy Now!” button.

So hurry and cash in my special gift to you before the time is up (remember after 2/15/15 it will be $199).

Applying Agile

For those of you who had no idea there were 12 Principles behind the Agile Manifesto, let me tell you about one that I think is vitally important: Principle #6

The most efficient and effective method of conveying information to and within a development team is face-to-face conversation.

This means the team works best when co-located so they can easily talk to each other during the day.

HINT: If not co-located, you need to be sure you have an adequate instant messaging system in place to facilitate their daily interaction. And that the team agrees to use it!

In addition, another best practice is to hold Team Huddles every morning. In the class, I give a lot of details about huddles and how they work, but the main point is that the team needs to meet briefly once a day (usually the morning) to make sure they are all one the same page as to what they are all working on.

I can tell you for a fact, that the daily huddles and ongoing interaction is definitely a critical success factor in adopting agile practices for your data warehouse team. I have seen great success where this was implemented properly and I have also seen lots of issues when the team did not communicate daily. There is no better recipe for disaster than to have your data architect building the wrong view when the report writer is trying to finalize the output with the user. Yikes!

So, if you want to learn how to apply the 12 Principle of Agile to become more successful in delivering usable results to your data warehouse and BI program, please go over to the training site and sign up from my class.

Here’s to your success!

Kent

The Data Warrior

P.S. Don’t forget to sign up before 2/15/15 with coupon code GRAZIANO50 to get 50% off the full price.

 

Live from #OTW14: Worst Data Warehouse Design Practices

Back in September at the now annual OakTable world (OTW) at Oracle OpenWorld, I was privileged to give a talk where I ranted a bit about some of the worst data warehouse design mistakes that I have seen.

Well, if you missed out, now you can see that talk thanks to Kyle Hailey who had all the OTW talks videoed. This week, he tweeted that the video was ready for viewing.

So if you missed the talk, or just want to see it again, check it out!

Kent

The Oracle Data Warrior

P.S. If you would like to have me do this very fun presentation at your company or meeting, I would be happy to discuss arrangements with you. You know how to find me so drop me a comment, email, tweet, FB, DM, or even call 🙂

Oracle 12c Release 1 is here!

After much anticipation the new Release 1 of Oracle 12c (12.1.0.2) is finally available!

Get it here: http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html

What does this mean:

Oracle’s ground breaking In Memory Database is now available!

As they say…this is BIG. Get more details about In Memory here: http://www.oracle.com/technetwork/database/in-memory/overview/index.html

I am very excited about the possibilities of what we can do with this technology. It will be a game changer especially for those of us trying to do agile data warehousing and business intelligence.

Now we can talk about having big data in memory – quickly accessible so it can be used.

Anyway, it is a big day in Oracle-land.

Now if I can just get my client to upgrade….

Cheers.

Kent

The Oracle Data Warrior

Post Navigation

%d bloggers like this: