Architecting a Supply Chain Control Tower (~20 sources, 6-tier ETA fallback, PO+Colour granularity) – Need advice on Star Schema vs PQ Staging to fix 10-min refresh
I am rebuilding an enterprise Supply Chain Control Tower in Power BI that tracks ~20 different files (Master data, PO booking platform, 6 ETA feeds, Warehouse receipt logs). I'm facing a major modeling dilemma: I need…