Bharti Airtel - Offline Audit Survey for a SIM Company

Location

Delhi

Name of Client

Mercurius Advisory Services (MAS)

End Client

Bharti Airtel

Start date (month/year)

Sept 2023

Completion date (month/year)

Ongoing

Sample Collected

97,965 (approx.)

Industary

Accounting

Project Objective:

Bharti Airtel wants to conduct an extensive offline audit survey to assess their distribution network and performance in various regions. The survey will be carried out by multiple teams across several locations. To ensure accurate data collection, they need a custom questionnaire with dynamic logic and media files. Additionally, they require a solution that allows large volumes of data to be captured, stored, and transmitted efficiently once the devices are back online.


Key Requirements:

  1. Customized Report Generation:

    • Generate tailored reports for each tower audit based on predefined formats and custom form responses.

  2. Survey with Repeat Feature:

    • Collect audit data multiple times for the same locations to ensure accuracy and comprehensive evaluation.

  3. Team Management:

    • Manage five separate teams, each assigned distinct datasets and responsibilities for conducting audits.

  4. Dynamic Form Assignment:

    • Create multiple forms with dynamic logic and assign them to enumerators based on the team and dataset allocation.

  5. Efficient Offline Functionality:

    • Ensure smooth data collection and form submission without relying on a stable internet connection.


Fieldata’s Solution:

  1. Custom Portal for Team Management:

    • Developed a portal enabling the creation of distinct teams with role-based access.

    • Allowed the MAS admin to assign specific datasets and forms to enumerators within each team.

    • Enabled tracking of team progress in real-time through dashboards.

  2. Offline App Functionality with Repeat Feature:

    • Modified the Fieldata app to include a repeat feature, allowing enumerators to capture audit data multiple times for the same location seamlessly.

    • Ensured offline functionality for uninterrupted data collection, even in remote areas.

  3. Dynamic Form Handling:

    • Created multiple forms with custom logic tailored to Airtel's audit requirements.

    • Dynamically assigned respective forms to enumerators based on the dataset and team allocation.

  4. Custom Report Generation:

    • Designed a reporting system that generated audit reports based on data collected from each enumerator.

    • Provided customization options to include relevant metrics, photographs, and audit summaries in the final report.

  5. Real-time Data Sync and Storage:

    • Integrated secure synchronization mechanisms to upload data to the portal as soon as enumerators regained connectivity.

    • Enabled the MAS team to access and analyze data instantly through the portal.

  6. Scalability and Data Security:

    • Ensured that the solution was scalable to accommodate additional teams and datasets.

    • Encrypted data storage and transmission to ensure Airtel’s sensitive data remained secure.


Implementation Process:

  1. Requirement Gathering: Collaborated with MAS to understand Airtel’s tower audit requirements, team structure, and data reporting needs.

  2. System Customization: Modified Fieldata's portal and app to incorporate multi-team management, the repeat feature, and dynamic form assignments.

  3. Enumerator Training: Provided training sessions for enumerators and team leads to familiarize them with the app and portal functionalities.

  4. Data Collection and Reporting: Enabled smooth offline data collection, dynamic form handling, and the generation of comprehensive audit reports.


Results:

  • Efficiently managed five teams with customized datasets and forms, improving task allocation and completion rates.

  • Captured and validated audit data multiple times for thorough tower evaluation.

  • Delivered tailored reports for each tower audit, exceeding Airtel’s expectations for detailed and actionable insights.

  • Achieved 100% offline functionality, ensuring uninterrupted survey operations in remote areas.

  • Provided MAS with a centralized system to oversee team progress and data quality, streamlining the audit process.


Impact:

The offline audit survey empowered MAS and Bharti Airtel with an efficient, reliable, and secure system for managing large-scale tower audits. With Fieldata’s customized solution, MAS achieved enhanced operational efficiency, accurate data collection, and timely report generation, reinforcing their commitment to delivering top-notch services to Airtel.


Fieldata continues to be the trusted partner for survey and audit solutions, offering innovative tools tailored to unique business needs.

Last updated