

|
|
|
Good Housekeeping is the essence of Quality data where Excellance is a moving target and 'good houskeeping' is a continuous improvement and a maintenance process.
Data Governance and Report Maintenance Engineering are top down key dual processes of due-diligence data integrity testing and recording where-by management,
auditors ... can be assured that reporting data processes
for decision making are Quality (Effective with effiencies) Assured.
Several RDBMS
and multidimenasional Fact & Dimension CUBE processes including data and metadata churn issues can cause data corruption and interpretations
including Application Miss-fires during intertable updating, new client & server versions installation & alignment, ... , Data Entry dyslexia and distortions, ... , Network and Server Ghostings, ... .
Quality Technical Documentation and data validation continuously maintained can provide a Pre-Compliance data posture.
This PC can qualify the Business Effective Technology efficiencies of the reporting linkage.
Data Goverance Pre-Compliance may include:
- Business Client|Server Application Structural Approval (UAT) for the latest Application version
- Each Report Owner's responsibiliy for the data and information of the report - PDR, Personal Data Responsibilities
- IT working with 'Report Owners' to ensure Quality as data and metadata churn
- Being able 'on demand' to constantly check Data Entry for ERRORS - Data Valadation Devices
- Savings - Some testing can take up considerable higher priority time for a Business Tester. A Business set of Data Valadation Device Dashboard test scripts can focus on specific differences
needing attention vs searching through whole record sets. DVD time savings also through Data Comparative Analyst Dashboards and Versioning Approvals, UAT.
- At least three views (Triangulation) of data as a minimum to best show any data issues.
- The Report Owner (looking at the big numbers & aggregates) KNOWS when the data is RIGHT.
- Detailed documentation of metadata processes along with meaningful CheckDigits can demonstrate that what is being published in a report is correct.
- Good design fundaments {settings, In Line documentation, …}
- Good RDBMS Database Concepts
- Pedantry - a basic positive skill of Senior Management - the Numbers MUST be checked and be RIGHT.
AGG provides On-Call Report Maintenance Engineering Services.
Quotation contact 0419 877 776
|