SQL Server 2012 - Column Store indexes - Reporting Solution

SQL Server 2012 - Column Store indexes - Reporting Solution

We (Team) are in process of putting Audit Reporting solution for a huge
online transactional website.
Our auditing solution is to enable CDC on source table and tracking every
change happens on the objects, grab them and push them into Destination
table for reporting.
As of now we got one to one table in source - destination.
There will be only inserts in destination and no updates or delete.
So end of the day audit tables will grow large than actual source tables
as these keeps history of changes.
My plan is flatten the destination tables to fewer based on subject /
module, enable column store indexes and then utilize same for reporting.
Is there any suggestion on the above approach or there is any alternative.