Case study · P—06

Azure Reporting Platform for 1,200+ Business Users

Role
Migration · Senior Data Engineering & Data Architecture Group Manager
Period
May 2022 – August 2024
Organisation
LC Waikiki
Stack
Azure Data Factory, Azure Synapse Analytics, Analysis Services, Power BI
Status
Completed

In short

Reporting platform for 1,200+ business users migrated to Azure Data Factory, Synapse, Analysis Services and Power BI; 2nd place, IDC Turkey Awards.

Context

LC Waikiki’s reporting platform serves 1,200+ business users. This work belongs to the same role period (2022–2024) as the enterprise data warehouse migration to BigQuery.

Role: migrated the reporting platform to Azure, as Senior Data Engineering & Data Architecture Group Manager.

Approach

The reporting platform for 1,200+ business users was migrated to Azure services for data movement, analytical storage, semantic modelling and reporting.

Architecture and technology

  • Azure Data Factory: data movement and orchestration.
  • Azure Synapse Analytics: analytical store.
  • Analysis Services: semantic model.
  • Power BI: reports and dashboards.

Outcome

  • 1,200+ business users on the Azure reporting platform.
  • 2nd place at the IDC Turkey Awards.

Lessons

  • A reporting migration is measured by its users as much as by its platform: here the scope was 1,200+ business users.

Write to me about a similar project.