The purpose of this book is to document the methodology and chronology of work activity used by the author to successfully implement a Data Warehouse. Each of the eleven steps of the methodology is reviewed in the book, often using actual working documents as examples. The book contains lessons learned (both good and bad) as well as measures of success for each step. An essential aspect of DW project implementation (and other IT projects as well) is using established business practices to manage development and implementation. Discussion of use of these "due diligence" practices in Step 1 establishes the foundation for starting the DW project with the proper levels of management oversight. Step 2 presents examples of business models necessary for the DW developer to understand the needs of the business that the DW will serve. Other DW books describe the data modeling process but neglect to provide modeling instruction and actual examples to insure that the DW is properly aligned with business needs. An elegant data warehouse that doesn't meet the needs of the business is wasted effort.Step 3 documents and displays the level of detail needed to define CSF's (Critical Success Factors) and KPI's (Key Performance Indicators). If calculations for these important metrics are not defined in detail, and consensus to use them is not reached, then again, the most elegant data warehouse implementation is a wasted effort. In addition, developing and documenting functional requirements is essential in identifying legacy system reporting deficiencies. Step 4 describes how to access and display field level information on the iSeries platform. Actual shots of the resulting screens are shown. Step 5 presents the functional contents of an RFP for a Data Warehousing tool-set. Step 6 presents the progression of work required to build a data warehouse. Step 6 also:· Describes and displays a hybrid dimensional to flat file data model that may be, in reality, the best data organizatio
Book Description
Editorial Reviews
About the Author
Bruce R. Ullrey is the Chief Information Office for Rumpke Consolidated Companies, a $350,000,000 regional waste hauling company headquarted in Cincinnati, Ohio. Mr. Ullrey began his career with IBM in 1966 and spent time developing integrated cost estimating systems at the IBM San Jose California manufacturing facility. Ullrey has been successfully provisioning and managing IBM mainframe and midrange technology for businesses since 1976. He holds a Masters Degree in Management of Technology and teaches at the university level in the Cincinnati area.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
0 of 7 people found the following review helpful:
2.0 out of 5 stars
Methodology without reality,
By
This review is from: Implementing a Data Warehouse: A methodology that worked (Paperback)
This methodology not use last approach and cases from BI leaders (for example SAS, SAP and Oracle ).
The famous BI software vendor deliver with software own methodology based on personal best practice using functionality of their BI platform . For example, SAP & SAS have own successful implementation methodologies. SAS deliver IPI (Intelligence Platform Methodology) and PMM ( project management methodology) , SAP offer ASAP for BW. If You have notes or questions please sent to elena963@gmail.com
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
Key Phrases - Statistically Improbable Phrases (SIPs):
(learn more)
residential customers, based upon defined requirements, warehouse toolset, driver log entries, data warehouse developer, upon the business models, data warehouse users, load queries, customer master file, data marts, productivity reports Key Phrases - Capitalized Phrases (CAPs): (learn more)
Build Business Models, Build the Data Warehouse, Build the Data Marts, Methodology Step, Corporate Technology Overlay Model, Build the Initial, Statement of Work, Commercial Customers, Continue Cancel Figure, Project Management, File Tools View Help, Service Type, Field Name, Row Fields Data Fields, Requirements Requirements, Qport Access, Harold Kerzner, Drill Down Additional Fields, Lessons Learned, Database File Version, Logical Business Model, File Fmt, Executive Overview, Ralph Kimball, Market Names Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Back Cover | Surprise Me!
residential customers, based upon defined requirements, warehouse toolset, driver log entries, data warehouse developer, upon the business models, data warehouse users, load queries, customer master file, data marts, productivity reports Key Phrases - Capitalized Phrases (CAPs): (learn more)
Build Business Models, Build the Data Warehouse, Build the Data Marts, Methodology Step, Corporate Technology Overlay Model, Build the Initial, Statement of Work, Commercial Customers, Continue Cancel Figure, Project Management, File Tools View Help, Service Type, Field Name, Row Fields Data Fields, Requirements Requirements, Qport Access, Harold Kerzner, Drill Down Additional Fields, Lessons Learned, Database File Version, Logical Business Model, File Fmt, Executive Overview, Ralph Kimball, Market Names Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Back Cover | Surprise Me!
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
