Data Analyst guy

1 Comment

    • Will Data Integration Break Out of the Silo? [view article]
      The point you make is correct. Data overlaps across systems but it is organized and structured differently and over time, while the overlap continues, inconsistencies pop up. It is these inconsistencies that cause business heartburn. What data do I trust from which system and when do I trust it?

      The problem is that no one knows what the rules are that relate the common data across systems. In addition, the tools that the major vendors provide do a good job of moving data... only after you know those cross-system rules. Those same vendors provide data analysis tools. But those tools only analyze one data source at a time. That means that to figure out how two systems relate to each other, a data analyst has to do that work by hand. Since data structures are different, and data formats are different and the rules that relate data across systems can be complex, this work can take a long time, is not accurate and puts integration projects at risk before they event get off the ground.

      There is a new but small vendor, Exeros, whose product my company has purchased and they are the only company so far that does cross system data analysis and automates what we have previously had to do manually. The other integration vendors need to catch up to the Exeros functionality if our industry is going to be truly efficient at data integration.

      However, the critical issue you miss is that the ETL companies d       Apr 18 11:07 AM
Loading...
Symbols:
Authors:
Quick Links:
Contribute an Article Become a Seeking Alpha Contributor

Transcripts

More Transcripts»

Trading Center