My org has only OLTP, we are pulling data from it directly to powerbi and building facts and dims in semantic model. Now my org is thinking about creating datamarts for each department since there are so many requests for adhoc reports and proposed to do…