Data Analyst

Who doesn’t know Excel? A green application to tabulate data, quite popular in any working industries, right?

I used to think being able to manage Excel has already been great. But, it is not really. Talking about Excel, we are only controlling around 1 million rows of data.

Did you know? There is a tool to tabulate number with infinity numbers of rows, one of them is… A friend of mine, MI, is an expert in this tool. He is a data analyst. Excel? I think it is just a piece of cake for him.

Then I wonder, why would a data analyst need a tool with infinity limits of rows? What do they need to cound?  What kind of information do they need to analyze that they need this kind of tool? Why does Excel is not enough for them? There are millions of rows there.

Then his story impressed me. He needs to analyze financial report, comparing company A to other companies in the same industries. He would check on the total amount of loan for example, has 12 zeroes, checking how many active accounts at that bank, 3 million for example, then apply ‘one to one’ and or ‘one to many’s rule, listing it one by one, checking the due date, date of payment, interest rate, rest of payment to be deposited and so on. If he or the other data analyst have to use excel to process the data, that one with only around 1 million rows. He can’t imagine how inefficient it will be because they are going to Copy Paste the date to different tab. Possible but it gonna takes a lot of time.

Now that I usually only use not more than 100 rows of Excel, I am amazed there are people in this world need to use the one with infinity rows.

Author: Rena

a young perpetual learner loves to meet new people and explore new places as well

Leave a Reply

Your email address will not be published. Required fields are marked *