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.