Power Pivot vs. Data Warehouse tool RRS feed

  • Question

  • Hello. I was telling an IT manager the capabilities of what power pivot can do and he said that is exactly what the data warehouse tool can do. A couple of questions. What is the difference between a data warehouse and a data warehouse tool (Pentaho in our case). Our data warehouse is very summary level, can you get down to the granular level with a data warehouse tool. I love the flexibility of building whatever I want in power pivot. I've heard that power pivot is complementary to a data warehouse tool but currently I feel like power pivot is much superior. 

    Friday, September 30, 2016 11:04 AM