Azure SQL is a highly scalable, durable, performance centric, highly available service for transactional data. This has traditionally been called Online Transaction Processing (OLTP) applications. There is another set of applications popularly known as the Online Analytics Processing (OLAP). Typically, OLAP applications are based on a data warehouse that stores massive amounts of data in a format readily consumable by analytics engine as the SQL Server Analysis Services (SSAS). The data warehouse stores data that is de-normalized for efficient querying.
Data warehouses are categorized into read major data stores. The write to this data store happens periodically contrary to OLTP applications where both writes and reads are comparable. Generally, applications that provide reporting, visualization, and analytics services connect to a data warehouse...
