Unlocking OLAP with SQL Server 7 and Excel 2000
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.
- Mixed media product | 550 pages
- 182.9 x 228.6 x 33mm | 861.82g
- 01 Jul 2000
- John Wiley & Sons Inc
- Hungry Minds Inc,U.S.
- Foster City, United States
About Wayne S. Freeze
About the Author Wayne S. Freeze has more than 20 years of experience as an IT professional, most recently as Manager of Systems Programming at the University of Maryland. His many books include The SQL Programmer's Reference and Hands On SQL Server 7 with Visual Basic 6.