Skip Main Navigation
Page Content
This event has ended

From Here to BI: Data Warehousing from Start to Finish

SQL Saturday #242

Friday, August 9, 2013 from 8:30 AM to 4:30 PM (EDT)

From Here to BI: Data Warehousing from Start to Finish

Ticket Information

No tickets available.

Who's Going

Loading your connections...

Share From Here to BI: Data Warehousing from Start to Finish

Event Details

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

 

Topics include:

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

Topics include:

A tour of SSIS

Control Flow Basics

Data Flow Basics

How to load Dimensions with SSIS

How to load Facts with SSIS

Frameworks

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

 

Topics include:

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

 

Refund Policy
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 sqlsaturday242@sqlsaturday.com.

Have questions about From Here to BI: Data Warehousing from Start to Finish? Contact SQL Saturday #242

When & Where


Lids - Using the North Entrance, park in the North-East parking lot after the loading bays and use the main entrance
7555 Woodland Drive
Indianapolis, IN 46278

Friday, August 9, 2013 from 8:30 AM to 4:30 PM (EDT)


  Add to my calendar

Organizer

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

  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.