Data Profiling and Discovery

Designed primarily for Data Architects, Data Analysts & Auditors, Pandora Data Profiling & Discovery provides a single, consolidated view of all enterprise data. It allows the evaluation and measurement of data content, structure, relationships, and quality, and allows unlimited speed-of-thought browsing and navigation through data and metadata on all data-dependent projects. Pandora allows Auditors to carry out enterprise-wide ad-hoc internal audit and counter-fraud investigations by allowing them to interactively follow the inherent relationships in the data.

Data Integration

Data Governance

Pandora Data Integration provides unique functionality to Data Architects and Analysts for use on all data integration tasks (data migration, system implementation or consolidation, DWH feeds, etc. ), allowing them to go from raw source data through to an automatically generated, 100% objectively validated implementation-ready data-mapping specification.

Pandora allows the interactive specification and execution of data movement, transformation, cleansing and business rules (filter, transform, join, sort, group, sum, count, etc,) immediately showing the results on-screen. Users can rigorously validate their specifications by analysing the data which results from the application of their rules.

The same output data is used to validate the data integration implementation and for early trials of target applications.

Pandora Data Governance permits Data Stewards to define and organise a full Glossary of business terms, allowing them to associate the terms in various ways with each other and with the actual data already analysed by Profiling and Discovery.

Pandora Data Governance also allows the specification and execution of data quality assessment and improvement rules. Because it keeps a full history of all data and associated analyses over time, rules can even be applied retroactively to previously analysed data.

Data quality is objectively measured, trends analysed and issues addressed. Results are leveraged by Pandora Data Integration to produce specifications for corrective work, and in some cases provide actual corrected and cleansed data.