Business Intelligence Guidebook: From Data Integration to Analytics

Business Intelligence Guidebook fills the gap between high-level BI concept books and vendor tool manuals by walking the reader through the entire lifecycle of creating a world-class BI environment: justifying the investment, defining requirements, building architectural blueprints (information, data, technology, and product), designing data models (entity-relationship and dimensional), engineering data integration processes, developing BI applications and advanced analytics, taming data shadow systems, and managing the organizational dimensions of people, process, politics, project management, and centers of excellence. Drawing on decades of consulting and implementation experience, Rick Sherman argues that BI is not a one-and-done project but an evolving program that must be built incrementally and iteratively, grounded in the recognition that raw data must be transformed into clean, consistent, conformed, current, and comprehensive information before it delivers business value. The book is deliberately product-neutral so its concepts endure beyond vendor mergers and hype cycles, and it repeatedly stresses that the hardest part of BI is not technology but the human and organizational factors that determine whether solutions are actually adopted and trusted.

What it argues

Business Intelligence Guidebook: From Data Integration to Analytics

Key ideas it contributes

• Architectural Discipline — The degree to which the enterprise designs and follows an overarching four-layer architectural framework (information, data, technology, product) before selecting products, avoiding the accidental architecture and silos.
• Data Integration Rigor — The extent to which data integration is engineered holistically with standards, reusable components, tools, documentation, and auditability rather than hand-coded extracts, representing the largest share of BI work.
• Dimensional Modeling Quality — The soundness of data design using dimensional and hybrid dimensional-normalized models, conformed dimensions, surrogate keys, slowly changing dimensions, and appropriate schemas to support analytics.
• Tool-Based Development Adoption — The degree to which BI, data integration, and database tools (selected as best fit for needs, skills, and budget) are used rather than ad hoc manual coding, enabling productivity, governance, and reuse.
• Requirements and Expectation Management — The thoroughness of defining business, data, quality, functional, and technical requirements and the active setting and managing of realistic stakeholder expectations through justification, roadmaps, and communication.
• Training Investment — The investment in vendor-agnostic foundational BI training, tool-specific training, and use-case-based training for both business and IT people.
• Organizational Governance and Sponsorship — The presence of executive sponsorship, data governance, project/program management discipline, and centers of excellence that manage people, process, and politics across the enterprise.
• Information Quality (Five Cs) — The degree to which delivered information is clean, consistent, conformed, current, and comprehensive, representing the central contextual condition that determines whether data has business value for analysis and decision-making.
• Data and Application Silo Proliferation — The extent to which disconnected data, application, and reporting silos (including data shadow systems and spreadmarts) accumulate across the enterprise, producing inconsistent and incomplete information.
• Trust in Information — The psychological state of business people having confidence in the data and analytics they consume, free from debate over whose numbers are correct.
• BI Adoption and Usage — The behavioral pattern of business people actively using BI applications in their jobs rather than reverting to spreadsheets or data shadow systems.
• Business-IT Collaboration — The behavioral pattern of business and IT groups working as partners with open communication, shared accountability, and active business participation throughout the BI lifecycle.
• Business Value and ROI — The outcome of BI delivering tangible business benefits—revenue optimization, cost reduction, risk reduction, improved decision-making—producing return on investment.
• BI Project Success — The outcome of BI projects being delivered on time, within budget, with quality, and—most importantly—meeting stakeholder expectations.
• Business and IT Productivity — The outcome of business people shifting time from data gathering and reconciliation to analysis, and IT shifting from maintenance to expanding BI value.