Source system analysis and profiling
Any enterprise will have a myriad of systems containing all kinds of data – from old mainframe systems to Excel spreadsheets. We need this data to provide the answers to the questions you pose. But not all data is equal - some is good and some is dubious. We ensure that you understand your data’s nuances allowing you to build the right solutions in the most efficient way.
We conduct a controlled assessment of the actual data your organisation holds - how it is structured and what properties it holds.
As part of this data profiling we use tools to identify data quality issues and capture metadata. We map data to understand the information held in the system and identify business rules for handling the data. We build prototypes to validate rules and confirm operations.
In short, we make sure that the data is fit for purpose.
It is all too easy to over analyse. We are driven by your business goals – concentrating on your core need. Aspective keeps source system profiling short, succinct and focussed - without cutting corners.
When a high street bank said to us that they didn’t know where data was coming from and what had been done to it, we knew they had a problem. Without knowing what recalculations it had been subjected to, how could they trust it? By building a system that showed where data came from, what recalculations it underwent and the reports that used it, discrepancies were flagged and data could be cleaned. The outcome was a single, trusted data source that is used for all reporting, whether board level, regulatory or operational reports.