A Practical Guide to Implementing and Supporting a Data Warehousing Solution.
Advanced Level Users.
Includes CD-ROM.
Data warehouses help users look at information in new ways so they can see patterns and trends and gain insights to make better business decisions. This book is the best introduction to building enterprise data warehousing solutions with SQL Server 7.0 available. It shows how to take advantage of all the power of SQL Server 7.0 to design, build, and manage data warehouses easily.
The book introduces and explains:
- Data warehousing
- Planning and design
- Online Analytical Processing (OLAP)
- Star schemas
- Data transformation services (DTS)
- Multidimensional query language (MDX)
- Developing SQL Server cubes with extensive sample databases and utilities
The CD accompanying the book contains sample databases and utilities.