March 12, 2007 Alliance 2007 Conference Orlando, Florida Your - - PowerPoint PPT Presentation

▶
march 12 2007
SMART_READER_LITE
LIVE PREVIEW

March 12, 2007 Alliance 2007 Conference Orlando, Florida Your - - PowerPoint PPT Presentation

Jul 28, 2023 136 likes •438 views

A new Generation of Reporting for Campus Solutions! University of Cambridge and Phytorion in partnership Session #23442 March 12, 2007 Alliance 2007 Conference Orlando, Florida Your Presenter Hugh Barnes Strategic Programme Manager

slide-1
SLIDE 1

A new Generation of Reporting for Campus Solutions! University of Cambridge and Phytorion in partnership

Session #23442 March 12, 2007

Alliance 2007 Conference Orlando, Florida

slide-2
SLIDE 2

2

Your Presenter

Hugh Barnes Strategic Programme Manager Management Information Services Division University of Cambridge

slide-3
SLIDE 3

3

Overview

  • The challenges we faced on upgrade from 8 to

8.9

  • The partnership we formed with Phytorion.
slide-4
SLIDE 4

4

What shall we talk about?

  • Background to our reporting need
  • History of what we had done in v8.0
  • The challenge of v8.9 and the drivers to

re-implement

  • Specifically, the Phytorion project
slide-5
SLIDE 5

5

What we won’t talk about

  • Not an introduction to data modelling
  • Not a Master class in Cognos
  • Costs
slide-6
SLIDE 6

6

The University of Cambridge: Ancient…..

slide-7
SLIDE 7

7

The University of Cambridge: ….. and Modern

slide-8
SLIDE 8

8

The University of Cambridge: ….. A major tourist attraction

slide-9
SLIDE 9

9

The CamSIS Project was the first UK implementation of Campus Solutions. Now in our third year of live running with all modules after a 2 year implementation Project.

The CamSIS Project

slide-10
SLIDE 10

10

Reporting Background

  • Our reporting need
  • Our v8.0 solution
  • The challenge of v8.9
slide-11
SLIDE 11

11

Partner Choice

  • Why partner?
  • Finding the right partner
  • Partnership philosophy
  • The pitfalls!
slide-12
SLIDE 12

12

The Phytorion Project

  • Preparation
  • Investigation
  • Review and prioritisation
  • Design
  • Build
  • Transfer of ownership
  • Operational running
slide-13
SLIDE 13

13

Preparation

  • Consider ‘genuine’ reporting need
  • Think in terms of business cycle
  • Think about security!
  • Sell the idea of ‘day old data’
slide-14
SLIDE 14

14

Investigation

  • Identify tables that contain that data
  • Identify columns within the tables.
  • Identify data upon which security should

be based

slide-15
SLIDE 15

15

Review and prioritisation

  • Review to prioritise the build process
  • What areas are already well supported?
  • What areas may change in the near

future?

  • Agree a program of work with your

Partner

slide-16
SLIDE 16

16

Design

  • Design will have a direct effect on

performance

  • Design is a skill in its own right
slide-17
SLIDE 17

17

An introduction to star schemas

“The star schema is the simplest data warehouse schema, consisting of a single ‘fact table’, with one segment for each ‘dimension’ and with additional columns

  • f additive, numeric facts”

(source: wikipedia)

slide-18
SLIDE 18

18

An introduction to star schemas

“a dimension table contains attributes or (fields) used to constrain and group data when performing data warehousing queries” “a fact table consists of the measurements, metrics or facts of a business process”

(source: wikipedia)

slide-19
SLIDE 19

19

An introduction to star schemas

Put them together….

slide-20
SLIDE 20

20

Build

  • Not necessarily an everyday skill of a

programmer or DBA

  • Validation of datamart contents
  • What to do with bad data?
slide-21
SLIDE 21

21

Build process design

C:\Documents and Settings\hb10001\Desktop\Datamart creation route.vsd

slide-22
SLIDE 22

22

Transfer of ownership

  • Vital if working with a partner.
  • The build is now ours
  • Documentation:
  • Facts
  • Dimensions
  • Star schema designs
  • Source tables and columns
  • Usage matrix
slide-23
SLIDE 23

23

Documentation

C:\Documents and Settings\hb10001\Desktop\Committee Membership Fact.docm C:\Documents and Settings\hb10001\Desktop\Committee Dimension.doc C:\Documents and Settings\hb10001\Desktop\Campus Community.vsd C:\Documents and Settings\hb10001\Desktop\Cambridge SDM Builds.xls C:\Documents and Settings\hb10001\Desktop\Fact and Dim Xref.xls

slide-24
SLIDE 24

24

Operational running

  • Define your own standards
  • Procedures to deal with bad data
  • Complete re-build or iterative updates?
slide-25
SLIDE 25

25

Roundup

What are the important things?

  • Distinguish between a datamart creation and the

delivery of an ad hoc reporting system

  • Identifying need
  • Good design is key to efficiency
  • Partner choice makes all the difference
  • Communicative, Collaborative, not Contractual
  • 23 Star schemas in 9 weeks speaks for itself
slide-26
SLIDE 26

26

Choice of Partner

slide-27
SLIDE 27

27

Questions?

slide-28
SLIDE 28

28

Contact

Hugh Barnes Strategic Programme Manager Management Information Services University of Cambridge E-mail: hb10001@cam.ac.uk

slide-29
SLIDE 29

This presentation and all Alliance 2007 presentations are available for download from the Conference Site

Presentations from previous meetings are also available