Modern Data Warehouse Azure Synapse: 4-Wk POC

This POC is designed to prove if Azure Synapse platform is right for your organization’s Advanced Analytics initiative. This Proof-of-Concept implementation can be easily expanded to a production deployment.

Agenda

Week 1 - 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 2 - Design

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

Week 3/4 - Development

*Provisions Azure resources needed for the POC. *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