Open Source Data Warehousing and Business Intelligence

xxix, 398 p. : 25 cm Includes bibliographical references and index 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. Open Source Date 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 form 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 implantation 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 A 20-year veteran of information technology based in New Jersey, Lakshman highlights the practical aspects of using open source data warehousing and business intelligence technologies from an end-to-end lifecycle perspective: from concepts through implementation to customization. He concentrates on deciding factors, key design criteria and methodologies, expert techniques, and best practices. The material could be useful for any person or team involved in creating, implementing, or operating open source systems but could also be interesting to researchers, students, and instructors. Annotation ©2012 Book News, Inc., Portland, OR (booknews.com) Foreword Introduction Acknowledgements About the author Introduction Data warehousing and business intelligence : an open source solution Open source DW & BI : successful players and products Analysis, evaluation and selection Design and architecture : technologies and methodologies by dissection Operational bi and open source Development and deployment Best practices for data management Best practices for application management Best practices beyond reporting : driving business value EDW/BI development frameworks Best practices for optimization Open standards for open source : an EDW/BI outlook Index. 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. It explains the key differences between open source, vendor data warehousing, and business intelligence technologies.