Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 by Art TennickPractical DMX Queries for Microsoft SQL Server Analysis Services 2008 by Art Tennick

Practical DMX Queries for Microsoft SQL Server Analysis Services 2008

byArt Tennick

Paperback | October 8, 2010

Pricing and Purchase Info

$53.35 online 
$59.95 list price save 11%
Earn 267 plum® points

Prices and offers may vary in store

Quantity:

In stock online

Ships free on orders over $25

Not available in stores

about

250+ Ready-to-Use, Powerful DMX Queries

Transform 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 queries
  • Examine the content of a data mining model with DMX Content queries
  • Perform DMX Prediction queries based on the Decision Trees algorithm and the Time Series algorithm
  • Run Prediction and Cluster queries based on the Clustering algorithm
  • Execute Prediction queries with Association and Sequence Clustering algorithms
  • Use DMX DDL queries to create, alter, drop, back up, and restore data mining objects
  • Display various parameters for each algorithm with Schema queries
  • Examine the values of discrete, discretized, and continuous structure columns using Column queries
  • Use graphical interfaces to generate Prediction, Content, Cluster, and DDL queries
  • Deliver DMX query results to end users

    Download the source code from www.mhprofessional.com/computingdownload

Art Tennick has worked in relational database design and SQL queries for more than 20 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Art is the author of Practical MDX Queries for Microsoft SQL Server Analysis Services 2008 and Practical PowerPivot & DAX Formulas for Exc...
Loading
Title:Practical DMX Queries for Microsoft SQL Server Analysis Services 2008Format:PaperbackDimensions:336 pages, 9 × 7.4 × 0.7 inPublished:October 8, 2010Publisher:McGraw-Hill EducationLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0071748660

ISBN - 13:9780071748667

Look for similar items by category:

Reviews

Table of Contents

Chapter 1 Cases Queries
Chapter 2 Content Queries
Chapter 3 Prediction Queries with Decision Trees
Chapter 4 Prediction Queries with Time Series
Chapter 5 Prediction and Cluster Queries with Clustering
Chapter 6 Prediction Queries with Association and Sequence Clustering
Chapter 7 DDL (data definition language) Queries
Chapter 8 Schema and Column Queries
Chapter 9 After You Finish
Appendix A Graphical Content Queries
Appendix B Graphical Prediction Queries
Appendix C Graphical DDL Queries