[vc_row][vc_column width=”1/1″][vc_single_image image=”717″ css_animation=”appear” img_link_target=”_self” img_size=”1080×432″][/vc_column][/vc_row][vc_row][vc_column width=”1/2″][vc_text_separator title=”BI in a Box” title_align=”separator_align_left” title_heading=”h1″ separator_type=”type2″ margin_top=”0″][vc_column_text]

This project was implemented for each of the cellular network group’s operational companies in Ghana, Uganda, Syria, Sudan, South Sudan, Yemen, Iran, Rwanda, Afghanistan, Zambia, Swaziland, Cameroon, Nigeria, Cote d’Ivoire, Liberia and the Congo.

 

The process included:

  • Data warehouse architecture, design, data modelling and building as well as information exploitation. The data warehouse was implemented in Oracle with ETL processing done using Informatica and a PBT-developed Oracle framework. Exploitation and reporting were implemented using OBIEE report writer.
  • Data warehousing consisting of several star schemas that represent the core business processes of the cellular network enterprise. The largest of these star schemas stores detailed call data records (CDRs), which is a consolidated view of the raw CDR, with the call charges and roaming charges added separately from the relevant billing systems.
  • Other star schemas that include prepaid events (recharges, adjustments), sales, call centre interactions, general ledger transactions, balances and budgets, and post-paid billing details. Major dimensions included MSISDN / subscriber, IMSI (SIM card), IMEI (handset) and some smaller dimensions like base station, sales channel and distribution channel etc. All the information is available for ad hoc reporting and analysis.

[/vc_column_text][/vc_column][vc_column width=”1/2″][vc_text_separator title=”Project details” title_align=”separator_align_left” title_heading=”h1″ separator_type=”type2″ margin_top=”0″][vc_accordion active_tab=”false” collapsible=”yes”][vc_accordion_tab title=”Industry”][vc_column_text]

Telecommunications/mobile

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”PBT Group entity”][vc_column_text]

PBT Technology Services

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”Services”][vc_column_text]

Data warehouse architecture, design, data modelling and building, information exploitation

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”Project description “][vc_column_text]

Standardised BI solution architected, designed, implemented and deployed to all the cellular network’s operational companies

[/vc_column_text][/vc_accordion_tab][vc_accordion_tab title=”Service details “][vc_column_text]

  • Strategic consulting
  • Programme and project management
  • Business analysis
  • Data analysis
  • Solution architecture and design
  • Dimensional modelling
  • ETL design and implementation
  • Report design and implementation
  • Testing
  • Training
  • Advanced analytics / data mining

[/vc_column_text][/vc_accordion_tab][/vc_accordion][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_text_separator title=”Similar items” title_align=”separator_align_left” title_heading=”h1″ separator_type=”type2″ margin_top=”0″][vc_teaser_grid grid_columns_count=”4″ grid_posttypes=”portfolio” grid_content=”teaser” grid_layout=”title_thumbnail_text” grid_layout1=”thumbnail_title” thumbnail_hover_icons=”link” grid_link_target=”_self” grid_template=”filtered_grid” grid_layout_mode=”fitRows” order=”DESC” grid_teasers_count=”All” grid_thumb_size=”250×150″][/vc_column][/vc_row]