Monday, August 15, 2022

Ramsar Sites in India

India, on its 75th year of Independence (15th August), achieved a milestone of 75 Ramsar sites. 


It recently added 11 more wetlands to the list of Ramsar sites to make total 75 Ramsar sites covering an area of 13 lakh 26 thousand 677 Hectare in the country. 


I have created an interactive map. Kindly visit the map at https://andybandra.github.io/ramsar_india/ You can see and click the map shown below.


On the map you may click an icon to get the name and state of a site, and its area in hectares.  


India is one of the Contracting Parties to Ramsar Convention, signed in Ramsar, Iran in 1971. India signed it on 1st February 1982. These are wetlands deemed to be of "international importance" under the Ramsar Convention.


What is RAMSAR Wetland Sites

The Ramsar Convention is an international treaty for the conservation and sustainable utilization of wetlands, recognizing the fundamental ecological functions of wetlands and their economic, cultural, scientific, and recreational value.


Tamil Nadu has the highest number of Ramsar Sites in India with 14 Ramsar Sites. The largest site is marked in blue icon. It is the Sundarbans National Park a national parktiger reserve and biosphere reserve in West Bengal,


The list is available at https://en.wikipedia.org/wiki/List_of_Ramsar_sites_in_India.



75 Ramsar India Sites

Wednesday, June 1, 2022

CSR-Dashboard

The Benefits of Digital Dashboards for Corporate Social Responsibility

Updated on

Introduction

Corporate Social Responsibility (CSR) is a self-regulating business model that helps a company be socially accountable. In this digital age, dashboards have become a significant tool in managing CSR activities effectively. Let's delve into the benefits of digital dashboards for CSR.

Real-Time Data

Digital dashboards provide real-time updates and insights, enabling companies to make immediate decisions based on current data. This is particularly useful in CSR initiatives where timely response is crucial.

Improved Transparency

With digital dashboards, companies can share their CSR progress with stakeholders and the public in a transparent manner. This can enhance the company's reputation and build trust among its stakeholders.

Efficient Resource Allocation

Digital dashboards allow companies to see which CSR initiatives are performing well. This can help them allocate resources more efficiently, ensuring that their CSR efforts have the greatest impact.

Let's begin:

I have developed a very simple and easy to understand spend dashboard for corporate social responsibility. it is intended for senior CSR executives such as CSR committee members.


How is this dashboard organised?

On the left hand side, you have the KPIs. and on the right hand side, you have the respective spend shown in percentage of the total. In KPIs, you have the yearly spend, spend by domain (such as education), spend by location ( e.g. state), spent by NGO. It quickly gives a bird eye view of the spend. By choice, it's a static dashboard. It can be updated and customised as often as required. It can be put in conference room, in the reception area for communicating the progress of CSR spend.


Reading the dashboard:

Let's say you want to know the spend on Domain – health. It is shown as 27% as a numeral as well as a corresponding darkened arc in a circle. The arc starts from equivalent position of 9 o'clock on the clock face. Any progresses clock wise. Showing the data in percentages of the total, helps in getting a grasp of the size of the proportion. Let's take another example. We want to know the spend on the top NGO as a percentage of the total. It is shown as 35%. This will help you take an executive decision such as reducing the spend on the top NGO.


How is this dashboard made?

It is drawn using 100% Visual Basic For Applications (VBA). It is customisable in so many different ways. Sustainable Development Goals (SDGs) can also be linked. Similarly you can add photos, logos, other art clippings. 

The concept can be extended to cover other functions namely Sustainability, Marketing, Social Media, Sales, Admin. And many more.

It is not using chars from excel and pasting it in Dashboard. It uses native shape objects of PowerPoint. 

But it uses excel for data and necessary calculations. The VBA code resides in Excel. You may put your actual data. Such static visualisations have great impact in corporate conference room discussions. 


Conclusion

Digital dashboards offer numerous benefits for managing CSR initiatives. By providing real-time data, improving transparency, and aiding in resource allocation, they can help companies make a significant social impact.


Hope you like it. Please do give your suggestions. 

CSR dashboard showing KPIs and the associated progress using circular arcs and percentages


Monday, May 23, 2022

Organising Data in Spreadsheets

Organising data in spreadsheets

The guide is designed so that you may down load it and keep it handy with you for a reference.

For a detailed explanation, please click the blog post.

The below guide explains how to organise data in spreadsheets.

Infographics to download

 

Thursday, May 12, 2022

Nifty50_index

Nifty50_Index: Rs 2 trillion AUM mark has been breached by ETFs and Index funds tracking the Nifty 50 Index

  • April_2022: AUM reaches Rs 2 trillion
  • Aug_2020: AUM reaches Rs 1 trillion
  • Dec 2001: First ETF linked to Nifty50 - launched



Nifty50 Index


Sunday, May 8, 2022

Indian_Unicorns_by_2025

 India could have 250 unicorns by 2025.


Indian Unicorns by 2025
Growth of Indian Unicorns

#vba

#powerpoint

#excel

#India


Sunday, December 26, 2021

How chart can be made interactive using Altair Vega-Lite Python and Pandas.

Interactive Altair Vega-Lite Plot
using Python and Pandas

Milk Production over years

Click a country name, to see its chart

MMT is million metric tonnes

India is #1, followed by #USA


The interactive Chart


The code is available on my github account.