#AgileDataWarehouse | The Data Warrior

Archive for the tag “#AgileDataWarehouse”

A quick note for all the folks out there that have been contemplating diving deep into Dan Linstedt’s Data Vault 2.0 System of Business Intelligence.

Dan will be teaching a Data Vault 2.o Bootcamp in February! You can sign up here.

You’ve read the articles, read the blog posts (mine included), attended the talks at the conferences, maybe even read the Super Charge book…

Are you done trying to figure it out on your own?

Ready to not only learn how to do it right, but get certified as a Data Vault 2.0 Practitioner?

Well let’s get 2016 off to a great start and attend the 1st Data Vault 2.0 Bootcamp of 2016 in beautiful St. Albans, Vermont, taught by none other than the inventor of Data Vault, my good friend Dan Linstedt.

You could of course just buy the new book, and try it out on your own…

But if you are like me, you do much better when you can interact, face-to-face with a qualified instructor, ask the hard questions, and get the insights that will make you truly successful.

So why not invest in yourself and your future success? Go sign up now.

As an added incentive, Dan has added some brand new material.

NEW TOPICS

Dan will be discussing DV2 on Hive / Hadoop, the benefits, pros and cons, some suggestions on how to build it and leverage it properly. He will be talking about Satellites on HDFS, Hubs & Links on Hive. He will discuss data modeling implications, and using SERDe definitions at query time. This is the first time ever that this information will be presented in the DV2 class!

Make the commitment to a great 2016 now and go sign up before the class fills up. If you sign up before February 1st, you can save over $400!

To your success!

Kent

The Data Warrior

Data Vault Master and CDVP2

P.S. For you skiers, St. Albans is a short drive to both Stowe and Smuggler’s Notch – both great east coast ski areas and with the snow they just got the skiing will be epic. Go take the class, then reward yourself with a little weekend ski trip.

Posted in Data Modeling, Data Vault, Data Warehouse and tagged #AgileDataWarehouse, #BetterDataModeling, #datavault, @dlinstedt, agile, agile data vault, bootcamp, DAD, Data Warehouse, data warehouse design

28 Dec 2015

Snowflake SQL: Making Schema-on-Read a Reality (Part 1)

This is my 1st official post on the Snowflake blog in my new role as their Technical Evangelist. It discusses getting results from semi-structured JSON data using our extensions to ANSI SQL.

Schema? I don’t need no stinking schema!

Over the last several years, I have heard this phrase schema-on-read used to explain the benefit of loading semi-structured data into a Big Data platform like Hadoop. The idea being you could delay data modeling and schema design until long after the data was loaded (so as to not slow down getting your data while waiting for those darn data modelers).

Every time I heard it, I thought (and sometimes said) – “but that implies there is a knowable schema.” So really you are just delaying the inevitable need to understand the structure in order to derive some business value from that data. Pay me now or pay me later.

Why delay the pain?

Check out the rest of the post here:

Snowflake SQL: Making Schema-on-Read a Reality (Part 1) – Snowflake

Enjoy!

Kent

The Data Warrior

Posted in Big Data, Data Warehouse, SnowflakeDB and tagged #AgileDataWarehouse, #BetterDataModeling, #bigdata, #ElasticDW, #YesSQL, data warehouse design, data warehousing, schema-on-read, semi-structured data, SQL

18 Dec 2015

Data Warrior Agenda for 2016

Hard to believe 2015 is almost over.

It was a very busy year for me:

Lots of interesting #AgileDataWarehouse work as an independent consultant. Worked on at least 4 different clients with 4 different partners. (and thankful for every one!)
Recorded two online training classes with my good friend Dan Linstedt at LearnDataVault.com
- Agile Methods & Data Warehousing
- Oracle SQL Developer Data Modeler Jumpstart
Spoke at several events:
- DAMA Houston
- RMOUG Training Days 2015
- World Wide Data Vault Consortium 2015 in Stowe, VT (the hills were alive!)
- KSCOPE15 in Hollywood, FL (great white party!)
- ECO2015 in Raleigh, NC (beer…)
- Oracle Open World 2015 (in the #Cloud)
- Did a presentation while on the road for the Oracle Virtual Technology Summit (VTS)
- Did a webinar for the ODTUG Leadership Training Program
- am I forgetting any?
Wrote a guest blog post series on Data Vault for the folks at Vertabelo
Got interviewed by the Opal Alapat for a profile piece on the ODTUG blog (thanks again)
Went to Colorado a few times to officiate at several advanced black belt exams for Rocky Mountain Tae Kwon Do (Denver) and Blue Wave Martial Arts (Salida)
Wrote a little Kindle book with tips for using Oracle SDDM (Sql Developer Data Modeler)
Wrote another Kindle book! This one on Data Vault 2.0.
Took a new position as Senior Technical Evangelist for Snowflake Computing (fyi – look for coming blog posts here)

All of that has entailed a lot of air miles! This year I have visited:

Denver (several times!)
Salida, Colorado
Hollywood, Florida,
Raleigh, NC
Charlotte, NC (thanks to Lynn Winterboer for that one!)
San Francisco
Redwood City, California (Oracle HQ)
Austin (drove this one)
Minneapolis/ St Paul (thanks to Redpill Analytics mostly)
Kansas City, Missouri
Portland, Maine
St Albans, Vermont
Stowe, Vermont
San Mateo, California (HQ for Snowflake Computing)

And that was just work related! Family trips took me to:

Galveston (beach!)
South Padre Island, TX (more beach!)
Road trip to Central NY:
1. Joplin, Missouri
2. Hannibal, Missouri (Mark Twain museum)
3. Chicago (to see robots at the Museum of Science and Industry)
4. Sandusky, Ohio (just to sleep)
5. Fulton, NY (to see my dad)
6. Old Forge, NY (summer vacation in the mountains!)
7. Huntsville, Alabama (NASA Rocket Center!)
Who knows – the year is not over yet!

Speaking in 2016

2016 will be very busy with the new job for sure. I am already booked for a bunch of events. Here they are so far:

Data Day Texas – January 16 in Austin, TX

TDWI Webinar – Dymstyfying Elastic Data Warehousing (with Philip Russom) – January 26th

BIWA Summit – January 26-28 at Oracle HQ

RMOUG Training Days 2016 – Febuary 9-11 in Denver, CO (I have 2 hour deep dive on Feb 9th). Register early for discounts.

Enterprise Data World – April 17-22 in San Diego. Register early for discounts (by the end of the year for the best rate).

ODTUG KScope16 – June 26-30 in Chicago, IL. Register early and be sure to book the hotel!

Also likely speaking at World Wide Data Vault Consortium (WWDVC) – May 25-28 in Stowe, Vermont (TBD)

And many more to come! (watch my twitter feed for updates)

Hopefully I will see you at one or more of these events!

Wishing a safe a joyous holiday season!

Merry Christmas & Happy New Year!

Kent

The Data Warrior

Posted in Data Modeling, Data Vault, Data Warehouse, ODTUG, Oracle, SnowflakeDB, SQL Developer Data Modeler, Tae Kwon Do and tagged #AgileDataWarehouse, #datavault, #ElasticDW, #Kindle, #SnowflakeDB, #SQLDevModeler, @dlinstedt, @KentGraziano, @odtug, @SnowflakeDB, agile, Data Modeling, Data Warehouse, Kindle book, Oracle, Oracle SQL Developer Data Modeler | Leave a comment

The Data Warrior

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

Archive for the tag “#AgileDataWarehouse”