I really enjoyed watching this video. Why? I love the concept of Self Service BI. But you need to have business critical data maintained at one single place (Single Source of Truth).
Microsoft Analysis Services Part 1: The Tabular Model and Why You Need It!
ERP and BI 