Monthly Archives: June 2008

SAS measures eco-friendliness

From IT Web Article -

Business intelligence firm SAS is set to release a solution that enables companies to measure how their operations impact the environment – a tough sell for now but a step in the right direction, according to one analyst, says

SAS says its Sustainability Management solution allows end-users to measure business based on what it refers to as the “triple bottom line” of environmental, social and economic indicators.

SAS says its solution uses predefined “green” metrics from the Global Reporting Initiative, used by more than thousands of businesses to measure the environmental impact of their operations.

Jaspersoft Puts A New Face On BI Suite

From Intelligent Enterprise -

In leveraging the new technologies, Jaspersoft has built a UI that runs in all the major browsers and uses a drag-and-drop approach to using business intelligence tools.

Users start with a list of domains, such as billing, inventory, sales, marketing or any other topic for analysis and reporting. Under each domain is a list of data items organized in a typical tree structure. After a user drags data items to the workspace on the right side of the UI and clicks “done,” the software automatically generates the SQL statements for querying data stores.

Once the queries have been generated, the retrieved data can be dragged onto a designer workspace for generating reports that can be saved in the Jaspersoft repository and then used in a variety of ways, such as in a PowerPoint presentation, Excel spreadsheet, a PDF document or email.

Ireland is facing a data tsunami

From Silicon Republic, an interesting article on the exponential growth of data -

CURRENTLY the amount of data worldwide is doubling every 11 months – by 2010 it will double every 11 hours.

Ireland stands in the direct path of this tidal wave of data, warns a senior executive with business intelligence (BI) giant SAS.

Dr John Brocklebank, director of analytic solutions at privately held software giant SAS Institute, believes Irish firms are ill-equipped to deal with this rapid growth in the world’s data.

He says the challenge for Irish companies is to capture and exploit the 1-2pc of data that is relevant to their decision-making processes and strategic objectives.

“We know that, on average, managers spend two hours a day looking for data and that more than half of this is useless to their decision-making process,” Brocklebank explains.

“Most frightening is that 42pc of managers say they accidentally use the wrong information to make a decision at least once a week. So never mind trying to deal with the data in its entirety; it needs to be made meaningful and accurate to support business decisions.

Informatica Positioned In Leaders Quadrant In Data Quality Tools

From Informatica Press Release, this is an important win for Informatica.

Informatica Corporation (NASDAQ: INFA), the leading independent provider of data integration software and services, today announced that it has been positioned by Gartner, Inc. in the leaders’ quadrant in the 2008 Magic Quadrant for Data Quality Tools report.

Ted Friedman and Andreas Bitterer, authors of the report state, “leaders in the market demonstrate strength across a complete range of data quality functionality, including profiling, parsing, standardization, matching, validation and enrichment. They exhibit a clear understanding and vision of where the market is headed, including recognition of noncustomer data quality issues and the delivery of enterprise-level data quality implementations. Leaders have an established market presence, significant size and a multinational presence.”

According to the report, “growth, innovation and volatility (via mergers and acquisitions) continue to shape the market for data quality tools. Investment on the part of buyers and vendors is increasing as organizations recognize the value of these tools in master data management and information governance initiatives.” The complete report, including the quadrant graphic, is available on the Informatica web site at

Sybase IQ Delivers Worldwide Analytics

From Press Release -

