Professional SQL Server

Analysis Services 2005 with MDX

Book Details:

Publisher:	Wrox
Series:	Wrox , Professional
Author:	Sivakumar Harinath
Edition:	1
ISBN-10:	0764579185
ISBN-13:	9780764579189

Pages:	864
Published:	May 30 2006
Posted:	Nov 19 2014
Language:	English
Book format:	CHM
Book size:	72.41 MB

Book Description:

Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databasesThe authors then describe the development processes for building dimensions and cubes from various data sourcesDemonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problemsFinally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

Download Link:

Related Books:

Professional SQL Server 2000

Data Warehousing with Analysis Services

Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise. In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and optimize your data warehouse. There is also an in-depth...

Professional SQL Server 2005 Integration Services

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.What you will learn from this bookWays to quickly move and transform dataHow to configure every aspect of SSISHow to interface SSIS with web services and XMLTechniques to scale the SSIS and make it more reliableHow to migrate DTS packages to SSISHow to create your own custom tasks and user interfacesHow to create an application that interfaces with SSIS to manage the environmentA detailed us...

Professional SQL Server 2008

Internals and Troubleshooting

A hands-on resource for SQL Server 2008 troubleshooting methods and toolsSQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operatin...