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

Continue Reading →

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

Continue Reading →

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.

The Microsoft Data Warehouse Toolkit

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset
Author: Joy Mundy,Warren Thornthwaite
Publisher: John Wiley & Sons
ISBN: 9781118067956
Category: Computers
Page: 704
View: 2404

Continue Reading →

Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming “Business Intelligence release” of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most organizations. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, as well as Microsoft Office, the authors walk you through a full project lifecycle, including design, development, deployment and maintenance. Features more than 50 percent new and revised material that covers the rich new feature set of the SQL Server 2008 R2 release, as well as the Office 2010 release Includes brand new content that focuses on PowerPivot for Excel and SharePoint, Master Data Services, and discusses updated capabilities of SQL Server Analysis, Integration, and Reporting Services Shares detailed case examples that clearly illustrate how to best apply the techniques described in the book The accompanying Web site contains all code samples as well as the sample database used throughout the case studies The Microsoft Data Warehouse Toolkit, Second Edition provides you with the knowledge of how and when to use BI tools such as Analysis Services and Integration Services to accomplish your most essential data warehousing tasks.

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

Continue Reading →

"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

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

Continue Reading →

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

Continue Reading →

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.

Das Data Warehouse-Konzept

Architektur — Datenmodelle — Anwendungen
Author: Harry Mucksch,Wolfgang Behme
Publisher: Gabler Verlag
ISBN: 9783409422161
Category: Computers
Page: 543
View: 8743

Continue Reading →

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.

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

Continue Reading →

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

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

Continue Reading →

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

Continue Reading →

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

Continue Reading →

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

Continue Reading →

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

Three Volume Set of Ralph Kimball's Toolkit Books


Author: Ralph Kimball
Publisher: Wiley
ISBN: 9780471404101
Category: Computers
Page: 1632
View: 496

Continue Reading →

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 mining, data warehousing

datenschutzrechtliche Orientierungshilfen für Privatunternehmen
Author: Alex Schweizer
Publisher: N.A
ISBN: 9783280025406
Category: Data mining
Page: 416
View: 3498

Continue Reading →

Private Unternehmung.

Data Warehouse Technologien

2. Auflage
Author: Köppen / Saake / Sattler
Publisher: MITP-Verlags GmbH & Co. KG
ISBN: 3826695887
Category: COMPUTERS
Page: 351
View: 9512

Continue Reading →

Detailliert werden in diesem Buch sowohl der Aufbau als auch die Nutzung von Data-Warehouse-Systemen beleuchtet. Dabei stehen Modellierungskonzepte und die Thematik der multidimensionalen Anfragen im Vordergrund. Zudem werden Interna wichtiger Systemlösungen von Oracle, IBM und Microsoft anhand zahlreicher Beispiele erläutert.

Information Age Economy

5. Internationale Tagung Wirtschaftsinformatik 2001
Author: Hans U. Buhl,Andreas Huther,Bernd Reitwiesner
Publisher: Birkhäuser
ISBN: 9783790814279
Category: Business & Economics
Page: 986
View: 3127

Continue Reading →

Der Einsatz von Informations- und (Tele-)Kommunikationssystemen für die Wirtschaft ist durch den rapiden technologischen Fortschritt zu Beginn des 3. Jahrtausends zur allgegenwärtigen Erscheinung geworden. Unter Schlagworten wie e(lectronic)-, m(obile)-, u(biquitious)-Computing/Commerce werden heute Zukunftsvisionen diskutiert, die den Informations- und Kommunikationssystemen weit über ihre derzeitigen Einsatzzwecke hinaus eine zentrale Rolle auf dem Weg zur Elektronischen Dienstleistungswirtschaft einräumen. Dieses Buch betrachtet diese Entwicklung in all ihren Facetten und stellt richtungsweisende Forschungs- und Praxisarbeiten an der Schnittstelle von moderner Betriebswirtschaftslehre, Wirtschaftsinformatik und angewandter Informatik vor. Es schlägt die Brücke zwischen Wissenschaft und Praxis, indem es die wesentlichen Gestaltungsoptionen- und Empfehlungen aufzeigt, die den Unternehmungen den erfolgreichen Weg in die "Information Age Economy" ebnen.

Analytische Informationssysteme

Data Warehouse, On-Line Analytical Processing, Data Mining ; mit 19 Tabellen
Author: Peter Chamoni
Publisher: N.A
ISBN: 9783540658436
Category: Business
Page: 484
View: 6198

Continue Reading →