Knowage Reviews

The advantage of the solution is we don't need to have any third-party tools to connect to the different databases. It has in-built features such as data mass and data warehousing. The big data concept is also included. It's very easy to implement graphical reports. We don't need to have a data warehouse for maintaining the historical data and things like that. We can achieve most of the goals without using third-party tools.

It's very easy to get the historical reports you need based on the business requirements and this helps our executives for taking decisions.

It is cross-platform. We can use it on desktops and on mobile versions and we don't need to have a separate mobile version for this.

We can easily do our own customizations. 

If you have a great technical team, it's a great option.

The solution can scale.

The product is stable. 

We primarily use the solution to embed reports. We are using it as a server to share our embedded reports.

In terms of reporting, it gives us a central place to store all our reports. We can also do version control. Instead of just relying on emails to disperse our reports, having a central server to do this for us has helped our organization and has pushed us into a better place. It's simplified our reporting.

We can test. There's room for testing reports before you deploy to other users and so forth. Just that functionality as well as their dashboards and the statistics you can collect on the usage of Knowage also helps our organization function effectively.

I created some tunnel processes and tunnel scripts in an Oracle database that helped me collect all aspects of profitability. We have around 14 million customers, and they generate a lot of records—for example, many activities like millions of records per day. I created a script that condensed that information and then aggregated that further to an activity level. I do it to determine if the company was profitable each month and understand if we have a positive or negative margin or a zero margin.

From there, I drill down to those customers that sort of caused that negative margin and try to analyze what caused that negative margin. For example, I look at what products or activities caused that negative margin. That's the analysis I do, and it gives me that access to tools. I could join two to three reports that help me analyze and drill down and export that information in whatever form I need.

I can't name the features the way the Knowage community calls them because I still don't know the lingo. However, I can describe them. I like the ability to join more than one report, set all fields on one end, and replicate that on the other reports. I like that a lot. I think it's one of the features that got me using Knowage. 

They have tables, and I like that too. They took SQL scripts and many other scripts and enabled them to even correlate with Python. That's also one of the best things about Knowage. You could also decide to get information per user role, and this is also a feature that I like in Knowage.

The most valuable features to us are application implementation, development, and analysis.

It provides implementation of reports for SpagoBI dynamic and static applications.

Allows development according to client needs. We can implement admin/user-level auto-refresh for reports by pulling data from a database according to a specific format. We can also add code for end-to-end SpagoBI applications.

We can perform database analysis at the client level.

We can get live application status. E.g., machine status on/off at the front end. Also, quarter/half/yearly status of company marketing campaigns. E.g., forecasting and earlier income remedies.

The health data warehouse is a centralized repository for data that allows organizations to store, integrate, recall, and analyze information.  Healthcare organizations may wish to use their warehouses perform clinical analytics using patient data stored in the EHR, or they may try to improve their financial forecasting by diving into business intelligence and revenue cycle analytics using claims and billing codes.

Making better decision using KPI, Peforming predictive analytics about each department/functional units

• SpagoBI Server offers the core and analytical functionalities. It provides the Analytical Model (reports, ETL, OLAP analysis, real-time dashboards, KPI, cockpits, GIS information, etc.), administration tools and cross-platform services.
• SpagoBI Studio has high productivity in the development phase; it easily permits the developer to design analytical documents such as reports, charts, geo, cockpits.
• SpagoBI SDK for integration and to use SpagoBI with external applications.

In other words, the main goal of my project was to create detailed reporting and a dashboard for managing various local departments (ASL) of the ministry to analyze the various performance and geographical distribution (through the use of maps and geo-referenced data) of expenditures, with the purpose of providing support to strategic choices of the senior management. One of the features that attracted us with the choice of SpagoBI was that it offers a simplified query functionality for business users, requiring no technical knowledge.

• Deploying and running BIRT Eclipse reports: We only use BIRT reports, and we couldn't find any satisfying solution for deploying them, except SpagoBI. None of the other open-source report servers we have tested had this feature or it was difficult to implement. In SpagoBI, it is very easy to create a new report, define the report parameters and upload the report template file.
• Open source and free.
• Web application.
• Parameterized data source
• It can use Oracle database for storing metadata.
• Parameter GUI components with great features (tree, combo, correlations, etc.).

SpagoBI makes delivering reports to our clients very easy.

The most valuable feature of SpagoBI is that it is open source and 100% free without limits.

The goal of the project that I was working in, is the realization of KPIs and a dashboard in order to understand the customers’ behavior and by using SpagoBI, this task was successfully done.