Data Warehousing Fundamentals for IT Professionals 2e
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Computer hardware > Data Warehousing Fundamentals for IT Professionals 2e
Data Warehousing Fundamentals for IT Professionals  2e

Data Warehousing Fundamentals for IT Professionals 2e


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Since the first edition of Data Warehousing Fundamentals , there has been an increase in enterprises either already having or in the process of obtaining the data warehousing programs. Data Warehousing Fundamentals not only explores important topics, like planning requirements, architecture, infrastructure, data preparation, and information delivery, but also the most up-to-date research on areas of technological improvements since the first edition. Additionally, Information Technologists will find expert advice, review questions, exercises, as well as an answer section are all included in this revised text.

Table of Contents:
Preface. Part 1 OVERVIEW AND CONCEPTS. 1 The Compelling Need for Data Warehousing. Chapter Objectives. Escalating Need for Strategic Information. Failures of Past Decision Support Systems. Operational Versus Decision-Support Systems. Data Warehousing--The Only Viable Solution. Data Warehouse Defined. The Data Warehousing Movement. Evolution of Business Intelligence. Chapter Summary. Review Questions. Exercises. 2 Data Warehouse: The Building Blocks. Chapter Objectives. Defining Features. Data Warehouses and Data Marts. Architectural Types. Overview of Components. Metadata in the Data Warehouse. Chapter Summary. Review Questions. Exercises. 3 Trends in Data Warehousing. Chapter Objectives. Continued Growth in Data Warehousing. Vendor Solutions and Products. Significant Trends. Emergence of Standards. Web-Enabled Data Warehouse. Chapter Summary. Review Questions. Exercises. Part 2 PLANNING AND REQUIREMENTS. 4 Planning and Project Management. Chapter Objectives. Planning Your Data Warehouse. The Data Warehouse Project. The Project Team. Project Management Considerations. Chapter Summary. Review Questions. Exercises. 5 Defining the Business Requirements. Chapter Objectives. Dimensional Analysis. Information Packages-A Useful Concept. Requirements Gathering Methods. Requirements Definition: Scope and Content. Chapter Summary. Review Questions. Exercises. 6 Requirements as the Driving Force for Data Warehousing. Chapter Objectives. Data Design. The Architectural Plan. Data Storage Specifications. Information Delivery Strategy. Chapter Summary. Review Questions. Exercises. Part 3 ARCHITECTURE AND INFRASTRUCTURE. 7 The Architectural Components. Chapter Objectives. Understanding Data Warehouse Architecture. Distinguishing Characteristics. Architectural Framework. Technical Architecture. Architectural Types. Chapter Summary. Review Questions. Exercises. 8 Infrastructure as the Foundation for Data Warehousing. Chapter Objectives. Infrastructure Supporting Architecture. Hardware and Operating Systems. Database Software. Collection of Tools. Data Warehouse Appliances. Chapter Summary. Review Questions. Exercises. 9 The Significant Role of Metadata. Chapter Objectives. Why Metadata is Important. Metadata Types by Functional Areas. Business Metadata. Technical Metadata. How to Provide Metadata. Chapter Summary. Review Questions. Exercises. Part 4 DATA DESIGN AND DATA PREPARATION. 10 Principles of Dimensional Modeling. Chapter Objectives. From Requirements to Data Design. The STAR Schema. STAR Schema Keys. Advantages of the STAR Schema. STAR Schema: Examples. Chapter Summary. Review Questions. Exercises. 11 Dimensional Modeling: Advanced Topics. Chapter Objectives. Updates to the Dimension Tables. Miscellaneous Dimensions. The Snowflake Schema. Aggregate Fact Tables. Families of STARS. Chapter Summary. Review Questions. Exercises. 12 Data Extraction, Transformation, and Loading. Chapter Objectives. ETL Overview. Data Extraction. Data Transformation. Data Loading. ETL Summary. Other Integration Approaches. Chapter Summary. Review Questions. Exercises. 13 Data Quality: A Key to Success. Chapter Objectives. Why is Data Quality Critical?. Data Quality Challenges. Data Quality Tools. Data Quality Initiative. Master Data Management (MDM). Chapter Summary. Review Questions. Exercises. Part 5 INFORMATION ACCESS AND DELIVERY. 14 Matching Information to the Classes of Users. Chapter Objectives. Information from the Data Warehouse. Who Will Use the Information? Information Delivery. Information Delivery Tools. Information Delivery: Special Topics. Chapter Summary. Review Questions. Exercises. 15 OLAP in the Data Warehouse. Chapter Objectives. Demand for Online Analytical Processing. Major Features and Functions. OLAP Models. OLAP Implementation Considerations. Chapter Summary. Review Questions. Exercises. 16 Data Warehousing and the Web. Chapter Objectives. Web-Enabled Data Warehouse. Web-Based Information Delivery. OLAP and the Web. Building a Web-Enabled Data Warehouse. Chapter Summary. Review Questions. Exercises. 17 Data Mining Basics. Chapter Objectives. What is Data Mining?. Major Data Mining Techniques. Data Mining Applications. Chapter Summary. Review Questions. Exercises. Part 6 IMPLEMENTATION AND MAINTENANCE. 18 The Physical Design Process. Chapter Objectives. Physical Design Steps. Physical Design Considerations. Physical Storage. Indexing the Data Warehouse. Performance Enhancement Techniques. Chapter Summary. Review Questions. Exercises. 19 Data Warehouse Deployment. Chapter Objectives. Data Warehouse Testing. Major Deployment Activities. Considerations for a Pilot. Security. Backup and Recovery. Chapter Summary. Review Questions. Exercises. 20 Growth and Maintenance. Chapter Objectives. Monitoring the Data Warehouse. User Training and Support. Managing the Data Warehouse. Chapter Summary. Review Questions. Exercises. Answers to Selected Exercises. Appendix A. Project Life Cycle Steps and Checklists. Appendix B. Critical Factors for Success. Appendix C. Guidelines for Evaluating Vendor Solutions. Appendix D. Highlights of Vendors and Products. Appendix E. Real-World Examples of Best Practices. References. Glossary. Index.

About the Author :
Paulraj Ponnian, PhD, with over thirty years of experience as an IT consultant, has worked with such organizations as Texaco, Sotheby's Blue Cross/Blue Shield, NA Philips, New York-Presbyterian Hospital, Panasonic, and Bantam Doubleday Dell. He specializes in the design and Implementation of data warehouse and database systems. Dr. Ponniah has published three successful books and, as Adjunct Professor, continues to teach college courses in data warehousing and database design.

Review :
"...clearly the author is a long-time practitioner and expert in this area. And if this were not enough, the language is clear and precise, and the associated content is easily internalised." ( BCS , August 2010)


Best Sellers


Product Details
  • ISBN-13: 9780470604137
  • Publisher: John Wiley and Sons Ltd
  • Publisher Imprint: Wiley-Blackwell
  • Height: 257 mm
  • No of Pages: 608
  • Weight: 1162 gr
  • ISBN-10: 0470604131
  • Publisher Date: 18 Aug 2010
  • Binding: Other digital
  • Language: English
  • Spine Width: 32 mm
  • Width: 187 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Data Warehousing Fundamentals for IT Professionals  2e
John Wiley and Sons Ltd -
Data Warehousing Fundamentals for IT Professionals 2e
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.

Data Warehousing Fundamentals for IT Professionals 2e

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

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!