The Business Intelligence space is one fraught with vendors, tools, and opinions of how best to implement BI solutions. This book addresses key areas of BI such as data structure and delivery, tools evaluation, and more. The subject areas are presented from the author's point of view and experiences. At the heart of the materials are points to ponder, food for thought, and significant errors to avoid.
Table of Contents
1. Introduction to Business Intelligence.
2. Defining Business Intelligence.
Query Tools. Data Warehouse Processes. BI Biases and Internal Squabbles. Establishing a More Global BI Perspective. BI at the Business Unit and Departmental Levels. BI at the Enterprise Level. Hindsight “Rules”. Intranets/Extranets-Data and Analysis Within You and Without You. Know Your User Base. 3. The History of Business Intelligence.
The Early End-User Computing Era. The Information Center Era. Charge-Back Systems. Personal Computers. The Client/Server Wave. The Information Warehouse Concept. The Data Warehouse Era of BI. Advanced Analytics: Delivering Information to “Mahogany Row”. BI Milestones. 4. The Impact of Business Intelligence.
The IT Department and Business Intelligence. Non-Technical End Users and Business Intelligence. Business Analysts and Business Intelligence. External End Users-The Extranet Environment. Business Intelligence and the Enterprise. 5. Content Management and Unstructured Data.
Industry-Related Content Management Areas. Why a Relational Database Can't Solve This. 6. End-User Segmentation.
End-User Segmentation. End-User Attributes. A Holistic View of the Users. 7. Elements of Business Intelligence Solutions.
Data Warehouse versus Data Marts. Setting Up Information for BI Processing. Data Extraction, Transformation, and Cleansing. The Data Side of BI. The Analytics Tools. End-User Assumptions about Tools. The Spreadsheet's Role in BI. The Three Major Categories of BI Analytics Tools. Query and Reporting Tools. Time and Date Elements in Reporting. OLAP Tools. Data Mining Tools. Advanced Analytics-Executive Information Systems (EIS). 8. Justifying Business Intelligence Solutions.
ROI: Return on Investment. Business Impact Justification. The True Costs of BI. Big Purchase with No Plan. Bringing in the “Hired Guns”. Your Justification Scenario. 9. Corporate Performance Management (CPM) and the Executive View of Business Intelligence.
Data Readiness and Availability for CPM. Role-Based Analytics. Pushing Information: Proactive BI-Effective Communication. Buy or Build CPM. A Viable Approach to CPM. 10. Platform Selection, Technology Biases, and Other “Traps”.
Traditional IT Traps. The BI Trap. Evaluating Analytics Usage for User Populations. The Database Is the Most Critical Choice. How Well Do Your Approved BI Tools Support the Database Decision? A “Typical” History Lesson. 11. End-User Support and Productivity.
BI Products Are Still Computer-Based. A “Straw Person” Scenario. Setting Up BI Support. 12. Implementation for Business Intelligence Solutions.
Back Up and Restore What You Have Already Done. System Sizing, Measurements, and Dependencies. Setting Early Expectations and Measuring the Results. End-User Provisos. Recap the First Project, and Tune Your Support and Implementation Models. OLAP Implementations. Expanding BI Based on What You Now Know. Establishing a BI Competency Center (BICC). 13. Planning for the Future-What's the Next Wave of Business Intelligence?
Advanced Analytics. Database Enhancements and BI. Thinner and Thinner Clients. Data Formats with BI Aspects. Portals. BI Networks. Conclusion. Appendix A: Checklist for BI Planning.
Corporate BI Strategy. End-User Support Strategy. Database and Tools Strategy. Intranet and Extranet Strategy. About the Author. Index.
Making business intelligence work: Start-to-finish guidance for managers
This book offers a true enterprise view of business intelligence. IBM expert Mike Biere shows managers how to create a coherent BI plan that reflects the needs of users throughout the organization-and then implement that plan successfully. Biere explains how to objectively assess the business case for BI, and identifies proven solutions for the obstacles that lead many BI projects to fail. Coverage includes:
- Setting appropriate expectations and goals for your BI project
- Understanding how the key components of a complete BI solution fit together
- Designing effective BI solutions-including content management, handling unstructured data, and end-user segmentation
- Providing effective support for BI end users
- Introducing Corporate Performance Management (CPM): an executive's view of BI
- Previewing tomorrow's "next wave" in BI solutions
- Comprehensive checklists for planning your BI project
MIKE BIERE is Worldwide Sales Specialist for Business Intelligence Analytics Tools for IBM Corporation. He has more than 20 years' experience in business intelligence-related technologies, working in every stage of the BI project lifecycle, and in every role from sales and marketing to product development and technical support.