advertiser here

Posts Tagged ‘ business intelligence ’

By Michael Fitzgerald
Computerworld (US)
July 16, 2010

FRAMINGHAM - Even before his company had finished developing its first mobile business intelligence application, Manoj Prasad was deep into planning the next one.

“We could immediately see [mobile] would be big for us,” says Prasad, vice president of enterprise architecture, global applications and testing at Life Technologies Corp., a multinational biotech tool maker in Carlsbad, Calif.

In fact, Prasad made mobile business intelligence a 2010 strategic priority for his department. His goal was to roll out mobile applications that would allow its 800-person sales force in the field to dive deeply into data regarding the cutting-edge tools Life Technologies develops and sells to scientific researchers.

Loosely defined, business intelligence (BI) systems take vast quantities of data and put it into visually useful forms (such as graphs and charts) for sophisticated analysis of business trends.

Making that analysis mobile, most typically by tapping the power of today’s sophisticated smartphones, can give companies the ability to interact in real time with their customers and business partners, thereby improving service and boosting productivity.

“All enterprise companies will start moving on the mobile path,” Prasad predicts, saying that this trend will be spurred on by improvements in the ability of smartphones to display graphical information and the emergence of intuitive graphical interfaces that can better handle BI visualizations.

Mobile BI on the radar

To be sure, mainstream adoption of mobile BI has been on the horizon for a while now. Two years ago, Aberdeen Group Inc. analyst David Hatch produced a report looking at best practices in making business intelligence available on mobile phones.

At the time, only 17% of the companies Aberdeen Group surveyed said that they were delivering business intelligence data to mobile phones, though 78% indicated they were interested in doing so. At the same time, several BI vendors had introduced mobile versions of their products.

But then the recession hit, and that stymied investment in mobile BI product development and marketing, Hatch says.

What the recession didn’t stop was the development of mobile gadgetry, most especially the iPhone, the iPad and the various Android phones. These new mobile hardware devices can finally handle the complexities of BI, Hatch says.

Companies are responding aggressively. In a May 2010 Aberdeen survey, 23% of the companies responding said that they now have a mobile BI application or dashboard in place, and another 31% said that they plan to implement some type of mobile business intelligence within the next year.

Users demanding mobile BI

A number of things are drawing companies to mobile BI, says Andrew Borg, a mobile analyst at Aberdeen. “It gives them real-time decision-making, operational efficiency, flexible workflow and increases their responsiveness to customers,” he explains.

Delivering those benefits to employees who work in the field held obvious appeal to Life Technologies, where user demand within various departments pushed mobile BI to the top of the strategic list, Prasad says.

In response, Prasad asked his architecture team to look for ways to get data from SAP Business Objects and IBM Cognos BI systems onto employees’ BlackBerries and iPhones.

The team suggested Mellmo Inc.’s Roambi, a data-visualization app that takes BI data from various sources and makes it iPhone- and iPad-friendly. Prasad asked an architect and a developer on his team to use Roambi to develop two reports — sales quotas and daily sales reports — that are important to Life Technologies’ salespeople.

“I showed it to the CIO, and he got excited. And we showed it to some customers, and they got excited too,” says Prasad.

A test version of a system showing daily sales reports taken from Life Technologies’ Cognos data warehouse was rolled out this spring to some 50 salespeople with iPhones. Roambi doesn’t work on BlackBerries, so Prasad’s team plans to use the mobile version of Cognos to deliver similar functionality to the sales department’s BlackBerry users.

Prasad already has his team working on applications for other parts of the company, like a global warehouse report, and has set up a mobile development architecture team to devise an entire mobile strategy for Life Technologies, with a particular emphasis on business intelligence.

Airport data takes flight

If Life Technologies is a mobile BI newbie, Fraport AG counts as an experienced veteran.

Fraport AG, the organization that runs Germany’s Frankfurt Airport and a number of other airports, started a business intelligence project six years ago, says Dieter Steinmann, senior manager of business systems there.

The initial goal was to provide data from around the airport — data about flight departures and arrivals, wait times at security checkpoints, and reasons for delays — to employees in operations every five minutes, 24 hours a day.

In 2008, Fraport made that data mobile and delivered it to some 100 operations and customer relations managers at Europe’s third-busiest airport, which last year saw more than 50 million passengers.

About 800 employees can now access information from a SAS Institute Inc. BI system via their phones. “When managers can get some actual information on the actual situation, it helps them make better decisions,” says Steinmann.

For instance, through May of this year, 68% of the flights at Frankfurt Airport were on time. But that means that 32% of the flights weren’t on time. Managers who meet with airlines to discuss the reasons for delays used to have to retreat to their offices to find data about delays affecting specific flights; they typically don’t carry laptops into meetings, Steinmann says.

But they do carry BlackBerries, and now they can use those devices to instantly find out what happened to cause a delay, including whether the airline itself played a role. Knowing the answers immediately means problems can be resolved faster because there’s less need for managers to make one another wait for answers while they stop to look up information.

Steinmann said that Fraport needed to do relatively little work to get the data from SAS 9 onto the BlackBerry platform — some XML coding and style sheets, worked up by a student intern who did the project as part of his master’s dissertation. “It was a quick and not very expensive way” to do it, says Steinmann, who later hired the intern full time.

For the mobile version of the BI system, Fraport did need to limit the quantity of the information that it made available, and it couldn’t use as many graphics as it did in the desktop version. But the managers took to it. Steinmann says they use it as a way to show customers, “I have the information you need, I have it right here, and I have it in color.” It also serves as a feather in the IT department’s cap, he notes, since the application both looks good and works well.

A slew of apps on the way

Fraport’s application is an early example of what will likely become a bigger phenomenon. “Going forward, we’ll see a whole slew of apps for sales forces and field service [teams],” says Stephen Drake, an analyst at research firm IDC.

He says the BlackBerry will still be used for BI, but he notes that more companies will develop applications for devices like Apple Inc.’s iPad tablet and for powerful new phones like the HTC Evo, which has a high-definition screen that makes it easier to do analytics on a mobile device.

Meanwhile, software providers have renewed their mobile BI push, with several of the big business intelligence vendors making moves in that arena recently: SAS added a Mobile dashboard in April, SAP recently introduced versions of its BusinessObjects Explorer for the iPhone and the iPad, and IBM in June showed off a spiffed-up new interface for its Cognos Go Mobile BI product.

In addition, the field has also attracted start-ups like Del Mar, Calif.-based Mellmo and Leapfactor Inc., which operates a cloud-based service that can bring corporate BI applications to smartphones.

And Drake points out that network technology is catching up as well. That’s a key development because “you couldn’t use [mobile BI] over a 2G network,” he says. “It used to be that you’d see these things and say, ‘It looks nice in the demo, but am I really going to be able to use this?’ Now, the answer is, yes”

Mobilize data to improve customer service

Samir Sakpal, an analyst at Frost & Sullivan, predicts that mobile analytics will move beyond niche markets, like the financial sector, into mainstream use because, he says, it helps businesses do two things: “Make faster decisions and drive a higher quality of customer service.”

The desire for better customer service drove the adoption of mobile BI at Johnson Controls Inc., according to Robert C. Weisman, a senior manager at the Milwaukee-based technology and industrial conglomerate.

Johnson Controls has been piloting a BlackBerry-based BI tool that’s designed to help its district and regional supervisors audit and manage custodial services for a major U.S. retailer, Weisman says.

Johnson has a series of benchmarks it uses for monthly audits that track things like the cleanliness of the retailer’s store lobbies, floors and windows, says Weisman, who declined to identify the retailer.

