Wednesday, December 14, 2011

To Enable Business Intelligence Across the Enterprise and using Data Stewardship


What you need to understand:



  • The user perspective

  • Data stewardship

  • Program governance

  • User support

  • Public relations

The User Perspective:


User Roles and Responsibilities:




  1. Attending training before receiving an ID to BI



  2. Browsing the technical and business metadata for information on data sourcing and data definitions



  3. Providing feedback to the BI build team


Data Stewardship Program



  1. “One” per major business subject area in BI

  2. Or prospectively in the future in BI
Business role


Data Steward Roles and Responsibilities




  1. Designing the transformation rules



  2. Contributing business metadata



  3. Understanding new usage needs



  4. Supporting the user community



  5. Data quality


Who determines the transformation rules that determine the look of business intelligence data?




  • Business intelligence ETL architect



  • Business intelligence data modeler



  • Data stewards from the business



  • Data stewards from information technology



  • Business Subject matter experts or the system analysts or solution architect


BI Program Governance


Interest in major additions of usage, subject areas and data sources should be catered by this committee if any of:


Perceived ROI is used as a driver for company efforts and therefore a forum is needed to confirm and refine these estimates


Limited budget or people resources


Expansion of data and data uses may strain the scalability of the environment



BI Program Governance Team


Management in data steward areas to Present and future data stewardship areas


User Support Plan


24 X 7 rotation: immediate response/ Per SLA defined


ETL, DBA, system administration functions


Escalation plans for non-response


Key vendors: DBMS, ETL, Data Access


Business hours on-call: data stewards


BI Public Relations Program




  1. Branding name



  2. Culture understands BI is center for corporate data



  3. Common elevator knowledge intra-and inter-team and users



  4. Subject-area orientation


Public Relations


User e-mail/voicemail lists


Outage notifications


Planned and actual enhancements


Improve the capture and clearing of BI requirements


Common Knowledge Repository:


Data model


Q&A forums


No comments:

Post a Comment