BI system for an online currency exchange platform.

Design and implementation in 2011 of a complete CRM and reporting system for an online currency exchange platform.

Full user workflow:

From registration → data verification → order placement → transaction execution and settlement.

A dedicated Business Intelligence system designed for the operational and financial management of an online currency exchange.

The solution covered:

• Currency transaction register (online and dealers),
• Margin, revenue and trend analysis,
• Real-time support for strategic decisions,
• Full automation of data retrieval and processing.

The main project challenge

The online currency exchange market offered no ready-made analytical tools.

• The company’s operations were based on:
• a high volume of daily transactions,
• sensitivity to exchange rate movements,
• the need for precise control over transaction efficiency and sales activity.

BI SYSTEM FOR THE CURRENCY EXCHANGE PLATFORM – TECHNOLOGY

• Automation: ODBC, VBA, SQL
• Database: PostgreSQL
• API integrations: Google Analytics, MixPanel, Forex
• Additional: integration with over 100 bank accounts
• Visualisation and analysis: MS Excel

The automated transaction register imports data from the PostgreSQL database and recalculates it in real time.

The dashboard enables:

• volume analysis by currency, period and client type,
• review of transaction execution assigned to individual dealers,
• flexible data filtering using Excel slicers.
• The system allows quick identification of trends and variances.

Data is grouped by:

• dealer,
• transaction type and value,
• execution period,
• client segment.

The solution supports sales performance evaluation and the settlement of the sales team’s work.

The dashboard presents changes in revenue and transaction volume over time.

The following are taken into account:

• seasonality,
• differences between client groups,
• exchange rate volatility and its impact on the scale of operations.

The BI system enables not only historical data analysis but also active support for operational decisions.

The user receives:

• real-time visibility into the scale and structure of transactions,
• the ability to quickly detect drops in activity or inefficiencies,
• a tool for day-to-day sales management and client relationship management.

The BI system ran continuously for many years without requiring any further modifications, updates or technical support.

During that time it:

• processed tens of thousands of currency transactions,
• handled operations with a combined value exceeding billions of Polish złoty,
• maintained full data accuracy — with zero discrepancies down to the single grosz.

The solution proved its reliability both during the company’s rapid growth phase and in day-to-day operational work.