Adserver reporting with kafka

Looking to implement adserver reporting Kafka with support tools. Real time reports and scheduled reports, data aggregation to relational or nosql or columnar data bases. Looking for best practices to follow and achieve this requirement. Thanks in advance.