Top

Octopai

Stop Struggling with Mismatched or Inaccurate Reports

A business user discovered inaccurate information on yearly revenue reports and loses precious time to business waiting for the BI group to respond.

Innacurate or Mismatched Reports

The Business Challenge

A business user discovered inaccurate information on yearly revenue reports and loses precious time to business waiting for the BI group to respond.

The BI Challenge

To reduce the amount of time and resources required to locate the source of the inaccurate reports and correct the problem, while maintaining accuracy.

How BI Worked Before Octopai

In order to identify the source of the problem, BI groups had to manually trace the data to discover and understand all the hops that the data went through to land in a specific report. They had to
analyze which database tables and ETL processes were involved in and affected by the particular inaccuracy and correlate the metadata to other reports that were affected – a very expensive, error-prone and time-consuming process.

Octopai Data Lineage Screenshot

Octopai’s simple user interface compares reports (either from the same or from different systems), and clearly illustrates any differences between, enabling users to understand exactly how they ended up different.

 

In this example, Octopai has identified an additional ETL process (the blue circles) and DB table (the red circles) in the report (the green circle) on the bottom of the screen that is missing in the report on the top. This is exactly where the two reports began to deviate.

BI Groups are Empowered by Octopai Automation

Octopai enables visibility and control of metadata, helping BI groups to:

• Discover all related ETL processes and tables used to produce a report, with one click
• Compare multiple reports to show specific metadata items, as seen in the image above
• Fix the problem much faster with all metadata centralized in one place
• The search is simple, accurate and effective

Value to the Organization

• Cut the metadata search and tracing cost by more than 50%
• Faster time-to-market than initially estimated
• Zero business disruptions or production issues when fixing the problem

Schedule a Demo

Contact Us

Blog Posts