close menu
Bookswagon-24x7 online bookstore
close menu
My Account
A Practical Guide to Microsoft® OLAP Server

A Practical Guide to Microsoft® OLAP Server

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

A Practical Guide to Microsoft OLAP Server introduces you to OLAP technology and leads you step-by-step through the process of deploying an OLAP server, focusing in particular on Microsofts OLAP Services. This book explains the basic concepts underlying OLAP, compares various OLAP products, and describes Microsofts OLAP Services architecture. In addition, it enumerates the development life cycle of an OLAP Services application from planning and design through installation and administration, discussing the goals and approaches for each phase and task. Essential topics covered include: *OLTP versus OLAP *Dimensions, measures, and aggregations *Multipurpose query tools *Dedicated desktop OLAP *Microsoft OLAP Services management software *Analyzing OLAP project goals, tasks, resources, and scheduling *Data source analysis, including host platform accessibility and dimensionality *Designing hierarchies, aggregation, storage, and partitioning *Security *OLAP server installation, including hardware requirements *Designing and building an OLAP database *OLAP and Excel *OLAP and the Web *Administration, training, and technical support A Practical Guide to Microsoft OLAP Server also provides information on more advanced OLAP topics, including virtual cubes, merging database partitions and custom OLAP development. Real-world examples demonstrate concepts and methods throughout the book, and plenty of practical advice will help you avoid trouble spots and achieve a smooth and successful deployment.

