• Overview
• InsightBI
  • Insight Dashboard
  • Insight Reports
  • Insight Analysis Server
  • Insight Incident Manager
  • Microsoft Adapters
• MetricsMart
  • ProcessMart
• Insight Studio
• Insight Personal Edition
• Comparison Chart
• List Prices

MetricsMart

The most challenging, time-intensive, and resource-intensive aspect of most BI implementations is data integration. Data integration is essential not only because it involves identifying and acquiring the right data to calculate the metrics that business requires, but also because data integration architecture will largely determine the efficiency and performance of the entire BI solution once it is delivered.

Unfortunately, most data integration projects involve a difficult tradeoff. The lower the data latency required, the greater the query load placed on operational systems. In 95% of cases, organizations choose high (24 hour+) data latency, and generally end up writing large amounts of custom code to automate the integration processes. In fact, approximately 75% of data warehouse development involves custom coded data integration.

At Altosoft, we do data integration differently.

Our MetricsMart solution fundamentally changes the way any company approaches the problem of data aggregation. Instead of writing volumes of ETL scripting and SQL to first centralize all data into a data warehouse or mart, and then following this up with more coding, scripting, and/or SQL to derive KPIs from this raw data, MetricsMart delivers the final KPI metrics in a single step – with ZERO coding. The result is that all KPIs are processed and stored in a third party repository (generally SQL Server or Oracle) as fully dimensioned tables that can be easily accessed by Insight’s web services interface or directly via any other off the shelf SQL reporting or analysis tools. Thanks to MetricsMart’s highly-graphical, intuitive UI, we can integrate data from multiple data sources and calculate and store multiple KPIs often in as little as a few hours.

MetricsMart makes data integration flexible and response to the needs of business users. It enables dynamic latency selection, so that metrics are delivered to business users when they need them, rather than at the whim of some batch refresh cycle. It can handle real-time environments. And it’s easy to configure and maintain. Rather than requiring custom code or scripting, it’s 100% codeless.

Click to zoom: View an interactive diagram showing how MetricsMart works

MetricsMart is different because:

• Rather than moving mass amounts of data in batch to a data warehouse, MetricsMart intelligently moves the data needed to deliver the KPIs your business needs. This approach, called Intelligent Data Aggregation (IDA), makes MetricsMart extremely efficient.
• MetricsMart generates pre-calculated, on-demand KPIs. That means that you tell it when you need a particular KPI, and it will deliver the calculated values of that KPI into a database or warehouse for you automatically.
• MetricsMart is business process aware. MetricsMart’s optional process state engine, ProcessMart, tracks every business process and enables you to view process performance and process quality.
• MetricsMart uses high performance in-memory processing to perform the most complex, time-consuming calculation, such as outer joins. That means low latency data and minimal query load on source systems.
• MetricsMart is easy to use. It’s configured using the Insight Studio tool. No code or script is required.
• MetricsMart will work with any data source. RDBMSs, warehouses, flat files, Excel, events, proprietary formats – you name it.