Présentation de l'éditeur
Design, Build, and Manage High-Value BI Solutions with SQL Server 2005
In this book, two of Microsoft�??s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft�??s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.
Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the book�??constructing solutions. Each chapter-length case study begins with the customer�??s business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You�??ll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation.
Whether you�??re a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you�??ll need to derive maximum business value from any BI project.
�?� Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services
�?� Build data warehouses and extend them to support very large databases
�?� Design effective Analysis Services databases
�?� Ensure the superior data quality your BI system needs
�?� Construct advanced enterprise scorecard applications
�?� Use data mining to segment customers, cross-sell, and increase the value of each transaction
�?� Design real-time BI applications
�?� Get hands-on practice with SQL Server 2005�??s BI toolset
Quatrième de couverture
Design, Build, and Manage High-Value BI Solutions with SQL Server 2005
In this book, two of Microsoft�??s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft�??s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.
Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the book�??constructing solutions. Each chapter-length case study begins with the customer�??s business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You�??ll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation.
Whether you�??re a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you�??ll need to derive maximum business value from any BI project.
�?� Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services
�?� Build data warehouses and extend them to support very large databases
�?� Design effective Analysis Services databases
�?� Ensure the superior data quality your BI system needs
�?� Construct advanced enterprise scorecard applications
�?� Use data mining to segment customers, cross-sell, and increase the value of each transaction
�?� Design real-time BI applications
�?� Get hands-on practice with SQL Server 2005�??s BI toolset
