Dylan’s BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Key Roles involved in a BI Data Warehouse Project

Posted by Dylan Wan on November 30, 2007

To develop or deploy a BI solution for your organizations, you need to have the right people involved in the time time. Here are typical roles involved in a BI data warehouse project.

  • Project Sponsor
  • Project Manager
  • Functional Analyst
  • SME
  • BI Architect
  • ETL Developers
  • DBA

The job description and responsibilities are listed in this table:

Job Role Description Responsibilities
Project Sponsor The project sponsor is normally an executive from the company, such as CIO, CFO, Controller.
  • Represent the data warehouse project to the upper management.
  • Authorize the resources to the project
  • Represent the client when the project is outsourced to the external consulting firm.
Project Manager The project manager is responsible for the project planning and tracking the overall project status. If the project is outsourced to the consulting firm. The project manager is typically from the external company.
  • Develop and Update the project plan
  • Held the periodic project meetings
  • Track progress
  • Track Issue
  • Report the project status to sponsor
Functional Analyst The functional analyst analyze the requirements and define the metrics, reports, and dashboards. The functional analyst should translate the business requirements to the technical specifications.
  • Gather requirements from users
  • Create the business requirement document
Subject Matter Expert (SME) The SME is typically from the deploying company. The SME is usually the end-user who represents the departmens or business function and can explain the business process and information requirements. The SME works as part time in the project, but are essential in the requirement gathering and user acceptance testing.
  • Describe the business requirement and business process to the functional analyst
  • End User Acceptence Testing
  • Provide feedback to the report and dashboard design
  • May be the trainer in their own departments
BI Architect The BI Architect is familar with dimensional modeling and the BI tools. BI architect defines the star schema and the metrics. BI architect typically comes from the specialized BI consulting firm.
  • Design the logical model with the inputs from the functional analyst
  • Develop the BI meta data in the repository
  • Define the Physical to Business Model Mapping
ETL Developers The ETL developer in charge of the programs which extract the data from source OLTP applications and populate the data warehouse. The ETL developer should be familiar with the ETL tool such as Oracle Data Integrator or Informatica, or the programming language used to perform the ETL jobs. The ETL developer typically from the external consulting firm.
  • Design and develop the ETL program
  • Perform the testing
DBA The DBA or system adminsitratoris from the deploying company to support the BI data warehouse deployment. DBA works with the BI architect and ETL developer on performance tuning.
  • Create and maintain the database
  • Provide the backup and recovery support to the development as well as on-ong environment
About these ads

5 Responses to “Key Roles involved in a BI Data Warehouse Project”

  1. […] The job description and responsibilities are listed in this table: Read the rest of this entry >> […]

  2. web hosting…

    […]Key Roles involved in a BI Data Warehouse Project « Dylan’s BI Study Notes[…]…

  3. best totally freewebsite hosting…

    […]Key Roles involved in a BI Data Warehouse Project « Dylan’s BI Study Notes[…]…

  4. pc said

    pc…

    […]Key Roles involved in a BI Data Warehouse Project « Dylan’s BI Study Notes[…]…

  5. project manager jobs…

    […]Key Roles involved in a BI Data Warehouse Project « Dylan’s BI Study Notes[…]…

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 38 other followers

%d bloggers like this: