Leading With Data· a Bicycle Guide

Partial book profile

Business Intelligence Guidebook From Data Integration to Analytics

Rick Sherman

A comprehensive guidebook that walks practitioners through the entire lifecycle of a business intelligence project, from justification and architecture to data integration and analytics, to transform raw data into actionable business information.

The full book profile is not available yet.

Get the book →

What it’s about

In an era of data deluge, many organizations have too much data but too little actionable information, leading to inconsistent reporting, wasted effort, and poor decision-making. The 'Business Intelligence Guidebook' provides a complete, start-to-finish roadmap for both IT and business professionals to navigate this complexity. It bridges the gap between high-level concepts and vendor-specific tool training by offering a practical, comprehensive framework covering every critical stage: building the business case, defining requirements, establishing a robust architectural framework (information, data, technical, and product), mastering data modeling, designing rigorous data integration processes, and developing user-centric BI applications. By also addressing the crucial 'soft' challenges of people, process, and politics, this book equips you to build a sustainable, world-class BI environment that transforms data from a liability into your organization's most valuable asset.

The through-line

Who it’s for
The reader is a business or IT professional, such as a manager, analyst, developer, or architect, tasked with building or improving their organization's business intelligence capabilities. They want to harness their company's data to drive better decision-making, improve performance, and gain a competitive edge.
The problem
The organization is drowning in a 'data deluge' with 'too much data, too little information.' Existing reporting is fragmented across disparate data silos and uncontrolled 'data shadow systems' (spreadsheets), leading to inconsistent numbers, wasted effort, and an inability to get a clear view of the business. They feel frustrated, confused, and powerless, unable to get the reliable, timely information needed for their jobs. They are skeptical of vendor hype and anxious about the high failure rate of BI projects, fearing they will lead another project that is late, over-budget, and fails to meet expectations.
The plan
  1. Justify the BI Program by building a solid business and technical case.
  2. Define the business, data, and quality requirements for the solution.
  3. Establish a comprehensive Architectural Framework (Information, Data, Technology, Product).
  4. Design the data models using foundational and dimensional modeling techniques.
  5. Design and develop the Data Integration processes to transform data into high-quality information.
The payoff
Leading successful BI projects that deliver consistent, clean, and actionable information across the enterprise. · Becoming a trusted strategic advisor who empowers the organization to make data-driven decisions with confidence. · Eliminating wasteful data silos and spreadsheet chaos, freeing up resources for value-added analysis.

See our guide

Related profiles we’ve built

Featured in these guides

Co-cited books