Open Source Data Warehousing and Business Intelligence is an all-in-one reference for developing open source based data warehousing (DW) and business intelligence (BI) solutions that are business-centric, cross-customer viable, cross-functional, cross-technology based, and enterprise-wide. Considering the entire lifecycle of an open source DW & BI implementation, its comprehensive coverage spans from basic concepts all the way through to customization.

Highlighting the key differences between open source and vendor DW and BI technologies, the book identifies end-to-end solutions that are scalable, high performance, and stable. It illustrates the practical aspects of implementing and using open source DW and BI technologies to supply you with valuable on-the-project experience that can help you improve implementation and productivity.

Emphasizing analysis, design, and programming, the text explains best-fit solutions as well as how to maximize ROI. Coverage includes data warehouse design, real-time processing, data integration, presentation services, and real-time reporting. With a focus on real-world applications, the author devotes an entire section to powerful implementation best practices that can help you build customer confidence while saving valuable time, effort, and resources.

Reviews

… As a practitioner himself, Mr. Bulusu is able to pinpoint the more critical aspects for consideration that a BI expert would truly appreciate. He does a great job of covering the subject thoroughly by first starting at a high-level, covering every aspect of BI and then breaking down the components to the most granular detail applying open source BI’s feasibility and validity as a viable solution. … Bulusu’s thorough, meticulous approach and in-depth examination of the subject, taken from a standpoint of an experienced author, educator, and technologist, has finally provided justice to this subject. Thank you, Mr. Bulusu. You have opened my eyes to ope BI.

—Rosendo Abellera, President and CEO, BIS3

Contents

Introduction

Data Warehousing and Business Intelligence: What, Why, How, When, When Not?

Taking IT Intelligence to Its Apex

Open Source DW and BI: Much Ado about Anything-to-Everything DW and BI, When Not, and Why So Much Ado?

Taking Business Intelligence to Its Apex: Intelligent Content for Insightful Intent

Data Warehousing and Business Intelligence: An Open Source Solution

What Is Open Source DW and BI, and How "Open" Is This Open?

What’s In, What’s Not: Available and Viable Options for Development and Deployment

Semantic Analytics

Testing for Optimizing Quality and Automation—Accelerated!

Business Rules, Real-World Perspective, Social Context

Personalization Through Customizable Measures

Leveraging the Cloud for Deployment

The Foundations Underneath: Architecture, Technolo...