Analysis of the 7th Population Census of Pakistan

Project Overview

This project analyzes the 7th Population Census of Pakistan using Power BI for data visualization and insights. The project identifies trends in demographics, housing, water access, energy use, and linguistic diversity to provide actionable recommendations.

Note: The dataset does not include data for Karachi, Gilgit-Baltistan, and Azad Jammu & Kashmir.

For a detailed analysis and insights, please refer to the DS331 Project Report.

Group Members

• Muhammad Adeel - 2022331
• M. Hamza Mehmood Zaidi - 2022379
• Nauman Ali Murad - 2022479
• Hassan Rais - 2022212

Course Details

• Course: DS331 - Data Warehousing and Business Intelligence
• Instructors: Dr. Ayaz Umer & Engr. Hafiz Syed M. Muslim
• Institute: Ghulam Ishaq Khan Institute of Engineering Sciences and Technology, Topi Pakistan
• Submission Date: 9th December 2024

Dataset Overview

Sourced from the Pakistan Bureau of Statistics, the dataset includes:

• Population Demographics
• Housing Characteristics
• Water Access
• Literay
• Languages
• Energy Sources

Key Statistics:

• Total Population: 246M
• Population Growth Rate: 2.82%
• Solar Usage: 7% (higher adoption in rural Balochistan)
• Housing Type: 55% Pakka, 24.85% Kacha, 19.58% Semi-Pakka

Tools & Technologies

• Power BI for dashboards and interactive visuals.
• Mapbox for geo-spatial visualizations.
• DAX for calculated metrics.

Key Insights

1. Housing & Energy:
   • Over 50% reliance on wood for cooking.
   • Solar adoption remains low but promising in Balochistan.
2. Water Access:
   • Sindh shows higher use of filtered water, while Balochistan relies on external sources.
3. Linguistic Diversity:
   • Diverse linguistic patterns require culturally tailored policies.
4. Population Growth:
   • Rapid urbanization demands improved planning and infrastructure.

Recommendations

• Expand Solar Programs in rural areas.
• Invest in Water Infrastructure in underserved regions.
• Targeted Education Programs in Balochistan and South Punjab.
• Improve Urban Housing Policies to meet growing demand.

Visualizations

Interactive Power BI dashboards include:

• Population Density Maps
• Housing Infrastructure Charts
• Water Access Visuals
• Linguistic Distribution Heatmaps

License

This project is for academic purposes only.

---

Contact: For queries, email us:

• Muhammad Adeel
• M. Hamza Mehmood Zaidi
• Nauman Ali Murad
• Hassan Rais