business intelligence Archive
-
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... -
SSWUG vConf – Analysis Services End-to-End
Posted on April 22, 2009 | No CommentsPresenter: Craig Utley craig@solidq.com DB –> SSIS –> Relational Data Warehouse –> SSAS (Cubes) –> SSRS Data Sources SSAS Projects have one or more data sources that point to data... -
SSWUG vConf – Best Practices SSAS 2005 and 2008
Posted on April 22, 2009 | No CommentsPresenter: Craig Utley, Mentor with Solid Quality Mentors craig@solidq.com http://learnmicrosoftbi.com General Design SSAS 2005 and 2008 are extremely different from SSAS 2000 Upgrading from 200 might work on small simple... -
SSWUG Vconf – The Accidental Business Intelligence Administrator
Posted on April 22, 2009 | No CommentsBelow I am posting some of my notes from the various sessions, along with comments, observations and occasional odd humor. The Accidental Business Intelligence Administrator This session is designed for...
