Professional Microsoft SQL Server 2014 Integration Services, Knight Brian, Knight Devin, Moss Jessica M.

Автор: Harinath
Название: Professional Microsoft SQL Server 2012 Analysis Services with MDX
ISBN: 1118101103 ISBN-13(EAN): 9781118101100
Издательство: Wiley
Рейтинг:
Цена: 47520.00 T
Наличие на складе: Поставка под заказ.
Описание: Professional SQL Server 2011 Analysis Services with MDX and DAX shows readers how to build sophisticated business intelligence solutions using SQL Server Analysis Services, along with SQL Server Integration and Reporting Services.   The authors begin with an overview showing how Analysis Services can be used to build data warehouses and multi-dimensional databases.  They then quickly move to a tutorial that describes the development process for building dimensions and cubes from various data sources. The authors show how MDX and the more simplified version of MDX, DAX,  can be used to query databases to provide sophisticated analysis of business problems.  They will demonstrate a variety of techniques against real-world case scenarios.   They will also show how Analysis Services can be used with other components of SQL Server, including Integration Services, Reporting Services, and Data Mining to provide comprehensive, end-to-end solutions. The 2011 book will be more than 50% new and revised to cover new features and enhancements, including:  Improved integration with Excel and SharePoint 2010 The new DAX language, which is a more simplified, user-friendly version of MDX. PowerPivot,  a new tool for performing simplified analysis of data. Integration of Analysis Services with PowerPivot, plus enhancements to PowerPivot, including Key Performance Indicators. The new Business Intelligence Semantic Model (BISM). Significant enhancements to Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) A new BI tool, code-named Crescent, that will revolutionize how data is reported. Integration with the Vertipaq engine for improved performance.

Автор: Mark Chaffin
Название: Professional SQL Server 2000 DTS (Data Transformation Services)
ISBN: 0764543687 ISBN-13(EAN): 9780764543685
Издательство: Wiley
Рейтинг:
Цена: 38010.00 T
Наличие на складе: Поставка под заказ.
Описание: What is this book about? (DTS) Data Transformation Services helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; however, SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data--driven applications, offering rapid and effective solutions to a wide range of common problems. Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential. What does this book cover? Here are just a few of the things you'll find covered in this book: A detailed explanation of the seventeen principal DTS tasks Connecting to, querying, and converting heterogeneous data Dynamic configuration of your DTS packages Enhancing your DTS packagwith VBScript and Visual Basic Writing your own custom tasks Using DTS in a data--warehousing environment Employing DTS in other applications Who is this book for? This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.