Developing a data analytics solution for Nokia that enables strategic data interpretation and decision-making.

From the clients’ end, Daffodil was provided a download of their raw data as flat files, which were then parsed by our team, and the schemas were defined to extract, modify and transform the data. The mobile and web applications were built with React Native and ReactJS respectively, using Python for data engineering. Users on these applications can comprehensively analyze the data around router performance and customer metrics. The prominent features of the desktop and mobile applications were as follows:

Multiple Data Visualizations

The data interpretation and analytics of this application allow users to gain valuable insights through the use of over 42 comprehensive dashboards, including:

• Microwave Utilization, which records the signals in the appropriate band to gauge performance
• Utilization Trends, help users observe the CPU utilization, which is another useful metric to measure the router’s performance.
• DWDM Topology offers a measurement of aggregate traffic over select wavelengths and a single fiber.
• Circle-Wise Fault Report, which neatly segregates the data about router downtime and uptime into circle-specific tables and graphs.
• Cyclic Redundancy Check Report, gives users an idea of the frequency of when files get corrupted, to ensure accuracy.

A combination of these highly crucial metrics helps the clients zero in on the specifics of how their business is functioning in the Indian marketplace in granular detail.

Auto-Scaling

The application can automatically adjust its computing resources and capacity to handle increased data processing requirements, without any manual intervention or downtime. Additionally, the web and mobile interfaces provide the user with various filters based on the customer Circle/State, the Router Brand, Initial Service Impact, and Router Technology for clear segregation of this data.

Centralized and Secure Administration

The Admin module enables the respective authorized central administrator to create new user profiles, track their activity on the application, remove users, and modify user profiles. Additionally, the administrator takes care of mapping routers to circles and making modifications related to circle-based analytics.

Concise Reporting

The tool allows for detailed error listing and reporting. While uploading the data files to the system’s secure file transfer protocol, or SFTP, the uploaded file may be corrupt or the file upload may fail. Every such error is reported and utilized to ensure that the capturing of data becomes a more seamless and efficient process, without causing any delays or downtime between data updates.
Reports of router circle-based data, router brand, type of router technology, and how these routers perform in terms of uptime, downtime, device ID, tickets raised, and resolutions for issues are all aggregated precisely.