Consultant for developing IPHC-E Resource Center analytics tools

About IPHC-E

The International Institute for Primary Health Care – Ethiopia (IPHC-E) aims to be a global hub for learning from Ethiopia’s experience in primary health care (PHC). The Institute provides a global perspective on PHC by exploring both historical and contemporary experiences worldwide. To support its mission, IPHC-E has established a Resource Center that collects, organizes, stores and disseminates information on PHC, building a comprehensive global hub of resources. IPHC-E seeks a consultant or consultancy firm to enhance the Resource Center and implement Apache Superset, an open-source data exploration and visualization platform. This initiative will include developing advanced search features and filters, improving user experience and enhancing data visualization and usage analytics

Introduction

This Terms of Reference outlines the objectives, scope of work and deliverables for a Consultant to assess and improve the Resource Center’s systems and to develop, install and configure the Superset platform across the Resource Repository, Library Catalog and specialized webpages.

Objectives

The primary objective is to design, develop, an analytics dashboard and reporting system using Apache Superset, providing Google Analytics-like capabilities for the IPHCE Resource Center. Specific objectives include:

• Tracking key user engagement metrics (eg, page views, unique visitors, session duration, bounce rate)
• Providing insights into content performance (eg, most popular resources, download trends, content categories)
• Facilitating understanding of user demographics and geographic distribution
• Supporting data-driven decision-making for content development and platform improvements
• Building internal capacity for the IPHCE team to utilize and maintain the analytics tool

Scope of work

The consultant will be responsible for, but not limited to, the following:

Duration: Two months

Phase 3.1: Discovery and requirements gathering

• Review existing data sources related to the IPHCE Resource Center (website logs, database records, survey data, and existing analytics platforms)
• Engage with the IPHCE team to identify analytical needs, reporting requirements, and key performance indicators (KPIs)
• Document functional and non-functional requirements for the analytics tool, including desired dashboards, reports, and data visualization capabilities.
• Propose a data model and architecture for integrating relevant data sources into Apache Superset.

Phase 3.2: System design and setup

• Set up and configure a dedicated Apache Superset instance, ensuring performance, scalability and security
• Design and implement data connectors to integrate various Resource Center data sources (databases, CSVs, APIs) into Superset
• Design data schemas within Superset to support the required analytics and reporting
• Implement system backup tools for recovery

Phase 3.3: Dashboard and reporting development

• Develop interactive dashboards and reports within Apache Superset, replicating Google Analytics-like functionalities where appropriate, including:
• Audience overview: Unique visitors, sessions, page views, bounce rate, average session duration
• Acquisition: Traffic sources, referral data (if applicable)
• Behavior: Top pages/resources, content categories performance, download tracking, search queries
• Technology: Browser usage, device types, operating systems.
• Geography: User locations (country, region, city, where data permits)
• implement custom metrics and filtering options and dimensions relevant to specific needs
• Ensure dashboards are user-friendly, visually appealing, and provide actionable insights.
• Develop drill-down capabilities and filtering options for deeper analysis.

Phase 3.4: Testing, deployment and documentation

• Test all dashboards, reports, and data pipelines for performance, accuracy and reliability
• Collaborate with the IPHCE team for acceptance testing and feedback
• Deploy the Apache Superset instance and develop analytics tools into the production environment
• Develop comprehensive technical documentation, including data models, dashboard configurations, and maintenance procedures.
• Develop comprehensive technical documentation and user manuals

Phase 3.5: Training and capacity building

• Develop training materials and provide hands-on training to the IPHCE team on Apache Superset usage, dashboard navigation, custom report creation and troubleshooting
• Offer guidance on data interpretation and utilizing insights for decision-making

Deliverables

• Detailed requirements document and data architecture proposal
• Fully configured and operational Apache Superset instance
• Set of interactive, user-friendly analytics dashboards and reports within Superset, providing Google Analytics-like capabilities
• Implemented data connectors and API integration.
• Comprehensive technical documentation and user manuals
• Training materials and training sessions for the IPHCE team.
• Final consultancy report summarizing achievements, challenges, and recommendations

Duration and reporting

• Duration: The consultancy is expected to be completed within 8 weeks from contract signing
• Reporting: The consultant will report directly to the IPHC-E Systems Librarian/IT Expert

Payment conditions

• The payment terms are structured as follows:
• 50% upon completion of phases 3.1-3.4
• 50% upon completion of phase 3.5

Qualifications

• Advanced degree in information technology and/or software engineering
• Proven knowledge and experience in digital library and in designing user-friendly dashboards and data visualizations
• Demonstrated experience in developing and implementing business intelligence (BI) solutions and data analytics platforms
• Extensive expertise in Apache Superset (installation, configuration, integration, dashboard development, and security management)
• Experience with web analytics concepts and metrics, preferably knowledge of Google Analytics functionalities.
• Familiarity with various data sources, including databases (e.g., PostgreSQL, MySQL), APIs, and flat files
• Strong organizational skills and attention to detail
• Experience with library systems and metadata is an advantage
• Demonstrated work in advanced searching/filtering and data visualization and analytics is an advantage

Duration and reporting