Tech4Him – Technology with Integrity

A Christian technology chaos wrangler and his thoughts

SSWUG vConf – Intro to SQL Server Analysis Services

Posted by Tom On April - 24 - 2009

312795799_42d968acecPresenter: Brian Knight
bknight@pragmaticworks.com

Is your customer looking for drag and drop reports or capabilities inside of Excel. SQL Server Analysis Services (SSAS) is the answer for you then. You’ll be amazed how quickly you can develop sophisticated reports after watching the basics of this session. Read the rest of this entry »

Popularity: 10% [?]

SSWUG vConf – Loading a Data Warehouse in SSIS

Posted by Tom On April - 23 - 2009

2089748072_b60a211f97Presenter: Brian Knight
bknight@pragmaticworks.com
Owner, Pragmatic Works

In this session, you’ll learn how to load a typical data warehouse in SSIS efficiently. You’ll start by seeing some of the strengths and weaknesses of the Slowly Changing Dimension (SCD) Wizard in SSIS and how you can get around some of the weaknesses including your own home-brewed solution. You’ll then see how to load a fact table using SSIS and how to make the common components scale. Read the rest of this entry »

Popularity: 19% [?]

SSWUG vConf – Fact Table Design 101

Posted by Tom On April - 23 - 2009

2580276686_9e502d4b5ePresenter: Erik Veerman
erik@solidq.com

In a Business Intelligence solution, the fact tables hold the core data that you are analyzing – facts (also called measures). Therefore, fact tables are a critical component to get right the first time. Poor fact table design will lead to poor performance and difficult calculations. This session dives into fact table and considers the basic column types, measure aggregation types, fact table types, and volume considerations. Read the rest of this entry »

Popularity: 4% [?]

SSWUG vConf – Dimension Table Design 101

Posted by Tom On April - 23 - 2009

2247481690_1976f16fdePresenter: Erik Veerman
erik@solidq.com

Dimension Tables are one of the core components in a dimensional design and it is critical to design your dimension tables correctly in order to lay a solid foundation to a Business Intelligence system. This session dives into the dimension design techniques and considers the core components of a dimension table, surrogate keys, attributes, and hierarchies. In addition, we will consider advanced hierarchy types such as parent-child hierarchies, snowflake designs and unbalanced hierarchies. Finally, we will consider the best practices in tracking changes historically. Read the rest of this entry »

Popularity: 6% [?]

SSWUG vConf – Dimensional Modeling 101

Posted by Tom On April - 23 - 2009

Presenter: Erik Veerman
erik@solidq.com

This session focuses on the basic design patterns for building relational database structures for Business Intelligence applications on SQL Server. By laying the foundation to dimensional modeling, this session provides an overview of dimension modeling theory and the justification of dimension modeling by reviewing the core structures involved in data marts and data warehouses and contrasting these design techniques to other types of systems. If you are new to Business Intelligence or feel you need a refresher on dimensional modeling, this session is for you. Read the rest of this entry »

Popularity: 4% [?]