Go Green One tree
One life


There is a large amount of data, with single tables having large records. There is high expectation of quick performance from predefined dashboards and reports and the telecommunication functional terms need to be understood.

They have their own ETL (Extract Transform Load) tool, through which they will populate the data into data warehouse database.

Selecting the open-source, columnar database (providing the read/write benchmark for the BI application)

In memory solution for caching the result of dashboard and report, so default quick output will be obtained (Combination of the filter parameter needs to be defined, based on use).

Database Insert/Load should work very efficiently as there is a large amount of data getting inserted over a period of time.

Our Solution

SPEC INDIA developed the solution using Pentaho stack with the below features:

Designed a Star schema based Data Warehouse after discussion, understanding and analysis of Telecommunication terms, current database structure and required dashboards and reports

Provided the suggestion of “InfiniDB” as a columnar database with distribution of data on three machines, finally selected it as the data warehouse DB, after providing the benchmark result to client.

Provided suggestion of advanced visualization tools, like “Heat MAP”, “Tree MAP “etc., for inclusion into dashboards.

Customized the Pentaho Community Edition, with “White Labeling”, where we masked everything which was named Pentaho and provided a look and feel of the desired application maintaining company standards.

For faster access of the dashboard and reports within no time, we cached the result into memory with Hazelcast in Pentaho. We identified the combination of filters which were frequently used, from logs and their inputs. In the night batch cycle, we generated the result set and put into cache for faster access.

CDR Network Traffic Analysis Communicate MOU, CALL QTY, OCN inclusion of different dimension and measures.

Filter based on all dimensions.

Highest aggregation is month, (Start with Year-Quarter-Month).

Compare the Year on Year, as well as month on month also.

Drillable down on all Hierarchy dimensions as well as Time dimension.

Show the average and median line on the chart, so easily identify the anomaly.

OCN Analysis Report Include the below dimension in report, with categorize and filter and sorting on every column, beside that provide category wise, OCN analysis like City wise OCN

Ocn List

Orig Call Number

Called Num Toll Free

Unique Toll Free


Term Call Number

On filter, number of the category is there, where you can view the bar chart based on the different category like, city, state, OCN etc.


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


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

SPEC INDIA‘s successful rollout for BI Analytics Solution facilitated the company in decision making for many crucial things, providing a lot of benefits:

Centralized Data warehouse, with columnar database – infiniDB, having relatively high throughput for query and analytics.

Report output generated and shared instantly, with help of Hazelcast.

Advanced analysis through Scatter chart etc. for better decision making.

Report monitoring by logging access/time/frequency to help the IT team identify the usefulness of report.

Analytics and Self-service Dashboard creation to help users create the dashboard and generate desired 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