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


Wednesday, May 25, 2022

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.

Saturday, December 11, 2021

KeralaDay3

Kerala Day 3

Periyar Tiger Reserve

We started from Munnar. We came down a moutain range and climed up another. I did not note down the geo locations while coming down and hence those are missing. While we did not see tigers and elephants we did see the following. Great cormorant, Woolly-necked stork, Sambar deer, Bengal monitor, White-throated kingfisher, Brahminy Kite and Gaur.
Please see the photos my facebook.

The path taken



The above interactive visualization was made using Python and Folium. I wanted to make a visualization with Folium for last 2 years!
The folium library in turn uses the leaflet library to render the web-page visualisation. Using Folium I do not have to worry about the HTML, CSS, Javascript code! Plus Python allows me to hold my data in pandas and manupulation of the data becomes convenient. Customizing markers and icons becomes easy using both the pandas and folium libraries.

Folium was not part of the standard Anaconda distribution. It had to be downloaded by using the following command.
$ conda install folium -c conda-forge
at the Anaconda promo. But before that I created a separate environment for folium (folium_project) by closing the base environment. The command was
$ conda create --name folium_project --clone base

Folium allows one to leverage the power of leaflet by just writing a few lines of code. The web-page visualization including its code is on my github account.