Published: September 2010
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 Excel 2010. His website is www.MrCube.net.
Keywords: PRACTICAL DMX QUERIES, SQL SERVER, ANALYSIS SERVICES, BOOK, GUIDE, HOW TO, ART TENNICK, CASES, QUERIES, CONTENT, PREDICTION, DECISION TREES, TIME SERIES, CLUSTER QUERIES, CLUSTERING, ASSOCIATION, SEQUENCE CLUSTERING, DDL, DATA DEFINITION LANGUAGE, SCHEMA, COLUMN QUERIES, BUSINESS INTELLIGENCE, MICROSOFT, SSAS, SSIS, SSRS, BUSINESS INTELLIGENCE, BI, CRYSTAL REPORTS 2008 THE COMPLETE REFERENCE, BUSINESSOBJECTS XI THE COMPLETE REFERENCE, DELIVERING BUSINESS INTELLIGENCE WITH MICROSOFT SQL SERVER 2008, MICROSOFT SQL SERVER 2008 REPORTING SERVICES, MICROSOFT SQL SERVER 2008 ANALYTICS & DATA VISUALIZATION, VISUALIZING INFORMATION WITH MICROSOFT OFFICE VISIO 2007, MICROSOFT OFFICE 2007 BUSINESS INTELLIGENCE 0071494243, BUSINESS INTELLIGENCE WITH MICROSOFT OFFICE PERFORMANCEPOINT SERVER 2007, SUCCESSFUL BUSINESS INTELLIGENCE, SAP BUSINESS INFORMATION WAREHOUSE REPORTING, CRCP CRYSTAL REPORTS CERTIFIED PROFESSIONAL ALL-IN-ONE EXAM GUIDE, ORACLE CRM ON DEMAND REPORTING, ORACLE DISCOVERER 10G HANDBOOK, APPLIED SAP BI 7.0 WEB REPORTS, THE POWER TO PREDICT, RESHAPING YOUR BUSINESS WITH WEB 2.0, CRM AT THE SPEED OF LIGHT, EVENT PROCESSING, HANDS-ON MICROSOFT SQL SERVER 2008 INTEGRATION SERVICES, BUILDING INTEGRATED BUSINESS INTELLIGENCE SOLUTIONS WITH SQL SERVER 2008 R2 & OFFICE 2010, IBM COGNOS 8 BUSINESS INTELLIGENCE: THE OFFICIAL GUIDE, DATA WAREHOUSE DESIGN, ORACLE ESSBASE & ORACLE OLAP, STAR SCHEMA THE COMPLETE REFERENCE, PRACTICAL POWERPIVOT & DAX FORMULAS FOR EXCEL 2010, PRACTICAL MDX QUERIES FOR MICROSOFT SQL SERVER ANALYSIS SERVICES 2008, PRACTICAL SQL QUERIES FOR SQL SERVER 2008
