1 / 14

Business Intelligence [09] Deploying, Supporting, and Expanding DW / BI System

Business Intelligence [09] Deploying, Supporting, and Expanding DW / BI System. EBUSS 27 October 2009. Content. Pre-deployment testing Deployment Documentation Training Maintenance and support Managing existing environment Reaching out and managing up Measuring and marketing success

marcin
Download Presentation

Business Intelligence [09] Deploying, Supporting, and Expanding DW / BI System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Business Intelligence[09] Deploying, Supporting, and Expanding DW/BI System EBUSS 27 October 2009

  2. Content • Pre-deployment testing • Deployment • Documentation • Training • Maintenance and support • Managing existing environment • Reaching out and managing up • Measuring and marketing success • Preparation for growth and evolution • Assessing environment • Prioritizing opportunities • Managing iterative growth

  3. Pre-deployment testing • Testing procedures • Data quality assurance testing • Operations process testing • Performance testing • Usability testing • Deployment testing • User desktop readiness

  4. Deployment • Relational database deployment • ETL deployment • OLAP database deployment • Report deployment

  5. Documentation • Core documentation • Business process dimensional model descriptions • Table and column descriptions • Report descriptions • Additional documentation

  6. Training • User training • Design and approach • Desktop training materials • Create a training database • Plan for the level of effort

  7. Maintenance and support • Manage the front room • Provide user support • Website, Power users, DW/BI team • Maintain the BI portal • Manage security • Monitor usage • Report on usage

  8. Maintenance and support • Manage the back room • Support data reconciliation • Execute and monitor the ETL system • Monitor resources • Manage disk space • Tune for performance • Backup and recovery • Long term archiving

  9. Manage existing environment • Reach business users • Manage up • Visionary leadership • Enterprise focus • Budget authority or the ability to affect funding decisions • Committee membership from both IT and business

  10. Manage existing environment • Measure and market your success • Evaluate ROI • Improved business user productivity • Reduced burden and cost on transaction systems • Improved business decisions • Improved operations • Monitor success and service metrics • Proactively market the data warehouse

  11. Manage existing environment • Communicate constantly • Business sponsors and drivers • Business users • General community • IT management • Data warehouse team updates

  12. Prepare for growth and evolution • Asses your current environment • Prioritize opportunities for growth • Prioritize minor enhancements • Prioritize major initiatives

  13. Prepare for growth and evolution • Manage iterative growth • Project planning and management • Business requirements definition • Technical architecture strategy and infrastructure • Dimensional modeling • ETL • Application design and development • Deployment planning, education and support

  14. Conclusion • Measure program success • Track program success • Communicate program success

More Related