Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Structured Anal...  Best way to graph/draw an ETL data flow
Previous Previous
 
Next Next
New Post 1/17/2014 11:08 AM
User is offline blasto
1 posts
No Ranking


Best way to graph/draw an ETL data flow 
Modified By Chris Adams  on 1/21/2014 12:37:51 PM)

 I am re-posting this stackoverflow question on behalf of a poster -http://stackoverflow.com/questions/21193833/best-way-to-graph-an-etl-data-flow 

I found the following Version 1 in one of our detailed design documents. If I were going to create it, I would have probably displayed it as shown in Version 2

However, I'm thinking that there probably is a more common standard way of showing the flow of data by programs acting on it and that, while I prefer version 2, it probably is unnconventional and non-standard.

In Version 1, programs are shown as boxes. In Version 2, programs are depicted as arrows indicating that they are moving data from one table to another.

Q: What is the better more accepted way? Sequence Diagrams? If Sequence Diagrams were used, I think it wouldn't show the flow of data from one table to the next as well...

Version 1:

 

Version 2:

 

 
New Post 2/28/2014 2:12 PM
User is offline A
1 posts
No Ranking


Re: Best way to graph/draw an ETL data flow 

This has been up for a while, but I'll take a swing at it.  Years ago when I did ETL work (Business Objects, SSIS), we would model our flows before working them up.  Your flows certainly work, but one suggestion I might make is to differentiate the process flow from the data flow.  The goal is to make sure people (especially those who come after you to maintain the job!) can understand and follow the diagram.  I simplified your items and didn't model the EAST process flow, but you'll figure out what you want to do.

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Structured Anal...  Best way to graph/draw an ETL data flow

Community Blog - Latest Posts

Dan Tasker
Dan Tasker
  In Part 1 of this series it was stated that the overall objective of these articles is to improve the quality of requirements produced by business analysts. Following the adage that “Context is Everything” it established that a number of different contexts...
4 Responses
Alice Bolingeryn
Alice Bolingeryn
Clearly, the most important step in getting a job is being selected for an interview, and a key part in that process is having a resume that stands out from others.   For many people, creating a good enough resume is an obstacle in achieving this, and so one way to address this problem may be to get a professional to create one for you. J...
0 Responses
Arash
Arash
It may sound routine, but the importance of operational decisions cannot be underestimated. After all, not a day goes by without even the smallest business making dozens, if not hundreds of operational decisions that may affect the bottom line. Elevate these to large scale companies and we are talking thousands, if not millions of actions that impa...
0 Responses




Latest Articles

Three Modes of Business Analysis Consulting
Jun 16, 2019
0 Comments
A business analysis consultant might perform three types of roles when working with clients: expert, pair-of-hands, and collaborator. Each of these re...
Copyright 2006-2019 by Modern Analyst Media LLC