A Practical Guide To Microsoft Olap Server - Shumate John

. .

Résumé :
With the introduction of Microsoft's OLAP Services, Online Analytical Processing (OLAP) technology has become a major force in today's marketplace. OLAP, which enables multidimensional databases for sophisticated decision support, is a technology that IT and database professionals need to know. Its a core technology of state-of-the-art customer management systems . budgeting and forecasting models . and sales, marketing, and financial performance analysis applications. Its also used in general-purpose "datamarts" that allow companies to monitor key business measures and discover the strategic opportunities they need to remain competitive in today's fast-paced e-commerce business environment. " A Practical Guide to Microsoft's OLAP Server " introduces you to OLAP technology and leads you step-by-step through the process of deploying an OLAP server, focusing in particular on Microsoft's OLAP Services. This book explains the basic concepts underlying OLAP, compares various OLAP products, and describes Microsoft's OLAP Services architecture. In addition, it enumerates the development life cycle of an OLAP Services application from planning and design through installation and administration, discussing the goals and approaches for each phase and task. " A Practical Guide to Microsoft's OLAP Server " also provides information on more advanced OLAP topics, including virtual cubes, merging database partitions, and custom OLAP development. Real-world examples demonstrate concepts and methods throughout the book, and plenty of practical advice will help you avoid trouble spots and achieve a smooth and successful deployment.

Biographie:
John Shumate is currently a Decision Support Consultant at Anteon Corporation in Fairfax, Virginia. His 16 years of experience in the development of business intelligence systems include work on large data warehouse projects for the United States Department of Housing and Urban Development, Capital Blue Cross, and the United States Postal Service. He taught courses in systems analysis and design and Visual Basic programming at George Washington University from 1993 to 1996 and is a member of the Data Warehousing Institute. John is also a Contributing Editor to "PC Week", and has published more than 25 articles on OLAP, business intelligence, and data warehousing. He has used Microsoft SQL Server extensively on numerous projects and bas been working with OLAP Services since its initial beta release in 1998. For this book, he used OLAP Services to develop and test the included examples and he interviewed the pioneers and early adopters of the OLAP industry.

Sommaire:
["BASICS","OLAP concepts","OLAP history and trends","Introduction to Microsoft SQL Server OLAP Services","IMPLEMENTATION : PLANNING, ANALYSIS, AND DESIGN","Planning the OLAP project","OLAP systems analysis","Designing your OLAP services solution","IMPLEMENTATION : CONSTRUCTION, RELEASE, AND SUPPORT","Installing OLAP services","Building the OLAP database","Using Excel as an OLAP Client","Managing the OLAP application","Third-party OLAP clients","BEYOND THE BASICS","Multidimensional expressions","Advanced application techniques."]