Posted on December 16th, 2010
For a company with fast growing data warehouse usage, at least these BW team members should be in place.
Data warehouse architect + Project Manager: who oversees the entire project with focus on architecture design, tools/patches/technology evaluation, system integration. Set overall team priorities on regular base.
BW functional analysts + Data modeler: who collect / translate business requirements, create data models in BW, work with SAP functional analysts to understand source systems data models/changes.
Report developers: who create user-friendly reports including Bex (excel format), web, mobile applications, and other form of “fancy” user interface.
BW Admin: who work with SAP Basis and DBA to setup and maintain BW systems; create roles, and authorization; schedule and monitor daily server activities, handle DB and SAP system performance issues.
Extractor developers: for different data sources, resources are needed to extract data. In most cases, it’s not a full time position.
For companies that use BW as (or as part of ) the Enterprise Data Warehouse / Enterprise Business Intelligence solution, these roles should be in place as well:
Enterprise Business Intelligence Officer: who create and reinforce the BI policy, oversees the information flow of all departments of the company, aligns BI objectives with the company objectives. This is not an IT staff, but need to have sufficient IT knowledge and take IT suggestions seriously.
Solution expert: who has good knowledge about all systems, provides end-users with alternative BI solutions to manual process, Foxpro, MS Access, etc.
Training and information sharing expert: training and information sharing are very important to the success of any BI initiative.
Data quality expert: who handles on-going testing and information cross-checking.
Enterprise Data Warehouse, SAP BW | No Comments »