The Data Warehouse Toolkit

The Definitive Guide to Dimensional Modeling

Author: Ralph Kimball,Margy Ross

Publisher: John Wiley & Sons

ISBN: 1118732286

Category: Computers

Page: 600

View: 4608

Updated new edition of Ralph Kimball's groundbreaking book ondimensional modeling for data warehousing and businessintelligence! The first edition of Ralph Kimball's The Data WarehouseToolkit introduced the industry to dimensional modeling,and now his books are considered the most authoritative guides inthis space. This new third edition is a complete library of updateddimensional modeling techniques, the most comprehensive collectionever. It covers new and enhanced star schema dimensional modelingpatterns, adds two new chapters on ETL techniques, includes new andexpanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide aseducators, consultants, and influential thought leaders in datawarehousing and business intelligence Begins with fundamental design recommendations and progressesthrough increasingly complex scenarios Presents unique modeling techniques for business applicationssuch as inventory management, procurement, invoicing, accounting,customer relationship management, big data analytics, and more Draws real-world case studies from a variety of industries,including retail sales, financial services, telecommunications,education, health care, insurance, e-commerce, and more Design dimensional databases that are easy to understand andprovide fast query response with The Data WarehouseToolkit: The Definitive Guide to Dimensional Modeling, 3rdEdition.

The Data Warehouse Lifecycle Toolkit

Expert Methods for Designing, Developing, and Deploying Data Warehouses

Author: Ralph Kimball

Publisher: John Wiley & Sons

ISBN: 0471255475

Category: Computers

Page: 771

View: 3326

"A comprehensive, thoughtful, and detailed book that will be of inestimable value to anyone struggling with the complex details of designing, building, and maintaining an enterprise-wide decision support system. Highly recommended." -Robert S. Craig, Vice President, Application Architectures, Hurwitz Group, Inc. In his bestselling book, The Data Warehouse Toolkit, Ralph Kimball showed you how to use dimensional modeling to design effective and usable data warehouses. Now, he carries these techniques to the larger issues of delivering complete data marts and data warehouses. Drawing upon their experiences with numerous data warehouse implementations, he and his coauthors show you all the practical details involved in planning, designing, developing, deploying, and growing data warehouses. Important topics include: * The Business Dimensional Lifecycle(TM) approach to data warehouse project planning and management * Techniques for gathering requirements more effectively and efficiently * Advanced dimensional modeling techniques to capture the most complex business rules * The Data Warehouse Bus Architecture and other approaches for integrating data marts into super-flexible data warehouses * A framework for creating your technical architecture * Techniques for minimizing the risks involved with data staging * Aggregations and other effective ways to boost data warehouse performance * Cutting-edge, Internet-based data warehouse security techniques The CD-ROM supplies you with: * Complete data warehouse project plan tasks and responsibilities * A set of sample models that demonstrate the Bus Architecture * Blank versions of the templates and tools described in the book * Checklists to use at key points in the project

THE DATA WAREHOUSE TOOLKIT, 2ND ED

Author: Raiph Kimball

Publisher: John Wiley & Sons

ISBN: 9788126508891

Category:

Page: 460

View: 6380

Market_Desc: · Data warehouse developers· Architects Special Features: · Single most authoritative guide from the inventor of the technique· Presents unique modeling techniques for e-commerce, and shows strategies for optimizing performance· Companion Web site provides updates on dimensional modeling techniques, links related to sites, and source code where appropriate About The Book: The Data Warehouse Toolkit, Second Edition is a complete library of dimensional modeling techniques - the most comprehensive collection ever written. In this new edition - more than 40% new and updated - Kimball shows specific technologies for common business applications, including: Retail sales, Inventory management, Procurement, Orders and invoices, Customer relationship management and Accounting. It also cover more advanced techniques for specific industries, such as financial services, telecommunications and utilities, health care, insurance and more.

Kimball's Data Warehouse Toolkit Classics

3 Volume Set

Author: Ralph Kimball

Publisher: Wiley

ISBN: 9781118875186

Category: Computers

Page: 1800

View: 6959

Three books by the bestselling authors on Data Warehousing! The most authoritative guides from the inventor of the technique all for a value price. The Data Warehouse Toolkit, 3rd Edition (9781118530801) Ralph Kimball invented a data warehousing technique called "dimensional modeling" and popularized it in his first Wiley book, The Data Warehouse Toolkit. Since this book was first published in 1996, dimensional modeling has become the most widely accepted technique for data warehouse design. Over the past 10 years, Kimball has improved on his earlier techniques and created many new ones. In this 3rd edition, he will provide a comprehensive collection of all of these techniques, from basic to advanced. The Data Warehouse Lifecycle Toolkit, 2nd Edition (9780470149775) Complete coverage of best practices from data warehouse project inception through on-going program management. Updates industry best practices to be in sync with current recommendations of Kimball Group. Streamlines the lifecycle methodology to be more efficient and user-friendly The Data Warehouse ETL Toolkit (9780764567575) shows data warehouse developers how to effectively manage the ETL (Extract, Transform, Load) phase of the data warehouse development lifecycle. The authors show developers the best methods for extracting data from scattered sources throughout the enterprise, removing obsolete, redundant, and innaccurate data, transforming the remaining data into correctly formatted data structures, and then physically loading them into the data warehouse. This book provides complete coverage of proven, time-saving ETL techniques. It begins with a quick overview of ETL fundamentals and the role of the ETL development team. It then quickly moves into an overview of the ETL data structures, both relational and dimensional. The authors show how to build useful dimensional stuctures, providing practical examples of beginning through advanced techniques.

Kimball's Data Warehouse Toolkit Classics

The Data Warehouse Toolkit, 2nd Edition; The Data Warehouse Lifecycle, 2nd Edition; The Data Warehouse ETL Toolkit

Author: Ralph Kimball,Margy Ross,Bob Becker,Joy Mundy,Warren Thornthwaite

Publisher: Wiley

ISBN: 9780470479575

Category: Computers

Page: 1628

View: 6511

Cowritten by Ralph Kimball, the world's leading data warehousing authority Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality This book is also available as part of the Kimball's Data Warehouse Toolkit Classics Box Set (ISBN: 9780470479575) with the following 3 books: The Data Warehouse Toolkit, 2nd Edition (9780471200246) The Data Warehouse Lifecycle Toolkit, 2nd Edition (9780470149775) The Data Warehouse ETL Toolkit (9780764567575)

Das Data Warehouse-Konzept

Architektur — Datenmodelle — Anwendungen

Author: Harry Mucksch,Wolfgang Behme

Publisher: Gabler Verlag

ISBN: 9783409422161

Category: Computers

Page: 543

View: 4019

Die Popularität des Data Warehouse-Konzepts unterstreicht die Notwendigkeit einer besseren Informationsbasis für Entscheidungsträger aller Managementebenen. In der 4. Auflage wurden alle Kapitel vollständig überarbeitet. Neu hinzugekommen sind Beiträge zur Datensicherheit. Das Thema Modellierung hat stärkeres Gewicht bekommen. Die Erfahrungsberichte orientieren sich nach einzelnen Branchen: Banken, Versicherungen, Dienstleistungen und Industrie.

The Data Warehouse ETL Toolkit

Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data

Author: Ralph Kimball,Joe Caserta

Publisher: John Wiley & Sons

ISBN: 111807968X

Category: Computers

Page: 528

View: 2536

Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copies Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality

Data Warehouse Blueprints

Business Intelligence in der Praxis

Author: Dani Schnider,Claus Jordan,Peter Welker,Joachim Wehner

Publisher: Carl Hanser Verlag GmbH Co KG

ISBN: 3446451455

Category: Computers

Page: 283

View: 7597

Data-Warehouse-Lösungen mit Blueprints erfolgreich umsetzen Dieses Buch gibt Ihnen einen Überblick über eine typische Data-Warehouse-Architektur und zeigt anhand von zahlreichen Best Practice-Beispielen, wie Sie die einzelnen Komponenten eines Data Warehouses realisieren und betreiben können. Skalierbarkeit, Performance und Integration sind dabei die wichtigsten Erfolgsfaktoren. Der kompakte und kompetente Leitfaden für Ihr Projekt Warum benötigt man eine Staging Area? Wie sollen fehlende oder fehlerhafte Daten beim Ladeprozess behandelt werden? Ist es zweckmäßiger, einen oder mehrere Data Marts zu erstellen? Wo werden die Daten aus verschiedenen Datenquellen integriert und wie sollen sie historisiert werden? Zu diesen und vielen weiteren Fragen erhalten Sie Antworten sowie Tipps und Tricks aus der Praxis. Wertvolles Know-how aus der Praxis Profitieren Sie von der langjährigen Erfahrung der Autoren. Die vorgestellten Konzepte und Vorgehensweisen haben sich bereits in zahlreichen Projekten bewährt. EXTRA: E-Book inside AUS DEM INHALT • Einleitung • Architektur • Datenmodellierung • Datenintegration • Design der DWH-Schichten • Physisches Datenbankdesign • BI-Anwendungen • Betrieb

Data-Warehouse-Systeme

Architektur, Entwicklung, Anwendung

Author: Andreas Bauer

Publisher: N.A

ISBN: 9783898647854

Category: Data warehousing

Page: 690

View: 1784

Hauptbeschreibung Dieses Lehrbuch gibt einen fundierten Einblick sowohl in die Architektur und Entwicklung eines Data-Warehouse-Systems als auch in den gesamten Ablauf des Data-Warehouse-Prozesses - vom Laden der Daten bis zu deren Auswertung. Der Schwerpunkt liegt auf den Datenbanken und deren Konzeption, Modellierung und Optimierung. Die Autoren zeigen u. a. betriebswirtschaftliche Einsatzbereiche sowie wissenschaftliche und technische Anwendungsgebiete auf und geben Hinweise für den Aufbau und die Wartung eines Data-Warehouse-Systems. Begriffsdefinitionen und ein durchgängiges An.

THE DATA WAREHOUSE LIFECYCLE TOOLKIT, 2ND ED

Author: Ralph Kimball,Margy Ross,Warren Thorthwaite,Bob Becker,Joy Mundy

Publisher: John Wiley & Sons

ISBN: 9788126516896

Category:

Page: 672

View: 9222

Market_Desc: · Data warehouse Designers· Data warehouse Architects· Data warehouse Developers· Data warehouse Managers Special Features: · The current first edition has sold more than 72,000 copies, generating net revenue of more than $2.5 million· The methods described in this book have been adopted by almost all leading data warehouse vendors· Ralph Kimball and his co-authors are recognized as the driving thought leaders in the data warehousing industry; there is no direct competition· The authors actively promote this methodology in training and consulting worldwide and in their writing in magazines and online About The Book: The book covers best practices from data warehouse project inception through on-going program management. About 30 to 40% of the content in the book is updated and new. This revised tutorial covers major lifecycle topics such as dimensional modeling, tech architecture, ETL, BI etc. It is targeted at both novice and experienced data warehouse professionals.

The Data Webhouse Toolkit

Building the Web-Enabled Data Warehouse

Author: Ralph Kimball,Richard Merz

Publisher: Wiley

ISBN: 9780471376804

Category: Computers

Page: 417

View: 1028

"Ralph's latest book ushers in the second wave of the Internet. . . . Bottom line, this book provides the insight to help companies combine Internet-based business intelligence with the bounty of customer data generated from the internet."--William Schmarzo, Director World Wide Solutions, Sales, and Marketing,IBM NUMA-Q. Receiving over 100 million hits a day, the most popular commercial Websites have an excellent opportunity to collect valuable customer data that can help create better service and improve sales. Companies can use this information to determine buying habits, provide customers with recommendations on new products, and much more. Unfortunately, many companies fail to take full advantage of this deluge of information because they lack the necessary resources to effectively analyze it. In this groundbreaking guide, data warehousing's bestselling author, Ralph Kimball, introduces readers to the Data Webhouse--the marriage of the data warehouse and the Web. If designed and deployed correctly, the Webhouse can become the linchpin of the modern, customer-focused company, providing competitive information essential to managers and strategic decision makers. In this book, Dr. Kimball explains the key elements of the Webhouse and provides detailed guidelines for designing, building, and managing the Webhouse. The results are a business better positioned to stay healthy and competitive. In this book, you'll learn methods for: - Tracking Website user actions - Determining whether a customer is about to switch to a competitor - Determining whether a particular Web ad is working - Capturing data points about customer behavior - Designing the Website to support Webhousing - Building clickstream datamarts - Designing the Webhouse user interface - Managing and scaling the Webhouse The companion Website at www.wiley.com/compbooks/kimball provides updates on Webhouse technologies and techniques, as well as links to related sites and resources.

Analytische Informationssysteme

Data Warehouse, On-Line Analytical Processing, Data Mining

Author: Peter Chamoni,Peter Gluchowski

Publisher: Springer-Verlag

ISBN: 3662057107

Category: Computers

Page: 484

View: 939

Neben den operativen Informationssystemen, welche die Abwicklung des betrieblichen Tagesgeschäftes unterstützen, treten heute verstärkt Informationssysteme für analytische Aufgaben der Fach- und Führungskräfte in den Vordergrund. In fast allen Unternehmen werden derzeit Begriffe und Konzepte wie Data Warehouse, On-Line Analytical Processing und Data Mining diskutiert und die zugehörigen Produkte evaluiert. Vor diesem Hintergrund zielt der vorliegende Sammelband darauf ab, einen aktuellen Überblick über Technologien, Produkte und Trends zu bieten. Als Entscheidungsgrundlage für den Praktiker beim Aufbau und Einsatz derartiger analytischer Informationssysteme können die unterschiedlichen Beiträge aus Wirtschaft und Wissenschaft wertvolle Hilfestellung leisten.

Three Volume Set of Ralph Kimball's Toolkit Books

Author: Ralph Kimball

Publisher: Wiley

ISBN: 9780471404101

Category: Computers

Page: 1632

View: 3418

Ralph Kimball's three data warehousing books, The Data Warehouse Toolkit, The Data Warehouse Lifecycle Toolkit, and The Data Webhouse Toolkit, provide you with everything you will need to create, manage, and use your data warehouse. His first book, The Data Warehouse Toolkit, is the definitive guide to building a data warehouse. Kimball uses actual case studies of existing data warehouses developed for specific types of business applications such as retail, manufacturing, banking, insurance, subcriptions and airline reservations. Using the techniques learned in Kimball's first book, The Data Warehouse Lifecycle Toolkit carries them to the larger issues of delivering complete data marts and data warehouses. The book shows you all the practical details involved in planning, designing, developing, deploying, and growing data warehouses. The Data Webhouse Toolkit is a groundbreaking guide which introduces the Webhouse, a powerful new way of capturing valuable information flowing into a Web site and ordering it in ways that are useful to managers, strategic decision-makers, and customers.

Star Schema The Complete Reference

Author: Christopher Adamson

Publisher: McGraw Hill Professional

ISBN: 9780071744331

Category: Computers

Page: 510

View: 5399

The definitive guide to dimensional design for your data warehouse Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a comprehensive resource for experts. This all-inclusive volume begins with dimensional design fundamentals and shows how they fit into diverse data warehouse architectures, including those of W.H. Inmon and Ralph Kimball. The book progresses through a series of advanced techniques that help you address real-world complexity, maximize performance, and adapt to the requirements of BI and ETL software products. You are furnished with design tasks and deliverables that can be incorporated into any project, regardless of architecture or methodology. Master the fundamentals of star schema design and slow change processing Identify situations that call for multiple stars or cubes Ensure compatibility across subject areas as your data warehouse grows Accommodate repeating attributes, recursive hierarchies, and poor data quality Support conflicting requirements for historic data Handle variation within a business process and correlation of disparate activities Boost performance using derived schemas and aggregates Learn when it's appropriate to adjust designs for BI and ETL tools

Data Warehousing Fundamentals

A Comprehensive Guide for IT Professionals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 0471463892

Category: Computers

Page: 544

View: 6972

Geared to IT professionals eager to get into the all-importantfield of data warehousing, this book explores all topics needed bythose who design and implement data warehouses. Readers will learnabout planning requirements, architecture, infrastructure, datapreparation, information delivery, implementation, and maintenance.They'll also find a wealth of industry examples garnered from theauthor's 25 years of experience in designing and implementingdatabases and data warehouse applications for majorcorporations. Market: IT Professionals, Consultants.