Anadolu Efes

Enterprise analytics with Power BI for Anadolu Efes

Deka Technology designed and delivered an enterprise analytics environment that connected data ingestion, ETL and Power BI reporting across core business functions at Anadolu Efes.

Primary service
Data & AI
Secondary capabilities
  • Enterprise reporting

Project overview

Client
Anadolu Efes
Focus
Enterprise analytics and business intelligence
Deka Technology scope
Data-platform architecture, data ingestion, ETL design and implementation, and Power BI report and dashboard development
Business areas covered
Sales, finance, quality management, product planning, materials management and human resources
Source-reported scale
200+ Power BI reports, 1,000+ concurrent users, 10,000+ daily report views and 1,200+ ETL jobs per day

Challenge

Anadolu Efes needed an analytics environment capable of serving several business functions from a shared data and reporting foundation. The initiative had to bring together information from multiple sources, prepare it for analysis and make reports accessible to a broad enterprise user base, including through mobile access.

The challenge went beyond dashboard design. It required an architecture for data-warehouse and big-data workloads, dependable ingestion and transformation, and reporting at enterprise scale.

Deka Technology role

Deka Technology designed and delivered the analytics environment. The scope covered data-platform architecture, ingestion from multiple sources, ETL design and implementation, and the development of Power BI reports and dashboards for operational and management needs.

Approach

  1. Platform architecture

    Design the data-warehouse and big-data platform architecture.

  2. Data ingestion

    Ingest data from multiple enterprise sources.

  3. ETL implementation

    Design and implement ETL processes for repeatable data preparation.

  4. Power BI delivery

    Develop Power BI reports and dashboards for the relevant business functions.

  5. Enterprise access

    Support report access for enterprise and mobile users.

Outcomes

The delivered environment supported more than 200 Power BI reports.

The delivered environment supported more than 1,000 concurrent users.

The source reports more than 10,000 report views per day.

The source reports more than 1,200 ETL jobs per day.

Evidence note: These figures describe the project scale reported in the archived project source.

Technology

  • Microsoft Power BI
  • IBM DataStage
  • Apache Hive
  • Microsoft SQL Server
  • Microsoft Azure

Deka Technology

Discuss a similar project

Share your data sources, reporting priorities and delivery scope through the contact form. Deka Technology can discuss an enterprise analytics or Power BI initiative with you.

Open contact form