Category: Data Normalisation

Is your data dirty?

A credible cloud billing solution must be able to provide insightful breakdowns of charges. In addition to per-customer reports it should be possible to ‘slice and dice’ data at deeper levels such that the total spend can be dynamically visualised using arbitrary combinations of criteria such as business unit, region, project and resource group to name only a few.

Ultimately this process is completely dependent on the initial data imported into the system. The phrase “garbage in, garbage out” is particularly apposite when generating financial reports. However with the right tools, knowledge and techniques it may be surprising what can be accomplished with data that would otherwise be difficult or impossible to report against.

Here at Exivity we use the term dirty data to describe information that is not well-formed, which is inconsistent or has holes in it. Typically, dirty data is interleaved within well-formed data and as such needs to be identified and dealt with as it occurs.

Continue reading

Delivering Billing & Reporting Solutions for Hybrid IT Environments. On-Premise and in the Cloud.


Contact Us

Kabelweg 21
1014 BA
The Netherlands