Q: Our company provides reporting capabilities to its clients with different needs. What is a potential approach to provide these clients performance reports customized to their needs? The volume of data the company deals with overall is substantial. We currently provide "client data marts" when the data size dictates it; separating their data. This is usually driven by the performance of their reports. Is this a sensible approach?

It will depend on how much the data overlaps. If the data for each of your clients is totally independent of the data for your other clients, it makes sense to keep each client data mart separate. If the data does overlap, then the degree of overlap should help determine your solution. Security requirements could also drive you to keep the data separate, especially if you let the clients create their own queries and reports. If you charge back to the clients, you would also want to keep their data separate.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access