Previously, Johnson’s 72 district supervisors and six regional operations managers did that auditing with pencil and paper, writing down scores as they walked through stores and then later entering the data on their laptops using Open Text Corp.’s enterprise content-management system, formerly known as Livelink.

If a store failed to meet certain standards, the managers had to go back and pull previous audits to look at discrepancies in scores. They would then perform a follow-up audit to see if the problems had been fixed, again recording their findings on paper, entering data into their laptops and then checking the score.

Under a pilot program launched in April, six district supervisors can enter data directly on their BlackBerries while visiting stores. The data is entered into Open Text’s content manager via Actuate Corp.’s open-source Eclipse BIRT (Business Intelligence and Reporting Tools) system, and it is displayed through Webalo Inc.’s Mobile Dashboard.

Data that a supervisor enters for a particular store is automatically sent into Open Text and can then be compared to that store’s previous audit scores and to the scores of other stores in that chain nationwide. “We can look at it from a single-store, district, regional and national perspective,” says Weisman.

Managers at the retailer can also parse the scores to see if the custodial services provider is doing only the minimum necessary to achieve a base score necessary to pass the audit. For instance, store entryways are difficult to clean, but poor scores in that area can’t sink an entire audit by themselves — and that could mean custodial firms might be tempted to be less careful about cleaning entryways if they know it won’t have a big impact on their overall scores. Now, Johnson’s supervisors can instantly see whether entryways consistently score poorly and then take steps to address such shirking.

Weisman says the system being piloted has performed exactly as he’d hoped, and Johnson Controls intends to roll it out this August to, among others, all district supervisors, regional operations managers and area managers at the custodial services companies.

After the rollout, his goal is to expand what the mobile app can do, turning it into a “super dashboard” to give supervisors reports not just on custodial work, but also on merchandise displays and appearance, and ultimately the condition of the entire store environment, including HVAC systems, plumbing and so on.

Weisman says that Johnson didn’t have to spend a lot of money to make the application work — the field managers already had BlackBerries for e-mail, and the company was already using Open Text. Only the Webalo dashboard was new, and Weisman says a 100-seat-plus-server license cost “a fraction” of what he spends on Open Text development.

Weisman says that the managers can’t do as much data manipulation on their mobile phones as they can on their laptops, but he thinks that will change over time. “I don’t think laptops will be around in five to ten years, at least in the form they are today,” he says. While he notes that the BlackBerry has limitations as an application platform, he says “these aren’t phones, they’re handheld computers.”

One major challenge for mobile BI is that its impact may be hard to measure. Steinmann says he couldn’t put a monetary value on Fraport’s application. The fact that it gets used is probably the best indicator that it’s a successful tool, he says.

“These applications have soft benefits,” agrees Prasad. But he says that despite the squishy ROI, the mobile BI apps will be undeniable drivers of productivity.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Lucas Mearian
Computerworld (US)
July 9, 2010

FRAMINGHAM - EMC’s agreement to buy Greenplum Inc. adds a key component to the storage vendor’s strategy to boost its business intelligence and data analytics business.

EMC has long been trying to shed its image as a data storage vendor in order to become recognized as a player in the larger information infrastructure business. Tuesday’s move is the latest aimed at fulfilling EMC’s goal of providing the hardware and software users need to build large cloud infrastructures, and the analytical tools that can be used to mine data stored within those clouds.

In a written analysis, Pund-IT Inc. analyst Merv Adrian said Greenplum gives EMC a structured data management tool for databases.

Citing dozens of other EMC acquisitions in recent years, Adrian wrote “Disruptive? You bet. Is EMC finished with acquisitions? I doubt it.” The acquisitions have ranged from very small vendors to large companies like unstructured data archive vender Documentum and virualization vendor VMware.

Adrian said EMC is likely to continue looking to buy business intelligence tool providers, master data management firms, as well as a companies that sells ETL (extract, transform, and load) software, which allow businesses to consolidate data from disparate systems.

“Finally, and not least, it’s about performance. Technical improvements become more possible when a vendor owns the whole stack. Balancing IO, processor speed, memory, multiple tiers of storage, virtualization, security, calls to external analytics, ingesting data, exporting data - all become more tunable, more optimizable, if you own all the pieces,” Adrian added.

Charles King, principal analyst at Pund-IT, said the Greenplum acquisition is also about EMC getting its foot in the door with cloud service providers, enabling the data storage vendor to compete against other cloud storage providers, such as Amazon.com and its S3 hosted storage service.

“It’s really about understanding that storing data is the foundation for information intelligence, but you need a lot of tools to really allow the users to enjoy the greatest benefits from it,” King said. “I think Greenplum is just another step forward in this broad but powerful strategy.”

EMC said that following the close of the acquisition, Greenplum will form the foundation of a new data computing product division within EMC’s information infrastructure business.

San Mateo, Calif.-based Greenplum sells a data warehouse platform based on a massively parallel processing (MPP) architecture that can scale out to hundreds of servers running a single database instance. Greenplum’s software is used in business analytics and is flexible in the different business applications for which it can be used, King said.

For example, privately-held Greenplum has a customer list of more than 100 companies that include large retailers such as Sears and Sony as well as financial services entities such as Nasdaq and the New York Stock Exchange or telecommunications providers such as Vodafone and Skype.

“They’re using Greenplum’s technology to mine their data warehouse to garner insight on data they’ve collected,” King said.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By John Mark V. Tuazon
Computerworld Philippines
March 19, 2010

German software provider SAP is opening its business intelligence doors to SMBs and other mainstream consumers by porting their standalone BI software to the cloud, aptly dubbed SAP BusinessObjects BI OnDemand.

Following its acquisition of enterprise software firm Business Objects in 2007, SAP brings the former’s expertise in information analysis into a software platform easily deployable and acquirable through the public cloud.

Answering the need of company managers for quick and informative business insights using idle data, SAP executives said BI OnDemand—which it claimed is the first of its kind in the market—will be most effective in identifying cost points in any company, especially relevant during the recent crisis. “It becomes effective even in cost cutting because executives now have a way of seeing which areas of their company need improvement,” explained Eric Sin, senior director for South East Asia hub, SAP.

The cloud approach also makes it easier for users to share processed information online. “Users can process data into charts and tables and send them easily through e-mail,” Robin Fong, business development manager for business users, South East Asia, SAP.

Among the many features of the offering include a way to integrate Crystal Reports, which presents data in a clean and neatly-formatted manner. The cloud app is also capable of executing “what-if” or predictive analysis of data without any programming required. “Everything is basically just drag and drop,” Sin quipped.

Since the firm’s release of BI OnDemand four years ago, executives said there have been at least 260,000 subscribers to the service.

With the new cloud-based service, Sin said SMBs can now leverage the power of BI in their companies without having to acquire licenses, hardware and software at such prohibitive costs.

An advantage for early cloud adopters is the software’s ability to integrate with data residing on users’ accounts on Salesforce.com, another cloud-based application that focuses on CRM. “Users can access the data warehouse and other CRM info from Salesforce.com and port them into BI OnDemand, all within just a day,” Sin related.

The move towards a cloud-based BI application is SAP’s answer to the growing demand for BI worldwide, which Gartner predicts to grow 22% even in a tough economy. A “big percentage” of SAP Philippines’ revenue, in fact, came from its on-premise BI offering, according to country manager Jennifer Ligones. “Business Objects is probably the best acquisition SAP has ever made,” she added.

Interested users can avail of the cloud BI service for at least 22 Euros per user per month, equivalent to as much as P1,600 per user per month. The price varies depending on what tools and add-ons the users need, the executives clarified.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By John Mark V. Tuazon
Computerworld Philippines
March 8, 2010

