Dual Business Intelligence Architectures

Thinking about differing architectures for casual versus power users of business intelligence.  Having worked with executive information systems that needed to deal with this distinction, as well as the embodied ease of use issues, I found this quite interesting. Does the distinction need to be made at the architecture level?