Firstlogic, Inc, the recognized market leader in worldwide data quality solutions, introduced a new version of the company's IQ Insight data profiling and analysis solution that enables business users to more quickly inspect data and quantify quality problems.  Used in conjunction with Firstlogic's Information Quality Suite, the company's flagship data quality software, companies have a proven solution to establish, monitor and manage data quality initiatives that deliver measurable and consistent benefits to their organization.

"IQ Insight makes it simple for business users to perform complex data profiling tasks' something that traditionally required the involvement of critical IT resources," said Art Petty, Firstlogic vice president of marketing.  "Data quality is a business issue, not a technology issue and IQ Insight enables subject matter experts to identify precisely what data is defective, get an inventory of the actual 'bad' data, assess the potential impact of that data to the bottom line and, most importantly, provide quantifiable justification for a broader data improvement initiative," Petty said.

IQ Insight enables users to monitor, analyze and report on the quality of information -whether it's in a relational database or flat file, in an open system or mainframe environment. The latest version of IQ Insight can perform drill-down frequency distributions, cross-column and cross-table comparisons, pattern recognition and analysis to help organizations gain control of their information assets and get optimum return-on-investment (ROI) from critical enterprise applications. The practical applications for such data profiling capabilities are limitless.  For example, the software can be used to determine how many SKU numbers apply to a catalog that is no longer valid or what customers pose the most risk to insure.

IQ Insight's methodology provides a framework for developing self-contained and reusable data profiling projects comprising business rules, analysis, measurements, history and reports about a particular source. Those projects become dashboards through which data quality can be improved and the improvements measured over time.

"In order to gain a better understanding of enterprise data, many organizations are turning to data quality profiling as a way to achieve a 'snapshot' of data issues," said Joyce Norris-Montanari, senior vice president of Intelligent Solutions, Inc., a leading provider of data management consulting, education and products to government and business organizations throughout the world.  "Those data issues are causing problems in enterprise systems in the form of non-compliance with regulatory issues such as Sarbanes-Oxley, HIPAA, and the U.S. Patriot Act, as well as lost revenue and an increased cost of doing business," Norris-Montanari said.  "A data assessment, profiling and analysis solution such as Firstlogic's IQ Insight quickly brings real value to organizations seeking to jump-start the investigation of their data quality issues."

IQ Insight's data profiling capabilities enable users to gain a quick view of the structure of the source data as well as the data within each column. Key new data profiling capabilities in the latest release of IQ Insight include:

  • Heterogeneous Database Comparisons: IQ Insight can simultaneously view multiple disparate databases.  For example, it can display the tables and rows of an IBM DB2 database on UNIX and an SQL Server database on a Windows NT system.  This version of IQ Insight enables users to conduct reference table checks using different databases from different vendors.  This feature is very important to organizations with many disparate databases and platforms that need to compare data elements from multiple source systems.
  • Generic pattern detection: This feature enables users to identify generic string patterns, count their frequency of occurrence, and graphically plot their distributions.  Values beyond a user-specified threshold will be identified as domain outliers, and candidates for inspection.
  • Duplicate column analysis: Enables the user to select multiple columns to be compared against one other to determine the percentage of similarity between them.  This function serves many purposes, one being the identification of candidate foreign keys.
  •  Pattern recognition of personal names:  IQ Insight counts and displays every unique name pattern (such as "firstname," "lastname," "title") found in the target column.  The user will not need to specify a pattern to search for IQ Insight will tell the user all the patterns that exist in the field.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access