San Francisco, California
London, United Kingdom
SQL Server MVPs and blogging team Audrey Hammonds and Julie Smith of DataChix.com offer a training day chock full of data warehouse, ETL, and business intelligence goodness. 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. Finally, they'll show you how to present your data to users and give them the tools they need to make their business... intelligent.
Part I Dimensional Modeling with Audrey
So you have a transactional database... what's next?
Why Third Normal Form is Tough for Reporting
Aligning Business Needs with Your Modeling Plans
Getting started with Dimensional Modeling
From Codd to Kimball: How to get your data BI-ready
Facts about Dimensions and Facts
Here Comes the Grain Again: Granularity and You!
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
What happened and when
Queing auditing and error handling
When things go wrong, how to know the details
Top quirks of SSIS—what, why, and how to get around them.
Part III Expand your BI Toolkit with Julie and Audrey
DQS – Data Quality Services and ETL
MDS – Master Data Services and the Data Warehouse
PowerPivot – Convert business users into reporting experts
About the Speakers
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.
Julie Smith has spent the last 13 years bending data using varied tools such as MS Access, MySQL, and SQL Server 2000-2012. She is a Consultant at Innovative Architects, and an active speaker, blogger and writer in the Microsoft SQL Server Community. In spite of being a SQL Server MVP, she remains “very simple woman with warm fuzzy secret heart.”
Cancelations requested before 10:00pm EDT July 26, 2013 will receive a 100% refund
Cancelations requested between 10:00pm EDT July 26 and 10:00pm EDT August 5, 2013 will receive a 50% refund
No refunds after 10:00pm EDT August 5.
To cancel your registration and request a refund, please email email@example.com.
When & Where
SQL Saturday #242
SQLSaturday is a FREE training event for SQL Server professionals and those wanting to learn about SQL Server. We are very excited to bring this wonderful event back to Indy! This year the event will be held on Aug 10 2013 at Indiana Wesleyan University North. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited. Make sure to spread the word to let friends and colleages know about the event.
Details and registration: http://www.sqlsaturday.com/242/eventhome.aspx