Skip Main Navigation
Page Content

Save This Event

Event Saved

Looks like this event has already ended.

Check out upcoming events by this organizer, or organize your very own event.

View upcoming events Create an event

Data Warehouse Dimensional Design and Architectural Planning - SQL Saturday #104 Precon

Colorado Springs SQL Server User Group

Friday, January 6, 2012 from 8:00 AM to 5:00 PM (MST)

Data Warehouse Dimensional Design and Architectural...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Data Warehouse - SQL Saturday #104 Precon Ended Free $0.00

Share Data Warehouse Dimensional Design and Architectural Planning - SQL Saturday #104 Precon

Event Details

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:


Confio Software

Have questions about Data Warehouse Dimensional Design and Architectural Planning - SQL Saturday #104 Precon? Contact Colorado Springs SQL Server User Group

When & Where

Mr. Biggs Family Fun Center
5755 Mark Dabling Blvd
Colorado Springs, CO 80919

Friday, January 6, 2012 from 8:00 AM to 5:00 PM (MST)

  Add to my calendar

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.