Why not create ColumnStore index on every single table?
In SQL Server 2016, if you have &amp; processing over million of rows, the only thing that would not allow you to use Columnstore Indexes will be the current technology limitations, such as Replication on CCI, CLR, CDC or CT over CCI and so on ... 
Otherwise this should be a default way to approach any modern Data Warehouse.