Dimensional Modeling: In a Business Intelligence Environment

Dimensional Modeling: In a Business Intelligence Environment PDF

Author: Chuck Ballard

Publisher: IBM Redbooks

Published: 2012-07-31

Total Pages: 670

ISBN-13: 0738496448

DOWNLOAD EBOOK →

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.

The Data Warehouse Toolkit

The Data Warehouse Toolkit PDF

Author: Ralph Kimball

Publisher: John Wiley & Sons

Published: 2013-07-01

Total Pages: 600

ISBN-13: 1118732286

DOWNLOAD EBOOK →

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

The Data Warehouse Toolkit PDF

Author: Ralph Kimball

Publisher: John Wiley & Sons

Published: 2011-08-08

Total Pages: 464

ISBN-13: 1118082141

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, 3rd Edition which was published in 2013 under ISBN: 9781118530801. The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including: Retail sales and e-commerce Inventory management Procurement Order management Customer relationship management (CRM) Human resources management Accounting Financial services Telecommunications and utilities Education Transportation Health care and insurance By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.

Mastering Data Warehouse Design

Mastering Data Warehouse Design PDF

Author: Claudia Imhoff

Publisher: Wiley

Published: 2003

Total Pages: 460

ISBN-13: 9780471324218

DOWNLOAD EBOOK →

A cutting-edge response to Ralph Kimball's challenge to the data warehouse community that answers some tough questions about the effectiveness of the relational approach to data warehousing Written by one of the best-known exponents of the Bill Inmon approach to data warehousing Addresses head-on the tough issues raised by Kimball and explains how to choose the best modeling technique for solving common data warehouse design problems Weighs the pros and cons of relational vs. dimensional modeling techniques Focuses on tough modeling problems, including creating and maintaining keys and modeling calendars, hierarchies, transactions, and data quality

The Kimball Group Reader

The Kimball Group Reader PDF

Author: Ralph Kimball

Publisher: John Wiley & Sons

Published: 2010-03-11

Total Pages: 744

ISBN-13: 0470633921

DOWNLOAD EBOOK →

An unparalleled collection of recommended guidelines for data warehousing and business intelligence pioneered by Ralph Kimball and his team of colleagues from the Kimball Group. Recognized and respected throughout the world as the most influential leaders in the data warehousing industry, Ralph Kimball and the Kimball Group have written articles covering more than 250 topics that define the field of data warehousing. For the first time, the Kimball Group's incomparable advice, design tips, and best practices have been gathered in this remarkable collection of articles, which spans a decade of data warehousing innovation. Each group of articles is introduced with original commentaries that explain their role in the overall lifecycle methodology developed by the Kimball Group. These practical, hands-on articles are fully updated to reflect current practices and terminology and cover the complete lifecycle—including project planning, requirements gathering, dimensional modeling, ETL, and business intelligence and analytics. This easily referenced collection is nothing less than vital if you are involved with data warehousing or business intelligence in any capacity.

Business Intelligence

Business Intelligence PDF

Author: David Loshin

Publisher: Elsevier

Published: 2003-07-10

Total Pages: 292

ISBN-13: 0080500544

DOWNLOAD EBOOK →

Business Intelligence describes the basic architectural components of a business intelligence environment, ranging from traditional topics such as business process modeling, data modeling, and more modern topics such as business rule systems, data profiling, information compliance and data quality, data warehousing, and data mining. This book progresses through a logical sequence, starting with data model infrastructure, then data preparation, followed by data analysis, integration, knowledge discovery, and finally the actual use of discovered knowledge. The book contains a quick reference guide for business intelligence terminology. Business Intelligence is part of Morgan Kaufmann's Savvy Manager's Guide series. * Provides clear explanations without technical jargon, followed by in-depth descriptions. * Articulates the business value of new technology, while providing relevant introductory technical background. * Contains a handy quick-reference to technologies and terminologies. * Guides managers through developing, administering, or simply understanding business intelligence technology. * Bridges the business-technical gap. * Is Web enhanced. Companion sites to the book and series provide value-added information, links, discussions, and more.

Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services

Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services PDF

Author: Chuck Ballard

Publisher: IBM Redbooks

Published: 2009-04-27

Total Pages: 276

ISBN-13: 0738432628

DOWNLOAD EBOOK →

In this IBM Redbooks publication, we discuss and describe a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner. The focus of this infrastructure is the InfoSphere Warehouse Cubing Services Feature. With this feature, DB2 becomes the data store for large volumes of data that you can use to perform multidimensional analysis, which enables viewing complex problems from multiple perspectives, which provides more information for management business decision making. This feature supports analytic tool interfaces from powerful data analysis tools, such as Cognos 8 BI, Microsoft Excel, and Alphablox. This is a significant capability that supports and enhances the analytics that clients use as they work to resolve problems with an ever growing scope, dimension, and complexity. Analyzing problems by performing more detailed queries on the data and viewing the results from multiple perspectives yields significantly more information and insight. Building multidimensional cubes based on underlying DB2 relational tables, without having to move or replicate the data, enables significantly more powerful data analysis with less work and leads to faster problem resolution with the capability for more informed management decision making. This capability is known as No Copy Analytics and is made possible with InfoSphere Warehouse Cubing Services.

Data Warehousing with the Informix Dynamic Server

Data Warehousing with the Informix Dynamic Server PDF

Author: Chuck Ballard

Publisher: IBM Redbooks

Published: 2009-12-10

Total Pages: 478

ISBN-13: 0738433845

DOWNLOAD EBOOK →

The IBM Informix® Dynamic Server (IDS) has the tools to build a powerful data warehouse infrastructure platform to lower costs and increase profits by doing more with your existing operational data and infrastructure. The Informix Warehouse Feature simplifies the process for design and deployment of a high performance data warehouse. With a state-of-the-art extract, load, and transform (ELT) tool and an Eclipse-based GUI environment that is easy to use, this comprehensive platform provides the foundation you need to cost effectively build and deploy the data warehousing infrastructure, using the IBM Informix Dynamic Server, and needed to enable the development and use of next-generation analytic solutions . This IBM® Redbooks® publication describes the technical information and demonstrates the functions and capabilities of the Informix Dynamic Server Warehouse Feature. It can help you understand how to develop a data warehousing architecture and infrastructure to meet your particular requirements, with the Informix Dynamic Server. It can also enable you to transform and manage your operational data, and use it to populate your data warehouse. With that new data warehousing environment, you can support the data analysis and decision-making that are required as you monitor and manage your business processes, and help you meet your business performance management goals, objectives, and measurements.

Lanterna Rally - Theme by Grace Themes