logo for information-management-architect.com
leftimage for information-management-architect.com

Business Intelligence Resources

Need to manage business intelligence resources and want practical standards and best practices for information management governance and accountability?

What are business intelligence (BI) resources?

Enterprise business intelligence (EBI) requires highly skilled specialistsBusiness Intelligence Resources with extensive experience in data warehouse design and development and with business intelligence analytics and reporting.

These resources include:
  • Business team resources i.e. the team responsible for understanding the data, and for using the solution;
  • Project team resources, i.e. all the specialized skills required to analyze, design, build, test and implement a business intelligence solution;
  • Production support staff, i.e. the IT operations team members responsible for operating the BI solution, maintaining software, responding to production and responding to production issues.
Business team members include:
  • Business data guardian e.g. the person accountable for
    • Establishing the data classification for information for which they are responsible;
    • Identifying the appropriate level of protection for that information; and 
    • For ensuring that the information is handled accordingly.
  • Data steward e.g. the person  accountable for managing data within a business area and is responsible for data requirements, standards, access rules, and business training;
  • End user team e.g. users who are involved with specifying BI requirements, defining requirements acceptance criteria, user acceptance testing, and with using the BI solution to achieve business objectives.
Project team business intelligence resources include:
  • Project manager e.g. the person with overall responsibility for project planning, obtaining appropriate resources and for status reporting to the sponsor and other external stakeholders;
  • Business intelligence architect e.g. the person with overall responsibility for architecture and design, development, testing and the technical quality pf all project deliverables;
  • Data modeler e.g. the person responsible for analyzing data requirement and documenting these requirements in the form of data models, creating data mart designs, and helping with business intelligence reporting tool data model considerations;
  • Data analyst e.g. the person responsible for analyzing source data quality and for developing source to target mapping documents (including data business transformation rules). Depending upon the nature of the project, data analysts may be responsible for data mapping from source systems to data warehouse structures and/or from data warehouse structures to data mart structures;
  • Business intelligence analyst e.g. the person responsible for analyzing analytical, reporting, and decision-making requirements and for documenting these in the requirements document. The business intelligence analyst frequently works quite closely with the data modeler and with the BI designer;
  • Database administrator (DBA) e.g. the person responsible for creating all development/test database environments and for building the development/test databases. A data base administrator may also be extensively involved in test data creation;
  • Data movement designer e.g. the person responsible for the overall design of the data movement (extract, transform and load) solution. This includes producing all design deliverables and for leading integration testing;
  • Data movement developer e.g. the person responsible for developing, and unit testing, extract, transform and load software;
  • BI reporting designer/developer e.g. the person responsible for developing, and unit testing, all BI reporting components. The BI designer frequently works closely with the BI Analyst, Data Modeler and end user
  • Quality assurance (QA) test lead e.g. the person responsible for quality assurance testing the entire solution to ensure that it is ready for user acceptance testing;
  • Quality assurance tester e.g. the person responsible for:
    • Creating QA test cases/test steps;
    • Documenting all test results; and 
    • Identifying QA test defects.
Production support team business intelligence resources include:
  • Release manager e.g. the person responsible for planning the release including release testing, directing the release test and for certifying that the release is production ready;
  • ETL and BI developers and operational experts who are responsible for on-going operations and software maintenance; and
  • Production database administrators, network administrators, etc who are responsible providing ongoing operational support as needed.
Summary...

Enterprise business intelligence (EBI) requires highly skilled business intelligence resources  with extensive experience in data warehouse design and development and with business intelligence analytics and reporting.


footer for Information management page