Need a custom proof of concept?
We're experts in a wide range of technologies. Reach out to us now.
A production ready POC that setup Advance Analytics scenarios in Azure using Azure Synapse , Azure Data Factory, Azure Analysis Services and Power BI.
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.
Deliverables
- Data Discovery Document
- Technical Design Document
- Azure Synapse Workspace with Data Connections and Data Model
- Data Cubes (Optional)
- Power BI Reports
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
