Which tasks were implemented

• UseCase creation for functional and non-functional requirements
• Identification of gaps in Power BI for use in enterprise environment
• Planning and configuration of Azure environment for DWH/BI
• Setup of Azure Datalake structures, Azure SQL Pool, gateway to on-premise Oracle database
• Adaptation of ETL processes in Azure Synapse
• Development of semantic BI model for Power BI
• Planning and implementation of row-level security for Power BI
• Introduction of regular operation

Which technologies were used

• MS Azure
• MS Azure Data Lake
• MS Azure Synapse
• MS Azure Data Factory
• MS Azure Serverless SQL
• MS Power BI
• Oracle Database 12c