eXensys Business Intelligence
eXensys Business Intelligence (eXBIS) improves an organization's ability to manage data with timely reporting and quick analysis. This application provides a complete portfolio of business intelligence capabilities and applies the power of analytics and data integration to create a complete and easy-to-use solution.
eXBIS delivers the tools to exploit the information by making the right decision, setting strategy and measuring the results of your business actions. The product turns data into insight and improves operations in every area of an organization.
The functional modeling for different industry verticals provides pre-configured analytics thus giving the plug and play option to the user.
eXBIS comprises three key components, they are:
eXBIS Relational Online Analytical Processing (eXBIS ROLAP)
eXBIS Multi-Dimensional Online Analytical Processing (eXBIS MOLAP)
eX-DATA
eXBIS ROLAP
eXBIS ROLAP provides a wide range of robust analytical reports. The system allows configuring user-defined data marts called “Universes”. This system provides a greater flexibility to define specific reports for different hierarchies of an organization. eXBIS ROLAP generates both Structural and Analytical (Graphical) reports with multi-level drill-down details.
Features
Anytime, anywhere, accessibility
Role-based access
Configurable Universe (Data Mart) definition
Numerous slicing and dicing options
On the fly report generation from existing reports
Structural and Analytical (Graphical) reports with multilevel drill-down details
Drill-down view on Charts
Export facility of reports to standard formats,
viz., MS Word, MS Excel, RTF, PDF, etc.
Report Designing Language Component (RDLC) enabled facility on exported reports
Advanced dynamic report scheduler
Executive dashboard
Separate security module
Report drill down facility on the exported report file of MS Excel
Report subscription services
Functional modeling for different industry verticals
Dashboard configurations
Standard aggregating functions on the fly
Dynamic grouping on the fly
eXBIS MOLAP provides flexibility to define Key Performance Indicators (KPIs) across different functionalities of the base system through asset of Measures and Dimensions and the algorithm to process the same. This leads to the formation of a multidimensional data structure called Cube. eXBIS MOLAP interprets the data in a multidimensional environment, giving the user the capabilities of KPI analysis across multiple dimensions.
Features
Anytime, anywhere, accessibility
Role-based access
Supports robust Performance Management Reporting (PMR) system through various user
defined KPIs
Numerous slicing and dicing options
Structural and Analytical (Graphical) reports with multi-level drill-down structure
Reports can be exported to all standard formats,
viz., MS Word, MS Excel, RTF, PDF, etc.
Advanced dynamic report scheduler
Configurable dashboards for dignitaries across different hierarchies
Robust application security through the advanced security module
Standard cubes for vivid functionalities of different business verticals
Effective tool for the cause – Effect Analysis
Numerous aggregation functions at the desired hierarchy level of the report
Generation of dynamic measures on the fly
Provides extensive cross functional business analysis
eX-DATA
eX-DATA is an ETL and data warehousing tool that processes the data from multiple data sources of multiple applications and creates the target databases through the ETL (E: Extract, T: Transform, L: Load) process, with robust business rules processing. These target databases are further used for ROLAP and MOLAP reporting.
eX-DATA supports the RDBMS, viz., MS Access, MS SQL, Oracle and File Systems, viz., Flat Files, XMLs, MS Excel as source. After taking the relevant data across multiple and heterogeneous data sources, the system cross validates them with the Business Rules (configurable) in the Transformation process. Then the system loads the desired data, duly transformed through the transformation process in the user defined data structures.
Features
Supports data extraction from multiple data sources of multiple applications
Supports all DBMS and RDBMS data sources along with XML, Flat Files, MS Excel, etc.
Customizable and configurable transformation
Supports simultaneous hosting of business rules
Facilitates processing of business rules for data extracted from multiple and heterogeneous
data sources
Provision to define user defined business rules during the transformation process
Provision to define the target database to facilitate the loading process
Back