Overview

Background

Currently there is a gap in producing requirements for Business Intelligence deliverables - it is technical requirements rather than business requirements that are currently driving the endeavour. This impacts the existing BI/MI service, and will impact a proposed Enterprise Data Warehouse in the future.

This project will provide a BI/MI Analysis Toolkit which we expect to consist of a set of templates, guidelines and any associated explanatory material that will describe how Business Analysis should be conducted in the Business Intelligence/ Management Information field and in future for the EDW. This will allow any future business driven project that wishes to adopt, or change, an element of BI/MI solution can do so with a full understanding of the business information required.

The BI/MI Analysis Toolkit will be used by Business Analysts in conjunction with end users (such as Management Information analysts, Management Information consumers, Business Managers, Users of operational systems etc.) and other stakeholders and the resulting analysis output will be used as input into the design phase, typically conducted by MI application designers and information architects.

 

Scope

  • Recruitment of a consultant with BI/MI business analysis expertise
  • Creation of a BI/MI Analysis Toolkit by consultant BI/MI analyst. The contents of the BI/MI Analysis Toolkit will be defined as part of the analysis but will likely consist of:
    • A set of templates that will enable us to capture business requirements:
      • for new BI items such as reports, dashboards, "universes" or other data sources
      • for changes to BI items such as reports, dashboards, "universes" or other data sources
      • for new data items in the proposed EDW
      • for changes to data items in the proposed EDW
      • The templates should be able to make users understand the impact of their change and should be agnostic about the technology used by end-users
    • Accompanying guidelines
    • Associated explanatory material that describes how Business Analysis should be conducted in the EDW/BI/MI field, and what is expected as outputs.  
    • The BI/MI Analysis Toolkit should ensure that BAs are aware of the basics of BI/MI (including time-bound trend reporting, near-actual-time MI, dashboards, data discovery, how to define a KPI and so on)
    • The BI/MI Analysis Toolkit should include awareness of what is possible with current end-user BI technology and prototyping as this will feed back into both how BI/MI is delivered and EDW design.
  • Review of the BI/MI Analysis Toolkit by appropriate stakeholders
  • Delivery of the BI/MI Analysis Toolkit which will form part of the overarching BI/MI Projects toolkit

 

Objectives & Deliverables

The deliverables are prioritised using the MoSCoW prioritisation method:

M=Must Have; S=Should Have; C=Could Have; W=Want

  • (M= has to be satisfied for the final solution to be acceptable in terms of delivery dates, compliance, viability etc.
  • S= high-priority requirement that should be included if possible -workarounds may be available
  • C= a nice-to-have requirement
  • W= want but will not be part of this project)

 

Objectives and Deliverables

Priority

MoSCoW

Owner

O1 To create a BI/MI Analysis Toolkit by the end of July 2017

M

 

D1. Definition on the contents and format of the BI/MI Analysis toolkit

M

Consultant BI/MI Analyst

D2. Creation of a BI/MI Analysis toolkit

M

Consultant BI/MI Analyst

D3. Review of the BI/MI Analysis toolkit by appropriate stakeholders

M

Project Manager

O2 To deliver the templates into the BI/MI Analysis Toolkit which will form part of the overarching BI/MI Projects toolkit

M

 

D1. Decision on the format of the delivery

M

Service Management

D2. BI/MI Analysis Toolkit delivered into overarching BI/MI Projects toolkit

S

Service Management

Benefits

The benefits from this project will be:

Benefit 

Owner

Recipient(s) 

Measure/Value

The BI/MI Analysis Toolkit will enable future business driven BI/MI change projects to deliver best and more consistent results.

 

Service Management /Project Services

Any activity that results in the creation and/or the modification of BI/MI solutions

Hard to quantify but the use of the BI/MI Analysis Toolkit should provide requirements based on business needs and not technical requirements leading to more meaningful reporting throughout the University

Success Criteria

  • The provision of a BI/MI Analysis Toolkit reviewed by UoE and signed off by both consultant and UoE

Project Milestones

Planning

26 Jun 17

 

BI/MI Analysis Toolkit created and reviewed

4 Aug 17

 

Delivery of BI/MI Analysis Toolkit into overarching BI/MI Projects toolkit

15 Aug 17

 

Delivery Review

22 Aug 17

1 week only between delivery and delivery review as no technical implementation

Close

29 Aug 17

 

Project Info

Project
BI/MI Analysis Toolkit
Code
DTI019
Programme
Digital Transformation - Enterprise Data Warehouse
Management Office
ISG PMO
Project Manager
Sue Woodger
Project Sponsor
Andrew McFarlane
Current Stage
Close
Status
Closed
Project Classification
Grow
Start Date
01-May-2017
Planning Date
26-Jun-2018
Delivery Date
25-Jul-2018
Close Date
31-Aug-2018
Overall Priority
Normal
Category
Discretionary