DSS Example One
This Silicon Valley computer company has implemented a traditional data warehouse using a star-schema approach. A star schema provides multiple paths (dimensions) to the central data facts. As you can see in Figure 3.4, a decision support user can get to their Sales Units, Sales Price, and Sales Returns through a Geographic dimension, a Time dimension, and a Product dimension. This allows questions such as “What were net sales like for North America for a particular month for a specific computer product?” SQL Server Integration Services (SSIS) packages populate this data warehouse and conformed dimensions on a daily basis with deltas (new data changes only). The data warehouse is unavailable for about 1 hour each night as daily ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
