As data-loving businesses amass more and more bits and bytes, the credibility of derived results — as showcased in BI dashboards, KPIs, reports, and sundry other deliverables flowing downstream of the ETL spigot — trends further out into dangerous territory.
Nothing reminds the data analyst of this tenuous balance like the CFO asking him where he got his numbers. “These numbers look off,” the CFO barks, glaring up from the preliminary 10-Q. “Where the hell did they come from?” Because he knows “the data warehouse” is not an acceptable answer, the analyst understands that a painful reconstruction of all the relevant ETL jobs is in his future.
Author: Alex Woodie