modeling Archive
-
SSWUG vConf – Intro to SQL Server Analysis Services
Posted on April 24, 2009 | No CommentsPresenter: 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... -
SSWUG vConf – Loading a Data Warehouse in SSIS
Posted on April 23, 2009 | No CommentsPresenter: 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... -
SSWUG vConf – Fact Table Design 101
Posted on April 23, 2009 | No CommentsPresenter: 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... -
SSWUG vConf – Dimension Table Design 101
Posted on April 23, 2009 | No CommentsPresenter: 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... -
SSWUG vConf – Dimensional Modeling 101
Posted on April 23, 2009 | No CommentsPresenter: 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...
