All it takes is one bad case.

Word gets out to the public that a child under county care has been placed in 20 different foster homes over the course of a year and everyone thinks the entire system has gone bad, said Roger Ward, manager of decision support research of the Hamilton County, Ohio, Department of Human Services. "Even though a case like that is an anomaly, it becomes the norm in the publics perception."

But fighting that perception can be hard if you dont have the data to prove one poorly managed case is the exception, not the rule.

Thats the dilemma the department faced when Ward and his staff began searching for a tool that could help management keep close tabs on caseloads, spending, outcome and performance. But not just any tool. It had to be something that nontechnical social workers would feel comfortable using. "We were interested in getting people to use data, but its really hard to do that with a staff who arent trained in data analysis, such as SQL queries," he said.

Ward decided to try a tool fairly new to the public-sector market: business intelligence (BI) software. Unlike traditional data-query tools, BI software hides cumbersome query languages behind a point and click interface. Actually, business intelligence software is much more than that. It can gather, store and analyze information, as well as provide quick and easy access to data.

Through the Internet, extranets and intranets, BI software allows agencies to easily share information with constituents and among workers at a relatively low cost. Thats good news for government agencies sitting on top of massive databases of information that are often inaccessible to government workers and the public alike.

Intelligent Software

"Business intelligence is about getting data out of databases and into the hands of knowledge workers and giving them the data in a way thats meaningful to them," explained Judd Lowe, area vice president of Cognos Corp., the firm that supplied Hamilton County with its BI software tool. Because of the explosive growth in electronic government, states and localities need to consolidate and integrate information from multiple agency databases more than ever so that workers can run queries, the public can conduct transactions and managers can report to policy makers on trends.

Meeting these requirements can be cumbersome, even with such solutions as data warehouses. For agencies stuck with mainframe systems, opening up data to greater access can be especially difficult. Ward pointed out that many department workers didnt bother to query the departments legacy system because the information was often out of date by the time they got the report.

But business intelligence software is specifically designed to allow workers, who dont know or care about query languages and complex analytical techniques, a fast, easy and understandable way to drill down into data and spot trends and patterns. According to Lowe, Cognos has sold its tools to welfare agencies that must report on outcomes to federal agencies so they can receive block grant funds. Criminal justice agencies use the software to analyze crime statistics, and education agencies have found the tool beneficial for spotting trends in standardized school tests.

In California, the Franchise Tax Board uses a business intelligence solution from IBM to identify residents who havent filed their taxes. In New York City, residents can visit a Web site and check the latest health inspector records of their favorite restaurant. The application was developed for the citys Department of Health using BI software from Information Builders.

Proven Intelligence

Although having a data warehouse can make it easier to use business intelligence software, its not required, according to Lowe. In Hamilton County, the Department of Human Services has been using Cognos software for two