David R., the chief business analyst for a medium-sized software company, walked into the office on Monday morning and greeted his staff with a smile and encouraging words. They had great numbers to round off Q3 and David was looking forward to sharing that exciting information at the shareholders’ meeting that afternoon.
But as he collected the Q3 report that he had generated from the printer, a notable inconsistency glared up at him.
Not today! David, thought. This error required fixing, which meant that he and his team would have to trace the data’s journey back to its source.
He quickly rounded up his team of analysts and they immediately began mapping the data lineage of the specific data point in order to determine where the inconsistency was made. David hoped that other data hadn’t been botched as well.
The head of BI knew that this process would take hours if not days, so he postponed the shareholders meeting, much to his dismay.
Why does it take so darn long?
Before automated data tools were introduced, whenever an inaccuracy was identified in a data set, BI teams had to manually trace the data or manually map out the entire enterprise data lineage. The goal was to discover and understand all of the processes that the particular data went through before it landed in a specific report. With data scattered across multiple systems, this was an error-prone, very time consuming and therefore costly process.
Once the business data lineage was mapped out for them, the BI team would then analyze which database tables and ETL (extract, transform, and load) processes were involved in and affected by the specific inaccuracy.
A visual mapping tool, also called a data lineage tool, is needed to create full lineage of the data journey as it flows through multiple systems to assist in the data context to continually improve the management process.
Automated business data lineage tools speed things up!
Data lineage tools, such as Octopai, work automatically to easily and quickly map out the entire business data lineage with a detailed visual map to show the BI team where each calculation was made in each system leading up to the current report. On one screen this tool shows all objects – such as processes and tables – related to the calculation instances throughout the entire landscape. With this easily accessible information, changes can be implemented accurately, in a fraction of the time.
Now, when David encounters an error in his reports, he or another business analyst can quickly locate where and why the mistake was made, and easily correct it, by utilizing Octopai’s automated data lineage system. Within moments, he sees the entire journey that the data took before it ended up in his report, so he can spot the mistake and ensure the accuracy of his entire report. David feels a renewed sense of confidence ahead of Q4 now that he is using Octopai.
Octopai’s automated data mapping tool enables the BI group to not only locate data instantly, but to see everything about their data from where it originated to any changes it underwent to where it is headed. It truly couldn’t be easier. And the best part of all: This data mapping software will help you become GDPR compliant.