The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball |
Microsoft SharePoint 2007 for Dummies (For Dummies (Computers)) by Vanessa L. Williams |
Microsoft® SQL Server™ 2000 DTS Step by Step (Step by Step (Microsoft)) by Carl Rabeler |
by Stacia Misner Hitachi Consulting
|
Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft)) by Reed Jacobson; Stacia Misner; Hitachi Consulting |
See buying choices for this item to see if it's one of the millions that are eligible for Amazon Prime.
Customers Who Bought This Item Also Bought
Product details
Would you like to update product info or give feedback on images?
|
Customers Viewing This Page May Be Interested in These Sponsored Links(What is this?) |
Product Description
Product Description
MICROSOFT® SQL SERVER™ 2000 ANALYSIS SERVICES STEP BY STEP shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You’ll discover why these services make it easier to analyze huge amounts of data quickly, and you’ll learn how to develop a wide range of advanced dimensional-data applications—from enterprise reporting tools to advanced decision-support systems. The book’s easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson. This title shows you how to: • Administer the Analysis Manager: Understand the fundamentals behind data dimensions and hierarchies, data warehousing, and the Microsoft Analysis Services architecture, and use the Microsoft Analysis Manager application to define and populate data cubes. •Create and display cubes: Define and modify measures and dimensions. Design, build, process, and view cubes, from simple to advanced, with cube and dimension editors. Use Microsoft Excel PivotTable® Reports and the PivotTable List in Microsoft Excel to browse cubes, and create cubes using Microsoft Office. •Query cubes: Use multidimensional expressions (MDX) values and sets and the MDX Sample application to query and display dimensional data. •Perform advanced administration: Choose data storage options and the Storage Design Wizard to optimize, manage, and update data efficiently. Automate the Analysis server to process an OLAP database. Work with partitions and automate updates, and apply security to cubes.
MICROSOFT® SQL SERVER™ 2000 ANALYSIS SERVICES STEP BY STEP shows Microsoft Excel and Access experts, IS managers, and database developers how to build applications that take advantage of the powerful data-analysis services in Microsoft SQL Server 2000. You’ll discover why these services make it easier to analyze huge amounts of data quickly, and you’ll learn how to develop a wide range of advanced dimensional-data applications—from enterprise reporting tools to advanced decision-support systems. The book’s easy-to-follow lessons begin with clear objectives and include real-world business examples, with a companion CD full of sample files that support each lesson. This title shows you how to: • Administer the Analysis Manager: Understand the fundamentals behind data dimensions and hierarchies, data warehousing, and the Microsoft Analysis Services architecture, and use the Microsoft Analysis Manager application to define and populate data cubes. •Create and display cubes: Define and modify measures and dimensions. Design, build, process, and view cubes, from simple to advanced, with cube and dimension editors. Use Microsoft Excel PivotTable® Reports and the PivotTable List in Microsoft Excel to browse cubes, and create cubes using Microsoft Office. •Query cubes: Use multidimensional expressions (MDX) values and sets and the MDX Sample application to query and display dimensional data. •Perform advanced administration: Choose data storage options and the Storage Design Wizard to optimize, manage, and update data efficiently. Automate the Analysis server to process an OLAP database. Work with partitions and automate updates, and apply security to cubes.
Inside This Book
(Learn More)
First Sentence
Suppose that you are the president of a small, new company. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Suppose that you are the president of a small, new company. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Do Customers Ultimately Buy After Viewing This Item?
 |
75% buy the item featured on this page: Microsoft® SQL Server™ 2000 Analysis Services Step by Step |
 |
25% buy Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft)) £31.96 |
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
Most Helpful Customer Reviews
Share your thoughts with other customers: Create your own review
|
 |
Listmania!
|
|
Look for similar items by category
- Books > Business, Finance & Law > Management > Human Resources > Professional Development
- Books > Business, Finance & Law > Management > Management Skills > Communication & Presentation > Information Systems
- Books > Computing & Internet > Computer Science > Artificial Intelligence
- Books > Computing & Internet > Databases > Beginners & Introduction > SQL & Relational Databases
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Programming > Algorithms > Artificial Intelligence
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Science & Nature > Popular Science > Artificial Intelligence
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
MCAD/MCSE/MCDBA Self-Paced...
Learn how to deliver powerful database solutions using SQL Server 2000...
Read more
|
More From Reed Jacobson
Microsoft® SQL Server™ 2005 Analysis... Teach yourself the fundamentals of SQL Server Analysis Services—one...
Read more
|
Treat Someone
With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is). |
||||||||
| |||||
Your Recent History
(What's this?)|
You have no recently viewed items or searches.
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. Look to the right column to find helpful suggestions for your shopping session. |
Continue Shopping: Top Sellers
| ||||
Amazon Home | |
| International Sites: United States | Germany | France | Japan | Canada | China | |
| Business Programs: Sell on Amazon | Fulfilment by Amazon | Join Associates | Join Advantage | |
| Customer Service | Help | View Basket | Your Account | |
| About Amazon.co.uk | Careers at Amazon | |
| Conditions of Use & Sale | Privacy Notice © 1996-2009, Amazon.com, Inc. and its affiliates |