← All projects
Completed analysis

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.