The Microsoft data warehouse toolkit with SQL server 2008 R2 and the Microsoft Business Intelligence toolset

Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming “Business Intelligence release” of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the a...

Descripción completa

Detalles Bibliográficos
Autor principal: Mundy, Joy, 1961- (-)
Otros Autores: Thornthwaite, Warren, 1957-, Kimball, Ralph
Formato: Libro electrónico
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley c2011.
Edición:2nd ed
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628885406719
Tabla de Contenidos:
  • Introduction
  • Part 1: Requirements, Realities, and Architecture
  • Chapter 1. Defining Business Requirements
  • Chapter 2. Designing the Business Process Dimensional Model
  • Chapter 3. The Toolset
  • Chapter 4. System Setup
  • Part 2: Building and Populating the Databases
  • Chapter 5. Creating the Relational Data Warehouse
  • Chapter 6. Master Data Management
  • Chapter 7. Designing and Developing the ETL System
  • Chapter 8. The Core Analysis Services OLAP Database
  • Chapter 9. Design Requirements for Real-Time BI
  • Part 3: Developing the BI Applications
  • Chapter 10: Building BI Applications in Reporting Services
  • Chapter 11. Power Pivot and Excel
  • Chapter 12. The BI Portal and SharePoint
  • Chapter 13. Incorporating Data Mining
  • Part 4: Deploying and Managing the DW/BI System
  • Chapter 14: Designing and Implementing Security
  • Chapter 15. Metadata Plan
  • Chapter 16. Deployment
  • Chapter 17. Operations and Maintenance
  • Chapter 18. Present Imperatives and Future Outlook.