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.

Wednesday, December 15, 2021

Indian_Unicorns_Plots

Indian Unicorns


The data was downloaded from web, cleaned using Excel Power Query.

Total number of Unicorns is 51.


Total Valuation of the unicorns 148.45 USD Billion


The total valuation of these unicorns is more than market capitalisation of Infosys and Wipro added together.


1) Valuation plotted against cities and in turn Industries


BengaluruGurugramMumbaiNew DelhiPuneNoidaFaridabadThaneChennaiJaipurEdtechFintechInternetAutoSupply chainHealthMobile_telecommE/comm DTCOtherTravelE/comm DTCSupply chainFintechHealthInternetFintechEdtechE/comm DTCFintechE/comm DTCE/comm DTCFintechE/comm DTCE/comm DTCOtherE/comm DTC0.025.4Valuation ($B)BengaluruChennaiFaridabadGurugramJaipurMumbaiNew DelhiNoidaPuneThaneCity

2) Count of Unicorns per industry per city


The size of the circle is proportional to valuation.

BengaluruGurugramMumbaiNew DelhiPuneNoidaFaridabadThaneChennaiJaipurEdtech3Fintech7Internet7Auto2Supply chain3Health1Mobile_telecomm1E-comm DTC1Other1Travel1E-comm DTC4Supply chain3Fintech1Health1Internet1Fintech2Edtech2E-comm DTC1Fintech1E-comm DTC1E-comm DTC2Fintech1E-comm DTC1E-comm DTC1Other1E-comm DTC13.011.9Valuation ($B) [sum]BengaluruChennaiFaridabadGurugramJaipurMumbaiNew DelhiNoidaPuneThaneCity [csvDistinct]

Credit:app.rawgraphs.io for graphics and CB Insights for data