What is behind…
Since the moment you register for SaaS or install on your hardware, BellaDati gives you all the BI features you need in one web application. There is no need to install or buy separate modules. Clean and upload virtually any data with ETL tools including scripting, scheduling and public API. Store, access and model it at one place in warehouse build for light speed performance using unique combination of Real-Time and Relational OLAP. Business users experience pure collaborative, analysis and reporting web environment without complexity hidden inside BellaDati power core.
Intelligence Core
Under easy to use front end is beating industrial-strength ROLAP SQL engine designed for hardcore analysis and reporting techniques. BellaDati is web based Java Enterprise application supporting 64-bit and 32-bit Java Virtual Machines and Application Server environments. It is true multi-tenant, cluster ready, OS and platform independent solution. Core installed in 64-bit mode can support even more than thousands of users because it offers much greater memory space. It means the highest performance even in environment with many concurrent user sessions and large reports.
Relational OLAP+
BellaDati data-warehouse do not have to calculate analysis and reports every time user ask for one. ROLAP and just-in-time caching technology offloads the most time-consuming and processor-consuming queries from the database. Queries are served to the users much more quickly, directly from memory. Result is faster average query time and a much more evenly utilized database system. Have we mentioned prior FIFO queue and Complex queries optimization techniques?
Query scheduler
Schedule Extract Transform and Load capability. Friendly calendar like component let you plan exact time an periodicity of new data uploads. BellaDati native scheduling system is all that is needed to repopulate ROLAP cubes with fresh data from databases, web services or data residing on URL. For each department domain you can allow scheduling in particular periods and time frame. You have got ETL time window and database workload under perfect control. Most intensive uploads can be shift to off-hours freeing up database capacity for interactive peaks of the day.
Import wizard contains scripting functions to transform imported data
Self-Service GUI
Front end was designed in technology allowing business users do most of the analytical work on their own. Developers can do more important tasks like coding data cleaning scripts instead. GUI is build in technologies including AJAX, HTML5, LESS, CoffeeScript and TAPESTRY. User is experiencing truly interactive and responsive environment on all major web browsers. Processing shifts load from shared Web servers to the individual web browser. Components of the GUI can be easy embedded into the different web pages while preserving its interactive content.
Analysis interface
BellaDati ROLAP capability enables users "surf" through entire data warehouse. Drill-down anywhere and create innumerable combination of data simply clicking on the report. Templates of these reports can be used for new one. Dozen grid and graph reports can be consolidated into the dashboard. Multiple independent dashboards can be further consolidated into a single dashboard book. Each developed dashboard is later accessible from menu on one screen. Reports and dashboards support screen auto-layout function and full drill in interactivity.
Read more about BellaDati analytics
Modelling KPI and drill-down in BellaDati
Enterprise administration
Distributed governance model builds domain for every department filled with user groups and users with specific roles. Each domain can have its own administrator. This offloads that task from centralized IT personnel and is generally more responsive to local departmental business requests. Supported are single-sign-on capabilities including Active Directory protocol. You can easy monitor BellaDati usage by users, number of created reports, data sets and size of data cubes in each department. Whole domains can be backed up and reused for creation of the new one.
Collaboration engine
Secure sharing and do-it-yourself paradigm for users is omnipresent in BellaDati. Analysis in progress, reports and dashboards can be shared in work group, department or enterprise domain. Graphs and tables or whole dashboard can be shared in your intranet portal. Business users can subscribe themselves or co-workers for sharing, alerts and notifications. Graphs and tables or whole reports can be exported into the Excel, PDF, PPT and PNG formats. Printing support What-You-See-Is-What-You-Get. User roles security protects shared content.
Read more about collaboration feature
Warehouse architect
Modeling,Cleaning and Importing tools speed up setup of the right multidimensional business model into the meta-data. Import tool identify, which tables and columns from the various databases are to be used. Modeler describes the relationship between the columns. Inner and outer joins can be easy defined by mouse. It means joined data sets can be created from separated data sources. At the end of the process the user has a list of attributes and metrics objects that can be dragged-and-dropped onto reports and dashboards.
