Study. Reuse.

Free tools for personal and professional use. New techniques. Case studies showcase, methodology and implementation details.

Welcome to BabaGyan


CLT20 2013 Twitter Analysis of League



CLT20 2013 Twitter Analysis of League

CLT20 just concluded with Mumbai Indians winning the trophy. Congratulation!!!! Mumbai take the double of the IPL and Champions League title the same year. Chennai Super Kings did it in 2010.
Sachin Tendulkar completed 50000 Runs in Cricket... AWESOME!!!
Here is how the Twitter world was discussing the different topics in Champions Trophy T20 this year (2013).

Click here to find a graphical picture of the tweets during CLT20 2013. Total list of topics are here.
This is our very own Social Media Bigdata project using Twitter Firehose - Live Tweets. There were about 300 to 1000 tweets analysed Live per second during the matches.

TWITTER ANALYSIS OF CLT20 LEAGUE
00

Babagyan CLT20 2013 Analysis

This is How it works at the technical level.

The twitter data is loaded in to the Analytics server by using Python program. This ocean of tweets is kept into the BabaGyan Gyankund (knowledge base) for further analysis.
Then another program (R with Python) scans the GyanKund tweets and uses its Intelligence to find the relevance and then sends it to BabaGyan.com database and web server.
The database is then accessed by BabaGyan.com's Analytics page to show analysis results in text and graphical format.


Tool: Daily Expense Tracker in excel - free to use and share



Tool: Daily Expense Tracker in excel - free to use and share How many times it has happened that you wondered where all your money went? Where did you spend all of it? How frequently do you take out cash and spend it even more frequently and immediately.
All you wanted is to know a trend of your spending so that you can plan and if necessary, control it.

There are many sites and phone applications that are available for this but not all are easy to use.
Every application has its own method of usage - some ask you to create and define bank accounts while others just don't seem to be secure. All you really want is is place where you can mention how much you spend and earn and keep a track.

Here is an option for you in our very own EXCEL spreadsheet by BabaGyan.
All you have to do is update the rows with your account transaction - both credit and debit. Also available is a Cash sheet where you should enter your cash transactions. The ATM withdrawal transaction from Account tab is added into Available Cash in your Cash tab. This way, you don't need to worry about Cash Credits at all.

There is also an optional Forecasting tab. Here you should list down all the routine transaction like Rent payment, Fuel expenses, EMI installments, etc. This will help you predict how much you can save at the end of the month. If you need more to save, just spend less - at least try for it.

In short - Update the cells in Orange before starting to use the sheet and daily update the cells in Green.

Good luck in using this. Free download and share. You can provide your feedback or queries on our Contact page or comments on this post. Here is Expense tracking Month Excel file to download.


Tool: Project Stages Tracker in excel for Startups



Tool: Project Stages Tracker in excel for Startups - free to use and share In Project Management, there are many phases or stages such as Opportunity Discovery, Contract negotiation, Contract Sign off, Development, Testing and Implementation. Sometimes it is all followed by Support, Enhancement and Maintenance.

There are different tools - free and paid that are well verse of each phase of the Project Execution. However, for initial Start-Ups or Small Businesses, it will not be feasible to start using any available tool unless there is visibility of how the Business is going to grow.

For this reason and many other, we have created a simple to use to use and track excel - it spans from Opportunity to Delivery of Projects.

This is free to use and share EXCEL spreadsheet by BabaGyan.
There are three sheets - Report, Tracker and Values. The Report tab provides you with the summary of your business. The Values has the List of Values that you can use. Currently it is defined for Stages and Products/Solutions on BabaGyan.com.
The Tracker sheet is the one where you will list down all your actual Business Opportunities and Projects.

Good luck in using this. Free download and share. You can provide your feedback or queries on our Contact page or comments on this post. Here is Project Tracker Excel file to download.