Alpha
BI
Helping businesses and governments grow with insights from data
About the product
Alpha
BI
is
a
designer
of
corporate
analytical
solutions.
High
potential
to
replace
Enterprise
BI:
Oracle
BI,
SAP
BW,
IBM
Cognos,
MS
SSAS
Alpha BI – business analytics platform
Alpha BI is a multifunctional designer of corporate analytical solutions. It provides data analytics capabilities from building multi-layer corporate data warehouses (DWH) to the formation of regulatory reporting.
It has a high import-substitution potential as a domestic alternative to BI-platforms of corporate level: SAP BI, Oracle BI, IBM Cognos, surpassing them in functionality.
Suitable for companies with a branched structure
Our tool is in demand in areas where management information is contained in disparate information systems, office spreadsheet files and on paper carriers.
Russian BI-system providing a full cycle of work with data
Data collection and storage
- Creation of storage structure for subject area tasks
- Simultaneous connection to multiple data sources
- Conversion of raw data into analytical information
- Data consistency and integrity
- Easy modification/addition of storage structures for new tasks
Data analysis
- Multivariate analysis of indicators
- Ad-hoc queries
- Online analysis in web interface
- Analysis via Excel
- Tabular and graphical analysis
- Analytical hypothesis testing on the go
Visualisation and reporting
- Template-driven analysis scenarios
- Interactive collaboration
- Distribution and public or authorised access
- Integration into external systems
Data collection and storage
- Creation of storage structure for subject area tasks
- Simultaneous connection to multiple data sources
- Conversion of raw data into analytical information
- Data consistency and integrity
- Easy modification/addition of storage structures for new tasks
Data analysis
- Multivariate analysis of indicators
- Ad-hoc queries
- Online analysis in web interface
- Analysis via Excel
- Tabular and graphical analysis
- Analytical hypothesis testing on the go
Visualisation and reporting
- Template-driven analysis scenarios
- Interactive collaboration
- Distribution and public or authorised access
- Integration into external systems
Key tools
ETL
Analytical data warehouse
Forms
OLAP
Dashboards
Reports
Collecting, loading and processing data from different sources
Request for demonstration
Create a single repository of data required for analysis
Request for demonstration
A tool for inputting, outputting, editing and analysing “flat” data
Request for demonstration
A multidimensional data analysis tool that allows you to view information in different slices.
Request for demonstration
Visualisation of complex information in interactive graphs for making the right management decisions.
Request for demonstration
A tool for generating regulated reports
Request for demonstration
Tasks that Alpha BI solves
Creating multi-layer corporate data warehouses
- Alpha BI implements a constructor for building multi-layer DWH data warehouse, which allows to create an unified information space for all systems and subject areas of the company
- Alpha BI uses OLAP- and OLTP-technologies of data storage and processing, SCD versioning and incremental data loading.
- The peculiarity of Alpha BI is the ability to organise work with unstructured or partially structured data.
Obtaining/cleaning/uniting information from multiple source systems
- The platform allows to work both in “live” mode with direct connection to OLAP-cubes and execution of queries ‘on the fly’, and in ‘export’ mode through ETL-processes. Supports file formats: *.xlsx, *.xls, *.dbf, *.xml, *.csv, *.json
- Supports databases: PostgreSQL, Greenplum, Oracle, MySQL, MS SQLServer, Firebird, Vertica, Informix, Clickhouse, MonetDB, File Storage
- Alpha BI is equipped with a powerful independent ETL-processor, which extracts and transforms data, brings it to the required format in accordance with the specified rules and uploads data to other databases.
Organisation of manual data input
Alpha BI provides advanced possibilities of manual data input, among them:
- Editing from the object card
- In-line data input
- Creating custom views
- Row and column permissions
- Calculated columns and composite caps
- Ability to enter data directly into OLAP cube
- Data export. Build a logical layer of business indicators on top of internal or external storage
- Alpha BI logical data model builder allows you to work with flat and multidimensional objects, build business indicators and KPIs on top of the physical data model and maintain a unified security policy for the whole system.
Create operational, regulated and graphical reports
Alpha BI analytics platform provides a very wide range of possibilities for interactive analysis of KPIs, including regulated and non-regulated reporting:
- Regulated reports are a formatted presentation of data according to a specified template. Reports allow you to extract the necessary information from the database and present it in a form convenient for perception, as well as provide ample opportunities for data summarisation and analysis.
- Analytical OLAP reports – a self-service solution that allows the user to receive arbitrary reports independently, operating with all available data and system fields.
Report distribution via mailing lists or public links
The report distribution component allows you to send generated reports, links to analytical dashboards after data update or on schedule. Sending is available on behalf of the mailing initiator and on behalf of the recipient, taking into account data access rights.
Compatibility
Alpha
BI
has
compatibility
with
domestic
operating
systems
Look
at
our
solution
now
Learn
all
the
features
of
the
Alpha
BI
platform
