Optimizing data retrial with dax and power bi

[ammartino44]

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 reports. How does this change with Power Pivot? I'm trying to figure out what to ask them for in terms of SQL queries and how that whole process works.

2) Can a data warehouse tool eventually offer the same thing as power pivot in terms of granular access that allows for the building of metrics and "angles" on the fly?

[MattAllington]

http://powerpivotforum.com.au/viewtopic.php?f=6&t=500

[ammartino44]

Just trying to get various takes 🙂 Yours is certainly esteemed...