Building a Data Warehouse for Decision Support
Home > Computing and Information Technology > Databases > Data capture and analysis > Building a Data Warehouse for Decision Support
Building a Data Warehouse for Decision Support

Building a Data Warehouse for Decision Support

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

Table of Contents:
(NOTE: Each chapter concludes with a summary.) 1. Let's Start with the Basics. What is a Decision Support System? Understanding Operational versus Analytical Processing. What is A Data Warehouse? Real Life Data Warehouse Examples. Community Mutual Insurance Company. A Corporate Overview Meeting the Need for Information-Predecessor Systems. In the Beginning ... Gathering Data Requirements. Infrastructures. User Reaction to Initial Development. The User Community. Building on the Warehouse. What the Future Holds. 20/20 Hindsight. Tips from the Trenches 1.1: Learning from Community. Mutual Internal Cost Allocations: Chargebacks. A Consumer Packaged Goods Company. A Corporate Overview. How it Got Started. Implementation Project. Architecture and Infrastructure. End User Reaction. Data Warehouse Expansion 20/20 Hindsight. Endnote. 2. Understanding Terms and Technology. Analytical Processing. Operational Processing. Decision Support Systems. Data Warehouse. Environment for Data Access. Architecture. Technical Infrastructures. Source and Target Data. Levels of Users. Classes of Tools. Decision Support System (DSS) Applications. Data Transformation. Data Transformation Tools. Middleware Tools. Metadata. Star Schema. Hierarchies. Granularity. Database Gateway. Megabytes, Gigabytes, and Terabytes. Decision Support Development Cycle. 3. Understanding Architecture and Infrastructures. The Task at Hand. Understanding Data Warehouse Architecture. The Characteristics of Data Warehouse Architecture. Data Is Extracted from Source Systems, Database, or Files. The Data from the Source Systems is Integrated and Transformed before Being Loaded into the Data Warehouse. A Separate Read-only Database is Created for Decision Support Data. Users Access the Data Warehouse via a Front End Tool or Application. Expanding the Generic Data Warehouse Architecture. Understanding the Relationship of Infrastructures and Architecture. Architecture and Infrastructures as a Separate Project. Tips From the Trenches 3.1: Architecture and Infrastructures. And the Answer is ... 4. The Decision Support Life Cycle. Life Cycles for System Development. Issues Affecting the Decision Support Life Cycle. The Decision Support Life Cycle In an Architected Environment. The Phases of the Decision Support Life Cycle (DSLC). Phase 1: Planning. Phase 2: Gathering Data Requirements and Modeling. Gathering Data Requirements. Data Modeling. Phase 3: Physical Database Design and Development. Phase 4: Data Mapping and Transformation. Phase 5: Populating the Data Warehouse. Tips from the Trenches 4.1: Availabiliy of Data. Phase 6: Automating Data Management Procedures. Phase 7: Application Development-Creating the Starter Set of Reports. Phase 8: Data Validation and Testing. Phase 9: Training. Phase 10: Rollout. 5. Getting Started with Data Warehouse Development. The Proof Is in the Pilot. Clarify the Purpose and Goal of the Pilot Project. Treat the Pilot like a Development Project. Building on the Pilot. Choosing a Business Area for Data Warehouse Development. Tips from the Trenches 5.1: Choosing a Business Area. Ensuring a Successful Data Warehouse. Tips from the Trenches 5.2: Building a Successful Data Warehouse "The Big Eight". Be Clear on Your Goal. Understand the Chosen Data Warehouse Architecture. Make Sure the Technical Infrastructures Are in Place or Being Put in Place. Clarify the Project Team's Responsibility and Final Deliverable. Make Sure the Members of the Project Team Understand the Difference between Operational and Decision Support Data. Get the Correct Training. Get the Right Resources. Choose Front End Data Access Software Based on User Needs and Abilities. 6. Gathering Data Requirements. A Proper Mindset. User Interviews. The Purpose of Interviews. Setting up Successful Interviews. Who to Interview. Tips from the Trenches 6.1: Setting Up Successful Interviews. Key End Users and Analysts from the Target Business Functions. Managers from the Target Business Functions. Analysts & Users from Related Business Functions. Managers from Related Business Functions. Executives. What to Ask End Users. Job Responsibilities. Current Analysis. Ad Hoc Analysis. Business Analyses. Data Specific Information. A Wish List. What to Ask Executives. Documenting What You Heard. What You Have to Know for DSS. Developing the Data Model. Dimensional Business Model. Logical Data Model. Tips from the Trenches 6.2: The Basics of Data Modeling. 7. Designing the Database for a Data Warehouse. Transaction-processing Databases. Decision Support Databases. Star Schema Database Design. The Benefits of Using a Star Schema. Understanding Star Schema Design-Facts and Dimensions. Varieties of Star Schemas. How to Read the Diagrams. Tips from the Trenches 7.1: Understanding Facts and Dimensions. Simple Star Schemas. Multiple Fact Tables. Variations of a Star Schema. Multi-Star Schemas. A Salad Dressing Example. Understanding the Available Data, Browsing the Dimension Tables. Using Table Attributes. Creating Attribute Hierarchies. Aggregation. Denormalizaiton. Data Warehouse Database Design Examples. Reservation Database. Investment Database. Health Insurance Database. Putting It All Together. 8. Successful Data Access. General Understanding of Data Access. What Are You Really Trying To Do? Types of Access. Levels of Users. What Is a DSS Application? Data Access Characteristics. Visualization of the Data Warehouse. User Formulates Request. Metrics and Calculated Metrics. Constraining a Request. How the Request is Processed. Presentation of Results. Reports. Graphs. Maps. Communicate Findings. Advanced Features. Advanced Analytics. Batch Query Processing. DSS Application Development. Classes of Tools. Data Access/Query Tools. Report Writers. Multidimensional Database Management Systems (MDBMS). Advanced DSS Tools. Executive Information Systems (EIS). Tiered Architectures. Data Design Requirements. Metadata. Operational Metadata versus DSS Metadata. Warehouse Changes. How Is DSS Metadata Used? Application Deployment. Selecting Tools for Your Organization. One Tool Fits All? The Request for Proposal (RFP). Key Considerations. What Matters to You? Selecting a Vendor Not Just a Tool. 9. Training, Support, and Rollout. Success Criteria. Training. Support. Internal marketing of the Data Warehouse. Data Warehouse Marketing Ideas. Target Specific Groups. Get Clear and Visible Management Support. Provide Visible Opportunities. Be Proactive. Create a Publication. Planning a Rollout: Deployment. Phased Rollout Approach. Logistics of a Rollout. Appendices. Index.


Best Sellers


Product Details
  • ISBN-13: 9780133711219
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 242 mm
  • No of Pages: 240
  • Weight: 638 gr
  • ISBN-10: 0133711218
  • Publisher Date: 26 Oct 1995
  • Binding: Hardback
  • Language: English
  • Spine Width: 21 mm
  • Width: 187 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Building a Data Warehouse for Decision Support
Pearson Education (US) -
Building a Data Warehouse for Decision Support
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.

Building a Data Warehouse for Decision Support

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

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!