victorumeh/HR_Data-Population_data

A Power BI (.pbix) project with two integrated dashboards: an HR analytics dashboard tracking employee demographics, compensation, satisfaction, and attrition across HR, R&D, and Sales — and a Nigeria population dashboard comparing state-level census data from 2006 to 2019. # 📊 HR & Population Data Analysis Dashboard > **Dual-Dashboard Power BI Project** — Comprehensive workforce analytics and Nigeria population insights for data-driven decision making. --- ## 🎯 Project Overview This repository contains a **Power BI (.pbix) file** featuring **two integrated dashboards**: 1. **HR Workforce Dashboard** — Analytics on 1,470 employees across HR, R&D, and Sales departments 2. **Nigeria Population Dashboard** — Census data analysis covering 35 states (2006 vs. 2019) Both dashboards are designed for **stakeholders** and provide actionable insights for leadership decision-making. --- ## 🔍 Dashboard 1: HR Workforce Dashboard ### Key Metrics Tracked - **Total Employees:** 1,470 active staff - **Departments:** HR | R&D | Sales - **Age Distribution:** Under 25 to Over 55 (5 age bands) - **Attrition Tracking:** Yes/No classification - **Overtime Status:** Yes/No monitoring ### Insights Delivered #### 👥 Demographics - **Age Profile:** Majority (554 employees) in the 25–34 age band - **Gender Split:** Male and Female representation tracked - **Marital Status:** Married (34%), Divorced (34%), Single (32%) #### 💰 Compensation Analysis - **Highest Earners:** Managers ($17K–$19K/month average) - **Lowest Earners:** Sales Representatives ($2K–$3K/month average) - **Education Field:** Life Sciences leads in hourly rate generation ($66.83K total) #### 😊 Job Satisfaction - **Most Satisfied Role:** Healthcare Representative (2.79/scale) - **Least Satisfied Role:** Human Resources (2.56/scale) - **Most Satisfied Department:** Sales - **Least Satisfied Department:** HR ⚠️ #### 📈 Career Progression - **Longest Without Promotion:** Managers (~5 years average) - **Average Tenure:** 7+ years across all departments - **Manager Relationship Duration:** Sales department leads (~4+ years) #### ✈️ Travel Distribution - **Non-Travel:** Largest category - **Travel Rarely:** Second largest - **Travel Frequently:** Smallest group --- ## 🗺️ Dashbo …