joining the borg: creating the library cube (287912419)

8/20/2019 Joining the Borg: Creating the Library Cube (287912419)

http://slidepdf.com/reader/full/joining-the-borg-creating-the-library-cube-287912419 1/35

Joining the Borg: Creating the Library Cube

Dr. David Evans • Erik Bowe • Dr. Linda Golian-Lui



Joining the Borg: Creating the Library Cube

Kennesaw tate has atte!"ted to re"li#ated the Library Cube

initiated at the $niversity o% &ollongong 'Co( and Jantti). *he

Library Cube is based on a !ultidi!ensional data warehouse

that +oins library usage data and student de!ogra"hi# data and

students !arks.



What the Collective is doing

today• Case study of how Kennesaw Statereplicated the Library Cube atUniversity of Wollongong

• Our ongoing eorts at building ourunique data cube

• What software was used to developthe data cube

• Results and coparisons

• !uture eorts



"oining the #org$Creating the Library

CubeOr How I stopped

worrying and love the

Cube

Soe Coparisons

%he #org

%he Borg is de&nedas the collective

intelligencecoprising allebers lin'edtogether(

%he )ata Cube

%he data cube is a

three diensionalarray of values*coonly used todescribe a tie

series( %he array canbe lin'ed to otherdata arrays(



Collecting Reliable Data

Di%%i#ult to ,uanti%y how the library adds value to:

tudent rogression ate

tudent etention ate

tudent Graduation ate

Di%%i#ult to #olle#t reliable data

Di%%i#ult to validate the data we did have

Di%%i#ult to de!onstrate the intrinsi# value and the /0 o% the

library



KSU and S+SU +re,Consolidation

KSU:

• !ounded in -./0

• 1eadcount$ 23*4-0 5as of !all26-07 1 8raduate$ 2*-22

• !%9$ 22*.4-

• Carnegie Classi&cation$ 0, :ear +ublic* ;aster<sColleges and Universities5larger progras7

• 2-$- Student to !aculty Ratio

• Large suburb setting

• 3=> feale to 02> ale

SPSU:

• !ounded in -.0=

• 1eadcount$ /*4=/ 5as of !all26-07 1 8raduate$ =-3

• !%9$ 3*.?3

• Carnegie Classi&cation$ 0,:ear+ublic* ;aster<s Colleges andUniversities 5ediuprogras7

• 2-$- Student to !aculty Ratio• Sall city setting

• 2-> feale to 4.> ale

• S%9; focused



%he @ew KSU

• 1eadcount$ ??*23? 5as of !all 26-37 1 8raduate$ 2*402

• Coprehensive State University withlight research activity

• ;ulti,capus service environent*including four library facilities

• ApproBiately 36> feale and 36>ale

• "ust over 36> of progras are S%9;focused



"oining the #org$

Creating the Library CubeOr How I stopped worrying and love the Cube

Soe Coparisons

%he #org

%he )ata Cube



0nitial Library E%%orts



Library Data Cube



A Collective Waiting to be

Assiilated

• 1orace W( Sturgis Library at KSU utiliEes 9FproByfor authenticating and trac'ing access to onlineresourcesGdatabases by @et)

• 9FproBy logs contain &elds quintessential tocreating usage analytics and analyEing the HhiveI

• KSU aintains the log &les for up to ?6 days

• /6> of the students log into 9FproBy eachseester allowing for a variety of potential dataining initiatives 1 %his includes integrating 9FproBy log data using

ultiple data sources



1ow the #org #uilt the Cube

Step 1: ssi!ilation

• A data art in an Oracle database was builtto aintain the 9FproBy logs over tie

1 %he data art is part of a larger data warehouse• 9FproBy logs are loaded into the art

nightly using SAS )ata ntegration Studio 1 KSU utiliEes the SAS 9nterprise ntelligence

Suite for 1igher 9ducation 1 %his occurs after the 9FproBy daily log roll

1 )ata is appended for perforance reasons



9FproBy +rocess

,OCLC




Step ": #stablishing a Collective Conscience

• %he library data art is Joined to other datawarehouse tables with &elds containing student

deographic and progression data 1 KSU uses 9llucian #anner 9R+

1 %he @et) serves as the priary 'ey initially

• SAS OLA+ Cube Studio was used to de&ne

diensions* hierarchies* and easures 1 9Baples include institutional 8+A ranges andgrade distributions

1 %he cube is built at the end of the process



1ow the #org #uilt the Cube$ Understandingthe Cube

9F+roBy

Logs

Circulation

CardSwipe)ata

#anner

)ata




Step $: Con%uering the Universe

• %he SAS cube is then surfaced for end,userconsuption in SAS Web Report Studio

1 SAS WRS is a thin client web,based reporting tool 1 %hic' client SAS tools can also use the cube for

statistical analysis

• %rend analysis and assessents fro the

cubes data help support institutional andlibrary eectiveness 1 Use of data visualiEation tools li'e SAS isual

Analytics is possible



"oining the #org$


!indings$Use of 9lectronic Resources and Student +erforance

Wollongong 5UOW7

Kennesaw 5KSU7



&able "' (ibrary Usage by &er! )P andthe *u!ber o+ Students

#lectronic,esources

#lectronic,esources

University o+ .ollongong Kennesaw State University

/re%uency o+

Usage*o' o+

Students 0 .

/re%uency o+

UsageHeadcoun

t 0 &er! )P

no usage -*464 4(.> 3= -*036 406 0(-> M-(66

-,3 4*?-/ ??(.> /? 2*-/6 -*600 3(.> -(66,-(..

/,-6 0*63= -=(=> // ?*332 -*/3/ .(?> 2(66,2(0.

--,26 0*33/ 2-(-> /. 3*2=3 2*?=? -?(0> 2(36,2(..

2-,06 2*.2? -?(3> 4- --*?/6 0*.00 24(4> ?(66,?(0.

0-,=6 .2? 0(?> 4? -4*?3- 4*64? ?.(/> ?(36,0(66

=-,-/6 -22 6(/> 40

-/-,?26 4 6(6> 44



"oining the #org$


!indings

UOW

KSU



esistan#e is %utile: 4urther 5ssi!ilation

5t $/& 6alue ro"osition

engage!ent7 a##ess7 dis#overy7 and #olle#tion develo"!ent

5t K$ 6alue ro"osition

servi#es7 %a#ilities7 organi8ation7 and #olle#tions



esistan#e is %utile: 4urther 5ssi!ilation

4irst 9ear e("erien#e

rogression o% students

etention o% students

Graduation rates

&ithin degree "rogra!s usage

Between #olleges

Gender7 age7 and ra#e di%%eren#es

0nternational students

Low"oor usage

rogression %ro!



Further reading while waiting to be assimilated

• Return on Investment: Libraries and Student Retention by

E. 2. 2e8i#k

• ;Libraries need to be able to de!onstrate how e("enditures

%or resour#es and servi#es result in signi%i#ant #ontributions

to a#ade!i# and so#ial environ!ents that "ositively i!"a#t

institutional out#o!es su#h as student "ersisten#e.<

• ;*he strongest relationshi"s %ound were those between

student retention and total library e("enditures=<

• 0nvest!ent in the library leads to in#reases in student

retention.



• Academic Library Non/low Use and Undergraduate Student

Achievement: A preliminary report of research in progress

by D. Goodall and D. attern

• >onlow use de%ined as ?@ visits7 #he#king out ?@ books7

logging in to ele#troni# resour#es ?@ ti!es

• ;=the #orrelation with "rint and ele#troni# resour#e usage

is "resent and a""ears to re"eat over ti!e.<

• ;5lthough the a#tual library usage varies7 the gra"hs nearly

all show that students attaining lower grades !ade less use

o% the library than students rea#hing higher grades=<



2ust ead

Co(7 Brian. Aow Libraries hould 2anage Data: ra#ti#al

Guidan#e on Aow7 with !ini!u! resour#es7 to get the best

%ro! your data. Elsevier '0B>FHI)7 F.



•apturing !usiness Intelligence Re"uired for #argeted

$ar%eting& 'emonstrating (alue and 'riving )rocess

Improvement by B. L. Co( and 2. Jantti

•$sed Ero(y logs to esti!ate how long syste! users s"ent

sear#hing %or ele#troni# !aterials

•;=very strong nonlinear #orrelation between average usage o%

resour#es and average student !arks ' s,uared .).<

•;=only hal% o% one "er#ent o% the high users %ails '.IM)

whereas FM o% nonusers %ail.



o!e additional #onta#ts:

Dr. David Evans7 Dean and 56 Library ervi#esdevansNkennesaw.edu

Dr. Erik Bowe7 Dire#tor o% "e#ial ro+e#ts

eboweNkennesaw.edu

Dr. ob !ith7 56 %or 0nstitutional esear#h OChie% Data /%%i#er rs!itINkennesaw.edu

Dr. Linda Golian-Lui7 Dire#tor o% the turgis Library

lgolianNkennesaw.edu

2r. 2i#hael Luther7 5ssess!ent Librarian

!lutherFNkennesaw.edu

mailto:[email protected]








joining the borg: creating the library cube (287912419)

Documents