Data Warehouse & Analytics 1 WK Proof of Concept

IFI Techsolutions

Modern data warehouse, managed analytics and Databricks solutions that's limitless, performant & flexible. Your hub for all structured, unstructured & streaming data driving transformative solutions.

IFI Techsolutions is a leading cloud solutions and managed services provider that was recognized as a 2020 Microsoft Partner of the Year Finalist. Founded by former Microsoft executives, IFI Techsolutions has earned Microsoft Azure Advanced Specializations on Windows Server and SQL Server Migration, Modernization of Web Applications and Windows Virtual Desktop.

Azure Synapse analytics creates a bridge between Big Data Analytics and Enterprise Data warehousing to provide limitless and end-to-end analytics solution to gain powerful insights with unified experience.

As organizations move to the cloud, the various services enabling the modern Data Warehouse architecture allows a highly performant and available solutions. It enables securely bringing together data from multiple sources within or outside the organization, along with highly scalable processing capability to get insights through analytical dashboards, operational reports, or advanced analytics.

This is a 1-week engagement that aims to explore a business scenario at your organization, leverage Data Analytics to improve decision making and boost your business.

Agenda for POC

Phase 1: Understanding the current architecture

  • Kick-off meeting and finalize the scope of POC.
  • Analyse and review the client current environment.
  • Session on cost estimation.

##Phase 2: Environment Configuration

  • Setting destination environment.
  • Gain knowledge about the working of ETLs running on source side.
  • Setting up the ETLs into Azure environment using Azure Databricks or Azure Data Factory.

Phase 3: Implementation

  • Deploying ETLs and verifying the source and destination data
  • Verifying and Scheduling the working of ETLs.
  • Walkthrough of POC environment setup in Azure.


  • POC documentation.
  • Cost estimation.
  • POC Architecture diagram.
  • Session on understanding cloud data warehouse and analytics services.
  • Walkthrough of the POC environment