?

Log in

No account? Create an account
The Mad Schemes of Dr. Tectonic [entries|archive|friends|userinfo]
Beemer

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

Stats [Mar. 30th, 2009|10:16 pm]
Beemer
So my boss is interested in some stats on our data archive.

I have access to a SQL database that has details of every single download transaction. So I can definitely pull some stats together. The question is... what?

I mean, I can slice and dice the data in a million different ways. I can count number of users, total data volume downloaded, popular files... what else would be interesting?

Jerry suggested looking at number of files downloads per user, which might show some interesting patterns.

Any suggestions?
LinkReply

Comments:
[User Picture]From: flwyd
2009-03-31 05:59 am (UTC)
Your server's rating in Hurtling Station Wagon Full Of Eight Track Tapes equivalent units.
(Reply) (Thread)
[User Picture]From: dr_tectonic
2009-03-31 06:10 am (UTC)
I think it's actually A Lot.
(Reply) (Parent) (Thread)
[User Picture]From: da_lj
2009-04-05 12:16 am (UTC)
Not only is that a measure I need to note myself for future use (thanks)...

but B's background-color plus your icon plus the angle of my mac laptop screen combine to make a really stunning translucent image. I realize it is prolly bog-standard Mail.app bits there, but you mind if I steal the idea with attribution? :)

(Reply) (Parent) (Thread)
[User Picture]From: flwyd
2009-04-05 04:19 am (UTC)
No attribution needed, I just spent a few minutes futzing around to pull it out of an icon resource and into something postable.
(Reply) (Parent) (Thread)