Skip to content
Conglomerate · BI on Oracle EBS
Middle East Data marts, finance dashboard & team enablement

Management Reporting Across 40 Group Companies for a Qatar Conglomerate

Management reporting across 40 group companies of a Qatar-based conglomerate, from Oracle EBS and a home-grown ERP, delivered through data marts and one corporate finance dashboard.

Client
Diversified conglomerate, Qatar
Region
Middle East
Engagement
Data marts, finance dashboard & team enablement
CORPORATE FINANCE DASHBOARD · 40 GROUP COMPANIES SOURCESDATA MARTSCONSUMPTION Oracle EBS (GL) In-house ERP (AP·AR·FA) Finance marts Finance dashboard Board-level access Near-real-time KPIs INTERNAL TEAM TRAINED FOR FUTURE ENHANCEMENTS

40

Group companies on one dashboard

Near-real-time

KPIs for management

2

ERPs integrated: Oracle EBS + in-house ERP

In-house

Team trained to enhance

Requirement

The challenge

  • The client is a conglomerate with around 40 different companies operating in Qatar.
  • It had implemented Oracle EBS for the core general ledger and a home-grown ERP on Oracle for accounts payable, accounts receivable and fixed assets.
  • There was no reporting solution available to present insight to management.
Solution

What we did

  • Developed data marts on Oracle EBS and the home-grown ERP.
  • Developed a corporate finance dashboard accessed by all the business heads across the 40 companies.
  • Trained the internal team to handle future development and enhancement requests from the business.
Tools Oracle EBSOracle (home-grown ERP)

Outcomes

What changed for the client

  • Management has near-real-time insight into the most important KPIs for decision-making.
  • Management at board level can access the information of any group company and make more informed decisions rather than relying on manual reporting.
  • The IT team is trained to maintain and enhance the data marts as business requirements evolve.

Related insights

All articles
MANUFACTURING · 7 OPERATIONS DATA ENGINEERING + DATA SCIENCE DATA WAREHOUSE · SENSORS 1 Predictive maintenance 2 Real-time monitoring 3 Demand & inventory 4 Price optimisation 5 Supply chain 6 Product development 7 Worker safety

Manufacturing Analytics

7 Manufacturing Operations that Data Engineering & Data Science will Revamp
OIL & GAS · MARKET GROWTH +16.2% YOY REVENUE · FORBES 2019 GROWTH POWERED BY ADVANCED ANALYTICS Exploration & production ENERGY DEMAND +50% BY 2050 Changing regulations COMPLIANCE · CARBON FOOTPRINT Supply chain efficiency FIND GAPS · OPTIMISE Real-time operations INSTANT INSIGHT · LESS DOWNTIME HEADWINDS: PRICE SWINGS · FOSSIL-FUEL UNCERTAINTY · TRADE STRATEGY ON SHIFTING SANDS → BUILT ON DATA

Fueling Oil & Gas Sector with Tech

Implementing Advanced Analytics for Oil & Gas Market Growth
OIL & GAS · DATA WAREHOUSING ONE CONSISTENT SOURCE HETEROGENEOUS DATA Exploration Production Legacy systems Field sensors Finance 1980s → 1990s → TODAY Data Warehouse MULTIDIMENSIONAL · CONSOLIDATED · CONSISTENT EVERY BUSINESS UNIT Operations Compliance & reporting Planning Management ACCURATE · SHARED · REAL-TIME (NEXT) INTEGRATION + INFORMATION SHARING → BUSINESS PERFORMANCE

Fueling Oil & Gas Sector with Tech

Advanced Analytics in Oil & Gas: Unlocking the Potential with Data Warehousing