Table of Contents:
Preface Part I Basics Chapter 1 OLAP Concepts Five Characteristics of OLAP OLAP Applications Decision Support Decision Support versus Transaction Processing Decision Support and the Data Warehouse Datamarts and Data Warehouses Key OLAP Concepts Dimensions Hierarchies and Aggregation Multidimensional Cubes Components of an OLAP Application Data Acquisition Data Structuring and Storage Multidimensional Analysis Chapter 2 OLAP History and Trends The OLAP Story The First Generation The Second Generation The Third Generation The Little Engine That Could Plato OLAP Standards The OLAP Council OLE DB for OLAP and MDX OLAP Solutions Intended Function and Audience Data Acquisition and Storage End-user Client Model Visualization Time Intelligence Open Environment Automation OLAP Trends Analysis at Large Integration Packaged Applications Cutting Data Clutter Chapter 3 Introduction to Microsoft SQL Server OLAP Services The Enterprise Picture OLAP Services Functionality OLAP Services Architecture System Components Open and Extensible Environment Data Acquisition Read/Write Data Access Multidimensional Storage Options Time Intelligence OLAP Services Security OLAP Manager Architecture SQL Server 7 Software Versions Benefits of OLAP Services Part II Implementation: Planning, Analysis, and Design Chapter 4 Planning the OLAP Project Project Planning Steps Defining Project Goals Decomposing the Task List Identifying Resources Staff Resources Nonstaff Resources Estimating the Schedule Estimating the Budget Assessing the Risks Money Time Unknowns Dependencies Assumptions Conducting a Final Review The Plan in Action Project Planning Tools OLAP in the Self-actualized Enterprise Assessing the State of Your Enterprise Chapter 5 OLAP Systems Analysis The Analytical Process The Analytical Spirit Perspectives of Information Providers and Users Information-Collecting Interviews Strategic and Planning Executive Interviews Business Perspective Interviews Technical Perspective Interviews Reviewing Current Systems Source Data Analysis Host Platform and Data Accessibility Scope and Variance of Source Data Analysis of Data Quality Measures Analysis Dimensional Analysis Relational Analysis Physical Examination Recording Metadata Conducting a Final Review Roadblocks Bottlenecks Black Holes Miracles Redundancies Refocusing on Goals Chapter 6 Designing Your OLAP Services Solution The Solution Proposal Database Design The Subject of Analysis The Measures The Dimensions The Star and Snowflake Schemas Schema Complexities Source Data Transformations Data Transport Architecture Data Element Mappings and Transformation Rules Extraction and Transformation Processing Tools Quality Control Cubes and Cube Processing System Security A Basic User Security Scheme Beyond Basic Security Physical Security End-user Access Custom Components Design Review Part III Implementation: Construction, Release, and Support Chapter 7 Installing OLAP Services Minimum Requirements User Accounts Final Prep for Installation Performing the Installation Verifying the Setup Client and Database Drivers Administrator Accounts Registering OLAP Servers Migrating the Repository to SQL Server OLAP Manager Add-ins and Function Libraries Chapter 8 Building the OLAP Database Quick Guide to OLAP Manager Creating the Database Creating Data Sources Creating Dimensions Standard Dimension Time Dimension Creating Cubes Calculated Members Design Storage Options Database Roles and Read/Write Permissions Aggregation Functions Processing Cubes Chapter 9 Using Excel as an OLAP Client How Excel Works with OLAP Data Data Drivers and MS Query Data Sources PivotTables Introduction to PivotTables Creating OLAP PivotTable Reports Working with PivotTables PivotCharts Basics of PivotCharts Working with PivotCharts Offline Cube Files Creating OLAP Cubes from Relational Data Overview of Creating Cubes Creating an MS Query on Relational Data Running the OLAP Cube Wizard OLAP and Excel on the Web Overview of Office and Excel Web Functionality Noninteractive Web Reports Interactive PivotLists Interactive PivotCharts Preparing to Implement Excel as Your OLAP Client Minimum Requirements Creating a Shared Folder for Data Sources Chapter 10 Managing the OLAP Application Administrative Duties Scheduled Administrative Functions Unscheduled Administrative Functions Documentation and Metadata Administrators Guide Users Guide Metadata Training Administrative and Technical Training End-user Training User Support Refreshing Cube Data Incremental Update Processing Refresh Cube Processing Cube Usage Analysis and Optimization The Query Log Usage Analysis Wizard Usage-Based Optimization Wizard Write-back Data Maintenance Refinements and Additions Chapter 11 Third-Party OLAP Clients Overview Excel Add-ins Dedicated Fat Clients Internet Solutions Managed Query and Reporting Tools Vertical-Market and Value-Added Solutions Software Developer Kits Client Selection Process Establishing Selection Criteria Selecting Product Category Conducting Product Search Hands-on Product Evaluation Part IV Beyond the Basics Chapter 12 Multidimensional Expressions Overview of MDX How MDX Is Applied MDX Sample Application Learn Your Way Around the Cube Dimensional Structure and Family Relationships Member and Tuple References Set References Basic Selects Cube Specifications Axes Specifications Slicer Specifications MDX Functions Member Functions Set Functions Advanced Selects Nested Dimensions: Tuples and Crossjoins Multiple Measures Calculated Members Numeric Functions in Parameters Handling Empty Values Filtering Datasets Where to Go from Here Chapter 13 Advanced Application Techniques Member Properties and Virtual Dimensions Managing Member Properties Managing Virtual Dimensions Creating a Dual-axes Dimension View Virtual Cubes Managing Virtual Cubes Joining Fact Tables Data Partitioning Creating Partitions Merging Partitions Cell-level Security Permission Rules Setting Cell-level Permission Rules Time as an Analysis Factor Period Comparisons Rolling Period Ratios Moving Averages Alternate Time Dimension Hierarchies Breaking the Time Dimension in Two Multiple Time Dimensions in a Cube Contribution Percentages Real-time Data Feeds Appendix Bibliography Glossary Index


Best Seller

| | See All

Product Details
  • ISBN-13: 9780201485578
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison Wesley
  • Height: 234 mm
  • No of Pages: 432
  • Weight: 646 gr
  • ISBN-10: 0201485575
  • Publisher Date: 05 Jul 2000
  • Binding: Paperback
  • Language: English
  • Spine Width: 19 mm
  • Width: 188 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Be The First to Review
A Practical Guide to Microsoft® OLAP Server
Pearson Education (US) -
A Practical Guide to Microsoft® OLAP Server
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

A Practical Guide to Microsoft® OLAP Server

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    | | See All


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA