This text covers the topic of building business intelligence solutions using SQL Server 2000 from three different perspectives: developers, business analysts, and project managers. The data warehousing methodology introduced is not only simple, but should help to save developmental costs. Joseph Valiaveedu discusses in detail how to build an OLAP solution using SQL Server 2000 Analysis Services in many different business scenarios. Part One of the book discusses the topics of data warehousing and business intelligence with a new twist from the traditional solution methodologies. The text removes the mystery around data warehousing and introduces a simpler methodology that should help IT departments to deliver solutions that are needed by their business groups in a short time, with incremental deliverables, also ensuring end user participation. Part Two discusses building the OLAP solution using SQL Server 2000 Analysis Services in many different business scenarios. Part Three discusses programming and developing front-end solutions with Analysis Services using .NET Framework and XML.
It also discusses DTS (Data Transformation Services) that is helpful in building cost effective ETL solutions for data load into the data warehouse. Other topics include integrating with sharepoint portal, developing mobile analytical solutions, and data mining. Real code and examples in programming and developing solutions with Analysis Services using .NET Framework and XML are included. The examples on building ETL applications using DTS will be useful to database implementers. Other topics include integrating with sharepoint portal and developing mobile analytical solutions. SQL Server 2000 and Business Intelligence in an XML/.NET World covers the topic of data warehousing and business intelligence in a detailed, yet concise manner. After covering the basics of data warehousing, Valiaveedu drills down and covers XML, shows how to use analysis services as a Web service, and describes how to best ensure security.
Sprache
Verlagsort
Verlagsgruppe
Springer-Verlag Berlin and Heidelberg GmbH & Co. KG
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Professional/practitioner
Maße
Höhe: 235 mm
Breite: 189 mm
ISBN-13
978-1-59059-004-1 (9781590590041)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Part I: Data warehousing and business intelligence for managers. Chapter 1 Business intelligence and data warehousing concepts: towards better business intelligence systems - reporting, forecasting, CRM; enterprise business intelligence; measures, dimensions, and cubes; enterprise business intelligence framework. Chapter 2 BI strategy and project life cycle: developing a business intelligence strategy; success factors; project team; project methodology. Chapter 3 Building the data warehouse: overview of building a data warehouse; identifying the business user/information needs; integrating multiple data sources (commerce server, CRM); selecting the first data mart; designing the data warehouse schema; model implementation notes; data mapping; creating the data warehouse database; extraction, transformation, and load. Chapter 4 Utilizing the data warehouse/data mart: utilizing the data from the data warehouse/data mart; overview of data access methods. Part II: SQL server analysis services. Chapter 5 Introduction to analysis services: about analysis services; installing analysis services; using analysis manager; uninstalling analysis services. Chapter 6 Implementing an OLAP solution: about OLAP database; setting up an OLAP database; creating an OLAP database; defining data sources; defining dimensions; virtual dimensions; saving and processing dimensions; cubes; choosing cube architecture; processing cubes; archiving and restoring an OLAP database. (part contents).
