Training Course on 'Data Dissemination and Data Warehousing' in Oman
Date: 30 March - 01 April 2014
Venue: Muscat - Oman

In accordance with its 2014 Annual Work Plan, SESRIC organised the Training Course on 'Data Dissemination and Data Warehousing' at the National Centre for Statistics and Information (NCSI) in Muscat, Oman from 30 March to 1 April 2014. Ms. Medine Akyıldız, an expert of the Turkish Statistical Institute (TurkStat), conducted the training.

As defined in the Classification of Statistical Activities (CSA Rev. 1 - October 2009), data dissemination and data warehousing - a statistical activity category under the "Methodology of data collection, processing, dissemination and analysis" domain – includes issues pertaining to policies, strategies, methods and techniques of data dissemination, design and organization of output databases and data warehouses, including feedback from users, communicating with the media, work of NSO press offices, data and metadata presentation, electronic dissemination (Internet), and statistical portals.

The training course on 'Data Dissemination and Data Warehousing' covered the following topics:

  • Information Processes in TurkStat
  • Data Dissemination Policies of TurkStat
  • Database Basics, Relational Database Concepts
  • Database Design
  • Structured Query Language (SQL) Fundamentals
  • Normalization and De-normalization
  • Case Study: Database Design, SQL
  • Data Warehousing: Concepts, Goals and Objectives
  • Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) Terms
  • Data Warehouse versus Operational Database Management Systems (DBMS)
  • Data Mart Methodology
  • Star and Snowflake Schema
  • Data Warehouse Back-End Tools and Utilities
  • Essentials of Business Intelligence
  • Case Study: Data Warehouse
  • Extract, Transform, and Load (ETL) Process
  • Case Study: ETL
  • Data Dissemination Practices at the NCSI of Oman
  • TurkStat Central Data Dissemination Project
  • Discussion on the Data Dissemination Practices of the NCSI of Oman