“BI system for an online currency exchange platform.”
Designed in 2011 and implemented as a complete CRM and reporting system for an online currency exchange platform.
Full user workflow:
From registration → data verification → order placement → execution and settlement of transactions.
Dedicated Business Intelligence system designed for operational and financial management of an online currency exchange office.
The solution included:
- Register of currency exchange transactions (online and dealers),
- Analysis of margin, revenues, and trends,
- Support for real-time strategic decision-making,
- Full automation of data collection and processing.
Main project challenge
The online currency exchange market did not offer ready-made analytical tools.
- The company’s operations were based on:
- a high number of daily transactions,
- sensitivity to exchange rate changes,
- the necessity of precise control over the effectiveness of transactions and sales activities.
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
- Visualization and analysis: MS Excel
An automated transaction register imports data from the PostgreSQL database and converts it in real time.
The dashboard enables:
- analysis of volumes by currency, period, and customer type,
- review of transactions processed by assigned dealers,
- flexible data filtering using Excel slicers,
- the system allows quick identification of trends and deviations
Dealer performance summary presented as dynamic charts.
Data is grouped by:
- dealer,
- transaction type and value,
- execution period,
- customer segment.
The solution supports sales effectiveness evaluation and settlement of the sales team’s work.
The dashboard presents changes in revenue and transaction volume over time.
It includes:
- seasonality,
- differences between customer 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 decision-making.
The user receives:
- current insight into transaction scale and structure,
- the ability to quickly detect drops in activity or inefficiency,
- a tool for daily management of sales and customer relationships.
The BI system operated continuously for many years without the need for additional modifications, updates, or technical support.
During this period:
- it handled tens of thousands of currency exchange transactions,
- processed operations with a total value exceeding billions of PLN,
- ensured full data consistency — without discrepancies even at the smallest fraction.
The solution proved its reliability both during the company’s dynamic growth phase and in everyday operational work.