Skip to main content
Aynitech Factory
EN ES
background-header
Work / Bridging Dollars and Tonnes: Corporate BI for an Industrial Fishing Group

Bridging Dollars and Tonnes: Corporate BI for an Industrial Fishing Group

MicroStrategy + DWH & Datamarts (SQL Server 2016) · From Vessel Profitability to Season Quality

Client
Challenge

COPEINCA, part of CFG Investment and one of Peru’s large industrial fishing and fishmeal & fish-oil producers, wanted to move from reporting to genuine corporate decision support — to develop, as a company, the ability to turn data into information and information into knowledge, and so optimize both decision-making and operational performance. It had already made progress in reporting and analysis on a single tool, but needed one corporate platform that could answer real business problems and recommend decisions. The hardest part was bringing together two worlds that rarely meet: the financial-accounting world measured in dollars per unit of time (per month, per season, per year) and the productive world measured in tonnes — consumption, recovery and yield ratios.

Factories

Business Analytics + Data Engineering

Engagement
Project

The Approach

AYNITECH delivered a corporate Business Intelligence platform on MicroStrategy, built on a data warehouse and datamarts on SQL Server 2016. Data flows from the company’s operational sources — ERP, custom applications, databases and flat files — through a clean-and-reformat pipeline into a governed warehouse (data plus metadata) that feeds OLAP, decision-support (DSS/EIS) and data-mining. Delivery followed the way MicroStrategy works best: identify the data sources, confirm the KPIs, distribute the information as Dossiers, deploy successive Dossier versions, and iterate in an agile cycle. The platform is designed to climb the full maturity curve — operational data, operational management, management dashboards (Cuadros de Mando), and a Balanced Scorecard and DSS for profitability, results and decision-making, including what-if analysis.

What It Covers

The platform spans the business end to end, tying financial results to physical production:

  • Profitability & Results— vessel and plant profitability, fuel consumption, EBITDA, P&L, and what-if analysis with and without risk.

  • Management Information (SIG)— cost KPIs, administration, personnel and resource management.

  • Control— expenses and budgets.

  • Costs — extraction and production.

  • Maintenance — fleet and production.

  • Projects— fleet, production and general management.

  • Season— quality, logistics, and commercial allocation.

  • Other ratios— further operational and technology metrics.

At a Glance

  • Corporate BI on MicroStrategy, delivered as versioned Dossiers in an agile cycle

  • Data warehouse and datamarts on SQL Server 2016, fed by ETL from ERP, custom apps and flat files

  • One platform bridging the financial world (dollars per unit of time) and the productive world (tonnes)

  • Coverage from vessel and plant profitability to costs, fleet maintenance and season quality

  • Climbs from reporting to OLAP, DSS/EIS, data-mining and what-if decision support

Why It Matters

Industrial fishing runs on two languages — money and biomass — and very few BI programs unify them. COPEINCA shows AYNITECH building a corporate decision-support platform that ties financial results directly to physical production (tonnes, yield, fuel) across fleet, plants and seasons, on one governed warehouse. It turns scattered reporting into a single tool that answers business problems and supports decisions in a genuinely complex operational business.