Dotlabs
Azure Meal
Introduction
The Azure Meal Project is an automated cloud-based ETL (Extract, Transform, Load) pipeline designed to process raw data from Azure Blob Storage and ingest it into an Azure SQL Server Database. The data is then visualized in Power BI to generate meaningful insights.
Project Overview
This project uses Azure services like Blob Storage, Function Apps, and SQL Server to create a robust ETL solution. Raw data is stored in Azure Blob Storage, processed using Azure Function Apps triggered every 15 minutes, and ingested into a SQL Server database. The results are then visualized in Power BI, providing real-time reporting and data insights. This efficient workflow allows seamless data management and reporting, as depicted in the architecture diagram.