Skip Main Navigation
Page Content
This event has ended

A Day of Datawarehousing with the DataChix To Benefit the Cloverleaf School

The Cloverleaf School of Atlanta

Thursday, March 14, 2013 from 9:00 AM to 4:00 PM (EDT)

A Day of Datawarehousing with the DataChix To Benefit t...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Early Reg~Pi + $120 Ended $123.14 $4.07
Regular Reg~Pi + $150 Ended $153.14 $4.82
I am not able to attend, but here's a Donation! Ended

Who's Going

Loading your connections...

Share A Day of Datawarehousing with the DataChix To Benefit the Cloverleaf School

Event Details

Learn DataWarehousing with the DataChix! 

At the American Legion Post 251 in Duluth GA

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

Control Flow Basics

Data Flow Basics

How to load Dimensions with SSIS

How to load Facts with SSIS

Why SSIS has got such a bad rap sometimes.

Frameworks

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.

**Special Bonus--Data Quality with Data Quality Services!

 

 

About The Cloverleaf School of Atlanta:

 

About The American Legion Post 251:

American Legion Chattahoochee Post 251 welcomes VETERANS from all branches of our Armed Forces who have served and/or continue to serve our great Country. Joining Post 251 enables you to continue serving God, Country and Community as well as to enjoy the comradarie and fellowship of fellow Veterans. Our mission is to implement the goals, aspirations, dreams, peace and blessings for our country, friends and families.

 

About Audrey Hammonds:

SQL Server MVP Audrey Hammonds is working as a Consultant for Innovative Architects in Atlanta. (With my fellow Datachix!) Fourteen years ago, she volunteered for DBA training to escape COBOL, and never looked back. A firm believer that good fundamentals and solid design can save a database professional’s sanity, she has devoted much of her career to designing (hopefully) elegant databases and straightening up others’ not-so-elegant databases. Audrey has run the gamut from Database Developer to Production DBA to Architect.  

 

About Julie Smith:

Julie Smith has spent the last 12 years bending data using varied tools such as MS Access, MySQL, and SQL Server 2000-2012. She is a Consultant at Innovative Architects.  She is an active speaker, blogger and writer in the Microsoft SQL Server Community.   She is one of the co-founders of The Cloverleaf School of Atlanta, which educates elementary aged children with ADHD, High Functioning Autism and other learning differences.  In spite of being a SQL Server MVP, she remains “very simple woman with warm fuzzy secret heart.”


Bibliography:  Audrey was a contributing author to Microsoft SQL Server 2012 Bible and Professional Microsoft SQL Server 2012 Administration.  Julie was a contributing author to  Microsoft SQL Server 2012 Bible and is the author of the soon to be published Joes 2 Pros Data Quality Services.

 



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 attend our event but still looking for low-cost, high quality training?  Don't miss SQL Saturday Atlanta #220.  For the cost of lunch, get a full day of top training!

 

Have questions about A Day of Datawarehousing with the DataChix To Benefit the Cloverleaf School? Contact The Cloverleaf School of Atlanta

When & Where


American Legion Post 251
2760 Duluth Highway 120
Duluth, GA 30096

Thursday, March 14, 2013 from 9:00 AM to 4:00 PM (EDT)


  Add to my calendar

Organizer

The Cloverleaf School of Atlanta

The Cloverleaf School is a private, non-profit elementary school that specializes in educating children with ADHD, high functioning autism, and other learning differences to equip them with the skills needed to navigate the world with confidence.

We take “Quo Vadis?” (“where are you going?”) as our motto because we believe every child’s outcome can be influenced and is not a predetermined and immutable destiny.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.