Testmethods & Validation-Algorithms

BiG EVAL provides you with unlimited possibilities to test, validate and plausibilize your data.

Probes exactly equal

Compare an infinite amount of probes out of your systems.

E.g. Is the revenue of a specific product equal between the ERP, the CRM and the Data Warehouse? Even within an OLAP Cube.

Probes approximately equal

Perform plausibility checks on your data with a fuzzy approximation logic.

E.g. Does the monthly revenue of a product lie between +/- 2% of the previous months revenue?

Probes not equal

Does your systems have disparate KPI values?

Query Performance

Make a performance measurement for systems and database queries. Ensure that performance requirements get met every time. And let BiG EVAL send you a message when they appears to be a problem to respond proactively.

Schema Drift

Monitor the schema of a database to be informed about schema changes. Do not miss any changes anymore. e.g. datatype changes, field-name changes, adding or removing any tables etc.

Validation Logic in Database Queries

When the preconfigured testmethods are not enough, you can build your own just by using the query language of your database systems (MSSQL, Oracle, Teradata etc.).

Validation Logic in C#

And if that’s still not enough you can use C# as a scripting language. This opens much more possibilities than you can imagine.

  • Execute a test multiple times. So you just have to build a test once and execute it with different parameters. e.g. you execute it for every sales-region and every product and so on.
  • Take your test-parameters out of a database and apply them to testmethods.
  • etc.
Thomas BoltTestmethods