The second iteration of Oracle’s Exadata database engine will feature flash storage embedded within the server machine, eliminating the need to source data from storage disks and cutting query processing time significantly, a company executive revealed Friday.

The integration of Flash storage into the processing central of the stack makes it an ideal machine for OLTP (On-Line Transaction Processing) applications that only read small amounts of data but does it repetitively.

“Coupled with the hybrid columnar compression feature which groups data by column before compression, the flash storage can fit up to 50 terabytes of data,” explained Christopher Chelliah, general manager for Exadata and Appliance solutions, Oracle Asia Pacific.

Launched in September 2009, Exadata’s Version 2, according to Chelliah, hopes to address the growing volume of corporate data, which triples every two years. “As data grows, queries tend to go slower,” he said, adding that the transfer of huge volumes of data through the pipelines create a bottleneck that degrade the performance of the machines in the long run.

Aside from Flash memory integration, Chelliah said Oracle is approaching this problem in a two-fold manner: by integrating a Smart Scan feature in the storage drives, and by using transfer pipes with higher throughputs.

Smart Scan, Chelliah explained, turns disk drives into intelligent storage by fitting in a query processing feature. Using the analogy of a needle in the haystack, Chelliah said Smart Scan “looks for the needle” among all the disk arrays before sending it back, instead of transferring all the data up through the pipeline.

In solving the problem of bottlenecks, the Oracle executive said the new stack is using InfiniBand, a PCI card-based specialized cable which speeds up transfer rates up to ten times.

“The key value proposition of Exadata V2 is being able to process data quickly,” Chelliah remarked. “It eliminates the need to buy more storage to store more data, which can help companies save on costs.”

The second release of Oracle’s Exadata is using a Sun Microsystems server machine, different from its predecessor which uses an HP server. Asked whether this will be the natural direction of future Oracle database releases following its recent acquisition of Sun, Chelliah remarked: “I have no comment on future directions of Oracle, but what I know is that future database releases are still going to use x86 and 64-bit versions.”

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Agam Shah
IDG News Service (New York Bureau)
February 26, 2010

NEW YORK - IBM researchers have developed a new algorithm that could in minutes analyze terabytes’ worth of raw data to more quickly predict weather and electricity usage, the company said Thursday.

The mathematical algorithm, developed by IBM’s laboratories in Zurich, can sort, correlate and analyze millions of random data sets, a task that could otherwise take days for supercomputers to process, said Costas Bekas, a researcher at IBM.

The algorithm is just under a thousand lines of code and will be instrumental in establishing usage patterns or trends based on data gathered from sources such as sensors or smart meters, he said. The algorithm could be used to analyze a growing mass of data measuring electricity usage trends as well as air or water pollution levels. The algorithm could also break down data from global financial markets and assess individual and collective exposure to risk, Bekas said.

“We are interested in measuring the quality of data,” Bekas said. Efficient analysis of large data sets requires new mathematical techniques that reduce computational complexity, Bekas said.

The algorithm combines models of data calibration and statistical analysis that can assess measurement models and hidden relationships between data sets. IBM has been working on the research for two years, Bekas said.

The algorithm can also reduce the cost burden on companies by analyzing data in a more energy-efficient way, Bekas said. The lab used a Blue Gene/P Solution system at the Forschungszentrum Julich research center in Germany to validate 9TBs of data in less than 20 minutes. Analyzing the same amount of data without the algorithm would have taken a day with the supercomputer operating at peak speeds, which would have added up to higher electricity bills, Bekas said.

According to Top500.org, the Blue Gene/P is the fourth-fastest supercomputer in the world as of last November, with 294,912 IBM Power processing cores that can provide peak performance of up to 1 petaflop.

The traditional approach to data analysis is to take multiple data sets and look at them individually, said Eleni Pratsini, manager of mathematical and computational sciences at the IBM research labs. However, the algorithm compares data sets against each other, which could help enterprises point toward larger trends in particular areas, such as risk reduction in financial portfolios.

Enterprises will want faster ways of generating business intelligence as masses of data flood servers with the expansion of computing to new devices, he said.

Now that the algorithm has been proven to work scientifically, the research lab is collaborating with IBM’s Global Services unit to use it for specific services, Pratsini said. Ultimately, the algorithm could make its way to IBM applications such as the SPSS statistical analysis software, but the company didn’t provide a specific time frame for that.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Chris Kanaracus
IDG News Service (Boston Bureau)
February 25, 2010

BOSTON - SAP made a major new push into on-demand BI (business intelligence) Wednesday, announcing a new suite that combines all of SAP’s SaaS (software as a service) BI products and is aimed at “casual” users who are “underserved” by other products.

Users won’t need prior training to start working with the suite, thanks to built-in guides that walk them through the various processes, according to SAP.

One key component is the BusinessObjects Explorer data-visualization and exploration tool, which allows inexperienced users to intuitively and easily search through and analyze business data from a variety of sources, according to SAP.

Users can also create reports and share them with people inside or outside their company in a secure manner, SAP said. The vendor also said the suite will be able to tap data from on-demand CRM (customer relationship management) vendor Salesforce.com.

Partners will play a key role in selling the new suite to customers. SaaS BI vendor Oco will offer versions tuned for various industries and lines of business to large enterprises and upper-midmarket companies. The suite will also be sold via SAP’s PartnerEdge program later this year.

In addition, SAP will sell the suite directly to customers.

The product is available now in English, with added language support, including French, Japanese, Spanish and German, scheduled for the second quarter.

It will be available in a limited Personal Edition at no charge; a midrange Essential Edition; and a high-end Advanced Edition. Pricing details will be released soon, according to SAP. While the three-tier approach will be preserved across all countries, prices will be “calculated locally based on local conversions.”

SAP will be updating the suite monthly with help from “baked-in” user feedback, said David Meyer, senior vice president. Users can submit ideas for new features and others can cast votes in response to the proposals.

The product launch means changes for users of SAP’s crystalreports.com Web reporting service, as it will be rolled into the combined suite.

Any cost ramifications for those customers will become clear once the pricing model has been finalized, said Meyer. SAP has been working closely with crystalreports.com users to ensure a smooth transition, said Marge Breya, executive vice president.

Wednesday’s announcement ties into ongoing market trends. Analyst firm IDC recently predicted the SaaS BI market will grow much more quickly in coming years than on-premises BI and analytics software sales, although it will remain fairly small.

A wide array of smaller companies such as PivotLink and Birst are fueling that growth, winning deals with smaller customers that are leery of the cost and complexity of an on-premises BI installation, as well as with large companies that want to give rank-and-file business users BI capabilities faster and cheaper.

With the new suite, SAP is hoping to keep its installed base close to home. In a statement, it stressed the benefits of a single-vendor approach to on-premises and SaaS BI, versus taking “a patchwork approach” to deployment.

At the same time, SAP is emphasizing the suite’s ability to work with other systems. A customer quoted in a press release issued Wednesday noted her company is “a big Oracle shop on the back end” and also uses Salesforce.com.

But the burning issue around SaaS BI has more to do with its intended audience, rather than those bread-and-butter IT issues.

Business users, versus specialized data analysts working in small teams, are the primary target of SaaS BI offerings today, according to Forrester Research analyst Boris Evelson.

At the same time, “IT is concerned about this since it may jeopardize standards, controls, create risk, etc.,” Evelson said via e-mail. “It’s an interesting dynamic. IT’s been asking for end-user self-service BI tools for decades, and now that we got it (as in BI SaaS), they are very much concerned.”

SAP is no doubt aware of this. During a conference call Wednesday, executives emphasized the security features SAP has built into the suite.

At the same time, SAP hopes that one day some 70 percent to 80 percent of users within a company have access to BI tools, according to Breya.

