Do you want to learn about Data Warehouses? Do you want to learn about Extract, Transform, Load with SSIS?
Do you like Pi?
Do you like Pie?
SQL Server MVPs and popular blogging team Audrey Hammonds and Julie Smith of DataChix.com offer this one day of training to benefit The Cloverleaf School of Atlanta in cooperation with The American Legion Post 251, Duluth, GA. Audrey will take you on a guided tour of converting a transactional model into Dimension and Fact tables. After the model has been created, Julie will guide you through loading those tables using SQL Server Integration Services.
To top it all off, it’s happening on March 14th folks.
That’s right. 3/14 Pi Day. Could there be a better way to celebrate the irrational number which represents the ratio of a circle’s circumference to its diameter than by using SSIS? NOPE! But maybe we’ll get some delicious Pie to celebrate as well!
Audrey and Julie bring over 25 years of warehousing experience to this fantastic day of training, but don’t say that to their faces!
Part I Dimensional Modeling with Audrey
Why Transactional databases are the way they are—Codd’s rules to live by
Why Codd’s rules don’t work for Reporting– Kimball’s rules to live by
Fun at the whiteboard converting a transactional model to a dimensional model.
Part II Extract Transform and Load using SSIS with Julie
A tour of SSIS
Data Flow Basics
How to load Dimensions with SSIS
How to load Facts with SSIS
Why SSIS has got such a bad rap sometimes.
What happened and when
When things go wrong, how to know the details
Top quirks of SSIS—what, why, and how to get around them.
Data Quality! We’ll throw in a little Data Quality Services with our ETL!
Lunch and Continental Breakfast provided. Please contact the organizer at the above email for any special dietary considerations! Thanks and see you on Pi Day!
Can’t make it to this great day of SSIS training to benefit the school, but you’d still like to support our mission? http://t.co/VX6yGftC