Dimensional Modeling: In a Business Intelligence Environment

Dimensional Modeling: In a Business Intelligence Environment
Author :
Publisher : IBM Redbooks
Total Pages : 670
Release :
ISBN-10 : 9780738496443
ISBN-13 : 0738496448
Rating : 4/5 (43 Downloads)

Book Synopsis Dimensional Modeling: In a Business Intelligence Environment by : Chuck Ballard

Download or read book Dimensional Modeling: In a Business Intelligence Environment written by Chuck Ballard and published by IBM Redbooks. This book was released on 2012-07-31 with total page 670 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this IBM Redbooks publication we describe and demonstrate dimensional data modeling techniques and technology, specifically focused on business intelligence and data warehousing. It is to help the reader understand how to design, maintain, and use a dimensional model for data warehousing that can provide the data access and performance required for business intelligence. Business intelligence is comprised of a data warehousing infrastructure, and a query, analysis, and reporting environment. Here we focus on the data warehousing infrastructure. But only a specific element of it, the data model - which we consider the base building block of the data warehouse. Or, more precisely, the topic of data modeling and its impact on the business and business applications. The objective is not to provide a treatise on dimensional modeling techniques, but to focus at a more practical level. There is technical content for designing and maintaining such an environment, but also business content. For example, we use case studies to demonstrate how dimensional modeling can impact the business intelligence requirements for your business initiatives. In addition, we provide a detailed discussion on the query aspects of BI and data modeling. For example, we discuss query optimization and how you can determine performance of the data model prior to implementation. You need a solid base for your data warehousing infrastructure . . . . a solid data model.


Dimensional Modeling: In a Business Intelligence Environment Related Books

Dimensional Modeling: In a Business Intelligence Environment
Language: en
Pages: 670
Authors: Chuck Ballard
Categories: Computers
Type: BOOK - Published: 2012-07-31 - Publisher: IBM Redbooks

DOWNLOAD EBOOK

In this IBM Redbooks publication we describe and demonstrate dimensional data modeling techniques and technology, specifically focused on business intelligence
The Data Warehouse Toolkit
Language: en
Pages: 464
Authors: Ralph Kimball
Categories: Computers
Type: BOOK - Published: 2011-08-08 - Publisher: John Wiley & Sons

DOWNLOAD EBOOK

This old edition was published in 2002. The current and final edition of this book is The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling,
The Data Warehouse Toolkit
Language: en
Pages: 608
Authors: Ralph Kimball
Categories: Computers
Type: BOOK - Published: 2013-07-01 - Publisher: John Wiley & Sons

DOWNLOAD EBOOK

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Ki
Innovations in Computing Sciences and Software Engineering
Language: en
Pages: 622
Authors: Tarek Sobh
Categories: Computers
Type: BOOK - Published: 2010-06-26 - Publisher: Springer Science & Business Media

DOWNLOAD EBOOK

Innovations in Computing Sciences and Software Engineering includes a set of rigorously reviewed world-class manuscripts addressing and detailing state-of-the-a
Agile Data Warehouse Design
Language: en
Pages: 330
Authors: Lawrence Corr
Categories: Business & Economics
Type: BOOK - Published: 2011-11 - Publisher: DecisionOne Consulting

DOWNLOAD EBOOK

Agile Data Warehouse Design is a step-by-step guide for capturing data warehousing/business intelligence (DW/BI) requirements and turning them into high perform