Team Members

anmolgoyal74, ayush.khare, shivamsen_12579, pravesh_poonia

Project Team

Project Manager: Tripti Srivastava

Visit the site

Visit the site

Organizations Involved

SPC Fisheries, Aquaculture and Marine Ecosystems (FAME) Division faced challenges in managing dispersed data across 22 country portals. The lack of a centralized, cloud-based database and bulk import functionality limited operational efficiency. Although advanced reporting tools existed, they were previously managed through spreadsheets, which made data consolidation and analysis time-consuming and prone to errors. 

OpenSense Labs partnered with SPC FAME to implement a Drupal cloud-based centralized platform, integrated with Power BI dashboards, consolidating all member requests, training records, and feedback into a single, secure, and accessible system. This solution enabled real-time insights, scalable data management, and enhanced visual reporting for the organization. 

Describe the project (goals, requirements and outcome)
Back to top

Goals and Objectives: 

  1. Implement a centralized cloud-based database for all member country portals. 

  2. Consolidate data for member requests, training records, and feedback. 

  3. Ensure secure, real-time access to data for authorized users. 

  4. Enable bulk import functionality for large datasets. 

  5. Clean and migrate existing data accurately. 

  6. Integrate Power BI dashboards for enhanced visualization and reporting. 

Back to top

Key Requirements: 

  1. Centralized, cloud-based platform for data consolidation. 

  2. Real-time access and collaborative workflows. 

  3. Bulk data import and comprehensive data clean-up. 

  4. Power BI integration for advanced reporting and decision-making. 

Back to top

Outcomes: 

  1. 22 country portals consolidated into a single system. 

  2. 100% data migration accuracy after thorough clean-up. 

  3. Bulk import functionality enabled efficient handling of large datasets. 

  4. Power BI dashboards provided actionable, real-time insights. 

  5. Improved operational efficiency, collaboration, and decision-making. 

Back to top
Why Drupal was chosen

Drupal was selected as the foundation for SPC FAME’s new system due to its: 

  1. Centralized Data Management: Consolidated 22 country-specific microsites, member requests, training, and feedback into one platform.

  2. Flexibility and Scalability: Custom content types, fields, and taxonomies supported bulk imports and evolving data requirements. 

  3. Integration Capabilities: Seamless integration with Power BI for advanced dashboard visualization and reporting. 

  4. Data Migration and Cleaning: Built-in modules for importing, mapping, and validating data ensured accurate migration. 

  5. Access Control and Collaboration: Robust role-based permissions enabled secure access for users across multiple countries. 

Technical Specifications

Drupal version:

Why these modules/theme/distribution were chosen

The LocalGov Drupal distribution was chosen due to its capacity to offer a scalable and community-focused foundation for overseeing multi-site ecosystems.  

LocalGov Drupal serves as an open-source publishing platform that enhances the digital experience for citizens, boosts service outcomes, and lowers expenses. Its organized content model, adaptable architecture, and robust governance features made it an ideal fit for SPC FAME’s needs. 

By implementing this distribution, the team guaranteed uniformity, simplified management, and a sustainable method for scaling and maintaining 22 country portals. 

These modules and distribution were chosen to provide a scalable, secure, and efficient system, tailored to SPC FAME’s complex data management needs while supporting future growth and reporting capabilities.