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

  1. Data Discovery Document
  2. Technical Design Document
  3. Azure Synapse Workspace with Data Connections and Data Model
  4. Data Cubes (Optional)
  5. 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

Request POC

powerapps and flow proof of concept vnb consulting

Need a custom proof of concept?

We're experts in a wide range of technologies. Reach out to us now.

Work With Us

Our Customer Stories

VNB Consulting powerapps investment bank

An Asset Management Firm Automate Return To Workplace Using Microsoft Power Platform

VNB assisted an Asset management firm implement return to workplace power platform solution to ensure employee safety after covid-19 lockdown

VIEW DETAILS
vnb-custom-powerbi-visual

A pharmaceutical company implements Custom PowerBI Visual for deeper insights into drugs launch milestones

VNB developed a custom PowerBI visual for a pharmaceutical company to aid seamless reporting of program/product launch milestones across their products, regions, sub-regions, and countries 

VIEW DETAILS
power-automate-rpa-customer-story

Food Production Company Integrate Orders, Shipment & Invoices with Legacy Desktop Applications using Power Automate RPA

VNB assisted a Food Production company integrate orders, shipments & invoices with Legacy desktop application using Power Automate RPA

VIEW DETAILS

Latest Posts

VNB-MsIgnite-conference

March 11, 2021

Ignite Conference 2021: Power Platform and Azure

Microsoft recently held Ignite 2021 conference. In this blog we talk about key announcements specific to Power platform, Azure and Dynamics 365 from the Ignite conference.

February 10, 2021

Power Automate Robotic Process Automate (RPA) & AI Builder Part II

We discussed in the Part I how we can use Power Automate Desktop to record Windows and Web applications, but also leverage out of box actions such as manipulating Excel documents as part of an end-to-end invoice processing solution. Part II would give you an insight into the capabilities of the AI Builder.

VNB-azure-synapse-analytics-part4

February 18, 2021

Azure Synapse Analytics – Part 4: Predictive Analytics

In this part 4 of the series of articles on Azure Synapse Analytics, we will take a detailed look at the predictive analytics capabilities of Synapse. Predictive analytics is a modeling technique of using statistical algorithms and machine learning (ML) techniques to ascertain future outcomes, based on the historical data.