How to perform DNS log analysis

I have DNS analytics enabled on my domain controller. It creates lot of data, about the request clients make and client IP’s. How can i do analysis of the log, such as domain categorization, count of requests per client or per domain and other beautiful things with this data.