Unlocking OLAP With SQL Server 7 and Excel 2000 | 
 enlarge | Author: Wayne S. Freeze
Publisher: Hungry Minds
Category: Book
List Price: $49.99
Buy New: $23.99
You Save: $26.00 (52%)
New (4) Used (6) from $0.47
Rating:  6 reviews
Sales Rank: 1487756
Media: Paperback
Pages: 473
Number Of Items: 1
Shipping Weight (lbs): 1.9
Dimensions (in): 9 x 7.2 x 1.3
ISBN: 0764545876
Dewey Decimal Number: 005.7585
EAN: 9780764545870
ASIN: 0764545876
Publication Date: May 15, 2000
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Condition: BRAND NEW, NEVER READ,FAST SHIPPING!!!..."Our Small Bookstore Believes In Quality Over Quantity, Great Customer Service and Fast Shipping."
| |
| Similar Items:
|
| Editorial Reviews:
Product Description
There's so much information inside your database, but how do you get at it and use it successfully? With this guide to Online Analytical Processing (OLAP) tools, you can forego programming and custom data warehousing and tap into the power of Microsoft SQL Server technology. You can build your own data warehouse using the Enterprise Manager tool in SQL Server and pull out what you need using SQL Server Query Analyzer and English Query tools. What's more, Excel 2000, in tandem with these tools, serves up your data in multidimensional, mission-specific reports. The CD-ROM includes extensive sample databases and an evaluation edition of Microsoft SQL Server 7.0.
|
| Customer Reviews: Read 1 more reviews...
 Nice book December 6, 2001
gbworld@comcast.net (Nashville, TN USA)
2 out of 2 found this review helpful
When I first got this book, I was thrilled with it. After all, opening up OLAP with Excel 2000 is a pretty neat trick. Now, I have seen how bad this idea can be for Internet applications, and the honeymoon is over.
Don't get me wrong, this is not a bad book. Just because I do not find the book useful for the types of applications I work with does not make it bad. The three stars signifies that it is average, which is exactly what this book is.
In this plus column, this book gives you a nice introduction to OLAP. While not technical deep, the chapters on setting up your cubes will take you a long way into the world of OLAP. If you are interested in using Excel as your reporting front-end, you will find plenty of screenshots to help you through every step in the process.
On the downside, the book seems to rely a lot on screenshots and some of the written material is a bit thin. Understanding the purpose of the book, the thin parts are not so glaring.
Of course, the material is a bit old now, considering that both Excel and SQL Server have moved on to the next version. However, if you plan on using OLAP in SQL Server 7, consider putting this book on your wish list, as it has a lot of good content. I say this esp. if you have not worked with OLAP before.
Too basic. August 2, 2001
K. HUANG (Austin, TX United States)
This is definately a beginner book, and as a beginner book it probably deserves 5 stars. This book touches on many database topics, MS SQL server setup from scratch, ODBC connection with Windows, Windows security, structuring your data in the database, basic SQL syntax, etc.Unfortuneately, I was expecting more on OLAP and less about MS SQL server. The information specific to MS Excel and OLAP could be a simple 20 page read from the Excel 2000 help manuals or technet. As a beginner book, this is excellent because it gives you step-by-step instructions to set up the examples; however, if you are looking for more detailed analysis or understanding of OLAP, you may want to find a different, more advance book.
Too basic. August 2, 2001
K. HUANG (Austin, TX United States)
2 out of 2 found this review helpful
This is definately a beginner book, and as a beginner book it probably deserves 5 stars. This book touches on many database topics, MS SQL server setup from scratch, ODBC connection with Windows, Windows security, structuring your data in the database, basic SQL syntax, etc.Unfortuneately, I was expecting more on OLAP and less about MS SQL server. The information specific to MS Excel and OLAP could be a simple 20 page read from the Excel 2000 help manuals or technet. As a beginner book, this is excellent because it gives you step-by-step instructions to set up the examples; however, if you are looking for more detailed analysis or understanding of OLAP, you may want to find a different, more advance book.
 OLAP Jack July 9, 2000
2 out of 9 found this review helpful
Hi, I am Irish. Unlike our friend from the 38th parallel, I can write in English very easily and I'm quite adept at that thar American lingo as well. Therefore, I read this book in a week during me mornin' Guiness at the pub and it gave me the review on OLAP I was looking for. This is definitely a book for beginners and advanced developers as well and quite surprisingly me British bloks were able to read it in two weeks so it must be written well.
Simple... right? June 6, 2000
1 out of 1 found this review helpful
This book presents a fast and simple way to get familiar with SQL 7 OLAP tools and concepts. There are few details here, but you will be presented with an almost complete picture of the products capabilities. Data warehousing concepts are covered, but again, no detail. Regardless, this book is easy to read, well organized, and the sample data and examples are excellent.
|
|
|
