Azure Synapse Analytics : 8-Wks Implementation

VNB Consulting

As an early adopter and implementer of Azure Synapse Analytics for a limited time we are offering an end to end 8-weeks Azure Synapse Analytics implementation for any 2 data sources with 2 reports

This imeplementation is a great first step forward for your larger Advance Analytics initiative using zure Synapse. This implementation can be easily expanded to add more data sources and reports.

Agenda

Week 1-2 - Discovery

*Review high level requirements and finalize scope of POC. *Gather requirements from your strategic teams that is part of the proof of concept.

Week 3-4 - Design

*Design data model *Design ETL process *Design row level security model *Design sharing and collaboration strategies

Week 4-8 - Development

*Provisions Azure resources needed for the implementation *Implement the solution identified with the Azure resources such as ADF, Synapse, Analysis Services (Optional) and Power BI. *Build Azure Data Factory pipelines, data flows and data connections *Build distribution types and keys for synapse data warehouse model and create physical model (star\snowflake) *Build aggregations, measures and facts using Azure Analysis Services *Build reports and reports and dashboards using PowerBI *Review and Walkthrough of the solution *Training on the tools and resources used in the solution and knowledge transfer

Deliverables

*Data Discovery Document *Technical Design Document *Azure Synapse Workspace with Data Connections and Data Model *Data Cubes (Optional) *Power BI Reports

https://store-images.s-microsoft.com/image/apps.39121.aff44d12-00be-4b07-9146-3b3b4f02dbc3.fb09dfe3-bb73-4d9e-a3a0-6f075a40c9d7.9c8ceafc-5d75-4770-8f91-e3848c25b408
https://store-images.s-microsoft.com/image/apps.39121.aff44d12-00be-4b07-9146-3b3b4f02dbc3.fb09dfe3-bb73-4d9e-a3a0-6f075a40c9d7.9c8ceafc-5d75-4770-8f91-e3848c25b408
https://store-images.s-microsoft.com/image/apps.26994.aff44d12-00be-4b07-9146-3b3b4f02dbc3.fb09dfe3-bb73-4d9e-a3a0-6f075a40c9d7.48010b3d-5ce8-43f0-ab74-0bf2038df620