India Poverty Rate Analysis
An Excel-to-Power BI data project preparing socioeconomic data for an interactive view of India’s 2014–2023 poverty-rate trend.
Tools / technologies
- Microsoft Excel
- Microsoft Power BI
- Data cleaning
- Data visualization
Project context
I worked on this analysis during a Data Analytics Internship at CSBPOX with IBM SkillsBuild, from July to August 2025. The project explored a socioeconomic poverty-rate series for India covering 2014–2023.
My workflow
I used Microsoft Excel to review, clean, and structure the source data, then built interactive Power BI dashboard views to make the trend easier to scan and compare. I focused on taking the data from a working table to a prepared dataset, then to a readable set of views and concise written observations.
Project outputs
- A prepared dataset for analysis
- Interactive Power BI dashboard views
- Short descriptive observations grounded in the dataset
How I interpret the series
“Poverty rate” can refer to different measures, thresholds, and survey series. I keep this project’s conclusions descriptive and tied to the dataset used; I do not present its chart as a causal explanation or as the latest official estimate. A data source and indicator definition should accompany the public case study when the original project materials are available.