Azure Synapse EDW: 12-week Automated Resource Implementation

Neal Analytics

Leverage automated tooling to rapidly deploy an Enterprise Data Warehouse built on Azure Synapse Analytics

The Azure Synapse Enterprise Data Warehouse offer is designed to automate the process of deploying the data warehouse resources and configurations. Azure Data Factory is required to move and transform data and Azure Data Lake Storage will be deployed with the required configurations. After creating the necessary pipelines for the transformation of the data, your data will be ready to use in Power BI, Azure DB, or in Azure ML.

Azure Synapse Analytics.

Azure Synapse Analytics provides a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics. It allows you to query data on your terms, using serverless or dedicated options—at scale.

Deliverables and timelines

Azure Synapse Automated Resource Deployments typically follow the timeline below:

Weeks 1-2:

  • Understand key requirements and documentation
  • Key stakeholder and SME interviews
  • Review customer DataOps environment

Week 3-10:

  • Provision cloud environment (including Azure Synapse Analytics)
  • Deploy DataOps tools and services
  • Review maturity gaps and validate designs
  • Create a pilot framework based on an existing model
  • Update and finalize recommendations

Week 11-12:

  • Finalize documentation
  • Test framework and present results
  • Review progress and move to production

Sample Deployment

We have a GitHub repository for this solution where you can go through step by step to deploy the resources.

Click here to access the GitHub repository.

https://store-images.s-microsoft.com/image/apps.160.6cc68599-f953-4613-baf6-f5440949e5e5.4ee70c11-0d0d-4af9-a512-5432deb84bdd.d696568b-69d7-4c08-8164-9a82b774148c
https://store-images.s-microsoft.com/image/apps.160.6cc68599-f953-4613-baf6-f5440949e5e5.4ee70c11-0d0d-4af9-a512-5432deb84bdd.d696568b-69d7-4c08-8164-9a82b774148c