Identifying the appropriate skills to design and develop a data warehouse solution requires experience. Resources applied to the project often bring a mix of those skills, and it is not uncommon to expect a single resource to play multiple roles on a project. If the roles are generally chronological in sequence such as a Business Analyst and Report Developer, a single resource can be expected to manage the workload tied to both of the roles.

But often a resource is challenged with multiple roles where the tasks, activities and deliverables are simultaneous, such as a Project Manager and Data Modeler, or Business Analyst and Data Architect. The biggest challenge in such situations is that the resource becomes a bottleneck. The pressure to complete multiple deliverables on such a multi-role resource inevitably leads to either incomplete, delayed or poor quality deliverables.

A few tips to help resources playing multiple roles are below:

  • Clearly define the deliverables for each role
  • Identify critical path deliverables and emphasize timely delivery of the same
  • Establish deliverable management standards up-front (naming conventions, standard templates, version control, change control, directory structure)
  • Establish multiple interim reviews of "work-in progress" deliverables to quickly detect and restore deliverables going off-track
  • Pro-actively manage activities not contributing directly

    Requires Free Membership to View

  • to deliverables. E.g.: In a corporate culture where meetings are called frequently, reduce the time spent in meetings and avoid non-essential meetings by using short phone conversations, finding substitutes or delegating meetings to other resources

For more information, check out searchCRM's Best Web Links on Data Warehousing.

This was first published in February 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.