Data Warehouse & Analytics 1 Week Assessment

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

This 3 phase Azure detailed solution assessment will help you build cost-effective and optimized architecture into Azure Synapse Analytics and transform data using Azure Data Factory.

What is Azure ETL Assessment-

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.

Agenda

Phase 1: Overall review of Server

  • Analysis of databases with respect to facts and dimensions tables.
  • Relationship architecture analysis (if any) in the databases.
  • Procedures analysis, UDF analysis, jobs analysis.

Phase 2: Detailed Review

  • Data Profiling and recommendation as per source and destination.
  • Identify Business rules required to assess how much time azure synapse analytics requires to run.
  • Job analysis as per source and destination with respect to Azure Data Factory.

Phase 3: Final Delivery

  • Architecture diagram with respect to Azure data factory, on premise database, Azure Synapse Analytics.
  • Cost analysis for azure data factory and Azure Synapse.
  • Architecture diagram of azure data factory jobs w.r.t ETL's on how it will be executed.

Deliverables

  • An evaluation report of migrating into cloud including Data profiling and business rules documentation.
  • System Architecture and Azure Cost calculation.
https://store-images.s-microsoft.com/image/apps.5629.6976cade-5914-4db9-aa76-f3a8a96ebd27.a7ec6b49-6a11-45ef-90d5-949da823473b.37123084-cfa7-49db-9d30-d082d4061e3a
https://store-images.s-microsoft.com/image/apps.5629.6976cade-5914-4db9-aa76-f3a8a96ebd27.a7ec6b49-6a11-45ef-90d5-949da823473b.37123084-cfa7-49db-9d30-d082d4061e3a
https://store-images.s-microsoft.com/image/apps.18640.6976cade-5914-4db9-aa76-f3a8a96ebd27.a7ec6b49-6a11-45ef-90d5-949da823473b.a7ab76ea-57e0-4fe4-8bbf-95f276635f77