Practical DMX queries for SQL server analysis services

  • 1 Want to read

My Reading Lists:

Create a new list

Check-In

×Close
Add an optional check-in date. Check-in dates are used to track yearly reading goals.
Today

  • 1 Want to read


Download Options

Buy this book

Last edited by MARC Bot
September 1, 2024 | History

Practical DMX queries for SQL server analysis services

  • 1 Want to read

"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 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"--

"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"--

Publish Date
Publisher
McGraw-Hill
Language
English
Pages
308

Buy this book

Previews available in: English

Book Details


Table of Contents

Machine generated contents note: 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.

Edition Notes

Published in
New York
Other Titles
Practical data mining extensions for SQL server analysis services

Classifications

Dewey Decimal Class
005.75/85
Library of Congress
QA76.9.D343 T365 2010, QA76.9.D343, QA76.9.D343 T365 2011

The Physical Object

Pagination
p. cm.
Number of pages
308

ID Numbers

Open Library
OL24479016M
Internet Archive
practicaldmxquer2008tenn
ISBN 13
9780071748667
LCCN
2010037506
OCLC/WorldCat
649800009, 757519352

Community Reviews (0)

Feedback?
No community reviews have been submitted for this work.

Lists

This work does not appear on any lists.

History

Download catalog record: RDF / JSON
September 1, 2024 Edited by MARC Bot import existing book
August 2, 2020 Edited by ImportBot import existing book
July 6, 2019 Edited by MARC Bot import existing book
November 30, 2010 Created by ImportBot initial import