Suppose an organization wants to implement "self-service BI" on a large data set for a wide variety of users, e.g., financial, research, and marketing professionals in, say, the healthcare space (i.e., where the users are not techies, but use Excel, probably on minimal laptops). Each user wants to see a specific set of data, and have regular groups of dimensions (like, custom-built hospital or procedure groups) saved and accessible, against which they may do reporting.
Are PowerPivot and PowerView really going to provide that self-service BI solution for them? Anyone with experience in that problem space want to comment? Thanks.