BI Analytics for Telecom

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

NumberRelation

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.