Data Warehouse Dimensional Design and Architectural Planning - SQL Saturday #104 Precon
Friday, January 6, 2012 from 8:00 AM to 5:00 PM (MST)
Colorado Springs, CO
Data Warehouse Dimensional Design and Architecture Planning
A successful data warehouse project begins with the right design and planning. Conversely, poor design leads to bad performance, limited scalability, and even user rejection. This seminar covers the design principles of data warehouse solutions focusing on dimensional modeling techniques and then the planning steps involved in the solution architecture.
By laying the foundation to dimensional modeling, this seminar begins with an overview of dimensional design theory and the structures involved in data marts and data warehouses. We will review the core aspects of dimension table—surrogate keys, attributes, and hierarchies—as well as advanced hierarchy types and the best practices in tracking changes historically. In addition, fact tables hold the core data that you are analyzing and are a critical component to design right the first time. We will dive into fact table types and consider the various kinds of columns, measures, aggregation, and also volume considerations. Most importantly, we will discuss how to choose the right dimension and fact types based on business requirements.
Planning your data warehouse infrastructure and architecture is another up-front step critical to a successful solution. This includes estimating user load and volume, selecting the right hardware platform, and planning a partitioning and indexing strategy. Altogether, the dimensional modeling best practices and architecture planning you will learn in this seminar will set the stage for a scalable solution that adds value to your business users.
Prerequisites: This seminar requires a general understanding of business intelligence or data warehouse concepts and some experience working with relational databases.
Erik Veerman is the Director of Business Intelligence for SolidQ focusing on training, mentoring and architecting solutions on the SQL Server BI platform. His industry recognition includes Microsoft's Worldwide BI Solution of the Year and SQL Server Magazine's Innovator Cup winner. Erik has designed dozens of BI solutions across a broad business spectrum-telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high volume multi-terabyte environments has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, Erik is a presenter, author and instructor. He has helped drive the industry ETL standards and best practices for SSIS through his WROX books on SSIS and is the lead author of Microsoft Press SQL Server BI training kits.
Brought to you by: