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: 4786

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 TOOLKIT, 2ND ED

Author: Raiph Kimball

Publisher: John Wiley & Sons

ISBN: 9788126508891

Category:

Page: 460

View: 1064

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.

Das Data Warehouse-Konzept

Architektur - Datenmodelle - Anwendungen

Author: Harry Mucksch,Wolfgang Behme

Publisher: Springer-Verlag

ISBN: 3322993728

Category: Computers

Page: 679

View: 8202

Die Popularität des Data Warehouse-Konzepts unterstreicht die Notwendigkeit einer besseren Informationsbasis für Entscheidungsträger aller Managementebenen. Handelt es sich hierbei lediglich um eine Modeerscheinung, oder eröffnet dieses Konzept tätsächlich Möglichkeiten, Entscheidungsträger mit qualitativ besseren Informationen zu versorgen? Für die dritte Auflage wurde das Buch erneut in Teilen überarbeitet. Ausgehend von der Architektur, den charakteristischen Komponenten und Funktionen eines Data Warehouses analysieren namhafte Experten u.a. folgende Aspekte: Fragen der Entwicklung, Datenmodellierung und -speicherung, die Eignung veschiedener Datenbankmodelle, rechtliche Aspekte, Datenschutz etc. Verzeichnis: Ausgehend von der Architektur, den charakteristischen Komponenten und Funktionen eines Data Warehouses analysieren namhafte Experten u.a. folgende Aspekte: Fragen der Entwicklung, Datenmodellierung und -speicherung, die Eignung veschiedener Datenbankmodelle, rechtliche Aspekte, Datenschutz etc. Für die dritte Auflage wurde das Buch erneut in Teilen überarbeitet.

The Data Warehouse Lifecycle Toolkit

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

Publisher: John Wiley & Sons

ISBN: 1118079566

Category: Computers

Page: 672

View: 1740

A thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. In that time, the data warehouse industry has reached full maturity and acceptance, hardware and software have made staggering advances, and the techniques promoted in the premiere edition of this book have been adopted by nearly all data warehouse vendors and practitioners. In addition, the term "business intelligence" emerged to reflect the mission of the data warehouse: wrangling the data out of source systems, cleaning it, and delivering it to add value to the business. Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. The authors understand first-hand that a data warehousing/business intelligence (DW/BI) system needs to change as fast as its surrounding organization evolves. To that end, they walk you through the detailed steps of designing, developing, and deploying a DW/BI system. You'll learn to create adaptable systems that deliver data and analyses to business users so they can make better business decisions.

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: 5989

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)

Kimball's Data Warehouse Toolkit Classics

3 Volume Set

Author: Ralph Kimball

Publisher: Wiley

ISBN: 9781118875186

Category: Computers

Page: 1800

View: 6928

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.

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: 7120

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-Systeme

Architektur, Entwicklung, Anwendung

Author: Andreas Bauer

Publisher: N.A

ISBN: 9783898647854

Category: Data warehousing

Page: 690

View: 4441

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 Webhouse Toolkit

Building the Web-Enabled Data Warehouse

Author: Ralph Kimball,Richard Merz

Publisher: Wiley

ISBN: 9780471376804

Category: Computers

Page: 417

View: 6359

"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.

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: 2535

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.

Computer Publishing

Grundlagen und Anwendungen

Author: Ulrich Schmitt

Publisher: Springer-Verlag

ISBN: 3642957307

Category: Computers

Page: 481

View: 9002

Computer Publishing für die Praxis ist das Motto des Buches, mit dem Sie selbst anspruchsvolle Prospekte, Zeitschriften oder Bücher leicht erstellen können. Neben tagesaktuellem Anwenderwissen liefert es Ihnen Basisinformationen, die auch mit zukünftigen Hard- und Softwareversionen nicht veralten. Die maßgeschneiderte Arbeitshilfe für jeden Praktiker in Druckvorstufe, Druckindustrie, Design und Entwurf!

Three Volume Set of Ralph Kimball's Toolkit Books

Author: Ralph Kimball

Publisher: Wiley

ISBN: 9780471404101

Category: Computers

Page: 1632

View: 1775

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.

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: 3900

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 Warehousing Fundamentals

A Comprehensive Guide for IT Professionals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 0471463892

Category: Computers

Page: 544

View: 8591

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.

Star Schema The Complete Reference

Author: Christopher Adamson

Publisher: McGraw Hill Professional

ISBN: 9780071744331

Category: Computers

Page: 510

View: 9234

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

A Manager's Guide to Data Warehousing

Author: Laura Reeves

Publisher: John Wiley & Sons

ISBN: 0470549386

Category: Computers

Page: 480

View: 6927

Aimed at helping business and IT managers clearly communicate with each other, this helpful book addresses concerns straight-on and provides practical methods to building a collaborative data warehouse . You’ll get clear explanations of the goals and objectives of each stage of the data warehouse lifecycle while learning the roles that both business managers and technicians play at each stage. Discussions of the most critical decision points for success at each phase of the data warehouse lifecycle help you understand ways in which both business and IT management can make decisions that best meet unified objectives.

Ein Tag im Dezember

Roman

Author: Josie Silver

Publisher: Heyne Verlag

ISBN: 3641229936

Category: Fiction

Page: 480

View: 6678

Ein Augenblick reicht aus, um sich zu verlieben. Doch es braucht ein halbes Leben, um sich zu lieben. Jack und Laurie begegnen sich an einem kalten Dezembertag. Es fühlt sich an, als wäre es die große Liebe, doch dann verpassen sie den richtigen Zeitpunkt um ein paar Sekunden. Erst ein Jahr später treffen sie sich endlich wieder, aber mittlerweile ist Jack mit Sarah zusammen, Lauries bester Freundin, und ihre Liebe scheint unmöglich. Was bleibt, ist eine Freundschaft, die über Jahre hält, in der sie einander Geheimnisse und Träume anvertrauen. Eine Freundschaft, die ihnen Halt gibt, auch wenn alles andere aus dem Ruder läuft. Aber so richtig vergessen können sie ihre Gefühle füreinander nie ...