Tricentis logo blue 1000px square
Data management

BI and Data Warehouse Testing: Identifying Data Integrity Issues at Every DWH Phase

Provided by Tricentis

Category Data management

Type White Paper

Publish Date May 28 2020


Data integrity can be compromised at all DWH/BI phases: when data is created, integrated, moved, or transformed. However, testing of data warehouses is usually deferred until late in the cycle. If testing is shortchanged (e.g., due to schedule overruns or limited resource availability), there’s a high risk that critical data integrity issues may slip through the verification efforts. Even if thorough testing is performed, it’s difficult and costly to address any data integrity issues exposed by this late-cycle testing.

Download this paper to explore strategies and best practices for catching data integrity issues as early as possible—to reduce the resources required to address them and ensure that data integrity issues don’t compromise the accuracy of the data that business leaders rely on. You’ll learn ways to identify quality issues in:

  • Data warehouse design
  • Data sources
  • Each ETL phase
  • Staging and loads to the data warehouse
  • BI reports

Recommended for You

New report: Lockdown and the IT department

Kathryn Cave looks at the big trends in global tech

How CIOs manage cloud lock-in

Mark Chillingworth on IT leadership

How assistive technologies are transforming the lives of disabled people

Nic Fearn on the technology that aims to drive positive change in the world

Our Case Studies

IDG Connect delivers full creative solutions to meet all your demand generation needs. These cover the full scope of options, from customized content and lead delivery through to fully integrated campaigns.


Our Research

Our in-house analyst and editorial team create a range of insights for the global B2B technology community. These look at the latest IT trends and other zeitgeist topics.



Do you think your smartphone is making you a workaholic?