Open Source Data Warehousing and Business Intelligence

Examining implementation in terms of the systems development life cycle, this book highlights the practical aspects of implementing and using open-source data warehousing and business intelligence technologies. The text explains the key differences between open source, vendor data warehousing, and business intelligence technologies and provides end-to-end solutions that are scalable, high performance, and stable. It covers data warehouse design, real-time processing, data integration, presentation services, and real-time reporting. Emphasizing how they can be used in real-world applications, the author also presents best practices that can save time, effort, cost, and resources.

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.