How to analyze compression options for Azure SQL Database?
Kalen Delaney has created a version of sp_estimate_data_compression_savings specifically for this use case. 

Its available for download from the corresponding blog post here.