Business intelligence (BI) is a technology-driven process for analyzing data and delivering actionable information that helps executives, managers and workers make informed business decisions.
Business intelligence is presenting significant opportunities for banks and financial institutions to drive additional revenues and enhance their value proposition. The banking industry has a huge number of databases in completely different formats accumulated in data lakes from many sources. They were born out of the need to harness big data.
For SDK.finance, a payment technology vendor for banks and financial institutions, processing and convenient visualization of such raw, unstructured data for business use is an enormous technological challenge.
There are different business intelligence tools available on the market today. The choice of SDK.finance is top-level software Apache Superset™.
What is Apache Superset?
Apache Superset™ (“Superset”) is an open-source data exploration and visualization platform designed to be visual, intuitive, and interactive. It enables to analyze of the data using its SQL editor, and easily build charts and dashboards.
Superset began at Airbnb in 2015 as a hackathon project, was open sourced in 2016, and joined the Apache Incubator program in May 2017. After nearly four years of incubating at Apache, on January 21st, 2021, the Apache Software Foundation announced Superset as a top-level project. Apache Superset is in use at Airbnb, American Express, Dropbox, Lyft, Netflix, Nielsen, Rakuten Viki, Twitter, and Udemy, among others.
Superset capabilities help SDK.finance to transform data lakes into helpful insights. Processed data is used in charts, spreadsheets, tables so that most people in a company can read it and use it for business decisions. Combining Superset business intelligence with SDK.finance core software is a great Apache Superset example in banking and finance.
Superset Interactive Dashboards
SDK.finance highlights the following advantages of Superset dashboards:
- Rich visualizations and interactive dashboards
- Highly scalable modern architecture
- Easy to use. Simple no-code viz builder or state of the art SQL IDE
- Integrates with any modern SQL based databases
The list of Superset dashboards generated by SDK.finance is designed for key decision-makers such as CEOs, CFOs, stakeholders, KYC, compliance, financial, and marketing managers to find insights, make confident decisions in different parts of the payments business, and achieve synergy with powerful results.
Which business intelligence dashboards does SDK.finance offer?
- Merchant-terminal-card hierarchy. Card-Terminal Flow
- Daily inconsistency check dashboard
- Balance dashboard
- Commissions dashboard
- Limits dashboard
- Settlement & reconciliation dashboard
- Transaction anomaly detection analysis
- Turnover and revenue forecast
Merchant-terminal-card hierarchy. Card-Terminal Flow
This dashboard shows the data about all merchants, their terminals and cards by terminals. Card-terminal flow shows all card transactions by a terminal.
Daily inconsistency check dashboard
SDK.finance daily inconsistency check Apache Superset dashboard allows companies to check and compare the sums of transactions with the amounts on balance and the amounts transferred to bank accounts.
Security risk reduction is a huge advantage that SDK.finance has reached by integrating Apache Superset with our core payment platform for banks and financial institutions.
The new reporting Apache Superset layer implemented by SDK.finance also helps to identify problematic transactions and provides detailed information about them. It monitors and reports about anomalies for the detection and prevention of financial crime (internal and external fraud attempts).
The Balance dashboard is a high-level report about the balance in general with the ability to drill down to more detailed information and filter by any wallet type, source, level, etc.
The Commissions dashboard report includes the summary and details about all available commissions for different contracts, client, and operation types, etc. This Apache Superset dashboard also allows forecasting the results of the commissions’ changes.
The Limits dashboard presents the summary and details about all limits by different categories. It also assists in forecasting the results of limit adjustments.
Settlement & Reconciliation dashboard
The Settlement & Reconciliation dashboard allows review and reconcile third-party transaction details. It also helps to identify problematic transactions and provides detailed information about them.
Transaction Anomaly Detection Analysis
Anomaly detection is one of the common anti-fraud approaches in data science. Anomaly detection dashboard allows to detect unexpected transaction amounts and frequencies and take actions. Machine learning (ML) allows for creating algorithms that process large datasets with many variables and help find these hidden correlations between user behavior and the likelihood of fraudulent actions.
Transaction anomalies table provides a detailed view of every highlighted transaction as anomalous.
Turnover and revenue forecast
This dashboards contains visualisations of the daily predictions for turnvover and revenue across 3 dimensions:
- Predictions across the whole system
- Predictions per each terminal
- Predictions per each merchant
All predictions are in daily scope and prediction length is 90 days from the last observation point.