What do you think is the optimal organization structure for business intelligence and data warehousing for an organization?
 |
|
| |
|
Ask The Experts published in DMReview.com
December 13, 2004 |
| |
| |
By
Sid Adelman
|
|
|
|
|
Q: |
What do you think is the optimal organization structure for business intelligence and data warehousing for an organization? |
|
A: |
Sid Adelman's Answer: You still need a project manager responsible each of the 90 - 120 day projects. This project manager should have the following people reporting to him or her: - DBA for database design, backup and recovery, and performance monitoring and tuning.
- Data administration for data modeling and metadata administration.
- Data quality administrator for profiling the source data and dealing with data quality issues.
- ETL jockeys
- Query tool administrators to support the users and to administer the query and report library
|
...............................................................................
For more information on related topics visit the following related portals...
DW Administration, Mgmt., Performance and
DW Basics.
Sid Adelman is a principal in Sid Adelman & Associates, an organization specializing in planning and implementing data warehouses and in establishing effective data architectures and strategies. He jointly developed a methodology, MapXpert for Data Warehouse, that provides a master plan for implementing a data warehouse. Adelman is a regular speaker at The Data Warehouse Institute and IBM's DB2 and Data Warehouse Conference. He chairs the "Ask the Experts" column on DMReview.com and is a founding member of the Business Intelligence Alliance. Adelman is a frequent contributor to journals that focus on the data warehouse. He coauthored Data Warehouse Project Management with Larissa Moss and Impossible Data Warehouse Situations: Solutions from the Experts. He can be reached at (818) 783-9634 or sidadelman@aol.com. Visit his Web site at www.sidadelman.com.
| Solutions Marketplace
Provided by IndustryBrains
| | Bowne Global Solutions: Language Services
World's largest language services firm offers translation/localization, interpretation, and tech writing. With offices in 24 countries and more than 2,000 staff, we go beyond words with an in depth understanding of your business and target markets
| Award-Winning Database Administration Tools
Embarcadero Technologies Offers a Full Suite of Powerful Software Tools for Designing, Optimizing, Securing, Migrating, and Managing Enterprise Databases. Come See Why 97 of the Fortune 100 Depend on Embarcadero!
| Online Backup and Recovery for Business Servers
Fully managed online backup and recovery service for business servers. Backs up data to a secure offsite facility, making it immediately available for recovery 24x7x365. 30-day trial.
| Test Drive the Standard in Data Protection
Double-Take is more affordable than synchronous mirroring and enables you to recover from an outage more quickly than tape backup. Based upon the Northeast blackout and the west coast wild fires, can you afford to be without it?
| Help Desk Software Co-Winners HelpSTAR and Remedy
Help Desk Technology's HelpSTAR and BMC Remedy have been declared co-winners in Windows IT Pro Readers' Choice Awards for 2004. Discover proven help desk best practices right out of the box.
| | Click here to advertise in this space |
|
|
