From socioeconomic data to a poverty trend dashboard
What my India poverty-rate analysis taught me about cleaning data, choosing a measure, and keeping a chart within its evidence.
From workbook to dashboard
During a Data Analytics Internship at CSBPOX with IBM SkillsBuild in July–August 2025, I worked on an India poverty-rate analysis covering 2014–2023. I used Microsoft Excel to clean and structure socioeconomic data, then built interactive views in Power BI to make the trend easier to explore. The project outputs were a prepared dataset, interactive dashboard views, and concise descriptive observations.
Why the definition matters
“Poverty rate” is not one interchangeable measure. A poverty estimate depends on its underlying data, the threshold or indicators used, the survey period, and the method for comparing households or years.
For example, NITI Aayog’s National Multidimensional Poverty Index describes deprivation across 12 indicators spanning health, education, and living standards. It combines a headcount ratio with the intensity of deprivation. The World Bank’s 2025 update to India’s international poverty trends instead discusses consumption survey data, international poverty lines, and methodological adjustments for comparing 2011–12 with 2022–23. Those series answer different questions and should not be mixed into one chart without explanation.
A careful analysis workflow
My project work moved from data preparation to exploration and communication. The broader lesson I take from it is to keep the measure, units, period, and source attached to each view; check missing values and unusual changes before interpreting a trend; and separate what a chart shows from what might explain it. A descriptive dashboard can show a pattern, but by itself it cannot establish why that pattern occurred.
The public case study describes the dataset used in my internship project and does not present it as the latest official estimate. The original project record should accompany the chart with its exact data source and indicator definition before it is published as a research result.
Open thread / public discussion
Join the conversation.
Comments will appear after a public GitHub Discussions repository is connected and configured.