![Page 1: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/1.jpg)
Managing Managing Statistics at States and Statistics at States and Federal MDAs level using e-Template Federal MDAs level using e-Template
Platform under NSSPlatform under NSS
By
B i y i F a f u n m iHead (Data Management)
National Bureau of Statistics
![Page 2: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/2.jpg)
Past SituationPast Situation
• Past methods of assembling and managing administrative statistics rely on manual technologies which are slow and in the long run expensive. The methods are also very inefficient.
Sources Users
![Page 3: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/3.jpg)
Modern MethodModern Method
Dataset 1
Dataset 2
Dataset 3
Database
Management
System
Task 2
Task 2
Task 3
Task 1
Report 1
Report 2
Report 3
Report 3
• The foregoing shortcomings of assembling and managing administrative statistics make it desirable to introduce new technologies into the process.
Database(s)
![Page 4: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/4.jpg)
Need…..Need…..
• System Coordination
• Physical connection
• Well developed and structured Content – SSYB eTemplateeTemplate /database– Sector Statistics eTemplate eTemplate /database– Micro data Management System
![Page 5: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/5.jpg)
Statistical Coordination at Federal levelAlH. R.A. SanusiDirector CPTC
National Coordinator
AlH. R.A. SanusiDirector CPTC
National Coordinator
Coordination @ MDAs
&Research Institutes
Coordination WithinNBS
Supervisor A
Supervisor…..
SupervisorX
Officer I Officer…. Officer K
Ministry A
Departments/Agencies under
Ministry A
Ministry B
Departments/Agencies under
Ministry B
Ministry X
Departments/Agencies under
Ministry X
Department 1
Macro dataset
Department 2
Macro dataset
Department 7
Macro dataset
Research InstitutesUnder Ministry A
Research InstitutesUnder Ministry B
Research InstitutesUnder Ministry X Micro Dataset Micro dataset Micro dataset
![Page 6: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/6.jpg)
Statistical Coordination in NBS (States)
NSDSDirector CPTC
NSDSDirector CPTC
Mr. B.O Amobi (Coordinator)
Mrs. N.F. Nwokedi (Coordinator)
Mrs. F. O. Obikudu(Supervisor)
SE States
Mr. A.D. Mustapha(Supervisor)
SW States
Mr. M.Simon (Supervisor)SS States
Mr. S.B Harry (Supervisor)
NC States
Mr. J. Aikhionbare (Supervisor)
NW States
Mrs. F.A. Obamedo(Supervisor)
NE States
F. AkinyekeAbia
ebonyi
W. TariahAnambra
ImoEnugu
B. AkanniEkitiOndoOsun
A.A. AyoolaLagos OgunOyo
F. Adegoke•Akwa Ibom
•Bayelsa•C/Rivers
E.E NtukidemDeltaEdo
Rivers
L.A. IbrahimKogi, Kwara
FCTnassarawa
C.C. MbahBenueNiger
Plateau
NwokochaKebbi
SokotoZamfara
N.D AkomaJigawa, Kano
Kadunakatsina
O.M. OlatunbosunAdamawa
Gombetaraba
B. OdeBauchi BornoYobe
![Page 7: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/7.jpg)
.. an e-Statistics grid : MDA .. an e-Statistics grid : MDA connection to NBSconnection to NBS.. an e-Statistics grid : MDA .. an e-Statistics grid : MDA connection to NBSconnection to NBS
SSA & other
Connections
CPTC
CPTC
CPTC
CPTC
CPTC
CPTC
Codex Mode
m
Codex Mode
m
Cisco 2620
Router
Cisco 3640
Router
Fibre Digital Subscriber Line DSL
LAN
25
1
NBS Data Center
MDAsMDAs
![Page 8: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/8.jpg)
Internet
Cloud Covering all Data Producers, Data
Suppliers & Data Users in Nigeria
The VPN Cloud Of the NigerianThe VPN Cloud Of the NigerianData Nervous Systems (NDNS)Data Nervous Systems (NDNS)
![Page 9: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/9.jpg)
NBS & Federal MDAs VPN Design
Health
Customs
Finance
Account General
Labour
Cycle nameCycle name
NBS DC
Petroleum
Interior
Information & Comm.
Head of Service
National Assembly
CBN
NPopC
TransportEducation
Agric
Industries
Energy
Active
In progress
![Page 10: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/10.jpg)
Connectivity between NBS and SSAs
V-SAT connecting SSA in Niger State to NBS
V-SAT connecting NBS Hqrt to all SSAs
![Page 11: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/11.jpg)
NBS Failover Centre, Lagos
![Page 12: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/12.jpg)
April 21, 2023 Dr. V.O. Akinyosoye
Sever Room• Main Server, Proxy Server, Application Server , Communication Server, Portal Server• Storage Server & SQL Server
MDAs Server, UPS & Stabilizer Room
Communication Room
NBS Data Centre
![Page 13: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/13.jpg)
Content Development
![Page 14: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/14.jpg)
Sources of StatisticsSources of Statistics
14
![Page 15: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/15.jpg)
Features of the ApplicationFeatures of the Application
• User friendly
• Running on Windows7, XP, Vista, can be upgraded to
run on any new window environment
• Developed to have two Interfaces
– Administrator
– Users
• Backend database is Access and SQL
![Page 16: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/16.jpg)
State Statistical Year Book, SSYB
![Page 17: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/17.jpg)
The eTemplate/databaseThe eTemplate/database
User IconAdmin Icon
![Page 18: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/18.jpg)
Users’ Login windowUsers’ Login window
![Page 19: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/19.jpg)
Applicatio
n Window
Applicatio
n Window
![Page 20: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/20.jpg)
The Template Menu BarThe Template Menu Bar
![Page 21: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/21.jpg)
Table of Table of ContentContent
![Page 22: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/22.jpg)
![Page 23: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/23.jpg)
![Page 24: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/24.jpg)
Ministry Department & AgenciesMDAs
![Page 25: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/25.jpg)
List of Sectors coveredList of Sectors coveredThe 30 data groups, according to the International Standards of Industrial Classification (ISIC) and other UN classification systems:
1. Agriculture 16. Public Finance 2. Water Resources 17. Prices and Price Indices3. Petroleum 18. National Accounts4. Mining & Quarrying 19. Public Order, Crime & Justice 5. Manufacturing 20. Education6. Electricity Supply & Demand 21. Population & Vital Statistics7. Water Supply 22. Health and Human Services8. Housing, Building & Construction 23. Employment & Labour9. Distributive Trade & Services 24. Environmental Statistics 10. International Trade & BOP 25. Membership Organisations11. Hotels, Restaurants & Tourism 26. Recreation & Sporting Activities12. Transport 27. Religion & Related Activities13. Information and Communications 28. Public Administration &
Security14. Money & Banking 29. Meteorological Statistics 15. Financial Intermediation 30. Research and Development
![Page 26: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/26.jpg)
Compendium Compendium
Compendium of Terms,
Concepts, Definitions
& Methodologies
![Page 27: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/27.jpg)
Details of the CompendiumDetails of the Compendium• NBS has produced a compendium of Statistical Terms,
Concepts, Definitions and Methodologies for Data Production and Management in Nigeria covering 30 data sets and about 54,000 variables.
• The compendium helps every data producer and user to know
the sources of all types of socio-economic data about Nigeria,
• the definition of variables on which data are being or will be collected, preserved and disseminated.
• The process will also help to coordinate statistical operations in the country since state and local government version of the compendium will also be developed
![Page 28: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/28.jpg)
Coding and Coding and ClassificationClassification
• Sectroral Data Divisions used in compiling the Statistical Compendium follow the International Standard Industrial Classification (ISIC) Code and UN classification systems:
• The classification follow Division - Item - Details [DID] coding system
• The classification is to maintain standard among the Data Producers and Users as a step toward Statistical Data and Metadata Exchange Initiative
![Page 29: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/29.jpg)
Coding and Classification – Sector StatisticsCoding and Classification – Sector Statistics
29
![Page 30: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/30.jpg)
Coding and Classification – e.g. Education Coding and Classification – e.g. Education StatisticsStatistics
30
80 01
Division Item Code
![Page 31: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/31.jpg)
DIVISION
ITEMS
DETAILS
![Page 32: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/32.jpg)
• Coverage– Year– Month– Quarter– Week– day
• Location– National– State– City– LGA
![Page 33: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/33.jpg)
MDA, Data Capture Template
![Page 34: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/34.jpg)
![Page 35: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/35.jpg)
![Page 36: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/36.jpg)
![Page 37: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/37.jpg)
![Page 38: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/38.jpg)
Dissemination to users
![Page 39: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/39.jpg)
Data Portal - Data Portal - disseminationdissemination
![Page 40: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/40.jpg)
DevInfo - DevInfo - DisseminationDissemination
![Page 41: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/41.jpg)
Access to Micro Level Data
![Page 42: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/42.jpg)
![Page 43: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/43.jpg)
![Page 44: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/44.jpg)
Benefits Benefits
• Data Consistency
• Reduce data Conflict
• Timely Data release
• Reduce error emanating from data entry
• Provide level of data clearing mechanism
• Etc…
![Page 45: Managing Statistics at States and Federal MDAs level using e-Template Platform under NSS](https://reader035.vdocuments.us/reader035/viewer/2022081519/568145b2550346895db2b557/html5/thumbnails/45.jpg)