This is most definitely on the roadmap, not sure what release, but don't be surprised if it shows up sooner rather than later :D

Here's a quick one I just threw together (remove the DNN_ if you aren't using an objectqualifier in your database

select vi.name, (select count(iv.ItemId) from dnn_publish_itemView iv where iv.ItemId = vi.ItemId) 'count'
from dnn_publish_vwitems vi
group by vi.itemid, vi.name
order by 'count' desc

We store views at the ItemID level, to get a count of the views of articles in a particular category you would have to write a bit more indepth SQL than what I provided there. I can try to look at that next week, right now I'm trying to get some more enhancements into the next Publish release ;)