At Ultra, we generally advocate for transforming ERP and other organizational data into Star Schema Data Marts, and using those data marts as the input to Business Intelligence (BI) software suites. There are other valid approaches such as using the live ERP data (or a copy of it) as input to the BI tool (lower [...]