“Very few people believe they have the right information at the right time to make the right decisions in their workspace,” she said.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

BI stays top priority

By JM Tuazon on February 24, 2010

By Teresa Leung
Computerworld Hong Kong
February 24, 2010

HONG KONG - The upward trend of business intelligence is here to stay. BI made it to IDC’s top 10 tech priorities and Gartner’s top five for 2010.In Hong Kong, the BI software market is expected to reach US$19.6 million in 2009 and grow a five-year CAGR of 6.4 percent, according to an IDC report published in 2009.

“From results of a survey we did in 2009, 25 percent of respondents from Hong Kong said they will deploy or will increase current deployment of BI/analytics software during the next 12 months,” said Sharon Tan, research manager at IDC.

Innovative use of BI beyond reporting
Local users have also ventured into innovative use of BI, said Jason Tang, head of Practices and Solutions, SAS Institute Hong Kong. “Some of the local firms have gone into what we call sentiment analysis,” said Tang. “Firms analyze external data and texts from blogs, forums, and social networking sites to learn what customers think about their products and services.”

External data provides additional perspectives on targeted campaigns, he added. “Cost reduction was the goal last year, but this year differentiation and revenues generation are crucial, and will be facilitated by successful targeted campaigns,” said Tang.

Real-time decision making has also become possible for BI users, Tang noted. “For instance, customer service reps can immediately do cross-sale and up sale during phone conversation with customers,” said Tang. “BI can also help HR and logistics executives to automate resources allocations and identify available resources real-time.”

Predictive analytics will be hot next, said Linda Young, brand manager, Information Management, Software Group, IBM China/Hong Kong. “Historical data analysis was what BI tools did. This is what we call trend analysis,” said Young. “But predictions are what businesses need today.”

Predictive analytics are rule-based, ‘what-if?’ analyses that help firms estimate inventories, cash flow, turnaround of goods, and profitability, according to Young.

Industry-wise, companies are also using BI for a variety of purposes, including enhancement of green practices, said Young. “One of our customers, Cosco, deploys BI-based simulation to help control its CO2 footprint and operational costs,” said Young.

Other uses include complaint management by governments, credit analysis by banks, portfolio ROI prediction by investment banks, and identifying criminals and terrorists by police, Young added.

Before the credit crunch in 2008, most BI requirements were from retailers, manufacturers, and players in the financial sector, said Young. “But in 2009, inquiries from retail and manufacturing dropped, while most were from insurance and finance,” said Young. “We expect demand (for BI) to become stable in 2010.”

New requirements
“Users want to complete deployment and be able to use the tools within two to four weeks rather than several months to a year,” said Sinko Choy, sales director, EPM/BI, Oracle Hong Kong.

Integration with mobile devices is another capability required. “Because executives are always on-the-go, they need alerts to their mobile phones,” Choy noted.

As BI tools come with more capabilities these days, CIOs are increasingly concerned about users’ data analysis skills. “That’s why you see universities have added BI courses to keep up with the changing workplace,” said Young.

BI for SMBs

“Large organizations tend to have more BI users, therefore they make up a huge proportion of BI users in general,” said Tan from IDC. “But as there are cheaper express versions of BI tools, uptake in the SMB segment is expected while the economy is recovering.”

Free analytics tools like Google Analytics helps drive the adoption of BI among SMBs. According to Young, Google Analytics is an example of advanced analytics.

“Google Analytics or inexpensive SaaS-based BI that don’t require upfront investment in hardware are good ways for SMBs to learn more about the technology,” said Young.

“[But] these inexpensive tools don’t compete with on-premise BI tools,” said Young. “When SMBs grow larger, accumulate more data, and have more stringent data privacy requirements, they will build their own BI platforms.”

While agreeing cloud or SaaS is a tech enabler, Tang from SAS said it won’t drive BI uptake. “Cloud can make implementation much easier, but ROI and other benefits are the drivers,” he noted.

Businesses need to deal with key issues like risk management and compliance, said Tan. “Since BI contains much sensitive data, companies are cautious when it comes to putting them onto the cloud,” she concluded.

Efficiency Unit enhances complaint management with text miner
Business Intelligence tools don’t just work for corporations. According to the 1823 Call Center of the Hong Kong SAR Government’s Efficiency Unit, the use of a text miner that consolidates information and uncovers hidden relationships through statistical analyses helps improve complaint management.

The Efficiency Unit’s implementation of SAS Text Miner started in March 2009 and was completed in September, said WF Yuk, assistant director, Efficiency Unit, Chief Secretary for Administration’s Office, the Hong Kong SAR Government.

Data dictionary

At a cost of HK$3.3 million, the project isn’t just about implementing software, said Yuk. According to him, Chinese unstructured data is hard for text mining because of the structure of Chinese characters.
“For instance, Quarry Bay (鰂魚涌) in Chinese is a location in Hong Kong. But while 鰂 and 魚 together is a type of fish, 涌 means a river,” said Yuk.

“Another example is the category of construction waste,” said Yuk. “We need to let the system know that sand, rubble, concrete and bricks found in urban areas are related and belong to the category of construction waste. It took us a lot of effort to build a data dictionary.”

In 2009, the unit handled more than 2.6 million calls and more than 100,000 text-based messages including e-mails and fax, said Yuk, adding that about 10 percent of the calls are complaints.
Prior to the deployment of text miner and related tools, staffers needed to dig data out from each of the complaint cases to track progress, Yuk noted. “It also took a week to compile reports on key performance indicators such as abandoned call rate, customer satisfaction rate, and first-time resolution rate,” he said.
Now staffers answering calls input incidents reported into the system, said Yuk, adding that calls are recorded so that supervisors can check accuracy.

The text mining system is accessed only by business analysts and call center supervisors.

Timely response
What the text mining system does is to identify the same incidents as reported by different individuals. “For example, a person tells us a location is full of litter while another says there are many unlicensed hawkers,” said Yuk. “Yet a third caller tells us that snacks sold at the same location look dirty.”

“They seem to be three different incidents, but they are one incident at the same location,” said Yuk. “The text mining system is supposed to bring us to attention to this so that we response timely by notifying the responsible department rather than several departments related to hawker management, public hygiene, and food safety–thus delaying necessary actions.”

The text miner also tracks the progress of cases, said Yuk. “The text miner allows us to create performance reports at the click of a mouse through dashboards as all complaints information is consolidated into a single system, said Yuk.

In addition, users can track ‘black spots’ of different types such as locations where the highest number of dead birds is seen, said Yuk. “This helps us proactively prompt departments to take necessary action.”

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Kathleen Lau
ComputerWorld Canada
February 17, 2010

TORONTO - Today business intelligence may only reach 15 to 20 per cent of an organization’s users, but that will explode to 65 per cent in the next five years, said an executive with IBM Canada Ltd.

And as users increasingly get acquainted with these analytic systems, IT pros will have no choice but to deal with the massive flood of queries and data requests that will undoubtedly follow, said Jason Gartner, business analytics development executive with IBM Canada.

“Every bit of information you give them they ask for twice more back,” said Gartner. “You give them a global headcount. The next thing they are going to ask is give me a global headcount by geography. All of a sudden, it’s four times the information.”

Gartner spoke at a ComputerWorld Canada TechInsights event about driving business innovation with smart analytics.

As user requests grow exponentially, the daily challenge for IT pros will be to continue to serve those needs, said Gartner. He describes what he calls a “one-way mirror” which separates business users from IT who toil in the background ensuring the data is clean, rationalized and at the granular level users want it.

Microsoft, HP unveil ‘breakthrough’ stack integration

“(Users) don’t care where the data comes from, they don’t care how you got the data,” said Gartner.

