Synopses & Reviews
Extract real, actionable business intelligence using DMX
Practical DMX Queries for SQL Server Analysis Services shows how to write DMX queries within Microsofts BI stack. This solutions-based guide contains more than 240 DMX queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:
- Query: Introduction and description of query and its use
- Syntax: Complete syntax
- Result: Screen shot showing the data returned from the Analysis Services data mining model by the query
- Analysis: Analysis of the results and tips for customization
Specific emphasis is placed on writing DMX for use within Microsoft SQL Server Management Studio (SSMS) connected to Microsoft SQL Server Analysis Services (SSAS) – however, the techniques and queries can also be utilized across Reporting Services (SSRS), Integration Services (SSIS), WinForms and WebForms, and in a large variety of third-party front-ends.
Practical DMX Queries for SQL Server Analysis Services:
- Includes 240+ ready-to-use, easily customizable DMX queries, all available for download
- Features a practical, hands-on approach with a minimum of difficult concepts and theory
- Explains how to visualize actionable BI
- Shows how to surface knowledge discovery and make informed predictions quickly
- Helps to dramatically improve analysis and decision-making skills
Complete coverage of DMX queries
Cases Queries; Content Queries; Prediction Queries with Decision Trees; Prediction Queries with Time Series; Prediction and Cluster Queries with Clustering; Prediction Queries with Association and Sequence Clustering; DDL (data definition language) Queries; Schema and Column Queries
Synopsis
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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
Synopsis
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
About the Author
Art Tennick has worked in relational database design and SQL queries for more than 20 years and multidimensional database design, cubes, and DMX and MDX queries for 10 years. He has worked with several major corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2010. Art is the author of several books and hundreds of articles for computer magazines in the U.S., UK, and Ireland. His web site is www.MrCube.net.
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