Business Intelligence for the Enterprise

Overview

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 ...

See more details below
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (9) from $22.96   
  • Used (9) from $1.99   
Sending request ...

Overview

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
Read More Show Less

Product Details

  • ISBN-13: 9780131413030
  • Publisher: IBM Press
  • Publication date: 6/4/2003
  • Series: IBM DB2 Certification Guide Ser.
  • Pages: 240
  • Sales rank: 1,308,425
  • Product dimensions: 6.90 (w) x 9.00 (h) x 0.80 (d)

Meet the Author

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.

Read More Show Less

Read an Excerpt

Preface

Let me begin by stating that this book is not intended to be used as a technical reference for your validation or argument in the evaluation or assessment of Business Intelligence solutions. I have avoided the use of products and acronyms whenever possible. This is not because I do not know the products or because I don't have an opinion about them. It is because I want you to think about what you are doing for Business Intelligence and why.

A "best-of-breed" BI tool can be implemented so poorly that it provides no value at all. A dated but well employed BI tool may bring spectacular business results. I probably will repeat myself a bit, including using the phrase "Activity does not equate to success." BI success does not lie in the volume of usage nor the volume of paper generated. BI success is measured in business impact and by the improvements in critical areas that can be attributed to its implementation.

I began working in the end-user computing arena in 1981 and have worked with nearly every tool and database on the market since then. Behind all these efforts lies a common theme—the need to produce key business information from existing data.

I do not pass judgment on any specific solution or vendor. I do, however, believe that too many organizations take the easy way out by selecting some tools, hoping the end users will "magically" emerge with what they want. Meanwhile, the rest of the "important" work in data processing goes on...and on...and on. If an organization decides to provide some data and analytics tools to end users to get them off the Information Technology (IT) Department's back, it will fail and the organization will end upspending much more in the long run because ultimately they'll have to attempt to get it right.

Your view and definition of BI will dramatically vary from others depending upon your role within the enterprise. If your position requires you to work with getting the corporate data into shape for BI, the issues you face will be drastically different than those of individuals trying to use what you have created.

If you are a non-technical end user, your definition probably will be filled with noble business initiatives and some usage and functional assumptions about the tools you will use.

An enterprise view of BI would combine definitions from all users and roles into a singular view with goals that span the enterprise—oops, I just gave away the rest of the material in this book. Please do not stop here.

Years ago, I was sitting in an introductory class to a new, exciting query and analysis tool. The instructor had been constantly hammering into us that the tool we were trying to learn was "intuitively obvious to use." One of my fellow students finally said, "I am sorry, but I don't seem to be getting it. I thought you said this was going to be intuitive!?" The instructor said, "Well, the more you use it, the more intuitive it becomes!"

We have all heard the adage that a million apes with a million typewriters given a million years would eventually write War and Peace. Sometimes, a BI solution can seem that way. If the users have to constantly flail at data with obtuse options in an attempt to produce a result, then something is dramatically wrong.

Business Intelligence solutions are anything but intuitive. Regardless of how many names and technologies have been applied to the discipline we now call BI, it is a difficult yet incredibly rewarding area in which to work. BI can change the course of how an enterprise operates and can keep an organization afloat in difficult times. BI elements can be used to discover trends and information that "normal" thinking would not have disclosed.

How does one get from "flailing" to spectacular success? Needless to say, your business has to be viable and in a position to increase profitability and implement changes. The heart of any BI success story begins with the corporate "intent" in implementing BI. Sometimes, a firm just gets lucky and discovers that increasing the level of information flow has a positive effect on the business. In most cases, many end users feel warmer and fuzzier because they are getting more information but could not begin to tell you whether it has changed the bottom line.

Business Intelligence is mostly query and reporting. In Chapter 2, I will apply a more formal definition of BI, but for now I will limit my definition to query and reporting. Of course, you may be asking, "Isn't there much more involved in today's BI solutions? What about data extraction, cleansing, and all the data preparation required?" Yes, there are many ancillary and necessary steps involved in delivering BI solutions. But at the heart of every solution is the need to access the data we've captured and to perform some analysis that we will use in our business.

Let's look at an Executive Information System (EIS). There is so much talk about "executive dashboards" today. Somewhere beneath the clever graphical interface and presentation lies some data and a corresponding set of values that were produced with a query tool. The trappings of the presentation style do not negate the need for a core technology to deliver the data.