Also speaking at the event was Glen Sheffield, information management technical specialist with IBM Canada, who said the product landscape has become a lot more complex for IT pros in the last 15 years with all the possible options of databases, analytics, network, storage and servers. “The world got more confusing, there were more choices,” said Sheffield. “It’s time to start thinking about how we’re going to start delivering this in a faster manner.”

For this reason, Sheffield said the next trend among vendors, including IBM, is to address the simplicity of deployment with integrated hardware and analytics. IBM announced precisely this with its Smart Analytics last September. And just last January, Microsoft Corp. and Hewlett-Packard Co. unveiled what they called a “breakthrough” stack integration of both company portfolios.

Gartner said IBM is not attempting to solve all its customer problems with this integrated approach, rather it’s about letting IT pros focus on the business needs and not on “all the little pieces and nuts and bolts.”

IT pros can then customize available packaged analytics applications and add modules as needed, said Gartner.

Conan Lear, business intelligence consultant with Toronto-based T4G Ltd., attended the event wanting to find out more about IBM’s analytics strategy. In an interview with ComputerWorld Canada, Lear said IBM’s Smart Analytics approach is very ambitious. “I think it is great that they are thinking about solutions for every area and I love the idea of being modular,” he said.

However, Lear thinks it’s clear to IT pros that a one-vendor environment is never the entire answer. “I know customers are seeing that,” he said. “Just because I’ve got IBM Cognos doesn’t mean I need DB2.”

As a consultant, Lear must assess how his clients understand business intelligence and what they expect from it. At present, he said he doesn’t think the term is very well understood but that will change. “With the mergers and acquisitions that are going on at the moment, it’s going to become more and more clear to them,” said Lear.

Also in the audience was Alex Raul Pascua, a team lead for the business intelligence team at Scarborough, Ont.-based Toyota Canada Inc. Pascua said the objective at his company is to get to an enterprise-wide approach to data warehousing where eventually users will rely on self-service analytics tools.

IBM’s Smart Analytics approach and recent acquisitions happen to work well for Toyota Canada because it was already using technology from data mining company SSPS Inc. and business intelligence vendor Cognos Inc. when IBM acquired those companies, said Pascua. “Now that IBM bought those two companies, integration would be a lot easier for us,” he said.

Although an IBM shop, Pascua isn’t ruling out other vendors’ analytics tools should he find them better and users express greater comfort with them.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Tom S. Noda
Published in the CWP December 2009 - January 2010 issue

Although the economic crisis is yet to end, software firms see no let ups in technology adoptions of businesses next year. They see 2010 as a time for more strategic IT investments as companies seek to empower more their businesses and customers.

Natasak Rodjanapiches, regional managing director of Oracle ASEAN (Asia-Pacific), cites that global trends such as the Internet and instant communications, globalization of businesses and competition, the rise of virtual Internet-empowered business networks, and the presence of more empowered customers that are Internet savvy, are pushing companies to keep adjusting to change.

Rodjanapiches says businesses can’t help but go hightech, describing Net-savvy customers as very “knowledgeable” and “demanding” about their wants and needs.

Another “great” factor, according to business analytics firm SAS, data volume growth is making companies to be more IT-oriented, claiming that complex decision-making has now become a standard.

“We foresee that more and more companies will realize the importance of leveraging on their data,” says Maxie Ventura-Garin, country operations director, SAS Philippines.

And for business solutions company SAP, they see businesses, particularly smalland medium-size enterprises (SMEs) investing on their IT infrastructure all geared towards streamlining their operations.

“SMEs, majority of which are family-owned, see IT investments as a way to be more competitive and effectively manage their growth opportunities. They are looking at 2010 with guarded optimism,” says Jennifer Ligones, country manager of SAP Philippines.

Ligones adds that due to the recent natural calamities, risk management and mitigation are now also higher in the consciousness of business owners and decision makers.

John Bessey, newly appointed country manager for Microsoft Philippines, says globalization is a factor that continues to bring various challenges such as expanding market boundaries, the increasing need for workers to be able to collaborate easily anytime and anywhere, having a variety of new competitors, and facing complex market pressures and regulations and currency fluctuations.

In this yearend special feature of Computerworld Philippines, all four companies, Microsoft, Oracle, SAP and SAS, reveal some of their new products and strategies to help businesses become more efficient as well as to keep pace with their IT-savvy customers.

THE GREEN APPROACH

For Microsoft, the “green” approach is one of the major IT trends that businesses and organizations should adopt in order to save on cost yet become more productive and efficient.

Bessey says with enterprises becoming green, they don’t only contribute to environment protection but would also help them to lower their costs in doing business. He recommends virtualization and unified communication (UC) technologies.

“Virtualization enables organizations to take advantage of built-in power management features in their desktop and server operating systems, thus lowering the costs of power consumption. It can also help lower hardware and labor costs,” he says. “Unified communications, however, can also decrease an organization’s carbon footprint by reducing the need for travel.”

 Bessey adds besides saving costs on commuting, UC is helpful in reducing costly office spaces but, more importantly, the technology brings about a new culture of collaboration that improves productivity and efficiency.

“Microsoft is ready to provide the IT-enabled tools to our customers who are looking for ways to remain on top,” Bessey says. “We believe the key to delivering value in the near future is in combining the best of software running on PCs, servers, and devices with the best of services running on the Web – what we call software-plus-services. This gives companies flexibility through choice. Software plus services makes technology very accessible and affordable, lets customers and partners have more control, and builds on IT investments in software and skills.”

INTEGRATED

Rodjanapiches notes that Oracle aims to support the business and technology trends in 2010 by providing solutions founded on Oracle’s three key attributes – “comprehensive, open and integrated.”

He says there are six key areas of integration, and they are: “user experience, business process management, business intelligence, security, scalability and high availability, and also operational management.”

Rodjanapiches claims Oracle is planning for technology enhancements that would benefit more than 90,000 of its current customers which will enable cost reduction, improve efficiency and the ability to differentiate their organizations from competitors through unrivalled innovation.

“For applications, Oracle continues to place a significant focus on meeting our customers’ industry specific needs. For example, in financial services, Oracle provides applications to handle areas such as branch and call center automation, marketing automation and customer loyalty management, wealth management, financial, performance, and risk management, human capital management, and core banking systems,” Rodjanapiches says.

Rodjanapiches says through Oracle’s applications unlimited program, their customers worldwide can continue to enjoy business value from product upgrades and enhancements. Added to this is the Oracle Lifetime Support policy which assures its customers that their IT investments with Oracle will be protected no matter what product release they are running.

BI AS NEXT WAVE

SAP’s Ligones says business intelligence (BI) will be the next wave in 2010 since a lot of companies who have already set-up their back-end automation processes will be needing a system that enables them to “drill down and slice and dice data fast and interpret them into information that their management can use for decision making.”

The demand, she says, may also differ depending on industry.

“In banking for instance, a strong customer relationship management (CRM) system is needed to support them as they push their different consumer products. Large enterprises may look into GRC (Governance, Risk & Compliance) systems,” Ligones says.

She explains stakeholders normally demand effective governance, including enterprise risk management, transparency, accountability, and optimized performance. Successful companies address these challenges by proactively managing performance across the enterprise with risk-balanced strategy management, and risk-based controls embedded in business process areas. This can range from financial to human resources, environmental to trade management.

“Such companies increase visibility across risk and compliance initiatives, and they do so efficiently to minimize the cost of GRC,” Ligones says. “Achieving effective and efficient operations and reporting requires a unified strategy that guides people, standardizes processes, and integrates technology to embed GRC at every organizational level.”

With the two trends mentioned, Ligones says companies, more than ever, need a clearer and better understanding of their business. Rapid “go or no go” decisions will only be possible if companies have automated most, if not all, of their business processes.

