Worksheet

ETL trace worksheet

A worksheet that follows a single invoice from left to right. Boxes show the source table and field, the extract method, each transform rule applied, the reporting table and column, and the dashboard figure it feeds. Below sits a run log grid with columns for start, finish, rows read, rows loaded, rows rejected and error text.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “What is ETL and how data reaches a dashboard from your software”, www.gullysystem.com/blog/what-is-etl-and-how-data-reaches-a-dashboard-from-your-software