The marketplace today is flooded with BI tools. There are numerous query and reporting solutions available, and most large organizations have installed several solutions that are being used for any number of business purposes. Are they all necessary? Are there significant, unique differences among them that justify having several "power tools" installed at once? The answers to these questions are usually "no" to the first and "maybe" to the second. Is there any harm in having sets of tools from different vendors? I submit that the answer to this question is a definitive "yes!"

The title of this book is Business Intelligence for the Enterprise. I have found that a very small number of organizations have attempted to establish a global view and effort in implementing BI. The majority of firms that practice BI tend to perform random acts of analysis on data.

The roots of BI date back to early mainframe query tools when data processing departments began to open corporate data stores to end users with 4GLs (fourth generation languages). These early BI implementations via 4GLs managed to excite the users as well as raise the frustration level on both sides.

IT was unhappy at the unexpected impact on existing systems, as well as the inevitable hand-holding required to get the tools working. IT also had to spend time it simply did not have trying to resolve many technical issues such as getting a tool to work properly in accessing a data source. The end users were unhappy because in every case there was far more work involved in extracting results from the data. There were far too many techno-geek aspects to getting the job done.

The worst impact was the rift between corporate IT and the end users. IT was perceived as keeping the keys to the castle and creating massive roadblocks to prevent the users from accessing their data. The end users were perceived as being technically inept and a bunch of "whiners" who always had to run to IT when the going got rough—which typically didn't take very long.

In every case, there were a few individuals who emerged as experts in the tools and usage. Some were from IT, and some were end users with a more technical aptitude. The number of individuals outside of IT that could actually do very much with an analytics tool was typically small. In many cases, these savvy end users went on to succeed at higher levels within the organization. Many of them are the drivers of point solutions today.

Let me present an example of an early BI implementer. Customer XYZ has a mainframe with lots of data stored in a variety of formats including VSAM, sequential datasets, and even tape that the users require for historical analysis. The data has been stored in efficient formats, such as packed-decimal to take up as little disk space as possible. Many of the text fields have intelligent keys where a couple of characters are used to describe longer information items (e.g., two positions in a longer field used to signify districts or other lengthy information).

This company has discovered a vendor tool that allows it to access and query this legacy information. However, setting up the access and performing actions, such as stripping out the intelligent key positions and translating them into understandable text, is not trivial. The vendor's suggestion is to extract the data in its raw form, transform the encoded values to understandable ones, and store the data in the vendor's proprietary format.

Even when the data has been molded into a source that is better for common business use, it is still not structured for the non-technical end users to do much with it. The processing requirements and calculations are more challenging than many end users can handle, so we now have an enriched set of data held in a proprietary source. However, the era of end users performing their own query and reporting functions began, and it has been in a state of continuous change ever since.

Today, there are more choices for analytics tools than years ago. Instead of having the data, the tools, and the analysis processes on the same platform (e.g., S/390), one can now remotely analyze a server from afar using tools on workstation platforms. Many corporations allow users to perform these analytics from a variety of tools with varying results.

The difference between traditional BI and BI at the enterprise level is significant. I am an avid fan of using fewer tools and centralizing BI at the server level. I use several keywords in discussing BI with customers. One of the first ones I toss out is math. BI is all about "the math."

BI users often want to perform very specific and difficult calculations. Regardless of the platform, the tool, or the technologies, few BI solutions allow users to drag some columns onto a report and select the Run option. Even the most elegant data warehouse structure assumes the users will need to perform some calculations beyond the basic storage structure of the data. Where and how one decides to perform the math can have an enormous impact on BI architecture

The other word I use in discussing enterprise level BI is awareness. Do different user departments, groups, and so on have effective intercommunication with each other such that they can share their BI efforts? In the overwhelming majority of cases, the answer is a ringing "no!"

Because BI efforts require data and math, does it not make sense that one would try to condense as much of the effort into as little iteration as possible? We probably have all heard about the scenario where different users walk into a meeting with different results supposedly based upon the same data. Do these events occur because they are using different tools or different data? What if they are using the same tools, but have different skill levels? What if all the results are incorrect?

The objectives for quality BI efforts are many. The guidelines I recommend in establishing a successful BI environment are scattered throughout this book. I have included a series of checklists in the Appendix at the end of the book, and I hope that they will assist in your selection of BI solutions. Now let's define this thing we dub Business Intelligence.

Read More Show Less

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.

Read More Show Less

Preface

Preface

Let me begin by stating that this book is not intended to be used as a technical reference for your validation or argument in the evaluation or assessment of Business Intelligence solutions. I have avoided the use of products and acronyms whenever possible. This is not because I do not know the products or because I don't have an opinion about them. It is because I want you to think about what you are doing for Business Intelligence and why.

