Sql server® 2012 t-sql fundamentals

12  

Microsoft SQL Server 2012 T-SQL Fundamentals

See Also  This section about BISM has a lot of concepts to digest—perhaps too many for a fundamentals 

book about T-SQL. If you are curious about BISM and would like a more detailed overview, you can find it 

in the following blog entry from the Analysis Services team: http://blogs.msdn.com/b/analysisservices 

/archive/2011/05/16/analysis-services-vision-amp-roadmap-update.aspx.

data Mining

BISM provides the user with answers to all possible questions, but the user’s task is to ask the right 

questions—to sift anomalies, trends, and other useful information from the sea of data. In the dy-

namic analysis process, the user navigates from one view of aggregates to another—again, slicing 

and dicing the data—to find useful information. 

Data mining (DM) is the next step; instead of letting the user look for useful information in the 

sea of data, data mining models can do this for the user. That is, data mining algorithms comb the 

data and sift the useful information from it. Data mining has enormous business value for organiza-

tions, helping to identify trends, figure out which products are purchased together, predict customer 

choices based on specific parameters, and more. 

Analysis Services supports data mining algorithms—including clustering, decision trees, and others—

to address such needs. The language used to manage and query data mining models is Data Mining 

Extensions (DMX).