Speaker: Elizabeth Diamond, 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 here: SQLIS.com
Elizabeth Diamond of DesignMind 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.