International Research Journal of Engineering and Technology (IRJET)
e-ISSN: 2395-0056
Volume: 12 Issue: 11 | Nov 2025
p-ISSN: 2395-0072
www.irjet.net
Designing Dashboard for Analyzing Daily Water Consumption per Capita in Saudi Arabia Regions Based on Data Science Concepts Fahad Mesfer F Alsubaie 1, Awad Anis Abdullah1 1College of Computing, Fahad Bin Sultan University, Saudi Arabia
---------------------------------------------------------------------***--------------------------------------------------------------------1.2 Problem Statement and Motivation
Abstract - This study analyzes the average daily water
consumption per capita across Saudi Arabia’s thirteen regions in 2022 using data from the Saudi Open Data Portal. The dataset, managed by the Ministry of Environment, Water and Agriculture, was cleaned and visualized through Google Sheets and Looker Studio. An interactive dashboard with bar and pie charts highlights regional differences, showing the Central and Eastern regions with the highest consumption and Najran and Asir with the lowest. The results demonstrate how visual analytics can enhance understanding of national water use and support sustainability efforts. The designed dashboard is analyzed from security and privacy perspectives.
Understanding regional differences in water consumption is critical for developing informed conservation strategies. Although national averages are available, regional variations are not easily interpreted by the general public or policy makers. Therefore, this study leverages open government data and modern visualization tools to present regional consumption patterns in a clear and accessible form.
2. METHODOLOGY This section is structures so that it presents a description about used data set and its resource, connection data set with dashboard, and visualization of data.
Key Words: Water Consumption, Saudi Arabia, Data Visualization, Google Looker Studio, Sustainability, Security, Privacy
2.1 Data Collection and Preparation (Cleaning)
1. INTRODUCTION
The dataset used in this study, entitled “Average Daily Water Consumption per Capita for All Regions of the Kingdom (2022),” was obtained from the Saudi Open Data Portal managed by the Ministry of Environment, Water, and Agriculture [3]. It contains 13 entries, each representing one administrative region of Saudi Arabia, and two attributes: Region and Average Daily Per Capita Consumption (Liters/day). The file was cleaned in Google Sheets by removing empty rows, translating Arabic headers to English, standardizing region names, and verifying values against the ministry source.
Water is one of the most critical natural resources for human survival and economic growth. In Saudi Arabia, water sustainability has become a key national priority due to limited natural freshwater sources and increasing population demands [1]. This study explores official data published by the Ministry of Environment, Water and Agriculture, which reports the average daily per capita water consumption across the Kingdom’s regions for 2022. The objective is to analyze this data using modern data visualization tools and highlight consumption differences among regions. By building an interactive dashboard, this project aims to simplify the understanding of national water use and demonstrate how data visualization can support environmental awareness and policy planning.
Table 1 summarizes the average daily water consumption per capita across Saudi Arabia’s thirteen regions in 2022. The Central and Eastern regions recorded the highest levels (over 350 L/day), while Najran and Asir had the lowest (below 170 L/day). These variations reflect the influence of geography, climate, and population on water use across the Kingdom.
1.1 Background and Objective
Table -1: Average Daily Water Consumption per Capita in Saudi Arabia’s Regions (2022)
Water is an essential natural resource, and its sustainable use is a growing global concern. In Saudi Arabia, the scarcity of natural freshwater resources makes efficient consumption a top national priority [2]. The goal of this project is to analyze the average daily water consumption per capita across the thirteen administrative regions of the Kingdom for the year 2022 and visualize the findings through an interactive dashboard.
© 2025, IRJET
|
Impact Factor value: 8.315
|
Region
Average Daily Consumption (L/capita/day)
Central
352.7
Eastern
352.4
Al Madinah
327.5
ISO 9001:2008 Certified Journal
|
Page 389