| |
Business Intelligence in Enterprise |
| |
|
| |
In today’s extremely challenging business environment, many Enterprise carriers are measuring their success by the size and growth of their profit margins. As a result, carriers are under intense pressure to reduce or eliminate the major threats to these slim margins: |
| |
|
 |
Revenue leakage, costing the industry $100 billion annually1. |
|
Inaccurate or missed inter-carrier billing. |
|
Fraud, a $12 billion annual industry problem2. |
|
Churn, a multi-billion dollar problem exacerbated by the wireless number portability requirement. |
|
Inefficient network usage and least cost routing plans. |
| |
|
| |
Carriers rely on analyses of their terabytes of Call Detail Record (CDR) data to help them make business-critical decisions that will positively affect their bottom line. High-end data warehouses and powerful Business Intelligence (BI) solutions are essential tools to help carriers meet profit goals. Analyzing and integrating in-depth data from multiple departments enables carriers to reduce revenue leakage and churn, mitigate fraud, optimize network usage and increase profits. |
| |
|
| |
Unfortunately, carriers struggle with their existing patchworks of general-purpose data warehouse solutions to store and analyze the mountains of data they create every day. Large networks and their associated switches, billing systems and service departments can generate hundreds of millions of individual CDRs daily. These terabytes of dynamic customer data will continue to grow exponentially as carriers add new services and as IP-based traffic increases. This ever-expanding volume of data puts strain on the performance capabilities of today’s traditional relational databases, servers and storage systems that provide the foundation for BI. |
| |
|
| |
With traditional technology it has been difficult and expensive to analyze large volumes of records at the CDR level within reasonable time frames, or at a reasonable cost. As a result, millions or even billions of CDRs must first be sampled and summarized to reduce the data being analyzed. Even so, it still takes many hours of processing to analyze aggregated data sets on today’s platforms. This limits the effectiveness of customer relationship management (CRM), revenue assurance, fraud detection and network usage assurance programs that are crucial to improving the bottom line. |
| |
|
| |
Enterprise BI Challenges |
| |
|
| |
Many critical Enterprise functions rely on fast, complex analysis of CDR data. Key initiatives include analyzing behavioral data using CRM programs to optimally target services and reduce churn, ensuring complete and accurate billing and modeling call behavior with revenue assurance programs, and optimizing network operations using operations management programs. These initiatives all benefit from improved access to CDR-level data, access to large quantities of historical information for trend analysis and from the ability to quickly run complex BI queries. |
| |
|
| |
Unfortunately, acquiring and managing large volumes of data is costly and time-consuming. What’s more, even when tera-scale storage costs are justified, these costs are not as great a barrier as the lengthy processing time it takes to analyze so much data with legacy servers and RDBMS systems. Performing a single complex BI query against billions of records using traditional systems takes hours or days. This is a serious impediment to the adoption of CDR-level analysis and prevents real-time proactive responses by carriers. |
| |
|
| |
These significant performance limitations force carriers to make a choice. They must either summarize or filter the data for analysis, or create a massive, complex and often custom CDR warehouse to analyze call detail information. Both of these options pose serious limitations and challenges, resulting in incomplete information for decision-making, or costly and time-consuming system development and maintenance. |
| |
|
| |
Executive Information System |
| |
|
| |
The Executive Information System (EIS) is an application meant for catering to the information needs of Management team of one of the Largest Enterprise Industry. The application aims to provide single information view across the organization to present consistent information to all in Enterprise Industry i.e. “one version of truth”. |
| |
|
| |
The application aims to provide secured access to the data pertaining to Key Performance Indicators (KPIs) of the business, that are sourced (from multiple sources, which are both internal and external to the organization), massaged (applying the relevant business rules), stored, and reported in a user-friendly manner to the management executives. |
| |
|
| |
The EIS system would Besides catering to the above mentioned will provide adhoc report, dashboard, balance score card etc. linked to vision of the organization and system would provide functionalities like DSS (Decision Support System), advance analytics, workflow etc that can help the users to take timely decisions. |
| |
|
| |
EIS shall also provide Enterprise Industry with planning, forecasting and budgeting tool, which will maximize productivity and performance at all, levels of management. |
| |
|
