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

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 xie ll.c o m

How Many E Mu User s . . . • 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 people . . . • 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?

T he never ending joys of r epor ting . . . • 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

bage Out bage In, Gar Gar

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

A r eal wor ld example . . . “End of Month Collection Digitisation Stats at Item Level” a s do c ume nte d in . . .

Collec ting Statistic s Without the Statistic s Module • 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

t . . . epor A typic al r

ime fo r c o ffe e . . . T

still running . . .

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

the ne xt mo rning . . .

#$@%!

Statistic s Module

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

What is the Statistic s Module?

iodic ” oduc ing “emuper Intr

Intr oduc 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

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 o 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

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

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.

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

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

A real world example . . . “End of Month Collection Digitisation Stats at Item Level (Version 2)”

Collec ting Statistic s Using the Statistic s Module • 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

Co lle c ting Sta tistic s Using the Sta tistic s Mo dule • 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 o ta l run time : le ss tha n 1 minute

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

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?

ime fo r c o ffe e . . . T

Summar y • 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

T hought E xper iment 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 alk to us, it c ould look like this . .

hank you T