Professional SQL Server 2000 Data Warehousing with Analysis Services

Professional SQL Server 2000 Data Warehousing with Analysis Services

4.0 1
by Chris Graves, Robin Dewson, Sam Ferguson, Mike Benkovich
     
 

View All Available Formats & Editions

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… See more details below

Overview

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 discussion of the exciting new topic of Web Housing.

By reading this book, you will learn how best to employ data warehousing and OLAP in your business, and how to leverage it to provide your organization with improved revenue and profitability.

This book covers:

  • Understanding Analysis Services Architecture
  • Designing Data Warehouses and Data Marts
  • Using Data Transformation Services (DTS) in Data Warehousing
  • Techniques for Data Mining and Analysis
  • Building OLAP cubes with Analysis Manager, and programmatically through DSO
  • Securing, Administrating and Optimizing a Data Warehouse and OLAP system
  • Using Multidimensional Expressions (MDX) to query OLAP cubes
  • Building OLAP client applications with Visual Basic and ASP
  • English Query, PivotTable Service

    This book is aimed at the SQL Server developer who wishes to learn about the enhanced data warehousing features and new services available in SQL Server 2000 Analysis Services, and IT professionals and managers who wish to investigate SQL Server's data warehousing capabilities.

    Author Biography: Christopher Graves is President of RapidCF, a ColdFusion development company in Canton Connecticut. Chris leads projects with Oracle 8i and SQL Server 2000 typically coupled to web based solutions.

    Mark Scott serves as a consultant for RDA, a provider of advanced technology consulting services. He develops multi-tier, data-centric web applications. He is a Microsoft Certified System Engineer + Internet, Solution Developer, Database Administrator and Trainer.

    As a partner of a consulting firm, Applied Technology Group, Mike Benkovich has a broad range of experience with development technologies and platforms. Besides SQL Server, he has worked extensively with Informix, Oracle, C++, Visual Basic, PowerBuilder and Unix.

    Paul Turley is a Senior Instructor and Consultant for SQL Soft+ Training and Consulting in Beaverton, Oregon and Bellevue, Washington. He specializes in database solution development, software design, programming, and project management frameworks.

    Robert Skoglund is President and Managing Director of RcS Consulting Services, Inc. Robert also provides certified training services to Microsoft Certified Technical Education Centres nationwide and internationally.

    Sakhr Youness is a senior architect at Commerce One, Inc. He is a professional engineer and a Microsoft certified solution developer who has experience in data modelling, business-to-business (B2B) applications, client server and database application development.

    Denny Lee is the Lead OLAP Architect at digiMine, Inc. (Bellevue, WA), a leading analytic services company specializing in data warehousing, data mining and business intelligence. His primary focus is delivering powerful, scalable, enterprise-level OLAP solutions that provide customers with the business intelligence insights needed to act on their data.

    Robin Dewson is currently working on a system called "Vertigo", replacing the old trading system called "Kojak". He has been with a large US Investment bank in the City of London for over 5 years.

    Sam Ferguson is an IT Consultant with API Software, a growing IT Solutions Company based in Glasgow, Scotland. Sam works in various fields but specialises in Visual Basic, SQL Server, XML, and all things .Net.

    Tony Bain (MCSE, MCSD, MCDBA) is a senior database consultant for SQL Services. While he has experience with various database platforms, SQL Server has been the focus of his attention. During this time he has been responsible for the design, development and administration of numerous SQL Server based solutions.

    Terrence Joubert is a Software Engineer working with Victoria Computer Services. He also works as a freelance Technical Reviewer for several publishing companies. As a developer and aspiring author, Terrence enjoys reading about and experimenting with new technologies, especially the Microsoft .Net products.

    Read More

    • Product Details

    ISBN-13:
    9781861005403
    Publisher:
    Wrox Press, Inc.
    Publication date:
    10/01/2001
    Series:
    Professional Ser.
    Pages:
    800
    Product dimensions:
    7.28(w) x 9.01(h) x 1.53(d)

    Customer Reviews

    Average Review:

    Write a Review

    and post it to your social network

         

    Most Helpful Customer Reviews

    See all customer reviews >