Power BI vs. data warehouse

[ammartino44]

Hello. I had a couple of questions about powerpivot vs. data warehouse. Could someone give me some insight?

Advantages of Powerpivot vs. Data Warehouse tool?

Advantages of Data Warehouse tool vs. Powerpivot?

How can Power complement a Data warehouse tool?

Should you have everyone using Powerpivot? 

[v-haibl-msft · Accepted solution]

@ammartino44

For your above questions, I think you can read through following articles and the blog mentioned by BhaveshPatel. You may find the answers in them.

http://info.110consulting.com/blog/bid/374825/Top-10-Benefits-of-Using-Excel-PowerPivot

http://bi-insider.com/portfolio/benefits-of-a-data-warehouse/

Best Regards,

Herbert

[BhaveshPatel]

Hi There,

For more detailed discussion on this topic, You should visit this blog by Jen Ynderwood. However, PowerBI is moving forward in its journey to the truly Entreprise Scale BI but personally speaking, it is not a suitable  tool for the data warehouse due to no. of reasons and more are discussed in this blog post.

http://sqlmag.com/blog/does-excel-power-pivot-replace-data-warehouse