I have worked with on-premise Microsoft Analytics Platform System (PDW/APS) appliances which are costly solution in terms of hardware/software, support, and scalability. From this perspective Azure SQL Data Warehouse is a great solution with all the benefits of scalability, Modern data warehouse, Advanced analytics for big data, and Real-time analytics options.  But benefits will depend on the Data Warehouse design (replicated, distributed, and round robin tables), amount of processing, proper use of Column Store Indexes, SQL code.  If these are poorly designed and implemented Azure SQL Data warehouse can prove to be a costly proposition.