This event has ended

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)

Colorado Springs, CO

Data Warehouse Dimensional Design and Architectural...

Ticket Information

Type End     Quantity
Data Warehouse - SQL Saturday #104 Precon Ended Free  

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.


Biography

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:

SolidQ

SSWUG.org

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

Organizer

Colorado Springs SQL Server User Group

  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.