< back

data quality services

With Hvantage’s Data Quality-as-a-Service (DQS), you benefit from the latest data quality techniques without having to hire resources or to invest in infrastructure. Our DQS ensures that all five components Data Quality are properly executed to result in high – quality data:

Completeness – Ensure the values are not missing
Consistency – Check if the data is consistent across various data stores
Accuracy – Check if the data matches the rules
Validity – Ensure that data being collected
Timeliness - does the data represent reality from the required point in time

We provide a seamless service, where we agree with you what data, needs which services applied to it; we carry out those services, and then you get the improved data back complete with detailed reports providing analysis and a list of anomalies.

Our Expertise

Data Migration Testing Services:

Data Warehouse implementation projects often fail to achieve the required benefits due to improper quality assurance strategy. Our ETL or Data Migration Testing ensures the data migrated from heterogeneous sources to the data warehouse occurs with no loss of information/ data, with strict adherence to transfer rules, in compliance with validity checks. We are the leading Data Migration testing company offering quality testing services to our clients.

The HVantage Differentiators:

Extensive experience with end to end data migration validation projects.
Customized approach to ensure data quality at various phases of the ETL process.
Highly skilled professionals in DW/BI for designing test strategy and project execution.
Cost-effective and flexible solution for your DW ETL testing needs.

Our Process

HVantage typically review documentation and interview key personnel to understand each requirement. This allows for the follow-on Design and Build phases to be defined with a high-level view of requirements.

Discover / Plan

Source data format from the original data source
Field mapping requirements
Basic data entry workflow

Design & Develope

Data creation – dummy data is created in the legacy system format
Data read, formatted and mapped
Duplicate record identification

Test

Formatting and mapping
Duplicate identification and data cleansing
Full end-to-end testing

Delivery / Deploy

Once testing is complete the migration utility is then deployed on the customer’s environment. Once the customer is satisfied that initial imports are migrated correctly full migration resumes.

Tableau Testing

Our comprehensive Tableau Testing services include:

Upgrade Testing: Compare pre- and post-upgrade workbooks/views across all environments
Migration Testing: Compare Tableau reports data against the legacy reports (OBIEE, Objects and Cognos).
View Testing:Baseline and compare PDF snapshots of views to identify visual as well as data differences
Performance Testing: Monitor dashboard and report performance periodically in the production environment.
Security Testing: Baseline and compare the access levels of Tableau Users/Groups.
Stress Testing: Simulate concurrent user loads and gather view performance statistics with varying user loads.
Functional Testing: Map and compare report data with data from SQL queries to validate the views.
1. Workbook Testing: Baseline and compare Workbook PDF snapshots to identify data and layout differences

PowerBI Testing

Hvantage’s specialized PowerBI testing services include a range of functional and non-functional testing at both PowerBI workspace and Desktop level. Power BI and SSRS reports are thoroughly validated, including report Data Accuracy Check, Drilldown Report Check, Graphical representations and downloading and testing the PDF versions of the reports in the most up-to-date and accurate way. We also offer the following testing services:

Security testing: Validate the access of Users/Groups.
Performance testing: Validating the performance of the reports applying various page level and report level filters.
View testing: Compare the data by downloading the PDF versions of the reports against the views
Migration testing: Compare data generated by PowerBI against the legacy databases at query levels.