Data Warehouse Designs

Data Warehouse Designs
By:Fon Silvers
Published on 2011-12-14 by CRC Press

Market Basket Analysis (MBA) provides the ability to continually monitor the affinities of a business and can help an organization achieve a key competitive advantage. Time Variant data enables data warehouses to directly associate events in the past with the participants in each individual event. In the past however, the use of these powerful tools in tandem led to performance degradation and resulted in unactionable and even damaging information. Data Warehouse Designs: Achieving ROI with Market Basket Analysis and Time Variance presents an innovative, soup-to-nuts approach that successfully combines what was previously incompatible, without degradation, and uses the relational architecture already in place. Built around two main chapters, Market Basket Solution Definition and Time Variant Solution Definition, it provides a tangible how-to design that can be used to facilitate MBA within the context of a data warehouse. Presents a solution for creating home-grown MBA data marts Includes database design solutions in the context of Oracle, DB2, SQL Server, and Teradata relational database management systems (RDBMS) Explains how to extract, transform, and load data used in MBA and Time Variant solutions The book uses standard RDBMS platforms, proven database structures, standard SQL and hardware, and software and practices already accepted and used in the data warehousing community to fill the gaps left by most conceptual discussions of MBA. It employs a form and language intended for a data warehousing audience to explain the practicality of how data is delivered, stored, and viewed. Offering a comprehensive explanation of the applications that provide, store, and use MBA data, Data Warehouse Designs provides you with the language and concepts needed to require and receive information that is relevant and actionable.

This Book was ranked at 40 by Google Books for keyword Data Warehousing.

Book ID of Data Warehouse Designs's Books is vwSapMXY8fcC, Book which was written byFon Silvershave ETAG "FNVq0MWeI2I"

Book which was published by CRC Press since 2011-12-14 have ISBNs, ISBN 13 Code is 9781439870761 and ISBN 10 Code is 1439870764

Reading Mode in Text Status is false and Reading Mode in Image Status is true

Book which have "296 Pages" is Printed at BOOK under CategoryComputers

This Book was rated by Raters and have average rate at ""

This eBook Maturity (Adult Book) status is NOT_MATURE

Book was written in en

eBook Version Availability Status at PDF is falseand in ePub is false

Book Preview