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

    Power and Utilities Organization Consolidate Multiple CRMs to Target New Markets

    VNB assisted a Power and Utilities Organization Consolidate Multiple CRMs into One Dynamics 365 CE to Target New Markets

    VIEW DETAILS
    sales-dispatcher-performance-powerbi

    A Freight Company Leverages Power BI to Generate Sales and Dispatcher Performance Reports for Better Decision-Making.

    VNB assisted a freight company to create Sales and Dispatcher Performance Reports, which enable the company to track and analyze the performance of their sales and dispatcher teams. 

    VIEW DETAILS
    work-order-automation-powerapps-powerautomate

    Logistics and Supply Chain Company Automate Work Order Management using Power Platform

    VNB assisted a logistics customer to automate work order management process leveraging Microsoft PowerApps, Dataverse and Power Automate

    VIEW DETAILS

    Latest Posts

    May 30, 2023

    Customizing Dynamics and Power Platform with PowerApps Component Framework (PCF)

    Learn how PCF allows developers to create custom controls that can be used in Power Apps, Dynamics 365, and other Power Platform applications.

    May 30, 2023

    Dynamics 365 Customer Insights – Microsoft’s Customer Data Platform (CDP)

    Learn how to gain a deeper understanding of your customers and provide personalized experiences for better business outcome.

    paginated-reports-in-a-day

    April 26, 2023

    Paginated Reports in a Day Lab Pre-requisites

    The Power BI Paginated Reports in a day workshop delivered by VNB BI & Analytics team empowers attendees with the technical knowledge required to create, publish, and distribute Power BI paginated reports. This is a full-day instructor-led workshop.