The University is dedicated to creating a data warehouse programme that consists of an enabling structure that helps the University get the right information to the right people at the right time.
The EDW will hold data from disparate business administration systems and external data sources. Data will be linked and enriched to provide analytics and insight that was previously not possible, or was time-consuming to create. Data will conform to enterprise definitions established through data governance policies and procedures. Data will be held securely in compliance with Information Security Policy. Data will be designed to meet the BI/MI needs of our business partners.
By establishing a business engagement model that places emphasis on communication, governance, processes and technology, we will deliver an EDW that is sustainable, extensible and provides value to our business partners. The model will enable effective business collaboration and prioritisation on cross-functional data needs and ensure secure and authorised access to data, as well as the provision of analytics on usage.
By providing the cross-functional, multi-level governance structure that supports the data warehousing from the inception of the data warehouse project, the data warehouse governance structure will play a key role in the data warehouses ability to meet business needs and to adapt to organisational change.
The approach focuses on first building a foundation, then subsequent tasks will detail business processes that will inform data model and architecture design. Combined with creating governance bodies and policies.
Using this approach places emphasis on governance as well as technology and the organisations data warehouse environment becomes more sustainable, extensible, and capable of providing critical value to the business users.
The business engagement project is responsible for; building a business engagement model that supports current and future data acquisitions. Providing a communication strategy and plan that targets the most appropriate key stakeholders. A governance Strategy that is accountable for data project acquisitions . A data migration strategy that defines the way data will be migrated to the data warehouse.
Effective governance is a key to data warehousing success. EDW Business Engagement brings together key stakeholders at an early stage to address key business requirements and ensure EDW success. It will maximise utilisation of the EDW through better business - IT alignment, engagement and communication. It will reduce the level of business unit customisation. It creates a mandate for implementing policies and procedures to ensure the fulfilment of the data warehouse vision and mission. It creates a formal decision-making structure for data warehouse approval. It provides a two-way mechanism for communicating (reporting structure and communication plan) about data warehouse initiatives across the organisation. It creates formal procedures for liaising with the business and technical groups for data warehouse projects.
- Defines a well formed strong business acquisition pipeline
- Improves the ability to acquire data to populate the EDW
- A business operating model that supports data acquisitions over the next three years
- Data warehouse development projects are consistently defined and well understood across the university
Analysis of Resource Usage:
Staff Usage Estimate: 100 days
Staff Usage Actual: 72 days
Staff Usage Variance: 32%
Objectives & Deliverables
Design a communication strategy and plan that strengthens strategic alignment between EDW and the Universities data goals, objectives and vision. This alignment translates into a mandate intended to enhance the way EDW enables the business and also targets both the existing data acquisitions to populate the data warehouse and future data acquisition.
Produce a communication strategy that supports EDW
|D1.2||Collect communication content covering background, objective, purpose and goals that support the vision for an EDW to be used in stakeholder communications.||M||Achieved|
|D1.3||Identify key stakeholders groups that will support initial data acquisition targets in the development and implementation of the EDW.||M||Achieved|
|D1.4||Define metrics for communication success criteria – e.g. business demand, acquisition pipeline candidates, conversions to EDW from other datamarts, Decommissioned Datamarts||M||Achieved|
|02||Produce the communications plan and approach that defines stakeholder groups, communication objectives, communication engagement method, communication channels and activities together with a plan for implementing, delivering and managing the communications strategy.|
|D2.1||Produce a communication plan covering the scope and details of the data warehouse project targeting key stakeholder groups to gain buy-in to the EDW proposal.||M||Achieved|
|D2.2||Produce a communications schedule for stakeholder and other interested parties to build cross University engagement in EDW. Approach to include key delivery channels.||M||Achieved|
|O3||Deliver Communications Plan|
|D3.1||Execute the communications plan across priority data acquisition areas. The communications plan will only be partially delivered within the scope of the project. The intention is that the communication plan will be picked up and continued as part of a Service Management BAU process.|
Design and implement an EDW governance strategy and agile consolidated project framework and lifecycle processes, based on best practices and performance measurement, that is used across the university leading to; An EDW that is secure, populated accurately and responsively and delivers value to our business partner. Data Acquisition and Change Management processes to effectively prioritise and deliver the data needs of our business partners.
|D4.1||Produce a operating model and processes that facilitates data warehouse governance and business - IT engagement e.g. Steering Group and Data governance forums.||M||Achieved|
|D4.2||Document formal procedures for liaising with business and technical groups for data warehouse projects. Build organisation, structures and processes to support EDW as a ongoing business activity.||M||Achieved|
|D4.3||Create the EDW governance model processes that supports EDW foundation building and subsequent data acquisition project delivery as ongoing business activity.||M||Achieved|
|O5||Build an effective stakeholder engagement model to manage business collaboration and prioritisation on cross-functional data needs including a business requirements gathering process.|
|D5.1||Build a process that gathers business requirements for foundation project and subsequent data acquisition projects enabling EDW population.||M||Achieved|
|D5.2||Build an initial pipeline view of data acquisitions from existing data consumers that permits gap analysis of initial EDW candidate data.||M||Achieved|
|D5.3||Establish a Front Door process that supports new data acquisition business case assessments including a clearing house supporting approval / rejection for changes and subsequent EDW data acquisitions. This to serve as a ongoing operating model to support future EDW data acquisitions.||S||Achieved|
|O6||Define a data migration strategy|
|D6.1||Produce data migration strategy options paper for target data acquisitions.||M||Achieved|
|D6.2||Define the options for migrating existing data and BI/MI solutions to the EDW.||M||Achieved|
|D6.3||Produce costed and recommended approach(s) for data migrations.||S|
The project deliverables are located here. Only available to Service Management and authorised Wiki users.
Explanation for variance
The original estimate of 100 days to complete the tasks had been high as It was difficult to predict the level of effort and the number of resources required whilst assessing the current warehouse environment. Additionally, less work was required to establish the stakeholder community and to produce the communications strategy and plan. Time recording for a number of people did not materialise on Asta and this lead to actual effort recorded being less than the estimate. 72 days were recorded to complete the deliverables.
The use of the outputs from the deliverables must now be driven forward including;
- Governance structure and operating model implementation
- EDW follow-on project team to support business unit acquisition to be formalised to resource and maintain data acquisitions
- Funding arrangement to support data acquisition to be confirmed
Additionally, there has to be ongoing and regular communications with customers to manage the pipeline of demand and maintain the business value in using the EDW.
These outstanding points are currently being driven forward by Service Management and the Programme Owner.