Practical Dmx Queries for Microsoft Sql Server Analysis Services 2008: 250+ ready-to-use-queries - Softcover

Tennick, Art

 
9780071748667: Practical Dmx Queries for Microsoft Sql Server Analysis Services 2008: 250+ ready-to-use-queries
Softcover
ISBN 10: 0071748660 ISBN 13: 9780071748667
Verlag: McGraw-Hill Osborne Media, 2010

Inhaltsangabe

Extract real, actionable business intelligence using DMX
Practical DMX Queries for SQL Server Analysis Services shows how to write DMX queries within Microsoft s 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

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

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.

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
McGraw-Hill Osborne Media
Erscheinungsdatum
2010
Sprache
Englisch
ISBN 10 
0071748660
ISBN 13 
9780071748667
Einband
Taschenbuch
Anzahl der Seiten
336
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Nicht verfügbar