Key Components for an Azure BI Technical Strategy
Azure Synapse Analytics Dedicated Pool\Azure SQL
- Azure Synapse and SQL are both Platform-as-a-service managed database offerings hosted in Azure
- Synapse is optimized for high performance, high volume analytic workloads
- Azure SQL is typically optimized for OLTP workloads, but may still be appropriate for smaller scale analytic workloads at lower price points
- The Polybase feature of Azure Synapse enables queries to be passed through to non-relational data sources, such as those in the Data Lake
Azure Data Factory
- Fully managed orchestration tool hosted within Azure
- Pipelines provide framework for building isolated data load and transformation processes
- Pipelines can perform simple lift and shift, orchestrating processes either side of Data Factory
- Can also perform complex Data Transformation logic in flow if required
- Support for many different data sources and destinations (Sinks)
Azure Data Lake Storage Gen 2
- High-capacity BLOB storage facility hosted in Azure
- Primarily expected to provide a staging area for unstructured and semi-structured data before loading into Data Warehouse
- Data in Lake can also be interrogated directly for high-speed access to raw unsanitised data
Where Do you start?
Choosing the right Data Platform and Data Strategy is a challenging task but our team are here to help. Whatever your Data Source challenge our Data Analytics & Azure Consultancy team are here to help you. Call us on 0118 979 4000 or email us at info@ptr.co.uk for further information.