Die Daten-Warehallen haben sich entwickelt, um mit den riesigen Datenmengen am Arbeitsplatz zu bewältigen, indem sie die für die Berichterstellung und Entscheidung verwendeten Daten von den Betriebssystemen verwendet werden. Der Zweck des Data Warehouse ist einfach die Speicherung der Rohdaten und in Kombination mit Microsoft SQL Server 2000 Analysis Services können diese Daten in zugängliche Informationen umgewandelt werden, die die realen Faktoren widerspiegeln, die das Unternehmen beeinflussen. In diesem Buch stellen wir die Schlüsselkonzepte von Data Warehousing, OLAP und Data Mining vor. Neben der Abdeckung von Data Transformation Services (DTS) und MDX zeigt dieses Buch auch, wie man eine Analysis Services Client-Anwendung entwickelt und wie Sie Ihr Datenwarehouse sichern und optimieren können. Außerdem gibt es eine eingehende Diskussion über das aufregende neue Thema Web Housing. Durch das Lesen dieses Buches erfahren Sie, wie Sie Data Warehousing und OLAP in Ihrem Unternehmen am besten einsetzen und wie Sie es nutzen, um Ihrem Unternehmen einen verbesserten Einfluss und Rentabilität zu bieten. Dieses Buch umhüllt: 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 und programmatically through DSO Securing, Administrating and Optimizing a Data Warehouse and OLAP System Using Multidimensional Expressions (MDX) to Query OLAP System LAP Cubes Building O. LAP Client Anwendungen mit Visual Basic und ASP English Abfrage, PivotTable Service
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. Mike can be reached at mbenko@atgmn.com.
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. He can be reached at rskoglund@rcs-consulting-inc.com.
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. He can be reached at syouness@home.com.
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.