Business Intelligence through realtime Mobile dashboards and data visualization.

Article

BACKGROUND

KDM FORCE built an affordable, real-time, custom dashboards for mobile devices to monitor data from M2M services.

The Client, Enel, an Italian multinational manufacturer and distributor of electricity and gas that serves 61 million customers, at the time of the project had just formed it's own MVNO to connect its domestic smart meters around the country and to allow other M2M (Machine to Machine) services within its network and, despite the existence of a complete service dashboard for desktops and video wall, wanted to provide real-time BI (Business Intelligence) into the MVNO service metrics from mobile devices.

CHALLENGES

The Client needed to deliver dashboards for a wide range of users without developing an OS dependent Mobile App. as this choice would have resulted into increased ancillary costs. The Client needed a server-side layer that could process mountains of data and stream it on many different handsets each with its own OS version and hardware capacity. Finally, the solution needed to provide data rich infographics and charts that could run smoothly for all users.

Another constraint was represented by the security settings that were to be implemented with the IaaS chosen by the client: Amazon's AWS (Amazon Web Services).

THE SOLUTION

The Client asked the KDM FORCE team to help analyze their current BI stack and build a new efficient tool to turn data into the right business decisions. Our team was given limited budget and strict deadlines, but very few technical requirements or limitations.

We recognized the solution was critical for our Client’s business and development needed to be fast and, mostly, cost effective. We then suggested the following action points as a way forward:

  1. Decoupling the new dashboard architecture from the existing desktop dashboard to save on integration costs.
  2. Simplifying the cloud architecture and rebuilding it on free open-source database management system, which would allow the Client to have all functions necessary for the analytics.
  3. Facilitating data processing by employing open-source tools for data integration.
  4. Employing stabdard Javascripts for visual analytics presentation to provide convenient and user-friendly end-user reporting.

RESULTS

It took KDM FORCE less than two months of development time to build the Client's new mobile-optimized Web App. that provided User with Users the three following functional areas:

  • The QoS KPIs graphs.
  • Alerts.
  • APN (Access Point Name) real-time monitoring.

The QoS KPIs graphs

The graphs have been optimized for handheld devices. Users could easily monitor any aspect of the MVNO services' QoE with customized dashboards. The graphs also provided the Network Operation Centers (NOCs) with precise real-time information about the Quality, the Integrity and the Performance of the Services.

Alerts

Coupled with a smart alerting system, this continuous monitoring allows the NOCs to be warned about any confirmed service deterioration to prevent any severe service interruption of services' delivery proactively.

APN real-time monitoring

The real-time monitoring of the APNs allowed to ensure that service were being delivered complies with the SLAs, and that it is not inferior to the MNO’s own service through custom dashboards and a smart alert system.