Originally, this post was going to be a rant about how SQL Server Reporting Services is useless, and how Excel was so much easier for creating graphs & doing useful analysis of data. Then I spent an hour and a half messing around writing queries, executing queries, exporting & importing result sets, and then manipulating the data. So all the "oomph" has kind of gone out of that rant.

Besides, I shouldn't even be messing around with this data; there are a bunch of very nice programs/scripts sitting around on the Internet to do the analysis & reporting for me. But doing things the easy way would be cheating. So instead I keep mucking around with my own custom tools & processes.

In any case, here's a bunch of pretty graphs showing the human-like page views per week broken out by country of origin. Data for other views is a bit...messy...right now. The per-country stuff is fairly clean because I'm just using a geoip database to map requesting IP address to source country.

(yes, one would have probably been sufficient to show what I was doing, but hey, if one is good, five is even better?)

(also, in all honesty, I'm guessing I don't have enough consistent traffic to make looking at a week-by-week view meaningful; better would probably be to focus on longer time spans, like a month or so)

Now playing: Matthew Barber – Ghost Notes – 06 One Little Piece of My Love