PTR logo

Azure Data Platform Key Components Consultancy Services

Key Components for an Azure BI Technical Strategy

Choosing the right Data Platform and Data Strategy is a challenging task but our team are here to help.

Motion graphic.

Key Components for an Azure BI Technical Strategy

Content image

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.

Share This Post

Frequently Asked Questions

Couldn’t find the answer you were looking for? Feel free to reach out to us! Our team of experts is here to help.

Contact Us