BIZ ANALYTICS

Ventura-Garin, citing the economic crisis, explains the importance of “predictive analytics.” She says the technology is more about reporting on what happened, but using advanced analytical capabilities to develop deep insights and understanding about the business, the customers and the products to derive the organization’s competitive advantage.

“SAS knows that the future of an organization to sustain their competitive advantage using business analytics will be in their ability to take advantage of the different types of data beyond the traditional structured text data. The future dictates the ability to capture insights out of other types such as unstructured text, voice, video or web to enhance the customer experience, introduce product innovations or improve operational efficiencies,” Ventura-Garin says.

Coupled with the vast amount of data available, the data volume and complex analysis required, organizations will need to continue to leverage on a business analytics framework, she says. An agile framework that enables an organization to address its most critical business issues now and then add new functionality over time that will be critical in determining future behaviors.

She says imperative to the businesses are robust data integration, data quality, data and text mining, predictive modeling, forecasting and optimization technologies to anticipate what might happen. She reports that many implementations today have not capitalized on the full power of business analytics.

The private sector, Ventura-Garin claims, has been using business analytics to great effect, by managing risk and compliance, optimizing investments, competitive pricing, effective promotions quickened problem resolution, and producing more accurate forecasts to improve performance.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By John Mark V. Tuazon
Computerworld Philippines
January 26, 2010

Companies looking to rise from the economic slump of 2009 will benefit greatly from using business intelligence tools to make their data work for them, an official from a business analytics vendor remarked recently.

Because businesses are striving to overhaul their current work processes, managers can use fresh insights gathered by using BI tools available in the market, suggested Sonny Halili, SAS regional director for the Pacific region, and former managing director of SAS Philippines.

“Even before the crisis ends, companies who have taken steps early on will be way ahead of the competition,” Halili said, adding that the crisis has been particularly good to a business provider like SAS, whose main value proposition involves helping firms identify how they can create a more efficient workflow that can expand their bottom lines.

Companies with large volumes of data can implement business analytics software, Halili said, in order to drill down on certain factors that can help them work easier. “SAS offers solutions targeted at the eight levels of analytics—from standard reports up to optimization—which can help firms determine best courses of actions given any business situation,” he added.

SAS in the Philippines operates as a “trusted advisor” of companies, according to Halili, which enables them to offer services tailor-fit to each firm’s needs. Specifically, Halili noted that they have helped government agencies, for example, identify tax evaders; telecommunications firms reduce churn rate; and banking institutions manage their customer and loans portfolio, and identify credit risk management needs.

Halili said the company remains unfazed by mounting competition from similar providers, specifically IBM, which in October acquired the statistical package software SPSS, expanding its business analytics arm and hiring as much as 4,000 consultants to fuel the division. “We don’t really just sell products,” Halili claimed. “We’re here to solve business problems.”

SAS is poised to make its growth revenue larger this year, according to Halili, adding to its 40% year-on-year growth in 2009. “We are optimistic that BI adoption in the region is going to improve,” he quipped.

Halili said this projected growth is to be bolstered by new offerings from the BI vendor, which includes Social Network analytics—which can help marketing arms of companies identify the strength of their network—and Sentiment Analysis—a text mining module that determines how customers interact with the company through different communication channels, and helps to identify specific patterns of behavior.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Joab Jackson
IDG News Service (New York Bureau)
January 13, 2010

NEW YORK - While the number of users on Twitter, Facebook and other social-networking sites continues to grow, business intelligence practitioners remain skeptical about the value of knowledge such services could generate, if one survey by a data warehousing firm is any indication.

Kognitio surveyed 125 people on its sales contact list about the potential value of social-networking tools, in terms of providing raw data that could be analyzed. Respondents were ambivalent about this possible new source of intelligence, however.

“We wanted to find out if the enterprise architects, and the people in the BI trenches, are bringing in and analyzing social media data,” said John Thompson, CEO of Kognitio’s North American operations. “And for the most part, they aren’t.”

Only 14 percent of the respondents said they have any desire to incorporate social-networking data into their current data analysis efforts. A total of 63 percent of the respondents were “undecided” about the potential value of aggregated social-networking data, and 23 percent called social media “overrated.”

Kognitio released the results of the survey at the National Retail Federation’s annual conference, being held this week in New York.

Thompson said while organizations have started using social-networking sites as marketing tools, less thought has been thus far dedicated to analyzing feedback such sites could generate.

Thompson speculates that most BI practitioners are too busy refining the existing systems to look into new sources of raw data. Once upper management starts to see the strategic value in analyzing the chattering of the many, however, then we might see more social media-based BI.

Such social media-based conversations, recommendations and other user-generated data could be worth investigating, through such tools as text mining, sentiment analysis and geo-location. “It would be interesting for retailers to look at certain trends and to get an idea of what people are thinking, doing and talking about,” he said.

A large social-networking site can provide a snapshot of what people are talking about in near real-time, Thompson said. A retailer could track if a certain brand name is being talked about, and watch the buzz as it moves around to different regions. It can also summarize whether positive or negative things are being said about the brand, through a keyword-based technique called sentiment analysis.

Setting up a social-networking monitoring feed within an existing BI system shouldn’t be that difficult, Thompson said. Social-networking data is unstructured, so it is not organized in a formally defined database. By now, most BI tool vendors and service providers have incorporated some means of working with unstructured data. BI providers have also streamlined operations so that analysis can be generated in near real-time and displayed on dashboards and widgets. However, Thompson did caution that Twitter limits the number of times in a day a search call can be made to the service.

On the show floor of the conference, some vendors were showing off how their BI tools could ingest and make sense of social-media data. SAP spokespeople, for instance, talked up the ability of Business Objects software to aggregate, highlight and analyze Twitter data. The software could offer a dashboard detailing how much discussion a particular brand name generated, as well as how much of the conversation about the brand was positive or negative.

Jon Würfl, an SAP retail industry principle, noted that one of the company’s customers already uses this setup to monitor Twitter. When the company, which Würfl did not name, found itself to be the subject of some negative talk, it was able to pinpoint the talk to a particular region and determine that the source of the negativity came from one badly managed store.

The Kognitio survey also asked some questions about the use of BI in general. The company found that 31 percent of respondents planned to purchase new BI capabilities in the upcoming year, and 36 percent said that when setting up a new BI system, they must test, evaluate and deploy the system within a few weeks, far less time than management allowed in previous years.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Eric Lai
Computerworld (US)
December 23, 2009

FRAMINGHAM - When a tech vendor fails, rivals usually rejoice. Not in the nascent BI (business intelligence)-on-demand space, after well-funded startup LucidEra folded in June.

The company had raised almost $21 million in funding from high-profile venture capitalists. Though competitors immediately began wooing LucidEra’s customers , they also felt compelled to put out public statements saying that its failure was an outlier, not the beginning of a trend.

Not only have customers failed to adopt BI-on-demand the way they have for other kinds of apps such as CRM (Salesforce.com, for example) or productivity ( Google Apps), but it has also received little validation from the big players.

IBM, for one, is only starting to “research” a Web version of its Cognos BI software.

“The data model differs from company to company, which is why you just can’t put it into a multi-tenant environment,” said Rob Ashe, general manager for IBM’s BI and performance management division.

“I’d say we are of two minds. We like the benefits of the cloud, the elasticity and the way it scales,” Ashe continued. “However, you also have to deal with the realities of security and moving a lot of data around.”

While Sybase Inc. is launching on-demand versions of several apps, it doesn’t yet see strong demand from enterprises for an on-demand version of its BI-focused database, Sybase IQ, says CTO Irfan Khan.

