Hyperscale is a new tier for Azure SQL Database. In this video Anna Thomas and Jeroen ter Heerdt cover how to switch an existing Azure SQL Database to this new, scalable, tier.
More information about Hyperscale: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-hyperscale.
Note that for data warehousing some people are looking for MPP architectures rather than SMP. Hyperscale is based on SMP architecture. If you are looking for an MPP architecture database service, have a look at SQL Data Warehouse.