Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 (eBook)

250+ Ready-to-Use, Powerful DMX QueriesTransform data mining model information into actionable business intelligence using the Data Mining Extensions (DMX) language. Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 contains more than 250 downloadable DMX queries you can use to extract and visualize data. The application, syntax, and results of each query are described in detail. The book emphasizes DMX for use in SSMS against SSAS, but the queries also apply to SSRS, SSIS, DMX in SQL, WinForms, WebForms, and many other applications. Techniques for generating DMX syntax from graphical tools are also demonstrated in this valuable resource. View cases within data mining structures and models using DMX Case queriesExamine the content of a data mining model with DMX Content queriesPerform DMX Prediction queries based on the Decision Trees algorithm and the Time Series algorithmRun Prediction and Cluster queries based on the Clustering algorithmExecute Prediction queries with Association and Sequence Clustering algorithmsUse DMX DDL queries to create, alter, drop, back up, and restore data mining objectsDisplay various parameters for each algorithm with Schema queriesExamine the values of discrete, discretized, and continuous structure columns using Column queriesUse graphical interfaces to generate Prediction, Content, Cluster, and DDL queriesDeliver DMX query results to end usersDownload the source code from www.mhprofessional.com/computingdownload