Microsoft Corp., meanwhile, says it is unlikely to deploy a BI-in-the-cloud before 2013.

One independent analyst, Merv Adrian, says BI-on-demand remains too scary for most enterprises today. “A lot of companies are not willing to throw data in the cloud. Structurally there’s no good reason to do it,” Adrian said.

Also, BI providers “need to get ease of use right, and make it easy for data to get where it needs to be. You need to tease the value out quickly, otherwise, people are likely to abandon it,” he said.

Brad Peters, co-founder of on-demand BI startup Birst says the value proposition for BI-as-a-service remains strong. “When you buy a piece of on-premise software, you have to spend $3-5 on services on top of every license dollar spent because it’s still all on you to make it happen,” Peters said.

Like BI-on-demand players such as Oco Inc. , Birst emphasizes how quick and easy it can be for many would-be customers to deploy. “We look just like Business Objects,” Peters said.

And for those worried about Birst’s stability in light of LucidEra’s failure, he points out that the company’s fifty-something customers include big financial services firms such as Royal Bank of Canada (RBC) and Securian.

Other BI vendors such as ParAccel Inc. are hedging their bets. “We have several customers that are on-demand application providers for whom we are the behind-the-scenes engine,” said Barry Zane, CTO for the startup company.

However, ParAccel isn’t looking to launch an on-demand version of its columnar database appliance, which is aimed at companies with data warehouses with capacities of more than 100TB.

“There’s no way you can get the class of performance you need on a public cloud,” Zane said. “You need big, predictable pipes to the servers — that’s where the cloud tends to be weak … it’s a gimmick more than reality if you need performance.”

Forrester analyst Boris Evelson says BI-as-a-service remains a great tactical solution, especially for companies needing “something more Web 2.0 and collaborative than Excel.” But he argues that would-be customers should go through a rigorous checklist first.

As per usual with enterprise software and services, departments and small-to-mid-sized companies are deploying BI-on-demand first, Adrian says.

He thinks enterprises will eventually catch on, though it will take time. “It’s like open-source software adoption, it takes time for the tire-kickers to think it is safe enough,” Adrian said.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Stephen Bell
Computerworld New Zealand Online
November 18, 2009

WELLINGTON - Management of many organisations are calling for strategic business information from their ICT systems. But they have no real business information strategy, nor a dedicated team to create one, says consultant Roy Elgar.

Currently with Teradata, Elgar has consulted on data warehousing and strategic business information with companies worldwide that have some of the largest and fastest-moving collections of data. Bharti India’s largest cellphone network company, for example loads 1.2 billion call records a day, he says.

Improved business information has turned up repeatedly for the past three years in industry analysis of the top priorities signalled by the business to CIOs in the US and Europe. On a smaller scale, New Zealand companies are faced with the same need, he told an audience of Computer Society members earlier this month

Yet, there is little in the way of a truly strategic approach; what often emerges is a set of departmental point solutions.

Setting up a centre of expertise — even if only one person — simply to manage BI is critical, he says. A specialist staff member or team can take the larger view.

A company-wide data warehousing exercise analysing the needs of all departments in concert will have important synergies, Elgar says. Most items of data will be used to answer the business information questions of more than one department, yet the departments often collect and maintain those items separately in their own datamarts, with massive duplication and a risk of inconsistency.

One of the most prevalent errors in setting up a BI system, Elgar says, is to confuse technological elements with pure logical data questions. There are five separate layers to the exercise: the business goals; applications that provide the information; a logical data model (with no reference to technology) on which the applications work, a set of “views” which offer users a role-dependent “view” of the overall logical model and a physical data model that implements the logical model efficiently.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Trevor Clarke
Computerworld Australia
October 23, 2009

SYDNEY - Is it possible business intelligence solutions are too sexy for their own good? Yes, according to one Monash University lecturer.

Peter O’Donnell has been working as a business intelligence applications lecturer at the university since 1990. In that time he has focused on testing things people take for granted in the BI space – including sex appeal.

“As a collective BI industry, everyone has the rhetoric that it is about visualisation and letting people see their data; it’s a grand dream that we put this slice and dice interface in front of people,” he said. “That is the way vendors do their demos and somehow or other people will drop, click and drag to get to the relevant number and their day is better and the problem solved.”

But one of O’Donnell’s concerns is all the main vendors’ products are similar with the same style of interface. And it’s an interface that O’Donnell contends has contributed to low utilisation rates – often as low as single digits he claimed – despite strong sales.

According to analyst firm Gartner, the Australian BI market hit $US211 million in 2008 for growth of 11 per cent. BI applications were also ranked the top technology priority in 2009 for the fourth year in a row in Gartner’s annual survey of CIOs.

Globally the appetite for BI platforms, analytic applications and performance management software in 2008 increased 21.7 per cent on the previous year, from $US7.2 billion to $US8.8 billion.

Yet, according to O’Donnell’s research, many employees don’t get the full benefit out of BI applications. People who acquire knowledge and learn visually or kinaestheticly (by doing) are relatively comfortable with fancy graphical representations of data in BI solutions, but those who learn aurally or by reading aren’t.

“A lot of the tools are very sexy. You can do 3D pie charts and donut charts; in theoretical terms it is known as the data to ink ratio. If you have embellishments and 3D effects you are using a lot of ink for only a small amount of data,” he said.

“In a sample of 2 groups of 20 people, we gave the same data to each group. To one of them we gave them plain, boring looking charts that adhere to the guidelines of keeping the data to ink ratio close to one. The other one we gave them sexy stuff. One group would get a bar chart the other a pie chart. One would get a bar char the next would get a bar chart with 3D effects. We’d ask them to analyse very simple questions – i.e. compare this data, which one is bigger, which one is smaller, etc. The results were generally awful. There was something like a 62 per cent probability of getting the questions right if you got the plain charts. If you got the sexy ones it was like 47 per cent.”

While O’Donnell freely acknowledges it is hard to generalise from such a small sample he concludes there are significant problems with BI solutions using sexy graphics that are trying to support decision making processes.

“When all the vendors have tools that look the same, we may be supporting one group of people with one particular cognitive style and missing some others,” he said.

One of the reasons for the disconnect between strong sales and poor utilisation rates is there hasn’t been enough focus on employing developers that have advanced interface skills. O’Donnell’s research team has been observing the Australian job advertisements for BI positions. The findings appear to back up his position.

“Everyone says the front end is important but all the job ads are for data modelling skills or data transformation skills. I have seen in the last six months, and there are 500 or 600 jobs in Australia at any one time, one job mention anything about usability. They generally have got something on, must have business objects or must have used COGNOS or that kind of stuff – clearly front end technologies. But nobody is going beyond the tool set and saying they must know about visualisation or usability.”

In short, BI vendors may be capable of creating sexy hot graphics to present data, but they have failed to engage users. For O’Donnell providing greater choice, and in particular plain Jane options for graphics, would help boost the utilisation and success rates.

“I don’t think people are using the slice of dices to get the wrong data,” he said. “I think they just give up.”

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Eric Lai
Computerworld (US)

CHICAGO (09/17/2009) - When Raghu Bala, CTO of Automotive.com, joined the company in 2006 to help it build out its business intelligence infrastructure, he put up on his office wall a picture of a cup stuffed with dollar bills and change, with a caption underneath that said, “Panhandling for BI budget.”

“I actually got some money out of that,” Bala mused during his talk Wednesday at Computerworld’s Business Intelligence Perspectives conference. He and other IT leaders shared their tips on how to deploy BI cheaply, profitably and effectively.

A former Yahoo Inc. engineer, Bala was surprised more than once at how much of a “shoestring budget” the company, which operates 200 magazines and Web sites such as Motor Trend magazine, ran on.

