Business Intelligence and Data Warehouse Testing

LegiTest allows you to test all your Business Intelligence and Data Warehouse projects. Quickly and easily test SQL Databases, SSIS packages, SSRS reports and SSAS cubes.

Business Intelligence Testing

When you are building a Business Intelligence system, you want to test more than just the database. LegiTest helps you fully implement Business Intelligence testing across the entire Microsoft BI stack. Build an SSIS package test to ensure your ETL meets your requirements. Validate the measures in your SSAS cubes to balance to your data warehouse, as well as validate that your SSRS reports are showing the right totals. LegiTest brings the ability to put all your tests into a common framework and get a true picture of the readiness of your BI solutions.

Data Warehouse Testing

LegiTest can build data warehouse tests to make sure that the data in your data warehouse is correct. Use the wizards to build automated tests to validate that the numbers in your data warehouse match the numbers in your source system. You can also build data warehouse unit tests to validate the stored procedures and other query logic that might show in a report.