Art Tennick – författare
739 kr
Skickas inom 3-6 vardagar
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.
300+ ready-to-use, powerful MDX queries
This hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.
Work with dimensions, hierarchies, levels, and membersNavigate both horizontally and vertically across dimensions and hierarchiesSort the results of your queriesAccess subsets of dimension members and measure values using the Where clause and Filter functionUse MDX query calculationsExtract and manipulate dates and timesProduce totals, subtotals, and changes cross time using aggregate and other functionsCreate, visualize, and manipulate setsWork with perspectives, subselects, and subcubesDisplay and hide empty cellsUse, modify, format, and create Key Performance Indicators (KPIs)Deliver MDX query results to end users
599 kr
Skickas inom 3-6 vardagar
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 DAX formulas
Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide.
Build pivot tables and charts with PowerPivot for ExcelImport information from Access, Excel, data feeds, SQL Server, and other sourcesOrganize and format BI reports using the PowerPivot Field ListWrite DAX formulas that filter, sort, average, and denormalize dataConstruct complex DAX formulas from statistical, math, and date functionsCompare current and past performance using date and time intelligenceHandle non-additive numbers, non-numeric values, and running totalsDevelop complete self-service and sharable BI solutions in a few minutesDownload the source code from www.mhprofessional.com/computingdownload
720 kr
Skickas inom 3-6 vardagar
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.
400+ ready-to-use, powerful SQL queries
Learn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries for Microsoft SQL Server 2008 R2 contains more than 400 downloadable SQL queries you can use to extract meaningful insights from large amounts of data. The application, syntax, and results of each query are described in detail. The book emphasizes SQL for use in SSMS, but the queries also apply to SSRS, WinForms, WebForms, and many other applications.
Enter, maintain, and retrieve database dataSearch records using the Where clauseSort SQL query results with the Order By clauseCreate tables and perform joins on tablesPerform set operations using Union, Intersect, and ExceptGroup data and produce totals with the Group By clauseManipulate and transform data using built-in functionsCreate reusable views and user-defined functionsUse stored procedures to change SQL dynamically based on conditional factorsCreate, maintain, and secure database objects with DDL and DCLDeliver SQL query results to end users
524 kr
Skickas inom 3-6 vardagar
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 queriesExamine the content of a data mining model with DMX Content queriesPerform DMX Prediction queries based on the Decision Trees algorithm and the Time Series algorithmRun Prediction and Cluster queries based on the Clustering algorithmExecute Prediction queries with Association and Sequence Clustering algorithmsUse DMX DDL queries to create, alter, drop, back up, and restore data mining objectsDisplay various parameters for each algorithm with Schema queriesExamine the values of discrete, discretized, and continuous structure columns using Column queriesUse graphical interfaces to generate Prediction, Content, Cluster, and DDL queriesDeliver DMX query results to end usersDownload the source code from www.mhprofessional.com/computingdownload