Practical Business Intelligence with SQL Server 2005
Practical Business Intelligence with SQL Server 2005
ISBN: 0321356985
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 132
Pages: 132
Authors: John C. Hancock, Roger Toren
- Practical Business Intelligence with SQL Server 2005
- Table of Contents
- Copyright
- Acknowledgments
- About the Authors
- Preface
- Chapter 1. Introduction to Business Intelligence
- What Is Business Intelligence?
- Transaction Systems and the Search for Information
- Data Warehouses
- OLAP to the Rescue
- Dimensional Modeling Concepts
- A Practical Approach to Dimensional Modeling
- Business Intelligence Projects
- Summary
- Chapter 2. Introduction to SQL Server 2005
- SQL Server Components
- SQL Server Database Engine
- Integration Services
- Analysis Services
- Reporting Services
- Data Mining
- Other Technologies
- Summary
- Chapter 3. Building a Data Warehouse
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 4. Building a Data Integration Process
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 5. Building an Analysis Services Database
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 6. Reporting
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 7. Data Quality
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 8. Managing Changing Data
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 09. Scorecards
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 10. Data Mining
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Chapter 11. Very Large Data Warehouses
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Initial Loading of the Data Warehouse
- Managing Table Partitions
- Next Steps
- Summary
- Chapter 12. Real-Time Business Intelligence
- Business Problem
- Solution Overview
- Data Model
- Technical Solution
- Managing the Solution
- Next Steps
- Summary
- Index
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- X
- W
Practical Business Intelligence with SQL Server 2005
ISBN: 0321356985
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 132
Pages: 132
Authors: John C. Hancock, Roger Toren
Similar book on Amazon
- Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
- Understanding SQL Transactions and Transaction Logs
- Performing Multiple-table Queries and Creating SQL Data Views
- Writing External Applications to Query and Manipulate Database Data
- Monitoring and Enhancing MS-SQL Server Performance