When Bala requested to buy a pricey storage area network (SAN) for the data warehouse’s storage, management balked.

“One of the guys said, ‘I can go to Fry’s and buy a bunch of 10 TB drives and string them together. Why do you need to spend $200,000 for a SAN?’” Bala recalled. “I had to explain to him all about snapshot backups, Raid 5, Raid 10.”

When that didn’t convince his manager, an exasperated Bala sarcastically suggested that he “just go and get a bunch of thumb drives and cascade them together, since they’d be free after all.”

Eventually, Bala agreed to have his team build its own SAN out of a cluster of Linux servers. That involved $12,000 in hardware and software costs, and two to three months of time for its lead developer. The result is impressive: a custom operational data store with an “extremely fast” in-memory cache that Bala says can store millions of events per hour.

Bala also saved money other ways by using the free Excel-based BI tools that Microsoft Corp. bundles with its SQL Server database, sharing database administrators with the engineering team, and building cubes for reports only after watching what reports the power users at Automotive.com built for themselves.

This saved IT the labor of having to create and e-mail dozens or hundreds of canned reports, and instead trained the users to “generate their own reports and generally think for themselves,” he said.

For companies with long-term customer relationships, one of the best things BI can do is help figure out which are the profitable ones and which are the money-losers.

According to Basil W. Blume, chief analytics officer of Colorado Capital Bank, the average ratio of profitable:unprofitable customers in the retail banking industry is 70:30.

“It’s just not profitable when all they have is a $1,000 checking account,” he said. “But the other 30% of customers make it up.”

If not directed by management to solve this problem, Blume suggests that BI managers step in and draft a plan of how to figure this out.

But which of the many definitions of profitability should they use? Blume suggests using the “contribution margin.” That’s a relatively simple figure to derive, he said, especially compared to net income, which requires users to divide gross income by fully loaded costs.
Getting adoption in a non-techie workplace

Anthony Marano Company is a 50-year-old fruit and vegetable wholesaler in Chicago. Operating out of a single 400,000 square-foot warehouse, the $200-million-a-year family-owned company remains close to its heritage as an Italian American-owned grocer.

“There’s a lot of guys named Joey, Nicky and Tony here,” joked Chris Nowak, the chief technology officer.

Until 2003, none of Marano’s buyers and sellers used computers. Orders were handwritten and vendor and customer information was stored on Rolodexes. All of the expertise resided inside the brains of Marano’s buyers and sellers.

This seemed treacherous, considering the real-time nature of Marano’s business. The company specializes in supplying produce at the last minute. “We are the 24-hour Walgreen’s of fruits and veggies. People buy from us when they are short,” Nowak said.

Also, Marano’s huge size and customer base means that it could supply vital pricing information back to farmers that could influence their decision whether to go to the trouble of trying to recover a damaged crop, such as strawberries at risk from a freeze. That wasn’t easy without a BI system, much less PCs for the buyers and sellers to use.

Nowak was brought in to deploy the company’s first computer-based BI system. Knowing that overcoming resistance from the users — the sales staff — would be key, Nowak made sure to select an easy-to-use and powerful tool for them.

He licensed the Inxight software owned by SAP AG, which offers a visualization tool called StarTrees. These are circular expandable charts that Nowak purposely chose for their resemblance to old-fashioned Rolodexes.

These charts quickly and conveniently let the sellers get price and stock information on all 1,400 types of produce carried by Marano.

The charts were so useful that soon all 28 buyers and sellers were trained and using the StarTrees, Nowak said. It allows them to offer more fine-tuned pricing to buyers and farmers and move product more efficiently with less spoilage, ultimately boosting profits, he said.

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

By Thomas Wailgum
CIO.com
August 5, 2009

FRAMINGHAM - Most businesses today have more data than they know how to use. And getting at that data and then presenting it in a useful manner for cogent analysis are two tasks that typically haunt organizations.

Consider the treasure troves of data found inside companies’ enterprise systems: ERP, CRM, BI and supply chain applications. But the global recession has made it a tough time to get boards to pony up blank checks for large and exploratory projects to unlock those potential data stores.
A new Aberdeen Group report, however, points out a paradox: While the struggling economy has forced businesses to attempt to cut costs and “do more with less,” by leaving this data largely untapped, companies instead run the risk of “more is less.”

This is exactly the place and time for BI tools to step in, write Cindy Jutras and David Hatch, two Aberdeen VPs, in the July report, “The ERP/BI Connection: Adding Value through Actionable Intelligence” (pdf download).
“BI tools have reached a level of maturity which can elevate executives from the depth of the details, bringing them to a higher operating level where they can add strategic value to the organization,” Jutras and Hatch write. “The ability to provide better decision support with integrated enterprise data is an important factor in turning data into actionable intelligence.”

“The synergistic relationship between ERP and BI,” they add, “can indeed be the perfect storm, igniting improved performance and visibility.”

Can BI Light a Spark Under ERP Data?

In many respects, companies have been facing a nasty storm when it comes to their standalone (un-integrated) enterprise systems: Many companies are “oversoftwared” right now, and there’s been a substantial backlash and pleas for real-world, usable innovation.
With BI, in particular, surveys have shown that 40% of executives still trusted their gut in decision making (as opposed to their BI systems), and many more are frustrated with CIOs and IT for failing to give the business what it needs and deserves with analytic and decision-making tools.
In recent Aberdeen surveys of enterprises with BI and ERP applications, BI has ranked number one (two years running) in terms of the technologies that will have the most impact in the next two to five years. Coming in second in the April 2009 survey was “Enterprise application enhancements / extensions.” According to Jutras and Hatch, that topic “refers to the ongoing improvements that drive extended value from ERP and CRM investments.”

Digging deeper into the data, Jutras and Hatch determined that BI tools were the top “enhancement or extension” that organizations planned to use to integrate systems and tap into data flows. “Think of [BI] as a layer on top of or embedded within ERP and other applications,” they write, “which wind up being giant repositories of data.”

How to Get Started

In the Aberdeen report, the analysts preach an “integration” mindset when it comes to a more perfect ERP and BI union.
“Whether BI tools are currently embedded within your ERP solution, tightly integrated, bolted on after-the-fact or non-existent, don’t treat ERP and BI as separate projects,” Jutras and Hatch write. “Take the approach of using BI as a means to extract enhanced value from data within ERP (as well as other enterprise applications). ERP can transform data into information but BI tools are required to complete the transformation from information to intelligence.”

A good first step: Form cross-functional teams for both ERP and BI projects. “When left entirely to IT, the success of projects is often measured by cost and speed of implementation,” Jutras and Hatch write. “These are important factors but using them as the exclusive measure of success loses sight of the original business goals of the project.”

There’s much more work ahead, the authors point out and fully examine in their report, but time is of the essence. “Achieving transparency and visibility is no longer simply a lofty goal,” Jutras and Hatch write, “but a core necessity of the business.”

Possibly Related Posts:


  • Multiply
  • MySpace
  • Digg
  • Delicious
  • Facebook
  • Squidoo
  • Twitter
  • Yahoo Buzz
  • LiveJournal
  • Google Bookmarks
  • StumbleUpon
  • AOL Mail
  • DZone
  • Ask.com MyStuff
  • AIM
  • Share/Save/Bookmark

SEPTEMBER 2010 ISSUE

Latest Print Issue
 
 

QUICK POLL

Who is the Most Innovative IT Company?

View Results

Loading ... Loading ...

Web Stats

 
Media G8way Corp
Copyright (c) 2009 Media G8way Corp. All Rights Reserved. Reproduction in whole or part in any form or medium without express written permission of Media G8way Corp is prohibited.
IDG