iCorrelate—An ad hoc query tool for unlike any other for fast "time-to-answer."

Perform ad hoc queries and reporting across all of your data, with blazing speed

Sophisticated users, like data miners and business analysts, will be amazed at the capabilities of iCorrelate. This ad hoc query tool is unique, just like the data warehouse or data mart it accesses. A genuine data warehouse exploration and ad hoc query tool, it fully exploits the speed and flexibility of iLuminate. Its graphical user-interface means iCorrelate is intuitive and, despite the complex queries it handles, surprisingly easy to learn.

iCorrelate finally gives people the power to quickly analyze large and complex datasets without launching the ever-frustrating, seemingly never-ending, back-and-forth special IT projects to get to an answer. People can build ad hoc queries based upon the results of the previous query—incrementally getting to the answer they're looking for. And performance is never compromised. For the first time, people can do train-of-thought analysis on large datasets that include all possible correlations. Just think of it.

iCorrelate ad hoc query tool opens up analysis possibilities:

Ad hoc n-dimensional analysis

• Dynamically create a new analysis set (or data mart) with n dimensions and see the results immediately—no need to design or build a cube-like structure;
• Display results in table format and graphical visualization;
• Save results and export into different reporting tools (MS Excel, other databases, etc.); and
• Display 3D graphics for visualization of multivariable analysis.

Information navigation

• Auto-navigate through your information model; and
• Navigation operators available in query definition.

Train-of-thought analysis

• Do true ad hoc analysis—query anything, any time and any way;
• Perform Incremental queries for train-of-thought ad hoc queries and easy data navigation;
• Run ad hoc queries and reporting on detail data;
• Save and share queries with other users;
• Save, show and use query results as new tables; and
• Save queries as stored procedures to use by any ODBC-compliant tool.

"Clustering" (grouping)

• Group individuals, companies, products or other entities by any variable value;
• Group objects by similar or comparable values in the analyzed variable; and
• Group objects by values in related records without restructuring.