Kathleen Schaub, Vice President of Product Marketing for Intelligent Enterprise for Sybase, Inc., recently participated in an exclusive interview with Ron Powell and the Business Intelligence Network ( In this interview, Schaub explains how Sybase IQ handles the most challenging data warehousing requirements, meeting the demand for advanced analytics and fast reporting, and delivering unsurpassed query performance at the lowest price/performance available.

“Sybase IQ allows customers to achieve analytic feats they never dreamed possible with ordinary data bases,” Kathleen Schaub, Vice President of Product Marketing for Intelligent Enterprise for Sybase, Inc. “Sybase IQ is well suited for organizations with extreme analytics requirements such as analytics service providers, financial services and insurance companies.”

“Sybase is very focused on high performance and the ability to query large amounts of data,” says Ron Powell, Cofounder and Editorial Director of the Business Intelligence Network. “With Sybase IQ’s unique indexing and column-based processing, Sybase customers receive faster results for mission-critical business intelligence, data warehouse and reporting solutions on any standard hardware and operating systems.”

SmartStream Banks on Informatica to Accelerate Customer ROI

From the Press Release -

Informatica Corporation (Nasdaq: INFA), the leading independent provider of data integration software, today announced that SmartStream Technologies, a leading provider of software to the financial services industry, is OEMing the Informatica PowerCenter data integration platform as part of its flagship Transaction Lifecycle Management (TLM) solutions.

In making Informatica PowerCenter the foundation of its SmartStream TLM Business Integration (TLM BI) offering, SmartStream is empowering those customers with complex data environments to accelerate the return on investment of their TLM deployments through the high-performance and cost-effective integration of data involved in transaction cycles.

“The increasing drive to streamline global banking practices means our software needs to manage highly complex and rapid transactions across platforms and different banks. By using Informatica, rather than continually creating bespoke data interfaces, we can enable a faster ROI while freeing our professional services teams to provide more value to customers,” said Neil
Vernon, head of SmartStream’s Product Management Group. “We selected Informatica to power TLM BI following an evaluation where they scored highest against our key criteria of usability, reusability and performance. In addition, it was critical that TLM BI have the focus and support of a recognized best-of-breed vendor such as Informatica.”

NextGen BI ‘Humanizes’ Technology, Information Delivery

From Aptech Press Release -

There’s a fine line between having the right information you need to make hotel budgets and solid business decisions, and being confronted by so much data that it paralyzes thinking. For numbers-driven hotel companies, information should be king. But today it is too often the opposite, arriving as a stack of spreadsheets that managers must carefully review and analyze to see how their organization is performing–or was a week or more ago.

Business Intelligence (BI) applications solved this problem and are now widely used throughout the hospitality industry. A true BI system consolidates information from financial and non-financial sources such as multiple property management systems and financial planning software, Smith Travel Research (STR), guest satisfaction scoring, payroll and other systems and delivers an analysis that enables users to identify the reasons behind the numbers that affect how their hotel management business is performing. Today, over 20 hotel management companies and ownership groups with over 2,500 total properties use Aptech’s BI solutions to automate, analyze and deliver forecasting and performance information.

To make business intelligence data more accessible and the systems easer to use, hospitality BI leader Aptech Computer Systems, which utilizes the Cognos database engine, is rolling out a new version of its Execuvue Business Intelligence System based on the latest Cognos 8.3 technology that provides a much wider scope of data delivery options and formats. The new Execuvue BI platform ‘humanizes hotel software’ by making the system easier to use and enables a hotel company to customize its BI information output so each manager sees the data they need in the delivery format they can use best for faster and more profitable decisions.

Teradata Improves Analytics for Business Users

By Anshu Shrivastava of TMCNet, an article on the new Teradata Warehouse Miner.

The technology of data mining discovers patterns in customer, financial and operational data that can provide valuable business insights, according to Teradata.

The newest enhancements to Teradata Warehouse Miner are supported by the recently announced SAS (News – Alert) Scoring Accelerator for Teradata. Keith Collins, CTO at SAS, said that Teradata’s new functionality, and the recently released SAS Scoring Accelerator, are integrated and complementary solutions.

Teradata’s officials pointed out that the an initial benchmark of the SAS Scoring Accelerator for Teradata demonstrated the ability to process the number of records “45 times faster” than the traditional scoring method.

Moreover, the SAS Scoring Accelerator for Teradata also eliminates the need for manual translation of the SAS scoring code into SQL, or structured query language.

New Approaches to Business Intelligence

From Internet News, an article on how Web 2.0 is not the only new kid on the block.

“BI is getting bigger, growing from a departmental solution or application to an enterprise resource, so it needs an infrastructure that can support thousands or tens of thousands of users, not hundreds,” Microstrategy vice president of products Mark LaRow told

The traditional method of building reports on request consumes a lot of resources, and an IT department would have to build more than a million designs to cover a modest data warehouse, according to LaRow.

Now, IT designs “a small number of reports — maybe 1,000,” and users can take one report, click on different rows and columns to drill down, LaRow said.

He said they can surf the data they want, adding the data they need dynamically and either saving their version of the report or using it online.

For example, one of Microstrategy’s customers, the Loews (NASDAQ: LTR) hardware retail store chain, has 94,000 reports anyone can use. Only 3,000 were “explicitly designed by IT,” and the rest are variations of those with additional data added by users, LaRow said, adding that some of the derivative reports are “much larger than the originals.”

None of these approaches is fast enough for Terry Cunningham, the founder of Crystal Decisions, which sold the Crystal Reports BI tool. He is often considered the father of business intelligence.

BI is “evolving into what we call continuous BI; it never rests,” Cunningham told “Things need to be understood, and decisions need to be made in real time,” he explained. “There’s no such thing as ‘I’m going to run the report tomorrow and see how we did today.’”

Business Objects Dives Into Predictive Analytics

Business Objects is now officially into Predictive Analytics with its new tool Predictive Workbench and that’s a good news. Read more from Infoweek.

Business Objects on Wednesday announced Predictive Workbench, a new module for its business intelligence platform that lets businesses make predictions about such things as customer behavior and business performance. The module, based on technology from SPSS Inc., is the latest example of a traditional BI company looking to move beyond its expertise in reporting and analysis tools.

Predictive Workbench is the result of an OEM deal Business Objects struck last December to offer SPSS’s technology. IBM (NYSE: IBM)’s Cognos struck a similar deal with SPSS in March, and also plans to integrate IBM-developed predictive analytics within Cognos. Both efforts take a direct competitive shot at SAS Institute, by far the market leader in predictive analytics.


Since the December OEM deal, Business Objects has worked to integrate the SPSS technology, called Clementine, into Business Objects X1 3.0 so that it’s “totally transparent and seamless for customers,” said Franz Aman, VP of BI product marketing. The result is Predictive Workbench, from which a user can launch the Business Objects Universe metadata layer to run predictive analytics against various databases and data warehouses. Business Objects will disclose the price of the module only to interested customers, Aman says.