Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition

Other Types of Modeling

SSAS supports additional capabilities that may affect the final modeling of your cube source schemas. In our experience, most clients start with the concepts presented in this chapter, load some sample data to validate both the data and the modeling concepts, and then add the more advanced capabilities.

Data Mining

Data mining capabilities have been enhanced with each version of SSAS, due to the growing number and increasing sophistication of data mining algorithms. Data mining is the ability to use predefined algorithms to detect patterns in the data. Interestingly, SSAS's data mining capabilities can be used with either OLTP or OLAP source data. Data mining is covered in more detail in Chapter 14, “Introduction to Data ...