BI Platform for consultants and developers

BellaDati is Business Intelligence apps development environment. Applications can be delivered entirely on the web. You can customize data cleaning and processing inside BellaDati via Groovy script editor. Create mashups of data from many data sources in XML web services connectors. Design your data warehouse. Make any of your existing applications fully compatible for automatic communication through public API and CLI powered by Java. Utilize advantage of PaaS and focus on innovation that provides real business value instead of infrastructure setup.

• Easy and quick development of BI applications
• Monetize your products quickly
• Reusable code and business logic
• Easy collaboration
• Lower risk for development of new apps
• Minimize operational cost
• Zero development infrastructure
• Integration with other web services
• Cut off deployment times

Web services mashups

With no coding or basic HTML and CSS knowledge you can build fully interactive dashboards made of graphs, tables, videos, pictures and formatted text. Source data can be gathered from many XML web services, CSVs, Excels and Databases. Included XML datasource editor let you select data you need from the rest. All components of dashboards and reports can be integrated into your own web pages by copy and paste of its URL. Parameters of URL including size of component and access rights can by fully customized.

Import wizard with scripting

In-build Scripting Language

You can very easy develop your own data cleansing, modifying and joining scripts in Groovy language editor. BellaDati checks scripts in the debugging mode before you run it. Only secured and tested calls of methods in Groovy are allowed. Directly in reports you can use math functions environment that let you develop formulas and macros for manipulation with existing KPIs. Formulas and scripts are automatically embedded with concrete data sets or reports. All source codes are saved and can be exchanged between developers for future development.

Custom content development

In case you really want to develop original look for report with your own forms, buttons or list of exported PDF take advantage of Custom Content Dashlet. Switch the view into the code and you are ready to code and utilize HTML, CSS and JavaScript including jQuery and Prototype libraries. You can easy take existing components like tables or graphs from reports and copy paste code into the custom content dashlet and create new business process.

Modelling KPI and drill-down in BellaDati

Data Warehouse builder

BellaDati lets you build your own data warehouse structure on-demand. Every data set can represent one report or whole database. Data sets can be connected with each other. GUI tools for outer and inner joins are provided. You can easy specify over which attributes join will be realized. Alarms notifying on data values in warehouse can be setup without coding as well as periodical loading of data from different sources. Data errors during upload are monitored and stored in history. It can help you apply your cleaning scripts correctly in the future uploads.

Public API and CLI

You might need to push data in real-time from your application or database into BellaDati or create simply new application as an add-on. BellaDati offers a pure REST style API that can be used by Independent Software Vendors, Developers and Intergrators. It is HTTP based WEB API, that responds to requests in XML format. Thus enabling application integration and development in any programming language. Interface let you to insert, update, delete and fetch data either as single records or in bulk. Find more information in TRGIMAN Developer NetWork soon.

Clean your data

BellaDati detects non-valid data during import and automatically corrects them. Eliminates blank values or wrong formatting. You can select which columns and rows you want to import into your data warehouse. Data are sorted as drill-downs or KPIs. Distinguish different coding and data separators.

Intuitive data warehouse

Mash-up data starting with Excel, Google... finishing with SAP

Everybody manage exploit various data sources. Well-arranged menu let you connect flat files like Excel, CSV, XML or databases including Oracle, MySQL, PostgreSQL. You don't have to stay in local intranet. Dig data all over the internet including Google SpreadSheets and Google Analytics. Enterprise apps Microsoft SharePoint, Microsoft Dynamics CRM and SAP modules are also supported.

Wizard for table joining

Shape data warehouse as lego bricks

You don't have to be SQL or coding guru. In BellaDati you can build your own data wearhouse by clicking of the mouse. In the same way you can connect multiple data sources. It is very handy when you are connecting data from databases and Excel. Scripts and API are available for gurus.

Backup data on your notebook anytime

History of imported data is available for you permanently. You can back up your data on your computer whenever you need. Data can be recorded into the BellaDati from flat Excel file or from multiple databases.