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.
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
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, Technologies, and Methodologies
Open Source versus Proprietary DW and BI Solutions: Key Differentiators and Integrators
Open Source DW and BI: Uses and Abuses
An Intelligent Query Accelerator Using an Open Cache In, Cache Out Design
Analysis, Evaluation, and Selection
Design and Architecture: Technologies and Methodologies by Dissection
Best Practices Beyond Reporting: Driving Business Value
Advanced Analytics: The Foundation for a Beyond-Reporting Approach (Dynamic KPI, Scorecards, Dynamic Dashboarding, and Adaptive Analytics)
Large Scale Analytics: Business-centric and Technology-centric Requirements and Solution Options
Accelerating Business Analytics: What to Look for, Look at, and Look Beyond
Delivering Information on Demand and Thereby Performance on Demand
Open Standards for Open Source: An EDW/BI Outlook
Each chapter includes an Introduction and Summary
Lakshman Bulusu is a 20-year veteran of the IT industry with specialized expertise and academic experience in the management, supervision, mentoring, review, architectural design, and development of database, data warehousing, and business intelligence-related application development projects encompassing major industry domains such as pharmaceutical/healthcare, telecommunications, news/media, global investment and retail banking, insurance, and retail for clients across the United States, Europe, and Asia. He is well-versed in the primary Oracle technologies through Oracle11g, including SQL, PL/SQL, and SQL-embedded programming, as well as design and development of Web applications that are cross-platform and open source-based.
Mr. Bulusu has expertise in data modeling and design of enterprise data warehousing/business intelligence information architectures, with multiple customer implementations to his credit. His design of application development frameworks using PL/SQL, from design to coding to testing to debugging to performance tuning to business intelligence, has been implemented in some major Fortune 500 clients in the United States. He has implemented the Common Data Quality Framework for SQL Server, based on summarization-comparison-discrepancy isolation across disparate multivendor large-scale databases. He is also an educator who has been teaching technical courses for about a decade in the areas of Oracle design, development, and optimization, and he serves on the CNS Advisory Committee of Anthem Institute (affiliated to Anthem Education Group).
Mr. Bulusu has authored six books on Oracle and more than fifty educational/technical articles in journals and magazines in the United States and the United Kingdom; he has also presented at national and international conferences in the United States and the United Kingdom. He lives in New Jersey and likes to read, write, listen to, and lecture on English poetry and nonfiction when he is not working on IT projects. He can be reached at firstname.lastname@example.org.
… 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 open source BI.
—Rosendo Abellera, President and CEO, BIS3