Menu

Need advise

#azure#redditazure#oltp#building#semantic
Reading 0:00
15s threshold

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 it in traditional way like creating new star schema based data marts and using azure etl tools to pull data from oltp but Im not familiar in building them so i proposed fabric since everything comes in fabric and they can use copilot to build their adhoc reports based on semantic model

These are my questions

  1. Which way is better, answer it assuming i have only theoretical knowledge not practical experience
  2. Which one is cheaper and why
  3. Which is more easier
  4. Tell me anything if im missing

Thanks

submitted by /u/TrackTolly
[link] [comments]