A "best-of-breed" BI tool can be implemented so poorly that it provides no value at all. A dated but well employed BI tool may bring spectacular business results. I probably will repeat myself a bit, including using the phrase "Activity does not equate to success." BI success does not lie in the volume of usage nor the volume of paper generated. BI success is measured in business impact and by the improvements in critical areas that can be attributed to its implementation.

I began working in the end-user computing arena in 1981 and have worked with nearly every tool and database on the market since then. Behind all these efforts lies a common theme--the need to produce key business information from existing data.

I do not pass judgment on any specific solution or vendor. I do, however, believe that too many organizations take the easy way out by selecting some tools, hoping the end users will "magically" emerge with what they want. Meanwhile, the rest of the "important" work in data processing goes on...and on...and on. If an organization decides to provide some data and analytics tools to end users to get them off the Information Technology (IT) Department's back, it will fail and the organization will end up spending much more in the long run because ultimately they'll have to attempt to get it right.

Your view and definition of BI will dramatically vary from others depending upon your role within the enterprise. If your position requires you to work with getting the corporate data into shape for BI, the issues you face will be drastically different than those of individuals trying to use what you have created.

If you are a non-technical end user, your definition probably will be filled with noble business initiatives and some usage and functional assumptions about the tools you will use.

An enterprise view of BI would combine definitions from all users and roles into a singular view with goals that span the enterprise--oops, I just gave away the rest of the material in this book. Please do not stop here.

Years ago, I was sitting in an introductory class to a new, exciting query and analysis tool. The instructor had been constantly hammering into us that the tool we were trying to learn was "intuitively obvious to use." One of my fellow students finally said, "I am sorry, but I don't seem to be getting it. I thought you said this was going to be intuitive!?" The instructor said, "Well, the more you use it, the more intuitive it becomes!"

We have all heard the adage that a million apes with a million typewriters given a million years would eventually write War and Peace. Sometimes, a BI solution can seem that way. If the users have to constantly flail at data with obtuse options in an attempt to produce a result, then something is dramatically wrong.

Business Intelligence solutions are anything but intuitive. Regardless of how many names and technologies have been applied to the discipline we now call BI, it is a difficult yet incredibly rewarding area in which to work. BI can change the course of how an enterprise operates and can keep an organization afloat in difficult times. BI elements can be used to discover trends and information that "normal" thinking would not have disclosed.

How does one get from "flailing" to spectacular success? Needless to say, your business has to be viable and in a position to increase profitability and implement changes. The heart of any BI success story begins with the corporate "intent" in implementing BI. Sometimes, a firm just gets lucky and discovers that increasing the level of information flow has a positive effect on the business. In most cases, many end users feel warmer and fuzzier because they are getting more information but could not begin to tell you whether it has changed the bottom line.

Business Intelligence is mostly query and reporting. In Chapter 2, I will apply a more formal definition of BI, but for now I will limit my definition to query and reporting. Of course, you may be asking, "Isn't there much more involved in today's BI solutions? What about data extraction, cleansing, and all the data preparation required?" Yes, there are many ancillary and necessary steps involved in delivering BI solutions. But at the heart of every solution is the need to access the data we've captured and to perform some analysis that we will use in our business.

Let's look at an Executive Information System (EIS). There is so much talk about "executive dashboards" today. Somewhere beneath the clever graphical interface and presentation lies some data and a corresponding set of values that were produced with a query tool. The trappings of the presentation style do not negate the need for a core technology to deliver the data.

The marketplace today is flooded with BI tools. There are numerous query and reporting solutions available, and most large organizations have installed several solutions that are being used for any number of business purposes. Are they all necessary? Are there significant, unique differences among them that justify having several "power tools" installed at once? The answers to these questions are usually "no" to the first and "maybe" to the second. Is there any harm in having sets of tools from different vendors? I submit that the answer to this question is a definitive "yes!"

The title of this book is Business Intelligence for the Enterprise. I have found that a very small number of organizations have attempted to establish a global view and effort in implementing BI. The majority of firms that practice BI tend to perform random acts of analysis on data.

The roots of BI date back to early mainframe query tools when data processing departments began to open corporate data stores to end users with 4GLs (fourth generation languages). These early BI implementations via 4GLs managed to excite the users as well as raise the frustration level on both sides.

IT was unhappy at the unexpected impact on existing systems, as well as the inevitable hand-holding required to get the tools working. IT also had to spend time it simply did not have trying to resolve many technical issues such as getting a tool to work properly in accessing a data source. The end users were unhappy because in every case there was far more work involved in extracting results from the data. There were far too many techno-geek aspects to getting the job done.

