## Before
![[CleanShot 2025-04-04 at
[email protected]]]
- Data didn't flow in one direction (left to right)
- Data source provider can also be data consumer
## After
```mermaid
flowchart LR
subgraph Input
W[Weighbridge]
A[Accounts]
AP[AppSheet]
end
subgraph Storage
S[(SQL Server)]
end
subgraph Processing
D[dbt Data Modeling]
end
subgraph Output
M[Metabase]
end
W -->|Data| S
A -->|Data| S
AP -->|Data| S
S -->|Raw Data| D
D -->|Modeled Data| M
style W fill:#90CAF9,stroke:#1E88E5,stroke-width:2px
style A fill:#90CAF9,stroke:#1E88E5,stroke-width:2px
style AP fill:#90CAF9,stroke:#1E88E5,stroke-width:2px
style S fill:#A5D6A7,stroke:#43A047,stroke-width:2px
style D fill:#CE93D8,stroke:#8E24AA,stroke-width:2px
style M fill:#FFCC80,stroke:#FB8C00,stroke-width:2px
```
- Data flows in one direction (from left to right)
- Data producer != Data consumer
![[Data Engineering.png]]