Data Warehouse Testing Services
Data warehouse testing comprises ETL, BI, performance, and security testing types. Since 2005, ScienceSoft’s DWH testing ensures the proper functioning of BI apps, high DWH performance, corporate data security, and ETL processes’ working in line with corresponding business rules.
Data Warehouse Testing: What We Test?
We run comprehensive data warehouse testing to ensure that your DWH powers insightful business decisions. DWH testing with ScienceSoft includes:
To fit your needs best, we offer two cooperation models:
Complete DWH testing
Under this model, we perform an all-embracing check of your data warehouse and test ETL, DWH performance and security, as well as reports and dashboards.
Targeted DWH testing
Under this model, our team tests a certain aspect or aspects (for example, we run only ETL testing). We can also test a certain sub-aspect separately (OLAP, role-based access, etc.)
DWH Testing with ScienceSoft: Testing Process
Studying project requirements
Our testing team studies your DWH project requirements. Driven by our ISO 27001-certified quality management system, our QA specialists will help you improve the requirements, in case they are vague or incomplete.
You will get: DWH project requirements are reviewed and enhanced (if needed).
Test planning and test design
This stage consists of:
- Drafting a test plan. The test lead drafts a detailed test plan for you to review and approve.
- Test design. The testing team writes test cases/checklists according to the test plan and unites them into a test case document that comprehensively covers your data warehouse testing.
- Prep measures. Our testing team sets up a well-balanced strategy with an optimal mix of manual and automated testing and prepares test data sets to suit your DWH testing best.
You will get: the test plan, the test case document, adequate test data for DWH testing are created and approved.
Relying on the test case document and the test plan, our testing team tests your data warehouse using the prepared test data and test environment. Your business data security is guaranteed by our ISO 27001 certification.
You will get: updatable test suites and bug reports.
Result analysis and accountability
The testing team provides a test summary report describing the testing results and the overall DWH quality.
You will get: test summary report on your DWH quality.
Challenges We Solve
Huge amounts of data and data variety. To meet this challenge, our DWH testing engineers thoroughly select data samples to create quality test data. They also run performance testing to make sure large amounts of data don’t slow down the query execution time.
Time-dependent data meaning is changing as time goes. Our testing experts will prepare representative data samples covering the necessary period (2+ years) and load them to the test environment. Besides, time-dependent data is continually changing, for example, when current date changes from Aug/31 to Sep/1, current and previous months change. To solve this problem, our testing specialists regularly add new test data to test a particular feature of your DWH adequately.
Endless variations in OLAP. OLAP allows applying various filters, dimensions and measures, which creates a multitude of scenarios to be tested. To manage the testing process efficiently, our testing engineers draft a traceability matrix, which shows the test coverage for each dimension and measure and helps prevent under-testing.
Business specificity. Testing some DWH components (OLAP cubes and reporting) requires business understanding. Our testing engineers apply professional knowledge in 10+ domains, including retail, healthcare, banking and financial services, manufacturing, and more, to ensure that your solution is fully functional.