Stuart Cousins itle Pre se nte rs Na me a lm.a xie ll.c o m How - - PowerPoint PPT Presentation

▶
stuart cousins
SMART_READER_LITE
LIVE PREVIEW

Stuart Cousins itle Pre se nte rs Na me a lm.a xie ll.c o m How - - PowerPoint PPT Presentation

Oct 01, 2023 99 likes •509 views

Axie ll Sta tistic s E ve rything Yo u Alwa ys Wa nte d to K no w Ab o ut Sta ts* Stua rt Co usins (*But We re Afra id to Ask) a lm.a xie ll.c o m a lm.a xie ll.c o m Pre se nta tio n T Stuart Cousins itle Pre se nte rs Na me a lm.a

slide-1
SLIDE 1

a lm.a xie ll.c o m

Pre se nta tio n T itle Pre se nte rs Na me

a lm.a xie ll.c o m

a lm.a xie ll.c o m

Stuart Cousins

Axie ll Stua rt Co usins

Sta tistic s

E ve rything Yo u Alwa ys Wa nte d to K no w Ab o ut Sta ts* (*But We re Afra id to Ask)

slide-2
SLIDE 2
slide-3
SLIDE 3
  • Ha ve use d the Sta tistic s mo dule ?
  • Ha ve o pe ne d the Sta tistic s mo dule ?
  • K

ne w the mo dule e xiste d b e fo re this use r c o nfe re nc e ?

How Many E Mu User s . . .

slide-4
SLIDE 4
  • Are re q uire d to pro duc e re g ula r (da ily,

we e kly, mo nthly, q ua rte rly, ye a rly) re po rts tha t re q uire se a rc hing E Mu?

  • E

njo y pro duc ing tho se re po rts?

How many people . . .

slide-5
SLIDE 5
  • Co mple x
  • Re pe titive
  • Po te ntia l fo r e rro r
  • Ne e d fo r c o nsiste nc y

T he never ending joys of r epor ting . . .

slide-6
SLIDE 6

Gar bage In, Gar bage Out

slide-7
SLIDE 7

Wo rst o f a ll, ma na g e me nt re po rts c a n b e e xtra o rdina rily time c o nsuming

slide-8
SLIDE 8
slide-9
SLIDE 9

“End of Month Collection Digitisation Stats at Item Level”

a s do c ume nte d in . . .

A r eal wor ld example . . .

slide-10
SLIDE 10
  • Re da c te d instruc tio ns c o ve r

twe lve pa g e s, spa n fo ur da ta b a se s a nd inc lude ma ny time c o nsuming jo in (a tta c hme nt) q ue rie s

  • Pro c e ssing time : Se ve ra l ho urs

Collec ting Statistic s Without the Statistic s Module

slide-11
SLIDE 11

A typic al r epor t . . .

slide-12
SLIDE 12

T ime fo r c o ffe e . . .

slide-13
SLIDE 13

still running . . .

slide-14
SLIDE 14

ho me fo r so me we ll e a rne d re st . . .

slide-15
SLIDE 15

the ne xt mo rning . . .

slide-16
SLIDE 16

#$@%!

slide-17
SLIDE 17

Statistic s Module

slide-18
SLIDE 18

What is the Statistic s Module?

  • A mo dule de sig ne d to ho ld a ny me tric
  • A ve ry b a sic mo dule with a ve ry simple

sc he ma

  • E

a c h re c o rd c o mprise s the fo llo wing ke y e le me nts:

  • Hie ra rc hy de fining the me tric
  • A va lue me a sure me nt
  • T

he re po rting pe rio d fo r whic h tha t va lue wa s c a lc ula te d

slide-19
SLIDE 19

What is the Statistic s Module?

slide-20
SLIDE 20

Intr

  • duc ing “emuper

iodic ”

slide-21
SLIDE 21

Intr

  • duc ing “emuper

iodic ”

  • I

