2010 Meeting Schedule
| Date |
Subject |
Speaker |
| January 19 |
What All Microsoft BI Developers Need to Know About MDX |
Nathan Peterson (Solid Quality Mentors) |
| February 16 |
What's New in SQL Server 2008 R2? |
Phil Hummel (WinWire Technologies)
Allan Naim (Microsoft) |
| March 16 |
Architecting and Developing ETL for your Data Warehouse using SSIS |
Elizabeth Diamond (DesignMind) |
| April 20 |
Intro to Windows Server AppFabric for SQL Server Developers |
Rama Ramani (Microsoft) |
| May 18 |
StreamInsight |
Allan Naim and Kevin Tsai (Microsoft) |
| June 15 |
SQL Server Performance Tuning for Race Car Drivers |
Brent Ozar (Quest) |
Next Meeting: Mountain View - Tuesday, March 16 - 6:30 pm
Architecting and Developing ETL for your Data Warehouse using SSIS
Presented by: Elizabeth Diamond, DesignMind
Data Warehouse Architect, ETL Architect and Microsoft BI Expert
This session will focus on best practices and tips on how to design and develop a Data Warehouse using Microsoft SQL Server SSIS. Elizabeth will discuss how to use SQL Server 2008 as your data warehouse DB and SSIS as your ETL Tool.
You Will Learn:
- How to Architect an ETL for data warehouse and system integration
- The components of the data warehouse and ETL strategies for each
- How to Profile data and understand your source systems
- The staging area of the data warehouse
- ETL – How to Move data through your data warehouse system
Who Should Attend?
Any business or IT professional embarking on building an ETL effort within their data warehouse or systems integration, DBAs, data warehouse/ETL Architects, BI Application Developers, IT Consultants, and business Managers.
Microsoft Integration Services is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. Learn more about SSIS at SQLIS.com
Elizabeth Diamond is a DesignMind Consultant, Data Warehouse Architect, ETL Architect and Microsoft BI Expert. She has been a key member of teams that develop comprehensive Enterprise Data Management Systems since 1986. As the Lead Data Warehouse Architect and ETL Developer she has been responsible for implementing end-to-end Data Warehouse systems providing companies with valuable information resulting in business growth. She has been designed data warehouses for small to Fortune 500 organizations from Wall Street to Silicon Valley.
Elizabeth has conducted data warehouse training, written articles, and spoken nationwide on topics such as Building the Connection Between Your Business and Your IT Infrastructure, Developing Your Enterprise Data Warehouse Using Business Processes and many other Data Warehouse Architecture and ETL topics.
RSVP To reserve your place or for more information email Mark Ginnebaugh *Please email before noon on the day of the meeting.
Location Meetings are held at the Microsoft Office at 1065 La Avenida, Building 1, Mountain View, CA 94043.
Cost No charge
General Agenda
6:30 to 7:00 pm - Introductions, food, networking
7:00 to 8:30 pm - Presentation and Q&A