Unicorns Worldover By Numbers (total=863)

Indian Unicorns through Sankey Diagram

The story of #Indian #Unicorns. 

The count is 69. Almost half are in #Bangalore. Similarly almost half became #unicorn in #2021.

The total valuation is $235.4 Billion.

Great going! The data is taken from web.

My 10 computer skills learning during COVID-19

What skills I learned during COVID-19. 

I am restricting only to computer related skills. 

1. VBA. I had learned it already. Starting using it again and improved my VBA skills a bit.

2. Python 2.7. I learned it on Ubuntu with its built-in all purpose editor. 

3. Linux and writing shell scripts on Ubuntu. Also learned to upgrade Ubuntu version. 

4. Python3. I bought a new Windows laptop and learned the entire Data Science Stack. Key components were pandas, Matplotlib. 

5. Excel power query. Learned "M" language. 

6. Power BI. Learned DAX expression language. 

7. Power Shell and its scripts. 

8. MacOS. Learning the new MacOS. 

9. 2FA. Setting up two factor authentication, on all important web accounts, which is must these days. 

10. Google App scripts. I started it in 2015, but couldn't take it forward. I started it again. I wrote a script yesterday to create calendar entries from Google Sheets. 

The real challenge is what do I do with it? I am working on finding the answer. 

A quick way of CSR Reporting II Using Excel SUMPRODUCT

Example of SUMPRODUCT function in Excel used for an example from Social Sector. 

Continuing from my previous blog post. I have added a date column. 

Now your manager wants to know the spend on covid relief related activities for January to March of 2021.

You could easily answer the question using SUMPRODUCT function. The expression will look like =SUMPRODUCT(Table1[Amount]*--(Table1[Date]<DATE(2021,4,1))*--(Table1[Date]>DATE(2020,12,31))*--(ISNUMBER((SEARCH("covid",Table1[Purpose],1)))))

The answer is Rs 4,25,000.

I had converted the range in to Excel Table before using it.  

To check if your answer is correct, filter the Date and Purpose column as shown below. Our answer matches and it is correct.

10:59 03-09-2021