Big Data Testing

Big Data testing

Big Data Testing

In today’s data driven world the volume, velocity, and variety of data has exceeded the capabilities to function effectively on typical database architectures. The accurate storage and reporting of data is critical to the operational success of any organization.

Facing Big Data & Reporting Challenge?

  • Overwhelmed by Reporting, and missing Intelligence?
  • Reporting slow and needing a tune up?
  • Spending too much time emailing, cutting and pasting reports?
  • Tired of laborious repetitive data entry process and need automation?
  • Need guidance migrating to the cloud?
  • SOX Audit headaches tracking reporting changes?

We can help!!

  • Data Quality Analysis
  • Data Standardization Procedure Development, Implementation, and Maintenance
  • Full Life Cycle Data Quality Testing (Test Planning, Test Case Development, Test Execution, and Testing Metrics for Continuous Quality Improvement)
  • Big Data & Business Intelligence Architecture support (Data Architecture Schema, Source to Target Mapping, Data Dictionaries, ETL/Deployment/Security Procedures, etc.)
  • Business Intelligence Reporting Verification & Validation
  • Cognos Subject Matter Expertise
  • Automated ETL Testing
  • Data Integration Testing
CASE STUDY 1:

    Financial analysis of student lifetime value

    • Problem:
      • Ran a report 225 different ways (10 minute run) and manually pasted output into Excel for further analysis. Took one person 2 solid weeks.
    • Solution:
      • Created Cube for fast data aggregate
      • authored new report to use new Cube
      • Created 225 views reflecting prompt permutations
      • Connected to Excel w/ Cognos for Office
    • Result:
      • 5 Minutes to refresh report views to prep for import to Excel
      • 3 Minutes to refresh excel

 

CASE STUDY 2:

5 Accountants to run reports for account reconciliation

  • Problem
    • Accountants had to control click literally 100’s of account numbers on report prompt
    • Solution:
      • First Step: Taught them to use views and set prompts once
      • Second longer term: Set up process that managers maintained account numbers, Report Prompt leverage these ‘groups’
    • Result:
      • Need less accounts