Optimizing data retrial with dax and power bi

Hello. I'm loving power pivot. I'm trying to see where IT fits in this world. A couple questions: 1) IT currently is a bottleneck in the sense that they are creating a bunch of SQL and crystal repo...