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

    nonprofit-power-pages-customer-story-vnb

    A Non Profit Association Supporting Veterinarians Publish PowerBI For Its Members Using Power Pages

    VNB assisted a Non Profit Association supporting veterinarians publish PowerBI data portal for its members using Power Pages

    VIEW DETAILS
    cms-mandate-azure-health-data-services-customer-story-vnb

    Dental Plan Meets CMS Mandate with Azure Health Data Services

    VNB assisted a dental plan implement patient access and provider directory API using Azure Data Services to meet CMS Mandate

    VIEW DETAILS
    womans-healthcare-powerbi-case-study-vnb

    Womans Healthcare Provider Transform Data Consolidation and Visualizations to Improve Patient Care

    VNB assisted a womans healthcare provider build data warehouse for Meditech EMR data and creates visualizations using PowerBI to improve patient care

    VIEW DETAILS

    Latest Posts

    December 14, 2022

    App in a Day Lab Pre-requisites

    Pre-requisites: Before starting the hands-on labs Note: To participate in the App in a Day training, you require an internet connection, and you will use the web version of the Power Apps Studio, which will run in a browser: Microsoft Edge, Google Chrome, or Safari. Task 1: Download the Lab Files 1. Download file Lab

    VNB Microsoft Purview power bi

    November 10, 2022

    Microsoft Purview Data loss prevention for Power BI

    VNB talks about the new Microsoft Purview for power bi, an upgraded, unified data governance solution. The system facilitates businesses to define and apply DLP policies for sensitive content.

    microsoft-power-pages-introduction-vnb-consulting

    July 27, 2022

    Microsoft Power Pages: What to Expect?

    Microsoft Power Pages is a standalone product that evolved from their Power Apps portal. The enterprise-grade Software as a Service (SaaS) platform enables companies to build secure, business-centric web applications using low-code/no-code development tool