Case Study: Infrastructure Budget Analysis – DPIIT (India)
 |
| DPIIT Budget Allocation Analysis |
Business Understanding
India’s Department for Promotion of Industry and Internal Trade (DPIIT), under the Ministry of Commerce and Industry, allocates funds annually for various industrial schemes such as Startup India, Make in India, NICDIT (Industrial Corridors), and IPR Promotion. This analysis was undertaken to:
Track how budget allocations evolved over 4+ years
Identify key funded schemes and priority shifts
Examine the efficiency of fund allocation (e.g., Establishment vs. Schemes)
Assist stakeholders in understanding how industrial priorities and government strategy are aligned
Data Understanding
The primary dataset originated from a PDF document from the Union Budget, detailing DPIIT’s yearly allocations across schemes and initiatives. Key challenges included:
Extracting semi-structured tables from PDF
Mapping multiple columns across budget types (BE, RE, Actual)
Identifying scheme categories (Establishment, CSS, etc.)
✅ Cleaned dataset output: 135+ structured records
📄 Columns: Scheme_Name, Year, Budget_Type, Amount_Cr, Category, Notes
🛠 Technologies Used
🧹 Data Preparation
PDF to CSV conversion using tabula-py and manual verification.
Created a clean structure:
Mapped multi-year, multi-type columns (Actual, BE, RE)
Removed duplicate/empty rows
Added derived columns like YoY_Growth, Allocation_Trend, and Category
Final dataset exported as dpiit_budget_analysis_full.csv
📊 Data Analysis
Key Questions Addressed:
1️⃣ How has allocation evolved over the years?
📈 Insight: Strategic funding toward startups, but decline in infrastructure & IPR reflects budget reallocation.
2️⃣ Ratio of Establishment Expenditure
Establishment (Secretariat + IP offices) accounted for ~14–18% of total budget yearly.
3️⃣ Top Funded Schemes (FY 2024-25)
Fund of Funds for Startups – ₹1470 Cr
GST Refund (NE/Himalayan) – ₹1382 Cr
IPR & PLI White Goods – ₹318 Cr, ₹298 Cr
4️⃣ Year-on-Year Budget Growth
🧠 Compared to India’s GDP growth (~6–7%), DPIIT’s budget grew slower, showing fiscal discipline.
5️⃣ MSME & IPR Focus Areas
MSME (Seed Fund): ₹175 Cr in FY25, steady rise
IPR: Down from ₹360 Cr to ₹318 Cr
⚠️ Need for consistent funding in innovation/IPR to sustain competitiveness.
📈 Visualizations (Power BI Pages)
📄 Page 1: Executive Summary (KPIs, Line Trends, Donut by Category)
📊 Page 2: Scheme-wise Trends (Top Schemes, YoY Tables)
📍 Page 3: Drilldown by Scheme Type, Region (if enriched)
📋 Summary of Results
✅ Built a clean, structured dataset from unstructured PDF
🔍 Delivered multi-year trend insights for each major industrial initiative
📊 Created interactive Power BI dashboard
📈 Revealed changing government priorities in startup & MSME support
📉 Noted reduction in IPR/infrastructure allocations despite sectoral importance
 |
| impact metrics alongside budget |
📌 Recommendations
🧪 Introduce impact metrics alongside budget (e.g., scheme outcomes, reach)
🔄 Create year-on-year dashboards for continuous tracking
🧭 Recommend policy stakeholders to consider balance between establishment & capital expenditure
📦 Project Status: ✅ Completed
📁 GitHub Repo: https://github.com/rkthedataanalyst/dpiit-budget-analysis
📊 Power BI Dashboard: Available upon request
🗂️ CSV Download: dpiit_budget_analysis_full.csv
🙌 Credits
Source: Union Budget India PDF (Ministry of Finance)
Tools: Python, Power BI, GitHub
Special thanks to the OpenAI platform for NLP + visualization guidance Feel free to fork, suggest improvements, or reach out for collaboration!
No comments:
Post a Comment