DSS Example Two
This same Silicon Valley computer company has also implemented some of this same data in a more complex Analysis Services OLAP cube for data-mining purposes. They have many things that they do not know about their sales data and want to do complex trending and forecasting to better understand the demand for products worldwide. Figure 3.5 shows the OLAP cube that is built into Analysis Services for this complex BI purpose. Several demand forecasting and product sales trending models have been developed that allow this company to predict sales by each of their products within each geography.
FIGURE 3.5 Multidimensional OLAP cube ...
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.
