?

Log in

No account? Create an account
Stats - The Mad Schemes of Dr. Tectonic — LiveJournal [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: nehrlich
2009-03-31 02:42 pm (UTC)
Why does your boss want stats?

If it's to say "Gosh, what a great data archive we have" when he goes looking for more funding, I'd look for volume stats like users and bytes and things like that, things that would make people go "Ooooh, ahhh" (like the Eight Track number)

If it's to figure out how to run the data archive more efficiently, then I'd go with some of the per-user numbers in the comments.

But first figure out the question being asked, then you'll have a better idea of what answers you should be providing.
(Reply) (Thread)
[User Picture]From: dr_tectonic
2009-03-31 05:05 pm (UTC)
Mostly it's for more funding, so yeah, "oooh ahhh" factor. Good!
(Reply) (Parent) (Thread)