nitia te d b y the E Mu se rve r c ro n utility

  • Ca n run a uto ma tic a lly a t a ny time
  • Runs in b a c kg ro und
  • I

nitia te d imme dia te ly a fte r e nd o f re po rting pe rio d

  • Ca n b e use d to a uto ma te e xe c utio n o f

sc ripts

  • No limit to the numb e r o f sc ripts tha t c a n b e

insta lle d

slide-22
SLIDE 22

Why Use Sc r ipts to Gener ate Statistic s?

  • Sa me sc ript is run e ve ry time
  • Ca n b e run imme dia te ly a fte r the c o nc lusio n
  • f the re po rting pe rio d
  • Sc ripts c a n run in the e a rly ho urs o f the

mo rning a nd sta tistic s a re re a dy whe n yo u a rrive a t wo rk

  • Sta tistic s sc ripts inc lude o ptimisa tio n o f da te

ra ng e q ue rie s

slide-23
SLIDE 23

Why Use Sc r ipts to Gener ate Statistic s?

  • Sc ripts c a n pe rfo rm so phistic a te d

c a lc ula tio ns using multiple ta b le s, a nd

  • a s suc h, sc ripts c a n ra ng e fro m the

simple , suc h numb e r o f a c c e ssio ne d ite ms . . .

  • . . . to the c o mple x, fo r e xa mple ho w

ma ny ite ms we re o n displa y

slide-24
SLIDE 24

Whe n thinking o f po te ntia l a pplic a tio ns, think b e yo nd the so rt o f sta tistic s a c c umula te d using the E Mu c lie nt a pplic a tio n.

slide-25
SLIDE 25

Statistic al R epor ts

  • Onc e lo a de d into the Sta tistic s mo dule ,

me tric s c a n b e re a dily re trie ve d a nd re po rte d

  • Sta tistic s c a n b e e xpo rte d to a n E

xc e l re po rt c o nta ining c ha rts a nd g ra phs

  • Sta tistic s re ma in a c c e ssib le in pe rpe tuity
  • As pro duc tio n o f fig ure s is ide ntic a l e a c h

re po rting pe rio d, fig ure s fro m o ne re po rting pe rio d to the ne xt c a n b e c o mpa re d with c o mple te a c c ura c y a nd c o nfide nc e

slide-26
SLIDE 26
slide-27
SLIDE 27

I nse rt L ive De mo nstra tio n He re (o r c a ll Axie ll)

slide-28
SLIDE 28
slide-29
SLIDE 29

“End of Month Collection Digitisation Stats at Item Level (Version 2)”

A real world example . . .

slide-30
SLIDE 30
  • Use dro p-do wn lists to se le c t

de sire d me tric

  • E

nte r re po rt pe rio d

  • Pe rfo rm q ue ry

Collec ting Statistic s Using the Statistic s Module

slide-31
SLIDE 31
  • E

a rlie r twe lve pa g e e xa mple is re pla c e d b y two simple q ue rie s

  • T
  • ta l run time : le ss tha n 1 minute

Co lle c ting Sta tistic s Using the Sta tistic s Mo dule

slide-32
SLIDE 32

Ho w Ma ny Co lle c tio n I te ms We re On Displa y During June 2018?

slide-33
SLIDE 33

Wha t Pe rc e nta g e o f the Co lle c tio n’ s I te ms We re On Displa y During June 2018?

slide-34
SLIDE 34

T ime fo r c o ffe e . . .

slide-35
SLIDE 35
  • Ce ntra l
  • Ac c e ssib le
  • E

ffic ie nt

  • Co nsiste nt
  • Re lia b le
  • Busine ss I

nte llig e nc e

Summar y

slide-36
SLIDE 36

I nstitutio n wide , ho w muc h time is spe nt a nnua lly o n c o lle c ting a nd re po rting yo ur me tric s?

T hought E xper iment

slide-37
SLIDE 37
slide-38
SLIDE 38

T alk to us, it c ould look like this . .

slide-39
SLIDE 39

T hank you