The Data Warrior

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

Archive for the tag “data warrior”

Introduction to Snowflake!

Heads up! I will be giving a webinar next week, called Enabling Cloud-Native Elastic Data Warehousing to introduce folks to the Snowflake Elastic Data Warehouse. Sign up here and join me on July 12th!

Special thanks to DAMA International for inviting me to do this!

See you there!


The Data Warrior

#Kscope16 Blog Hop: #BigData and #AdvancedAnalytics Sessions Not to Miss

You are attending #KScope16 right?

Me too.

But there are so many sessions to choose from (mine included), which do you pick? How do you pick?

Well, I (and my fellow bloggers) are here to help you out with a Blog Hop. We are going to give you our top picks for for each track. In this post, I will give you my picks for the Big Data and Advanced Analytics track.

Big Data and Advanced Analytics Sessions

Why did I pick that this track? Really because it is a necessary adjunct to BI and Data Warehousing. In fact I find it hard to imagine that these two really won’t merge over the next few years (at my company, Snowflake, it really has already). Every company that is investing in BI/DW is also finding that they need to deal with Big Data too. And Advanced Analytics is, to me, the logical extension to BI.

So after looking at the agenda, really most of the sessions are of interest to me (sigh). But in reality I am sure I will not be able to attend them all, so here are my top 5 picks to see at KScope16:

  1. How to Build an Internet of Things Data Pipeline presented by Rex Eng
  2. Oracle Big Data Discovery: Extending into Machine Learning and Advanced Visualizations presented by Mark Rittman
  3. Introduction to Apache Kafka and Real-Time ETL presented by Gwen Shapira
  4. Getting Started with a Data Discovery Lab: You Don’t Have to Go Big to Gain Big presented by Kathryn Watson
  5. Getting Started with Oracle R and OBIEE presented by Kevin McGinley
 Why those? Simply because they hit on all the top issues and topics that see being discussed (or written about) in the field, and I need to get a better grip on these things:
  • IoT – it is here already
  • Machine Learning – I am pretty clueless about this one so far
  • Kafka – ETL/ELT in the cloud
  • Data Discovery – the next step beyond BI
  • R – the language of choice for data scientists

And I actually know all of but one of the presenters, so am sure they will be very informative and lively talks.

The rest of the blog hop:

Thanks for attending this ODTUG blog hop!

Looking for some other juicy cross-track sessions to make your Kscope16 experience more educational? Check out the following session recommendations from fellow experts!

I hope this gives you some great ideas on what to see at KScope16!

See you in Chicago.


The Data Warrior

P.S. Don’t forget to make time to attend my Morning Chi Gung sessions down by the river to get each day started right with a clear mind and strong heart. Look for signs at the hotel.


The Data Warrior Goes to Oracle Open World 2015 (#OOW15)

Yes boy and girls, it is that time of year again. Time for the BIG show in San Francisco – OOW15

I will as usual, attend, but only for a few days this year (been away from home too much).

My Talk

I will be presenting my session Worst Practices in Data Warehouse Design (UGF9985) on Sunday at 10:00 AM in Moscone South, room 274 (courtesy of ODTUG!).  This will be a quick one as I only have 45 minutes to do a one hour talk. Yikes!

If you will be in SF by Sunday, be sure to come by and say “hi.”

Morning Chi Gung?

As usual, I will try to gather some folks near either Union Square or maybe by Yerba Buena Gardens for a little morning relaxation with some Chi Gung (Qigong) . Most likely around 7 AM for 30 minutes. Probably Saturday, Sunday, and Tuesday, Follow me on twitter @kentgraziano and look for #MorningChiGung #OOW15 for final time and location.

Monday for sure though, I will be doing a shortened session on the beach at the 4th Annual OOW SF Bay Swim around 9:15 AM or so. Nothing like a little chi movement to warm you up before and after jumping in the bay.

The Rest of My Schedule

Much shorter than usual but here is what I plan to see so far:

Session Title Session Code Date Start Time End Time Room
Oracle Database 12c-Data Redaction UGF1513 10/25/2015 8:00 8:45 Moscone West-3011
Oracle Business Intelligence Best Practices: the Bad, the Worse, and the Really Ugly UGF7409 10/25/2015 9:00 9:45 Moscone South-301
Worst Practices in Data Warehouse Design (ME) UGF9985 10/25/2015 10:00 10:45 Moscone South-274
Oracle Database Security: Frustrating the Patient Intruder UGF10016 10/25/2015 11:00 11:45 Moscone South-274
Improving Analytics: Experiences Testing Oracle Database In-Memory 12c Feature UGF9936 10/25/2015 13:30 14:15 Moscone South-303
Fennia Two Years in Production with Oracle Exadata UGF5105 10/25/2015 14:30 15:15 Moscone South-305
Managing the Changes in Database Structures (Heli) UGF6317 10/25/2015 15:30 16:15 Moscone South-306
Oracle OpenWorld Welcome Keynote KEY10818 10/25/2015 17:00 19:00 Moscone North-Hall D
Oracle OpenWorld Monday Keynote Swim The Bay!
KEY10819 10/26/2015 9:00 10:00 Moscone North-Hall D The Dolphin Club
Oracle SQL Developer Tips and Tricks (Jeff Smith) CON8721 10/26/2015 16:00 16:45 Moscone South-304
Database Development for the Cloud and On Premises (Kris Rice) CON8779 10/26/2015 17:15 18:00 Moscone South-304

Other Fun Stuff

Along with the educational sessions is of course the opportunity to network with folks. I expect I will be doing that as much as possible. There is the annual Oracle ACE dinner, and who know what else. I am sure I will find plenty to keep me busy.

Since I arrive early for the Oracle ACE Directors annual briefing at HQ, I know I will be downtown Friday evening and all day Saturday. Drop me a note if you will be there too and want to hang out and see some of the sites and eat some top notch grub.



The Data Warrior

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.


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


TBD based on how much the space costs me here!

But will definitely be less than $3,000.


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.



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).

New Year, New Name, Same Mission

Happy New Year!

Looks like it will be another busy one. So, let’s get going!

Yes, I just changed the name of my blog from “Oracle Data Warrior” to “The Data Warrior.”


Well, for one, my company name is Data Warrior LLC, so it seemed to make sense.

Plus over the last few years quite a few of you that I see at conferences and such, simply call me “data warrior”. As in,

Hey, Data Warrior, how’s the battle going?

And after a some recent conversations and pondering, I realized that, while I am an Oracle ACE Director, and a fan of Oracle databases and tools, the things I write about and the work I do, is really database agnostic.

Think about it…

Regardless of the database, or data modeling tool, good design principles,  architecture, and standards transcend the technology.

Third normal form


Data Vault


There are standards and best practices that are applied in developing all of these models that have nothing to do with technology. (Yes, implementing them efficiently is another story).

Some of my favorite topics, like FKs in data warehouses, and naming standards, are somewhat philosophical, and apply in many situations.

But never fear, you will still see posts on my favorite tool, SQL Developer Data Modeler,  and reports from all the main Oracle events (RMOUG, ODTUG, OOW).

And there will be the occasional rants about badly behaving data models and data modelers.

And of course Data Vault, Agile BI, and varying forms of virtualization.

Plus the occasion inspirational quote.

So while the name has changed, the content will not; the mission will not.

My mission is still to Change the World, One Data Model at a Time.

Let’s see what the year will bring us.


The Data Warrior

P.S. Look for future posts about upcoming talks I am giving, and at least one surprise new offering.


Post Navigation

%d bloggers like this: