Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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
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
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