Hi Georgina
Thanks for your considered response to this which I - for one - found
very useful.
Durham ran a pilot DW project three years ago now and was totally sold
on the benefits. We have been holding off for various technical
reasons which I won't bore you with here but much of what you wrote
resonates with our experiences too. We will begin Implementation of a
full DW in august 2011 having spent a long time sorting out a whole
range of data issues identified during the pilot.
As to your question about making your business case. Our Registrar
recently conducted a major exercise to identify the main barriers to
implemting our new Strategy. She visited every academic dept to talk
to the admin staff. The main conclusion coming out of that exercise
was that we have as many duplicate student or finance systems as we
have depts (despite having a very good student record system in
Banner). Consequently, her top recomendation to our Exec is that in
order to reduce duplication and cut costs we need to invest in IT
systems which are fit for purpose and which provide excellent
management information. I'm sure she'd be happy to share the
conclusions of that extensive bit of internal research with you if you
thought it would help your case. Give me a call or email me if you
want to pursue this.
Steve
Steve Chadwick
Director of Satrategic Planning & Change
University if Durham
Office +44(0)1013346885
Home +44(0)1388871966
Sent from my iPhone
On 11 Feb 2010, at 05:15 PM, "Georgina Spary" <[log in to unmask]>
wrote:
> Hi Jennifer & all
>
> Rebecca Mander passed this email on to me, and I thought I'd let you
> know where we're at and also ask the group a related question.
>
> I joined Brookes in 2009 with the task of developing a data mart
> plus university wide reporting tool to support our MI for the
> strategic plan (a subset of our KPIs around students). I started
> small with a a static prototype based on one source only. I would
> recommend the prototype route because it allows you to take the time
> needed to define the fields properly, sorting out user requirements
> and getting a complete and robust set of requirements and ETL
> definitions before you invest in external expertise. The prototype
> was delivered in Nov 2009 and we're now in the middle of an ITT to
> find a supplier who can
> a) turn this into a 'live' data warehouse with data validation,
> automated refresh, slowly changing dimensions etc., using industry
> recognised ETL tools like BODI, OWB
> b) provide a universally acceptable (!!!) reporting tool, again
> we've played it safe, major players (OBIEE, SAP BO, Cognos) only
>
> We are also considering an interim stage: buying just the reporting
> software, and polishing up the prototype so that it's at least auto
> refreshed. ie we would omit the super duper time trend data
> warehousing development, and just have something up and running.
> Bearable in the short term and much much cheaper. It would not be
> futureproof in the long term as we bring in lots systems, but should
> be a cheap way to start bringing some of the core systems together
> in the first year.
>
> So. First - my attempts to answer your questions
> a) What products do you use? --- see above, procurement not yet
> completed
>
> b) What solutions have proven most cost effective? - well a staged
> approach starting small has worked for us (sort of). Every other
> person I've talked to who has got the full implementation to work
> from scratch has spent £100-250K up front + lots ongoing. I do see t
> hat your top priority is to bring several systems together (this is
> our long term priority too) - but I would start getting the thing wo
> rking just from one system. Also, using a contractor for us was much
> better value for money than a consultancy - but maybe we were just
> lucky.
> In the long term, to have a robust workable system from many
> sources, you should definitely go the full data warehousing route,
> but you can get quite far in selling in the idea with something less
> formal.
>
> c) Have there been many non-technical issues to resolve? -- some
> absolutely key things to get in place, which I have picked up over
> the years (iused to be a data mart project manager in the private
> sector):
> --- commitment at the highest level, an evangelistic VC sorts the
> whole project
> --- internal technical resource - 2 seems to be the minimum although
> possibly can work with 1 FTE, ongoing
> --- internal business resource - a BI reporting team, strong user
> representation
> --- this one's important - get all the requirements &definitions
> really pinned down to technical detail, as far as you can - this is
> where many projects fall over because they usually need the busiest
> people in the organisation to agree them, and no amount of time
> spent by IT or external people can replace this.
> --- I know lots of people have had issues with reporting tool
> licensing structures, may not be relevant for you.
>
> d) What would you do differently next time?
> Um. Demand £250K up front? alternatively write a persuasive business
> case to ensure sufficient in house IT resourcing for the project.
>
> *****************Which leads me to my question to the
> group:************************
> -- I need to write a persuasive business case justifying additional
> resource in a difficult climate, by demonstrating the direct
> financial benefits of a Business Intelligence system. Any of you
> people with existing well established systems have any thoughts and/
> or examples on their benefits you could share, at the highest level?
> Anything at all would be appreciated, however vague. and anonymised
> of course.
>
> Thanks - hope the above helps you as well
>
> Georgina
> --
>
>
> Georgina Spary
> Business Intelligence Manager
> SBPO, Corporate Affairs
> Oxford Brookes University
> + 1865 484887
>
>
> -------- Original Message --------
> Subject: [Fwd: Re: Reporting from multiple systems]
> Date: Mon, 25 Jan 2010 17:49:21 +0000
> From: Rebecca Mander <[log in to unmask]>
> Organisation: Oxford Brookes University
> To: Spary Georgina <[log in to unmask]>
>
>
>
> -------- Original Message --------
> Subject: Re: Reporting from multiple systems
> Date: Thu, 21 Jan 2010 12:53:29 +0000
> From: Andrea Cheshire <[log in to unmask]>
> Reply-To: Academic, financial or space planning in UK universities <[log in to unmask]
> >
> To: [log in to unmask]
> References: <[log in to unmask]
> >
>
>
>
> Dear Jennifer
>
>
>
> We have invested in a data warehouse at UWE and have operated the
> system over the last 2 years. Currently the warehouse holds data
> from our student record and finance systems but we are expanding to
> bring in admissions data. The warehouse has opened up completely new
> avenues for business analyses which single systems can never
> provide . Although it is quite an investment, it is paying off in
> terms of efficiency and effectiveness of analysis and reporting. We
> are currently using it to drive performance improvements across the
> institution.
>
>
>
> As the reporting front end we have chosen Business Objects, although
> there is very little difference to other systems like Cognos.
>
>
>
> The key factor of success of our project was the quality of the data
> warehouse design. You really need to get this right, as it
> determines the avenues for future analysis. We used consultants as
> we don’t have the knowledge in house. However we ensured significant
> know how transfer in the first project and are now confident to do
> more ourselves.
>
>
>
> The biggest non technical issue is the review of the quality of your
> data. We have spent months cleaning our records and are still
> picking up issues. But this is to be expected and I have had similar
> feedback from other institutions that went down the warehouse route.
>
>
>
> We are happy to give more in depths informaton if this is helpful.
>
>
>
> Best wishes
>
> Andrea
>
>
>
> Andrea Cheshire
>
> Director Business Intelligence and Planning
>
> University of the West of England Bristol
>
> [log in to unmask]
>
>
>
>
>
>
>
> *From:* Academic, financial or space planning in UK universities
> [mailto:[log in to unmask]] *On Behalf Of *Arkell J.H.
> *Sent:* 21 January 2010 12:10
> *To:* [log in to unmask]
> *Subject:* Reporting from multiple systems
>
>
>
>
>
> Dear all,
>
>
>
> Here at Southampton, we're looking to improve our reporting from
> multiple corporate systems (rather than the single system reporting
> which makes up the majority of information at the moment).
>
>
>
> I would welcome experience and advice from institutions who have
> been down this route already on issues such as
>
>
>
> What products do you use?
>
> What solutions have proven most cost effective?
> Have there been many non-technical issues to resolve?
>
> What would you do differently next time?
>
>
>
> We don't have a data warehouse system at the moment, and I would be
> particularly interested in institutions who have found interim
> solutions to this problem without investing in a data warehouse.
>
>
>
> Jennifer
>
>
>
> ________________
>
> Jennifer Arkell
>
> Corporate Planning Manager
>
> University of Southampton
>
> www.soton.ac.uk
>
>
>
> 023 80594447
>
> (internal 24447)
|