The worst impact was the rift between corporate IT and the end users. IT was perceived as keeping the keys to the castle and creating massive roadblocks to prevent the users from accessing their data. The end users were perceived as being technically inept and a bunch of "whiners" who always had to run to IT when the going got rough--which typically didn't take very long.

In every case, there were a few individuals who emerged as experts in the tools and usage. Some were from IT, and some were end users with a more technical aptitude. The number of individuals outside of IT that could actually do very much with an analytics tool was typically small. In many cases, these savvy end users went on to succeed at higher levels within the organization. Many of them are the drivers of point solutions today.

Let me present an example of an early BI implementer. Customer XYZ has a mainframe with lots of data stored in a variety of formats including VSAM, sequential datasets, and even tape that the users require for historical analysis. The data has been stored in efficient formats, such as packed-decimal to take up as little disk space as possible. Many of the text fields have intelligent keys where a couple of characters are used to describe longer information items (e.g., two positions in a longer field used to signify districts or other lengthy information).

This company has discovered a vendor tool that allows it to access and query this legacy information. However, setting up the access and performing actions, such as stripping out the intelligent key positions and translating them into understandable text, is not trivial. The vendor's suggestion is to extract the data in its raw form, transform the encoded values to understandable ones, and store the data in the vendor's proprietary format.

Even when the data has been molded into a source that is better for common business use, it is still not structured for the non-technical end users to do much with it. The processing requirements and calculations are more challenging than many end users can handle, so we now have an enriched set of data held in a proprietary source. However, the era of end users performing their own query and reporting functions began, and it has been in a state of continuous change ever since.

Today, there are more choices for analytics tools than years ago. Instead of having the data, the tools, and the analysis processes on the same platform (e.g., S/390), one can now remotely analyze a server from afar using tools on workstation platforms. Many corporations allow users to perform these analytics from a variety of tools with varying results.

The difference between traditional BI and BI at the enterprise level is significant. I am an avid fan of using fewer tools and centralizing BI at the server level. I use several keywords in discussing BI with customers. One of the first ones I toss out is math. BI is all about "the math."

BI users often want to perform very specific and difficult calculations. Regardless of the platform, the tool, or the technologies, few BI solutions allow users to drag some columns onto a report and select the Run option. Even the most elegant data warehouse structure assumes the users will need to perform some calculations beyond the basic storage structure of the data. Where and how one decides to perform the math can have an enormous impact on BI architecture

The other word I use in discussing enterprise level BI is awareness. Do different user departments, groups, and so on have effective intercommunication with each other such that they can share their BI efforts? In the overwhelming majority of cases, the answer is a ringing "no!"

Because BI efforts require data and math, does it not make sense that one would try to condense as much of the effort into as little iteration as possible? We probably have all heard about the scenario where different users walk into a meeting with different results supposedly based upon the same data. Do these events occur because they are using different tools or different data? What if they are using the same tools, but have different skill levels? What if all the results are incorrect?

The objectives for quality BI efforts are many. The guidelines I recommend in establishing a successful BI environment are scattered throughout this book. I have included a series of checklists in the Appendix at the end of the book, and I hope that they will assist in your selection of BI solutions. Now let's define this thing we dub Business Intelligence.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted July 20, 2005

    The BI Bible

    I worked in the BI industry & now I am teaching BI at a local university. I am using Mike Biere's book in the classroom because it is the most comprehensive guide to understanding & implementing BI that I have found. Biere has obviously worked in the industry & knows what he's talking about. This book is a MUST READ for anyone involved in or thinking about a BI or data warehouse initiative.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 15, 2003

    A thoughtful and thought-provoking book about BI

    This is a frank discussion about BI. Biere will help you to think about BI, and he will help you to think clearly. Business Intelligence for the Enterprise is written for the customer. The author is a sales guy, who works for a vendor (IBM - Good Grief!), AND he has written a book for the customer. Why? He is obviously interested in seeing Enterprise BI succeed. This book will help you think through sales hype, and move closer to success. In a certain sense, it is a book written to help business people like you deal with sales people like Mike Biere. Ironic? Yes. And no. A perspective like this doesn't come from being slick and clever (goodness knows there is an endless array of slick and clever sales people.) Rather, it comes from making a mature commitment to one's working life, which Biere has obviously done. It is as important for the C-level IT professionals to read as it is for their C-level bosses and colleagues. Needless(?) to say it is also an important read for those who are going to do the actual work of implementing the BI strategy. Read this book, but only if you are willing to spend some time thinking....

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)