Go Green One tree
One life


Cater heterogenous data into a unified format and make dashboards or data visualizations depending on the data.

Setup the entire BI stack starting from analysis till implementation, since the CRM system is already in place.

The database design is in open source vtiger CRM, of which, we had little knowledge and hence a challenge to us.

Development to be done in local environment, so rather than setting up the vtiger CRM, we had to replicate their test environment in SPEC INDIA premises.

Once project development is done, deployment of the BI app on his server, with https certification in Pentaho.

Adhoc analysis, for certain fact member and invoice which required separate cubes with row level security.

Data Cleansing and Profiling, as vtiger was a third-party system and the entire data was fed by the data operator.

Data source is the vtiger CRM system, based on the MySQL database.

Our Solution

SPEC INDIA developed the solution using Pentaho Community stack, for this client requirement, along with the following features:

Discuss, understand and analyze current requirements of the healthcare domain and transform them into a detailed SRS document, along with client approval. The SRS contained the technical scope of data warehouse as well as the 6-7 Dashboards and CUBE design.

Provide Transformation to populate the data from vtiger CRM to data warehouse designed into Mysql, set into schedule for daily frequency in night batch cycle.

Dashboard css and design approved by client and incorporate company standards into BI App.

All dashboards are tablet friendly (responsiveness) and all designs are boot-strap friendly.

Customized the Pentaho community Edition, with “White Labeling”, where we masked everything which was named Pentaho.

Deploy requisite information on their server and provide the mock test on the server, provide the user guidance document for the CUBE usage for adhoc analysis.

Provide two necessary CUBEs for the adhoc analysis, which would make decision making an easier task as well as make them less dependent on IT department.


Similar Project Idea?

We have helped a number of global clientele with our analysis and reporting services to drive better performance based on data

Submit Request

Technologies & Tools

SQL Server

Our Process


Our detailed and accurate research , analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.


We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.


Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.


Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.


We have a well-defined, robust, and secure launch criteria that offers us a successful implementation clubbed with detailed testing, customer acceptance and satisfaction.

Business Benefits

This BI Analytics Solution is yet another successful rollout by SPEC INDIA, assisting the client in enhanced with the following benefits:

Centralized Data Warehouse, which interacts with vtiger CRM and user can view the dashboard and reports without impacting the vtiger CRM database.

High performance and high flexibility in deployment.

Better Security implementation with https certification implementation in Pentaho.

Monitoring of the report access/Time/Frequency to help the IT team identify the usefulness of report.

Analytics and Self-service Dashboard creation help users to create the desired dashboard and reports.


Looking For Something Similar?

We have worked with some of the best innovative ideas and brands in the world across industries.

Connect With Us