1.    Elements of context on the intended database

Currently, there is no Energy Information System (EIS) in place in Tanzania to assist with the collection, production, and dissemination of energy statistics. This project intends to create the first EIS in the energy sector in Tanzania. The EIS will be developed considering existing IT systems at NBS or at other branches of the GoT (Government of Tanzania). Legal and technical requirements for IT systems in Tanzania will need to be understood and specified:

•       Legal texts or provisions dealing with specifications for GoT’s and NBS’ IT systems:

o   E-Government laws or decrees

o   E-Government Architecture Framework

o   Other e-Government dispositions and recommendations

•       E-government service platform available or being deployed:

o   Obligations to develop systems that are compatible with National e-Government Service Platforms

o   If practical; the EIS could build on “ready-to-use” e-Government services or components

Back in 2024, a team of two IT experts was recruited to help design the technical needs from all institutions involved in energy statistics. This allowed to pave the way for the definition of the Tanzania Energy Statistics Information System (TESIS) to be implemented under these ToRs

2.    Presentation of the system to be implemented - TESIS

General Presentation

The Tanzania Energy Statistics Information System (TESIS) is an initiative aimed at formalizing and strengthening the production and dissemination of official energy statistics in Tanzania. It is being developed under the leadership of the National Bureau of Statistics (NBS), in collaboration with key stakeholders including the Ministry of Energy, EWURA, TPDC, TANESCO, PURA, TBS, and the Mining Commission. TESIS seeks to transition the current data management approach from spreadsheet-based processes to a more structured, dynamic database system that aligns with international standards.

Objective

The overall objective is to implement TESIS as a modern, open-source, and license-free energy statistics platform. This platform will enable efficient data collection, compilation, processing, and dissemination of energy statistics for Mainland Tanzania. The implementation is expected to enhance the capacity of NBS statisticians and IT staff, support improved stakeholder collaboration, and ultimately lead to more timely and accurate statistical outputs.

Scope

TESIS is designed to serve two main functions:

·         Internal (Back Office): To support NBS in the systematic collection and processing of energy data through structured digital forms and automated routines, thereby improving accuracy and efficiency.

·         External (Front Office): To facilitate dissemination through existing NBS portals such as the Tanzania Integrated Statistical Portal (TISP), making statistics accessible to government agencies, private sector actors, investors, development partners, and the general public.

TESIS integrates a relational database structure based on international standards such as the Standard International Energy Product Classification and the International Standard Industrial Classification. It includes modules for data collection, processing, indicator generation, and dashboard visualizations.

IT and Integration Requirements

TESIS will be configured to integrate seamlessly with TISP, the official NBS platform for data visualization and dissemination. The technology stack must be compatible with TISP, rely on open-source tools, and be license-free to ensure sustainability and local adaptability. Additional requirements include:

·         Training for NBS statisticians to manage forms, calculations, and statistical workflows;

·         Capacity building for NBS IT staff on the technical framework and system maintenance;

·         Development and configuration of custom collection forms aligned with sectoral data needs;

·         Two years of post-implementation maintenance support.

Implementation Phase

The implementation will follow a phased approach:

·         Demonstration Phase: A consultant will visit Tanzania to demonstrate the capabilities of the selected off-the-shelf solution, provide introductory training, and assess integration into TISP.

·         Full Implementation: Upon successful demonstration, activities will include:

o    In-depth training for NBS statisticians, IT staff, and data providers;

o    Migration of existing energy statistics from 2013–2023 into TESIS;

o    Development and adjustment of data collection forms and routines;

o    Fine-tuning, troubleshooting, and initial maintenance.

Key Stakeholders and Roles

TESIS requires clear role definition among three primary stakeholder groups:

·         Administrators: Oversee system management, validate data, configure rules, and generate statistical outputs.

·         Respondents/Data Providers: Submit, edit, and manage data inputs; access historical data and performance benchmarks.

·         Users: Access, visualize, and interact with energy statistics through dashboards and query tools.

Expected Outputs

·         Operational, license-free TESIS platform integrated with TISP;

·         Fully trained NBS staff capable of system administration and statistical production;

·         Migrated and validated time series data on energy statistics;

·         Functional dashboards for internal use and public dissemination;

·         Sustained support and updates over a 2-year maintenance period.

As a result, two deliverables are expected:

·         D1: Demonstration phase of TESIS: Introduction training and assessment of IT compatibility

·         D2: Implementation phase of the full IT solution

3 experts will be recruited and expected to work as a team to achieve the expected outputs:

• EIS Expert: Focused on configuration, training, data migration, and indicator validation.

• IT Expert: Focused on technical development, feature integration, and technical training.

• Web Integrator: Primarily responsible for web integration, mobile compatibility, and technical support.