Home > Store

Business Intelligence for the Enterprise

Register your product to gain access to bonus material or receive a coupon.

Business Intelligence for the Enterprise

Book

  • Sorry, this book is no longer in print.
Not for Sale

Description

  • Copyright 2003
  • Dimensions: 7" x 9-1/4"
  • Pages: 240
  • Edition: 1st
  • Book
  • ISBN-10: 0-13-141303-1
  • ISBN-13: 978-0-13-141303-0

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. Business Intelligence is the conscious, methodical transformation of data from any and all data sources into new forms to provide information that is business driven and results oriented. It will often encompass a mixture of tools, databases, vendors in order to deliver an infrastructure that not only will deliver the initial solution, but it will incorporate the ability to change with the business and current marketplace. The purpose of investing in BI is to transform from an environment that is reactive to data to one that is proactive. A major goal of the solution will be to automate and integrate as many steps and functions as possible. Another goal is to provide data analytics that are as tool independent as possible.

Sample Content

Downloadable Sample Chapter

Untitled Document Download the Sample Chapter related to this title.

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.

Preface

Untitled Document

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.

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020