NREGA DATA ANALYSIS - POWERBI

Problem Statement:

NREGA is a vital initiative to alleviate rural unemployment and poverty. This project seeks to address several key questions and challenges associated with NREGA:

• How effective is NREGA in providing employment opportunities to rural households?

• Are there regional disparities in the implementation and outcomes of the scheme?

• What is the utilization of the allocated budget, and how does it correlate with employment generation?

• What are the key factors contributing to the completion of NREGA works, and are there any roadblocks to its success?

• Can data-driven insights guide policymakers and administrators in optimizing the scheme's impact?

Insights from Analysis:

1. Program Reach and Activity:
   • NREGA spans 34 states and 736 districts, showcasing its extensive coverage.
   • With 734 ongoing works and 670 completed, the program actively employs while ensuring project conclusion.
2. Financial Investment and Earnings:
   • A substantial total expenditure of 5.47 million underscores the government's commitment to rural development.
   • The average earnings of NREGA workers at 276.05 rupees present a significant income source for rural households.
3. State-Level Engagement and Expenditure:
   • Uttar Pradesh leads with 12,045,343 active job cards, contributing 12.41% to the total.
   • Tamil Nadu's highest total expenditure of 727,295.35 lakhs indicates significant financial commitment.
4. Resource Management and Focus Areas:
   • Positive correlation in expenditure categories highlights effective fund management.
   • Category B works, comprising infrastructure projects, dominate expenditure at 45.01%, emphasizing rural infrastructure development.
5. Community Engagement and Workforce Composition:
   • Varying engagement levels across communities and states, West Bengal leads in SC workers.
   • A diverse workforce includes 14.67% SC workers, 12.07% ST workers, and 73.27% other active workers.
6. Workforce Impact on Program Effectiveness:
   • A decrease in active workers correlates with a decrease in the volume of work undertaken, impacting program effectiveness.
   • Total expenditure tends to increase with the completion of more work, showcasing the financial implications of project completion.

Recommendations:

• Enhance Engagement: Given the significant disparity in the distribution of active job cards across states, efforts should be made to enhance engagement in states with lower participation.
• Improve Fund Management: The positive correlation between total expenditure and administrative expenditure suggests efficient fund management. However, strategies can be developed to further optimize the use of funds.
• Address Divergence: The divergence between the number of job cards issued and active workers, especially in states like Maharashtra, needs to be addressed. This could involve investigating potential barriers to participation and implementing measures to overcome them.
• Promote Inclusivity: While there is a diverse workforce engaged in the NREGA program, efforts should be made to ensure more equitable participation across all communities. This could involve targeted awareness campaigns or special provisions for underrepresented communities.
• Monitor Expenditure: Regular monitoring of expenditure across different categories (like NRM, Category B Works, and Agriculture & Allied Works) can help ensure balanced resource allocation and identify areas that may need more investment.