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

Art Tennick

Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 (Paperback)
  • 出版商: McGraw-Hill Education
  • 出版日期: 2010-10-08
  • 售價: $1,960
  • 貴賓價: 9.5 折 $1,862
  • 語言: 英文
  • 頁數: 336
  • 裝訂: Paperback
  • ISBN: 0071748660
  • ISBN-13: 9780071748667
  • 相關分類: MSSQL、SQL

    • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

相關主題

商品描述

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

商品描述(中文翻譯)

250+ 可立即使用的強大 DMX 查詢

使用資料探勘擴展 (DMX) 語言將資料探勘模型資訊轉換為可行的商業智慧。《實用 DMX 查詢：Microsoft SQL Server Analysis Services 2008》包含超過 250 個可下載的 DMX 查詢，您可以用來提取和視覺化資料。每個查詢的應用、語法和結果都有詳細說明。本書強調在 SSMS 中針對 SSAS 使用 DMX，但這些查詢同樣適用於 SSRS、SSIS、SQL 中的 DMX、WinForms、WebForms 及許多其他應用程式。本資源還展示了如何從圖形工具生成 DMX 語法的技術。

- 使用 DMX Case 查詢查看資料探勘結構和模型中的案例
- 使用 DMX Content 查詢檢查資料探勘模型的內容
- 根據決策樹演算法和時間序列演算法執行 DMX 預測查詢
- 根據聚類演算法運行預測和聚類查詢
- 使用關聯和序列聚類演算法執行預測查詢
- 使用 DMX DDL 查詢創建、修改、刪除、備份和還原資料探勘物件
- 使用 Schema 查詢顯示每個演算法的各種參數
- 使用 Column 查詢檢查離散、離散化和連續結構欄位的值
- 使用圖形介面生成預測、內容、聚類和 DDL 查詢
- 將 DMX 查詢結果傳遞給最終用戶

從 www.mhprofessional.com/computingdownload 下載源代碼

類似商品