【正文】
正是 NCR 的數據倉庫開發(fā)小組 —— 萬億數據( Teradata) —— 現在已經是一家獨立的公司。 A few years ago such technologies, called “business intelligence”, were available only to the world?s biggest panies. But as the price of puting and storage has fallen and the software systems have got better and cheaper, the technology has moved into the mainstream. Companies are collecting more data than ever before. In the past they were kept in different systems that were unable to talk to each other, such as finance, human resources or customer management. Now the systems are being linked, and panies are using datamining techniques to get a plete picture of their operations—“a single version of the truth”, as the industry likes to call it. That allows firms to operate more efficiently, pick out trends and improve their forecasting. 這樣的技術在幾年前被稱作“商務智能”,僅有幾家世界級的大公司能夠享有。但隨著計算和存儲產品的價格下降以及越來越好且越來越廉價的軟件系統(tǒng),該項技術已逐步成為主流。商業(yè)公司收集的信息比以往都要多得多。過去,這些數據都存儲在不能互相溝通的不同系統(tǒng)中,比方說財經系統(tǒng)、人力資源系統(tǒng)或者客戶管理系統(tǒng)等?,F在,這些系統(tǒng)都被連在了一起,而且商業(yè)公司都使用數據挖掘技術以獲得他們運作的一幅完整圖景 —— “事實的唯一版本”—— 業(yè)界樂于賦予其的稱呼。這樣的技術使商業(yè)公司能夠更高效的運作、把握趨勢和改善預測。 Consider Cable, a Swiss teles operator. It has reduced customer defections from onefifth of subscribers a year to under 5% by crunching its numbers. Its software spotted that although customer defections peaked in the 13th month, the decision to leave was made much earlier, around the ninth month (as indicated by things like the number of calls to customer support services). So Cable offered certain customers special deals seven months into their subscription and reaped the rewards. 瑞士的一個名為 Cable的電信運營商通過處理自己公司的數據使其客戶流失率從 20%下降到 5%。其軟件發(fā)現,雖然客戶流失率的最大值發(fā)生在客戶注冊后的第 13 個月,但是決定放棄使用 Cable 電信服務的決定卻發(fā)生在這很久以前,大概在客戶注冊后的第 9 個月(通過諸如聯系客戶支持服務中心的電話的數量等參數可以表明)。于是, Cable 通過在客戶注冊后的第 7 個月為相關客戶提供特別契約服務,從而有效地減少了客戶流失。 Agony and torture 痛苦與折騰 Such datamining has a dubious reputation. “Torture the data long enough and they will confess to anything,” statisticians quip. But it has bee far more effective as more panies have started to use the technology. Best Buy, a retailer, found that 7% of its customers accounted for 43% of its sales, so it reanised its stores to concentrate on those customers? needs. Airline yield management improved because analytical techniques uncovered the best predictor that a passenger would actually catch a flight he had booked: that he had ordered a vegetarian meal. 這樣的數據挖掘技術是毀譽參半的?!爸灰堰@些數據不停地反復折騰,它們總會供認不諱,”統(tǒng)計學家們嘲弄道。然而隨著越來越多的公司開始使用這項技術而使得它的作用更加顯著。 16 零售公司 Best Buy 發(fā)現其 7%的客戶貢獻了其 43%的銷售額,因此該公司針對這些客戶的需求重組了其商店。由于航空公司通過分析技術發(fā)現:乘客肯定會乘坐他預訂的那架航班(他還在該航班上預訂了素食餐),因而改善了公司的收益管理。 The IT industry is piling into business intelligence, seeing it as a natural successor of services such as accountancy and puting in the first and second half of the 20th century respectively. Accenture, PricewaterhouseCoopers, IBM and SAP are investing heavily in their consulting practices. Technology vendors such as Oracle, Informatica, TIBCO, SAS and EMC have benefited. IBM believes business intelligence will be a pillar of its growth as sensors are used to manage things from a city?s traffic flow to a patient?s blood flow. It has invested $12 billion in the past four years and is opening six analytics centres with 4,000 employees worldwide. IT 行業(yè)正設法擠進商務智能領域,并認為自己理所當然地將 —— 就像會計業(yè)務和計算等業(yè)務分別主宰了 20 世紀上半葉和下半葉那樣 —— 成為 21 世紀的主宰。事實上,PricewaterhouseCoopers、 IBM 和 SAP 等公司均對他們的咨詢業(yè)務注以重資。像 Oracle、Informatica、 TIBCO、 SAS 以及 EMC 等技術提供商均已從中獲益。 IBM 相信商務智能將成為其成長的中流砥柱,就像傳感器可以被用于管理從諸如城市交通流到病人的血流那樣得到廣泛使用。在過去四年中 IBM 已經投資 120 億美元在全球建立了 6 個分析學研究中心,雇員總數多達 4000 人。 Analytics—performing statistical operations for forecasting or uncovering correlations such as between PopTarts and hurricanes—can have a big payoff. In Britain the Royal Shakespeare Company (RSC) sifted through seven years of sales data for a marketing campaign that increased regular visitors by 70%. By examining more than 2m transaction records, the RSC discovered a lot more about its best customers: not just ine, but things like occupation and family status, which allowed it to target its marketing more precisely. That was of crucial importance, says the RSC?s Mary Butlin, because it substantially boosted membership as well as fundraising revenue. 分析學 —— 一系列為了預測的目的,或者是為了發(fā)現諸如 PopTarts 與颶風之間的相關性,而進行的統(tǒng)計運算 —— 能夠帶來巨大的收益。在英國,皇家莎士比亞公司( RSC)在市場營銷戰(zhàn)中通過篩查過往 7 年中的銷售數據使公司的常訪客數量增長了 70%。通過查看 200 多萬份交易記錄, RSC 發(fā)現其高端客戶很多的信息,除收入水平外,諸如職業(yè)和家庭地位等信息均使得公司能夠更精確地規(guī)劃其市場營銷的目標。“信息是至關重要的,” RSC 的 Mary Butlin 說,“因為它使得 我們的會員數量和資金籌措收入均得到了穩(wěn)步的攀升”。 Yet making the most of data is not easy. The first step is to improve the accuracy of the information. Nestl233。, for example, sells more than 100,000 products in 200 countries, using 550,000 suppliers, but it was not using its huge buying power effectively because its databases were a mess. On examination, it found that of its 9m records of vendors, customers and materials around half were obsolete or duplicated, and of the remainder about onethird were inaccurate or inplete. The name of a vendor might be abbreviated in one record but spelled out in another, leading to doublecounting. 然而要想充分地使數據發(fā)揮作用并非易事。首先必須要增加信息的準確度。比方說,雀巢( Nestl233。)公司,在 200 個國家銷售超過 10 萬種產品,擁有 55 萬個供應商,但該公司過去卻因為其數據庫亂得一塌糊涂而無法有效利用其巨大的消費群。通過檢查,雀巢公司的 900萬份關于供應商、客戶和材料的記錄,有一半 以上是作廢的或偽造的,而剩下的約三分之一 17 則不準確或者不完整。同一個名字在一張記錄上可能寫的是縮寫,而在另一張上則是完整的名字,這樣就很容易導致重復統(tǒng)計。 Plainer vanilla 抱怨的香子蘭 Over the past ten years Nestl233。 has been overhauling its IT system, using SAP software, and improving the quality of its data. This enabled the firm to bee more efficient, says Chris Johnson, who led the initiative. For just one ingredient, vanilla, its American operation was able to reduce the number of specifications and use fewer suppliers, saving $30m a year. Overall, such operational improvements save more than $1 billion annually. 在過去十多年間,雀巢已經對其 IT 系統(tǒng)進行整改,使用了 SAP 的軟件并且改善了其數據的質量?!斑@使得這家公司變得更