Use Case: Master Table vs Pipeline?

I am new to Pipelines and also new to Master Tables and would like community guidance: Use Case: We have a complex Project Management Tracking System built in QuickBase.   (400 projects, 150 users...