Data Warehousing with Microsoft SQL Server 7.0 Technical Reference (Microsoft Technical Reference)
| Author | : | |
| Rating | : | 4.58 (681 Votes) |
| Asin | : | 0735608598 |
| Format Type | : | paperback |
| Number of Pages | : | 500 Pages |
| Publish Date | : | 2013-05-11 |
| Language | : | English |
DESCRIPTION:
For data warehouse administrators and developers.. The CD-ROM contains sample databases and utilities. A book/CD-ROM showing how to take advantage of features of SQL Server 7.0 to design, build, and manage a data warehouse. Introduces basic concepts of data warehousing, then looks at online analytical processing services, data transformation services, advanced query processor and the MDX query language, and SQL Server cubes
this book is very good for certifications goob this book is very good for cetifications. A Customer said Not enough depth. This book has many useful examples and explanations about OLAP, ADOMD, and MDX. It also explains the basics of MS OLAP. However, the examples have many errors. Besides, if you are looking for depth, you will not find this book very helpful. The book is really designed for beginners who have little knowledge (or none) and want to learn about OLAP and the OLAP tools. These basics can be found in the online help and in the MSDN articles. If you want to learn about the cool functions in MDX and how they can be used to solve some of the drill-down and data presentation problems, this is not the book for you. I will have to give it. "You can get the same thing for free" according to A Customer. I've actually recommended this book on two occaisions to OLAP beginners because it is the only book I know of that covers OLAP from star schemas to DTS to cubes to MDX to ADOMD. That is this book's one redeeming quality. So if you read this, you'll get a good idea of what is going to be involved in an OLAP project. But don't expect to learn much else, however. There is very little in this book that you could not learn from Books Online or MSDN for free. The book is riddled with typos, grammar errors, spelling mistakes, and technical mistakes. I wonder if the editors were paid--they shouldn't have been! Don't be fooled by the
Microsoft SQL Server 7 has its own ways of implementing data warehouses and complex data-analysis tools, and Data Warehousing with Microsoft SQL Server 7.0 Technical Reference helps you get a handle on them. --David WallTopics covered:Data warehousing under SQL Server 7 Online Analytical Processing (OLAP) and other data-analysis mechanisms The OLAP Management Console The Cube Editor Multidimensional Extensions (MDX) ActiveX Data Objects Multidimensional (ADO MD) Data Transformation Services (DTS) General engineering matters . Although it's primarily a reference to Multidimensional Extensions (MDX) and ActiveX Data Objects Multidimensional (ADO MD), this book includes tons of information about the Microsoft way of collecting and managing large