DASHBOARD OUTPUT FRAMEWORK DATA ANALYTICS ON VARIOUS SDG
DASHBOARD OUTPUT FRAMEWORK DATA ANALYTICS ON VARIOUS SDG SCHEMES
Analysis Framework We shall generate the analysis by different levels as mentioned below Haryana SDG Snapshot SDG wise Performance in Haryana as per Niti Ayog Performance of SDG Targets & Indicators • • Current Performance Indexed & Actual Data Performance of Each SDG Targets & Indicators Budget & Expenditure SDG Targets & Indicator Wise Physical (Scheme) Targets & Achievement By SDG Targets & Indicators • Schemes, Departments & Sectors Contributing to the SDG Type of information on SDGs, Targets and Indicators • • Budget & Allocation Budget Expenditure/ Utilization Planning for Next Year Achievement of Physical (Scheme) Targets Similar Information’s & Insights Can Be Derived at Below Heads Sector Department District
Haryana SDG Snapshot On the landing page…
Haryana SDG Snapshot Sri Manohar Lal Khattar Chief Minister of Haryana No. of SDG 15 SDG Targets 81 SDG Target Indicators 127 Schemes 753 Departments 59 Sector 12 Budget Allocation 2019 -20 (Cr) 36605. 3 Budget Expenditure 2019 -20 (Cr) 34739. 3 Budget Utilization 2019 -20 94. 9% Percentage of Physical Target Achieved 2019 -20 20. 32 Data uploaded 19 th April 2020 Budget Planned 2020 -21 (Cr) Percentage of Physical Target Planned 2020 -21 43567. 3 2095
Performance of All SDGs in Haryana SDG Haryana National State Score (2019) 2019 No. of Departments (2019) No of target Indicator No. of Schemes (2019) Physical Budget for Target Allocation Expenditure Next Year Achieved Planned for (Cr. ) (2019) (Cr) 2020 2019 2020 1 -No Poverty 2 -Zero Hunger 3 -Good Health & Well Being 4 -Quality Education 5 -Gender Equality 6 -Clean Water and Sanitation 7 -Affordable and Clean Energy 8 -Decent Work and Economic Growth 9 -Industry, Innovation and Infrastructure 10 -Reduced Inequalities 11 -Sustainable Cities and Communities 47 43 65 68 36 81 77 71 50 35 61 58 42 88 70 64 10 12 6 8 4 12 7 8 13 10 9 8 5 12 29 109 31 65 6 33 16 33 542 2847 2571 3406 1584 2533 5816 4098 502 2676 2315 3114 1563 2420 5748 3570 3923 5832 3438 4668 1955 3762 1134 2363 157% 52% 30% 44% 0% 30% 62% 55% 331% 2259% 211% 200% 0% 236% 256% 193% 73 65 23 8 82 5518 5079 5603 67% 315% 54 64 8 10 53 6241 5978 9010 26% 774% 49 53 5 10 19 1579 1551 3499 71% 394% 12 -Sustainable Consumption and Production 39 34 40 55 60 66 3 4 3 11 5 12 4 8 10 0 426 170 0 426 153 585 1017 148 83% 46% 71% 121% 103% 153% 76 72 6 12 9 302 295 617 27% 2122% 13 -Climate Action 15 -Life on Land 16 -Peace, Justice and Strong Institutions Data uploaded 19 th April 2020
SDG Wise Performance, Departments & Schemes SDG No. SDG Name 1 No Poverty 2 Zero Hunger 3 Good Health & Well Being 4 Quality Education 5 Gender Equality 6 Clean Water and Sanitation 7 Affordable and Clean Energy 13 Decent Work and Economic Growth Industry, Innovation and Infrastructure Reduced Inequalities Sustainable Cities and Communities Sustainable Consumption and Production Climate Action 15 Life on Land 16 Peace, Justice and Strong Institutions 8 9 10 11 12 Data uploaded 19 th April 2020 50 47 35 10 61 65 58 68 70 39 54 53 49 55 77 40 16 12 23 82 8 11 4 8 5 6 19 10 3 3 53 10 5 4 33 12 8 State Score (2019) 33 5 64 66 6 8 4 73 72 76 National Score (2019) 8 71 60 34 65 10 9 88 31 13 8 81 65 109 8 4 64 29 6 42 No. of Schemes (2019) 7 12 43 36 No. of Target (2019) No. of Dept(2019) National and State Score (2019) 12 10 12 9
SDG Wise Budget Allocation & Expenditure SDG No. SDG Name 1 No Poverty 2 Zero Hunger 3 Good Health & Well Being 4 Quality Education 5 Gender Equality 6 Clean Water and Sanitation 7 Affordable and Clean Energy % of Utilization by SDG Allocation, Expenditure and Plan for next year 502542 3923 2676 2315 2847 2571 3114 1563 1584 1955 2420 2533 5832 3438 3406 4668 No Poverty 93 Zero Hunger 94 Good Health & Well Being 90 Quality Education 91 Gender Equality 99 Clean Water and Sanitation 3762 5748 5816 1134 Decent Work and Economic 8 4098 Growth 3570 2363 Industry, Innovation and 5518 9 5079 Infrastructure 5603 6241 10 Reduced Inequalities 5978 Sustainable Cities and 11 1551 1579 Communities 3499 Sustainable Consumption and 00 12 585 Production 426 13 Climate Action 426 1017 Budget Allocation (Cr. ) (2019) 170 15 Life on Land 153 Budget Expenditure (Cr. ) (2019) 148 Peace, Justice and Strong Budget for Next Year (Cr) 2020 302 295 16 617 Institutions Data uploaded 19 th April 2020 96 Affordable and Clean Energy 9010 Decent Work and Economic Growth Industry, Innovation and Infrastructure Reduced Inequalities 99 87 92 96 Sustainable Cities and Communities 98 Sustainable Consumption and Production Climate Action Life on Land 100 90 Peace, Justice and Strong 98 Institutions % of Utilization =Expenditure/ Allocation*100
SDG Wise Performance - Physical (Scheme) Target Achieved & Planned SDG Name Physical Target Achieved and Planned for Next Year (in Percentage) SDG No. 1 No Poverty 2 Zero Hunger 3 Good Health & Well Being 4 Quality Education 5 Gender Equality 6 Clean Water and Sanitation 7 Affordable and Clean Energy 8 Decent Work and Economic Growth 9 Industry, Innovation and Infrastructure 10 Reduced Inequalities 11 Sustainable Cities and Communities 12 Sustainable Consumption and Production 13 Climate Action 15 Life on Land 16 Peace, Justice and Strong Institutions Data uploaded 19 th April 2020 2122 27 71 153 46 103 83121 394 71 774 26 315 67 55 193 256 62 236 30 0 0 44 200 30 211 2259 52 157 331 Physical Target Planned for 2020 Physical Target Achieved 2019 Target Achieved= Physical Target Achieved/ Target enhanced for Next Year=Next Yr. Revised Physical Target/ Achieved Current Physical Target
Now Let’s Look at Each SDG in More Details One by One…. Lets look at performance and effort for SDG 2 (Zero Hunger) Haryana SDG-2 (Zero Hunger)SDG Targets & Indicators On Clicking – Specific SDGs Departments No. of Target 12 9 Physical No. of Budget Expenditur Budget for Target Total No. of Allocation e (Cr) Next Year Achieved Indicators Schemes (Cr) 2019 (Cr) 2020 (Achieved/ Target) 17 109 5922 5355 6495 100 Some data are overlapped
Performance: SDG 2 (Zero Hunger) SDG Target No. Target Name Haryana State Score 2019 2. 1 Ratio of rural households covered under public distribution system (PDS) to rural households where monthly income of highest earning member is less than Rs. 5, 000 54 65 6 2 15 1475. 75 1296. 23 18 18 2 4 4 1094. 6 30 41 5 4 32 13 33 i 4 3 34 23 1 - 2. 2 2. 3 2. 4 2. 5 2. a 2. b 2. c Percentage of children under age 5 years who are stunted Percentage of pregnant women aged 15 -49 years who are anaemic Percentage of children aged 6 -59 months who are anaemic (Hb<11. 0 g/dl) Percentage children aged 0– 4 years who are underweight Increase investment, including through enhanced international cooperation, in rural infrastructure, agricultural research and extension services Correct and prevent trade restrictions and distortions in world agricultural markets Adopt measures to ensure the proper functioning of food commodity markets and their derivatives and facilitate timely Data uploaded 19 th April 2020 Physical Target Achieved 2019 Physical Target Planned for 2020 1987. 73 100 918. 79 1070. 04 - - 968. 24 617 971. 6 43 492 10 260. 69 238. 63 242. 75 37 11523 2 3 147. 3 121. 59 134. 6 68 245 4 2 44 1945. 55 1759. 19 1684. 26 66 351 - - - - - 1 1 1 30 403. 92 404. 13 60 1777 National No. of No of Score Department target (2019) s (2019) Indicator Budget No. of Budget for Expenditur Schemes Allocation Next Year e (Cr. ) (2019) (Cr) 2020 (2019)
SDG 2 (ZERO HUNGER) - SDG Target Wise Performance, Departments & Schemes arget No. SDG Target Name National and State Score (2019) 2. 1 Ratio of rural households covered under public distribution system (PDS) to rural households 2. 2 Percentage of children under age 5 years who are stunted 2. 3 Percentage of pregnant women aged 15 -49 years who are anaemic 54 2. 5 2. a 2. b 2. c Percentage children aged 0– 4 years who are underweight 65 Data uploaded 19 th April 2020 15 5 33 13 23 4 41 30 State Score (2019) 10 2 4 National Score (2019) 32 3 1 1 4 4 4 34 No. of Schemes (2019) 2 3 Increase investment, including through enhanced international cooperation, in rural infrastructure, agricultural research Correct and prevent trade restrictions and distortions in world agricultural markets Adopt measures to ensure the proper functioning of food commodity markets and their derivatives and facilitate timely No. of Target Indicator (2019) 7 18 18 Percentage of children aged 6 -59 2. 4 months who are anaemic (Hb<11. 0 g/dl) No. of Dept(2019) Departments 3 2 1 44 Target Indicator 1 No. of Schemes
SDG 2 (ZERO HUNGER) - SDG Target Wise Budget Allocation & Expenditure Target No. SDG Target Name 2. 1 Ratio of rural households covered under public distribution system (PDS) to rural households 2. 2 Percentage of children under age 5 years who are stunted 2. 3 Percentage of pregnant women aged 15 -49 years who are anaemic 2. 4 Percentage of children aged 6 -59 months who are anaemic (Hb<11. 0 g/dl) 2. 5 Percentage children aged 0– 4 years who are underweight 2. a 2. b 2. c 1296 919 617 Adopt measures to ensure the proper 30 functioning of food commodity markets and their derivatives and facilitate timely 1476 1988 1095 1070 968 972 261 239 243 147 122 135 Increase investment, including through enhanced international cooperation, in rural infrastructure, agricultural research Correct and prevent trade restrictions 0 0 and distortions in world agricultural 0 markets Data uploaded 19 th April 2020 % of Utilization by SDG Allocation, Expenditure and plan for next year 1759 1684 1946 2. 1 88 2. 2 84 2. 3 64 2. 4 92 2. 5 83 2. a 90 2. b 404 Budget Allocation (Cr. ) (2019) Budget for Next Year (Cr) 2020 2. c 1346 Budget Expenditure (Cr. ) (2019) % of Utilization =Expenditure/ Allocation*100
SDG 2 ZERO HUNGER - SDG Target Wise Physical (Scheme) Target Achieved and Planned for Next Year Target No. Physical Target Achieved and Planned for Next Year (in Percentage) SDG Target Name 2. 1 Ratio of rural households covered under public distribution system (PDS) to rural households 2. 2 Percentage of children under age 5 years who are stunted 2. 3 Percentage of pregnant women aged 15 -49 years who are anaemic 43 2. 4 Percentage of children aged 6 -59 months who are anaemic (Hb<11. 0 g/dl) 37 2. 5 Percentage children aged 0– 4 years who are underweight 2. a 2. b 2. C Increase investment, including through enhanced international cooperation, in rural infrastructure, agricultural research Correct and prevent trade restrictions and distortions in world agricultural markets Adopt measures to ensure the proper functioning of food commodity markets and their derivatives and facilitate timely Data uploaded 19 th April 2020 100 0 0 492 11523 68 245 66 351 0 0 60 Physical Target Achieved 1777 Target Achieved= Physical Target Achieved/ Revised Physical Target for next Year Target enhanced for next year=Next yr. Target/ Achieved current Physical Target
Now Let’s Look at the Performance of a specific SDG Target in detail i. e. performance of individual SDG Target Indicators within a specific SDG target By Clicking =SDG 1 (Zero Hunger) SDG Target 2. 1 Ratio of Rural Households Covered Under Public Distribution System (PDS) Physical Target Budget for Total No. of Expenditure Achieved Department Allocation Next Year Schemes (Cr) (Achieved/Targ (Cr) et) 7 18 1476 1296 1988 100
Performance SDG Target 2. 1: Ratio of Rural Households Covered Under Public Distribution System (PDS) SDG Target Indicato r No. 2. 1. 1 2. 1. 2 Target Indicator Name Percentage of children aged under 5 years who are underweight. Proportion of population (marginalized and vulnerable) with access to food grains at subsidized prices No. of National Haryana State Score Departme Score – 2019 (2019) nts (2019) No. of Schemes (2019) No. of scheme Budget for output Allocation Expenditure Next Year indicators (Cr. ) (2019) (Cr) 2020 (2019) Physical Target Achieved 2019 Physical Target Planned for 2020 6 9 21 1356 1166 1884 100 1 2 2 120 130 104 - - Currently the score for national and state is not available for SDG Target Indicators. A system needs to be put in place for collation of this data and its updating in BAMS. Data uploaded 19 th April 2020
SDG Target Indicator wise Performance, Departments & Schemes: 2. 1 Ratio of Rural Households Covered Under Public Distribution System (PDS) SDG Target Indicator Name Indicator No. National and State Score No. of scheme output indicators (2019) 2. 1. 1 2. 1. 2 Proportion of population (marginalized and vulnerable) with access to food grains at subsidized prices 2. 1. 2 2 1 National Score State Score No. of Schemes (2019) 21 6 Percentage of children aged under 5 years who are underweight. Data uploaded 19 th April 2020 No. of Dept(2019) Departments 9 2 No. Target Indicators Total no. Schemes
SDG Target Indicator Wise Budget-Allocation & Expenditure: 2. 1 Ratio of Rural Households Covered Under Public Distribution System (PDS) SDG Target Indicator No. Target Indicator Name % of Utilization by SDG Target Indicator Allocation, Expenditure and Plan for next year 1356 2. 1. 1 86 1166 Percentage of children aged under 5 years who are underweight. 1884 120 2. 1. 2 Proportion of population (marginalized and vulnerable) with access to food grains at subsidized prices 130 108 104 Budget Allocation (Cr. ) (2019) Budget Expenditure (Cr. ) (2019) Budget for Next Year (Cr) 2020 Data uploaded 19 th April 2020 % of Utilization =Expenditure/ Allocation*100
SDG Indicator wise Physical (Scheme) Target Achieved & Planned: 2. 1 Ratio of Rural Households Covered Under PDS SDG Target Indicator No. Target Indicator Name Physical Target Achieved (Achieved/Target) 100 2. 1. 1 Percentage of children aged under 5 years who are underweight. 2. 1. 2 Proportion of population (marginalized and vulnerable) with access to food grains at subsidized prices 0 Target Achieved= Physical Target Achieved/ Revised Physical Target Data uploaded 19 th April 2020 Physical Target Planned for Next Year 0 0 Target Enhanced for Next Year=Next Yr. Target/ Achieved Current Physical Target
Now, Lets look at the Information at SDG Target Indicator Level By Clicking =2. 1. 1 (Percentage of Children Aged Under 5 Years Who Are Underweight) SDG Target Indicator 2. 1. 1 Percentage of Children Aged Under 5 years Who Are Underweight Total No. Departments of Schemes 17 05 No. of output indicators 21 Physical Target Budget Expenditure Budget for Achieved Allocation (Cr) Next Year (Cr) (Achieved/ Target) 1356 1166 1884 100
SDG Target Indicator in Detail: 2. 1. 1 Percentage of Children Aged Under 5 Years Who Are Underweight Scheme Name Department AGR - Agriculture and Farmer Welfare Scheme for management of crop residue Department AGR - Agriculture and Farmer Welfare Construction of Agriculture Office Building Department Sub-Mission on Seed & Planting Material (SMSP) under AGR - Agriculture and Farmer Welfare National Mission on Agriculture extension and T Department Scheme for National Project on Promotion of Organic HOR - Horticulture Farming Renamed as Organic Farming and Zero budg Scheme for "Silk Samagra" integrated scheme for HOR - Horticulture Development of Silk Industry (ISDSI) Scheme for "Silk Samagra" integrated scheme of HOR - Horticulture Development of Silk Industry (ISDSI) for Scheduled Ca Construction of Veterinary Infrastructure in the State ANH - Animal Husbandry NABARD Assistance Construction of Veterinary Infrastructure in the State -State ANH - Animal Husbandry Assistance Expected Outcome Better Management of Crop Residue in Haryana Physical Measurement unit Targets-201920 Number of Districts nd ea em el h sc exc c ifi in c e d sp laye n p o k dis c i cl be t s ill u j r, es w e rth hem u f sc n e e ev f th go s o to ail ed det e n te e e f. I w mpl co Physical Targets 2020 -21 BE App Expenditur Physical Targets BE App Outlay 2019 e 2019 -20 Achieved-2019 -20 2020 -21 (In Cr) 20 (In Cr) 0 22 0 0 453. 5 0 0 0 10 0 employment generation & upkeep of families of SC farmers staff salaried scheme 0 0 0. 85 0 promote organic farming No of District 0 22 0 0 100 0 Subsidy for Silk Samagra 0 0 0. 55 0. 53 Subsidy for SC Farmers 0 0 0. 6 0 0 0 0 5 0 0 0 0. 2 0 Ensured free insurance coverage of the livestock of Scheduled Caste beneficiaries of the State. White Revolution -Scheme for Assistance to State for Census ANH - Animal Husbandry of Livestock (100% CSS) Honorarium to Enumerator/ Supervisor of Scheduled Caste Category of 20 th Livestock Census work Mid-Day Meal for Primary School Children EDP - Education ( Elementry) To implement Mid Day Meal scheme Number of staff and children 886804 321. 15 300 321. 15 National Programme of Mid-day-meals schools EDP - Education ( Elementry) To implement Mid Day Meal scheme Number of children 561220 50 40 40 Number of workers 0 20770 0 400 453. 45 407. 63 Number of offices 0 170 0 Number of helpers 0 20360 0 Number of employees 0 169 0 275 260 Integrated Child Development Services Schemes (WCD) WCP - Women and Child Development Security of work among Anganwadi workers. Better working environment. Effective monitoring and facilitation of child welfare programme and polices in Haryana Construction of Anganwadi Centres -State Contribution WCP - Women and Child Development Better facilities for pre-primary education and nutrition Number of centres 0 150 0 80 60 10 Construction of Anganwadi Centres Better facilities for pre-primary education and nutrition Number of centres 0 500 0 20 20 1 Supplementary Nutrition Programme WCP - Women and Child Development Improved nutrition among mother and children. Number of benefeciaries 0 1086000 0 150 100 Supplementary Nutrition Programme for Scheduled Castes WCP - Women and Child Development Improved nutrition among scheduled castes pregnant/lactating women and malnourished children Number of beneficiaries 0 20000 0 59. 6 25 Number of smartphones 0 28484 0 60 51. 99 65. 16 Number of growth monitoring devices 0 25962 0 60 51. 99 65. 16 Scheme for Poshan Abhiyan WCP - Women and Child Development Effective implementation and monitoring of Poshan Abhiyan
Now Let’s Look at the Data Differently ……. Departments Contribution to SDG, SDG Target & SDG Target Indicator By Clicking Specific Department at Overall Level AGR - Agriculture and Farmer Welfare Department First, Let Us See the Overall No. of SDG Targets No. of Target Indicators (2019) No. of Schemes (2019) Total Allocation (Cr. ) (2019) Total Expenditure (Cr. ) (2019) Budget for Next Year (Cr) 2020 Physical Target Achieved 2019 Physical Target Planned for 2020 4 9 15 41 1470 1594 2439 1318 1444
Performance of All SDGs in Haryana – Department of AGR (Agriculture and Farmer Welfare Department) SDG No. of Target Haryana National No. of SDG Indicators State Score (2019) Targets (2019) 2019 No. of Total Schemes Allocation (2019) (Cr. ) (2019) Total Expenditure (Cr. ) (2019) Budget for Next Physical Target Year (Cr) 2020 Achieved 2019 Physical Target Planned for 2020 2 - Zero Hunger 43 35 5 11 36 1452 1580 2430 359 423 7 - Affordable & Clean Energy 77 70 1 1 2 2 0 0 3250 3750 9 - Industry, Innovation & Infrastructure 73 65 1 1 1 8 5 1 120 59 10 - Reduced Inequalities 54 64 2 2 2 9 8 8 1543 Data uploaded 19 th April 2020
SDG Wise Performance, Targets & Schemes in Haryana Department of AGR (Agriculture and Farmer Welfare) SDG No. 2 SDG Name No. of SDG Targets (2019) National and State Score (2019) 43 Zero Hunger 9 Affordable & Clean Energy 77 70 73 Industry, Innovation & Infrastructure 65 54 10 64 Reduced Inequalities National Score (2019) Data uploaded 19 th April 2020 State Score (2019) No. of Schemes (2019) 36 11 5 35 7 No. of Target Indicators (2019) 1 1 2 1 1 1 2 No. of SDG targets 2 No. of Targets Indicators 2 No. of Schemes
SDG Wise Budget Allocation & Expenditure in Haryana – Department of AGR (Agriculture and Farmer Welfare) SDG No. 2 SDG Name Allocation, Expenditure & Plan for Next Year % of Utilization by SDG 1452 Zero Hunger 109 1580. 3 2430. 0 7 Affordable & Clean Energy 2 13 0. 2 9 Industry, Innovation & Infrastructure 8 67 5. 0 1. 0 Budget Allocation (Cr. ) (2019) 10 Reduced Inequalities 9 8. 1 Budgetl Expenditure (Cr. ) (2019) 95 Budget for Next Year (Cr) 2020 % of Utilization =Expenditure/ Allocation*100 Data uploaded 19 th April 2020
SDG Wise Performance - Physical (Scheme) Target Achieved & Planned in Haryana – Department of AGR (Agriculture and Farmer Welfare) SDG No. SDG Name 2 Target Achieved and Planned For Next Year (In Percentage) Zero Hunger 359 423 7 Affordable & Clean Energy 3250 3750 9 Industry, Innovation & Infrastructure 120 59 1543 10 Data uploaded 19 th April 2020 Reduced Inequalities 1543 Physical Target Achieved (Achieved/Target Physical Target for Next Year Target Achieved= Physical Target Achieved/ Revised Physical Target enhanced for next year=Next yr. Target/ Achieved current Physical Target
We Can Generate Similar Tables & Informative Graphs at Different Levels Sector District And Filters Can Be Applied at Desired Level
i 3 rc insights Pvt. Ltd. B-718, Noida One B-008, Sector-62 Noida - 201309 FOR FURTHER DETAILS… Rohit Churamani Managing Director rchuramani@i 3 rcinsights. com 9910022956 Manoj Jha Associate Director mjha@i 3 rcinsights. com 9313195176
- Slides: 27