Business Analysis for Business Intelligence

Book description

Aligning business intelligence (BI) infrastructure with strategy processes not only improves your organization's ability to respond to change, but also adds significant value to your BI infrastructure and development investments. Until now, there has been a need for a comprehensive book on business analysis for BI that starts with a macro view and

Table of contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Table of Contents
  5. Preface
  6. Acknowledgments
  7. Chapter 1 Introduction
    1. Why This Book?
      1. ICT Has Grown Up
      2. A Practical Approach
      3. Hands-On Issues, Questions, and Methods
      4. Figures Don’t Explain Everything
    2. What I Mean by “Business Intelligence”
      1. From Decision Support to Information Democracy
      2. A Definition
      3. Scope of This Book
    3. What Does a BA4BI Do?
      1. Defining the Concept “Business Analyst for Business Intelligence”
        1. “How” Career Path
        2. “Where” Career Path
        3. “C-Level” Career Path
    4. Structure of This Book
      1. Principal Aspects
        1. Strategy Formulation and Formation
        2. Strategy Implementation
        3. Developing a Marketing Strategy
        4. Financial Perspective
        5. Operations Strategy
        6. HRM and BI
        7. Business Intelligence Framework
        8. Introducing a BI Project
        9. Typical Business Analysis Project Flow
        10. Business Intelligence Processes
      2. Tips, Tricks, and a Toolbox
      3. BI System
    5. Chapters of This Book
      1. Macroscopic View of Business Intelligence
        1. Increasing Cycle Speed of Growth and Its Laws
        2. Balancing the 5 Ps of Strategic Management
        3. Adapting BI to the Organization’s Configuration
        4. Understanding the 4 Cs
        5. Business Case for Business Intelligence
      2. Business Analysis and Management Areas
        1. BI and Cost Accounting
        2. BI and Financial Management
        3. BI and Operations Management
        4. BI and Marketing Management
        5. BI and Human Resources Management
      3. Business Analysis and the Project Life Cycle
        1. Starting a BI Project
        2. Managing the Project Life Cycle
        3. Mastering Data Management
        4. Mastering Data Quality
      4. Business Analyst’s Toolbox
        1. Project Direction Document Template
        2. Interview Summary Template
        3. Business Case Document Template
        4. Business Analysis Deliverables Template
        5. Project Charter Document Template
        6. Best Practice Sharing Template
        7. Generic Interview Guide
        8. Generic Business Object Definitions
      5. Appendices Overview
        1. Appendix A: What to Ask on Your Job Interview
        2. Appendix B: Business Intelligence from 1960 to Today
        3. Appendix C: The 101 on Data Warehousing
        4. Appendix D: Survey for a BI Project
  8. Chapter 2 The Increasing Cycle Speed of Growth and Its Laws
    1. Introduction
      1. Growth Has a Price
        1. Useful Lifespan of the PLC
      2. Three Deltas
        1. Time, the Essential Strategic Factor
      3. Business Analysis Issues
    2. First Law: The Triangle of Knowledge, Growth, and Strategy Processes
      1. The Knowledge Exchange Process
        1. Reciprocity
        2. Long-Term Perspectives
        3. Fewer Hierarchies
      2. Measuring Reciprocity
        1. Organizational Drivers
        2. Personnel Drivers
      3. Business Analysis Issues
    3. Second Law: Your Narrow Choice between Two Options
      1. Focus
      2. Conquest
      3. Retreat
      4. Redeploy
      5. Strategy Continuum
      6. Business Analysis Issues
    4. Third Law: Any Organization Optimizes Two Extremes
      1. Value Chain Revisited
      2. Business Analysis Issues
        1. What Defines Overall Cost Leadership?
        2. What Defines Differentiation?
    5. Fourth Law: Measure Only What You Can Measure But
      1. Experiment
        1. Results
        2. Conclusion
      2. Business Analysis Issues
        1. A Few Tips
    6. Fifth Law: There Is Always a Dominant Source
      1. The Strategic Apex
        1. Exploring Alternatives and Options
      2. Functional Management
        1. Marketing versus Finance
        2. Finance versus Operations
        3. Operations versus Marketing
      3. Operational Layer
        1. Bottom-Up Strategy Formation
        2. Cybernetic Feedback Loops
    7. Sixth Law: IT Is Here to Stay
      1. IT Can Create Competitive Advantages
      2. Alignment Movement
      3. Business Analysis Issues
  9. Chapter 3 Balancing the 5 Ps of Strategic Management
    1. Introduction
    2. The 5 Ps and Their Interaction
    3. Managing Strategy
      1. Three Strategy Management Styles
        1. The Linear Style
        2. The Judgmental Style
        3. The Bargaining Style
        4. Conclusion
      2. Strategy Management Styles and Plan–Pattern–Ploys
        1. Choosing the Center of Gravity
  10. Chapter 4 Adapting BI to the Organization’s Configuration
    1. Introduction
    2. Mintzberg’s Configurations
    3. Mintzberg’s Lessons for Business Intelligence
      1. Business Analysis Issues
  11. Chapter 5 Understanding the 4 Cs
    1. Introduction
    2. Applying the 4 C Perspective on Functions
    3. 4 Cs: The Foundation of a Balanced Scorecard
      1. Business Analysis Issues
  12. Chapter 6 Business Case for Business Intelligence
    1. Introduction
    2. Basics of Information Economics
    3. Illustrating IE with a Business Case
      1. From a Process to a Marketing Culture
        1. First Conclusion: Save on Reporting Operations
        2. Second Conclusion: Churn Reduction through Better Customer Analysis
        3. Third Conclusion: Better Prospect Qualification
    4. Generic Advantages of Business Intelligence
      1. Improved Communication Effectiveness
      2. Improved Data Quality
        1. Common Engineering Models
        2. Product Data Models
        3. Customer Data Models
      3. Better Understanding of Available Data
      4. Smarter Extraction and Exchange of Data
      5. Better Understanding of the Business Processes
  13. Chapter 7 BI and Cost Accounting
    1. Setting up an ABC System Using BI
      1. Assemble All Sources of Cost Registration
      2. Validate the Consistency
      3. Assign the Sources in a Meaningful Way
        1. Eight Steps for Cost Assignment
        2. Consider the Alternatives during the Cost Assignment Process
      4. Express Assumptions
      5. Communicate the Results and Validate Them in the Field
      6. Pros and Cons of Activity-Based Costing
        1. Pros
        2. Cons
    2. Closer Look at ABC Source Systems
      1. Accounting System
      2. Enterprise Resource Planning (ERP) System
      3. Product Data Management Systems
      4. Budgeting Systems
      5. Time Registration and Access Systems
      6. Payroll Systems
      7. Warehouse Management Systems
      8. Inventory Management Systems
      9. Document Management Systems
    3. Setting up ABC Analysis in the Data Warehouse
    4. Conclusion
  14. Chapter 8 BI and Financial Management
    1. The 101 on Financial BI Deliverables
    2. Keep Your SOX On!
      1. Data Lineage
      2. Mutual Adjustment
      3. Understanding the Business Process Flows
    3. Business Analysis for Financial Reporting
      1. Chart of Accounts
      2. Required Reports
        1. Certified Reports
        2. Analytical and Explorative Reports
        3. Finance Reports Connected to Other Subject Areas
      3. Special Attention for Slowly Changing Dimensions
      4. Special Attention for Presentation Options
      5. Business Analysis Issues
  15. Chapter 9 BI and Operations Management
    1. The 101 on Operations Management
      1. Customer Order Point (COP)
      2. Forecasting
      3. Optimization of the Supply Chain
        1. Business FAQs
      4. Quality Management
      5. Setting up Outsourcing Analysis
    2. Production Management and Information Architecture
      1. MRP II Software
      2. Capacity Management Software
      3. Network Planning Software
      4. A Basic Concept of IS for Production Management
    3. What to Measure
      1. First Example: Physical Goods Transport
      2. Second Example: Inventory Management Systems
        1. s,Q or the Two-Bin System
        2. s,S
        3. R,S
        4. R,s,S
    4. Basic Supply Chain Report Requirements
      1. Introduction
      2. Total Cycle and Optimum Variable Cost
        1. Rotation of Supplies
        2. Rotation of Production
        3. Rotation of Customers
        4. Rotation of Purchases and Subcontractors
        5. Total Cycle = RotationS + RotationPR + RotationC – RotationP Optimum Total Variable Costs
      3. EOQ with Partial Deliveries
      4. Product Analysis
      5. Supplier Analysis
    5. Setting up a Forecasting System Using BI
      1. General Recommendations
        1. Forecasting Can Have a Thorough Impact
        2. Forecasting Is a Total Process
      2. Defining the KPIs for a Forecasting System
      3. Cost Justification for Forecasting
        1. Step 1: Collect the Data
        2. Step 2: Decide on the Grain
        3. Step 3: Integrate the Data
        4. Step 4: Select the Data
        5. Step 5: Prepare the Data
        6. Step 6: Choose and Develop the Model
        7. Step 7: Validate the Model
        8. Step 8: Evaluate the Model in Detail
        9. Step 9.1: Evaluate the Results: Improved Delivery Performance
        10. Step 9.2: Evaluate the Results: Reduction in Inventory Carrying Costs
        11. Step 9.3: Do a Complete Cost of Ownership Analysis
        12. Step 9.4: Calculate the ROI
      4. Business Analysis Issues
        1. General Remarks
        2. Questions and Issues to Be Addressed
  16. Chapter 10 BI and Marketing Management
    1. Introduction
    2. What Do We Mean by “CRM”?
    3. What Do We Mean by Behavior Analysis?
    4. Can We Learn from Past Failures?
      1. When Operations Leads the Dance
      2. When Finance Leads the Dance
      3. When Overly Complex Sales Models Are the Rule
      4. When BI Is Used for the Wrong Reasons
    5. How BI Can Contribute to Marketing Management
      1. Market Research
      2. Affinity Analysis
      3. Direct Product Profitability (DPP)
      4. Product Development
      5. Sales
      6. Sales Promotion
      7. Customer Service
      8. Channel Management
      9. Retail Marketing
      10. Industrial Marketing
      11. Professional Services Marketing
      12. Fast-Moving Consumer Goods Marketing
      13. Consumer Investment Goods Marketing
      14. Pharmaceutical Marketing
        1. OTC Products Marketing
        2. Ethical Drugs Marketing
      15. Business Analysis Issues
        1. Check the CRM Data
        2. Check the Behavioral Analysis Status
        3. Market Research
        4. Affinity Analysis
        5. Direct Product Profitability
        6. Product Development
        7. Sales
        8. Sales Promotion
        9. Customer Service
        10. Channel Management
        11. Retail Marketing
        12. Industrial Marketing
        13. Professional Services Marketing
        14. Fast-Moving Consumer Goods Marketing
        15. Consumer Investment Goods Marketing
        16. Pharmaceutical Marketing
  17. Chapter 11 BI and Human Resources Management
    1. The War for Talent and How to Lose It
      1. Disconnect Strategy Planning Process—Competence Management
        1. A Lack of ERM Strategies
        2. Kurieren am Symptom
    2. Managing Absenteeism
      1. Introduction
      2. Absenteeism Measures
      3. How BI Can Lend a Hand
      4. Business Analysis Issues
        1. Security
        2. “Hard” KPIs
        3. “Soft” KPIs
      5. Questions for the HRM Department
  18. Chapter 12 Starting a BI Project
    1. Overview
      1. An Iterative Process
        1. Mapping the Process Stages on the Business Analysis Issues
    2. Creating the Need
      1. Expectations: In Search of the Business Value
      2. Funding the Business Intelligence Project
      3. Probing for the Motivation
      4. Focus on the Expectations through the Entire Project
      5. Formal Things Customers Want
      6. Informal Things Customers Want
      7. Handle Queues
      8. Close Loops
    3. Gathering the Information
      1. Study the Terrain
      2. Who You Need to Know
      3. What You Need to Know
    4. Analyzing the Decision-Making Processes
      1. Introduction
      2. Decisions, Teams, and Groups at Work
        1. A Classification of Decision-Making Environments
        2. Process View
        3. What Drives the Decision-Making Process
        4. Heuristics
        5. Stereotyping, the Dark Force
        6. Group Decision Making
      3. Organizational Change
        1. Make the Trade Profitable
        2. Make Them Dream
        3. Use Positive Feedback
        4. Phase Out the Old Systems, Fast
        5. Form a Coalition of the Willing
        6. Adapt to the Organization’s Risk Profile
        7. Prepare for Setbacks
      4. Mintzberg’s Management Myths
        1. What Do We Learn from This for Our BI Projects?
      5. Conclusion
      6. Business Analysis Issues
    5. Producing the Documents
      1. Project Direction Document
      2. Interview Summaries
      3. Business Requirements
      4. Business Case
      5. Project Charter
    6. Validating the Results
      1. “I Wanted Performance!”
      2. “Why Do I Need the Full Client?”
      3. “Now That I See the Results…”
      4. Check the Business Case
    7. Support and Maintenance
      1. Validation
      2. Vision Support
  19. Chapter 13 Managing the Project Life Cycle
    1. Business Analysis and Project Planning
    2. Business Requirements Gathering
      1. Interview the CEO
        1. What Are Your Objectives?
      2. Survey the User Group
        1. What Are Your Objectives?
      3. Interviews and Workshops
        1. What Are Your Objectives?
      4. Requirements Challenging
        1. How to Challenge the Requirements
        2. Testing the Robustness of the Requirements
      5. Making It Stick
        1. Solid Building Blocks
        2. Auxiliary Analysis Areas
    3. Dimensional Modeling
      1. Data Warehousing 2.0 from Bill Inmon
      2. Conformed Dimensions of Ralph Kimball
      3. Hubs, Links, and Satellites of Dan Linstedt
      4. Mixed Design Choices
      5. Conclusions
    4. BI Application Specification
    5. Business Analysis and Growth—Maintenance
      1. Source Changes
      2. Dwindling User Support
      3. Sharing Project Knowledge
        1. Knowledge Objects
        2. Interview
        3. Publication Platform
      4. Preparing a BI Competence Center
        1. Assess Readiness
        2. Build the Team
      5. Business Analysis Issues
        1. Conclusion
  20. Chapter 14 Mastering Data Management
    1. Major Components of Data Management
      1. Overview
      2. Master Data
      3. Source Analysis
      4. Data Profiling
      5. Source-to-Target Mapping
      6. Metadata Management for Business Analysts
        1. Before the Project
        2. During the Project
        3. After the Project
    2. Framework for Data Management
      1. Dublin Core
      2. Zachman Framework
      3. Structured Writing
        1. Structured Writing and Data Management
      4. How the Three Components Interact
  21. Chapter 15 Mastering Data Quality
    1. Which Quality?
    2. ROI Approach to Data Quality
      1. Data Quality for Source Systems
        1. Marketing Aspects
        2. Finance Aspects
        3. Operational Aspects
      2. Data Quality for Data Warehouse Systems
        1. Customer Segmentation
        2. Customer Credit Analysis
        3. Fraud Prevention and Detection
      3. Building the Business Case
      4. Data Quality Checklist
        1. History Review of the Data Sources
        2. Present Situation Review
        3. Future Outlook
  22. Chapter 16 Business Analyst’s Toolbox
    1. Overview
    2. Project Direction Document Template
      1. Introduction
    3. Document’s Contents
      1. Project Background
      2. Project Context
      3. Business Case
      4. Project Definition
      5. Project Organization Structure
      6. Project Approach
    4. Interview Summary Template
      1. Background Information
        1. Roles and Responsibilities
        2. Business Processes
        3. Interaction with or Ownership of Business Processes
        4. Interview Summary
        5. Open Issues—Questions
        6. Next Steps
    5. Business Case Document Template
      1. Introduction
      2. Efficiency Economics
        1. Ad Hoc Reports
        2. Asset Management
        3. Absenteeism Reduction
        4. Reduction in Coordination Costs
        5. Improved Negotiation Position
      3. Revenue Improvement
        1. Pricing
        2. Qualification Improvement
        3. Customer Valuation Improvement
        4. Improvement in Order Cancellations
        5. Improved Forecasting
    6. Strategic Opportunities
      1. Information Value for Your Customers
        1. Faster Response to Changing Conditions
        2. Quality of Decisions
    7. Business Analysis Deliverables Template
      1. Introduction and Overview
      2. Overview of the Deliverables
        1. High-Level Situation Analysis
        2. Purpose of the BI Project
        3. Stakeholder Matrix
        4. Business Requirements
        5. Project Management Constraints
        6. Scope of the Product
        7. Data Requirements
        8. Presentation Methods
        9. Business Security Requirements
        10. Other Requirements
        11. Project Plan and Task List Proposal
        12. Documentation
        13. Glossary
    8. Project Charter Document Template
      1. Overview
        1. Project Scope
        2. Project Organization
        3. External Relationships and Dependencies
        4. Project Approach
        5. Project Resources
        6. Risk Analysis
        7. Business Case
        8. Initial Project Plan
    9. Best Practice Sharing Template
      1. Overview
        1. Title Page
        2. Executive Summary
        3. Best Practice Identification
        4. Reason(s) Why This Is a Best Practice
        5. Definitions
        6. Resources for the Best Practice
        7. How the Best Practice Works
        8. Specific Instructions
        9. Cost
        10. Application Area
        11. Contact Information
    10. Generic Interview Guide
      1. Introduction
        1. How to Introduce the Interview Guide
      2. Generic Interview List
        1. Frame of Reference
      3. Generic Questions
      4. Finally
    11. Interview Guide per Functional Area
      1. Strategic Decision Making
      2. Finance and Controlling
      3. Marketing
      4. Sales
      5. Logistics and Operations
    12. Metadata Checklist
      1. Metadata for Integration
      2. Metadata for Transformation
    13. Generic Business Object Definitions
      1. Overview
    14. Defining the Principal Asset of an Organization: Customer
      1. Introduction
      2. Taxonomy of Customer
      3. Generic Definition of Customer
      4. Specific Customer Definitions
    15. Organization, a Meaningful Concept?
      1. The Many Definitions of Organization
    16. Employee or Partner?
    17. Product
    18. Territory
      1. Geographical Aspects of Territory
  23. Appendices
    1. Overview
      1. How Do You Become a BA4BI?
        1. Data Knowledge
        2. Application Knowledge
        3. Process Knowledge
        4. BI Skills
        5. Interpersonal Skills
    2. Appendix A: What to Ask on Your Job Interview
      1. Introduction
      2. Questions
    3. Appendix B: Business Intelligence from 1960 to Today
      1. Introduction
      2. Early Years
      3. Emergence of the Data Warehouse
      4. Business-Driven Business Intelligence Era
    4. Appendix C: The 101 on Data Warehousing
      1. Business Need
      2. Technology Barriers
        1. Denormalization versus the Third Normal Form
        2. Definitions
        3. Open to Multiple Sources
      3. Solutions
        1. Components
        2. Extract, Transform, Load Process
    5. Appendix D: Survey for a BI Project for the Purchasing Department
      1. Introduction
      2. A Few Caveats
      3. Example
  24. Bibliography

Product information

  • Title: Business Analysis for Business Intelligence
  • Author(s): Bert Brijs
  • Release date: April 2016
  • Publisher(s): Auerbach Publications
  • ISBN: 9781466581159