This site under reconstruction.
Last week I made some progress in delving into the numbers at work. I was trying to reconcile data between two systems and nothing was tying out. I knew there were some issues, but it couldn’t be that bad. I figured I was not looking at the information correctly. In order to get some kind…
Most of the time, when I do a download of data, the numbers all fall in nice orderly columns, and if I have to do multiple downloads, the data consistently fall into the same columns, from download to download. However, when I do a download from a software called OneSite, the numbers can shift from download…
Ahhh, I’m working with another one of those downloads where the data do not lie in nice columns. I want to be able to compare data between two different downloads to make sure that the data is migrated correctly from one software to another. I would like to make Excel do most of the comparison…
In the effort to expand my horizon beyond finance and accounting and to learn how others think and analyze, I’ve started reading a book about web analytics: Avinash Kaushik’s Web Analytics 2.0. His name and this book keep coming up as THE source on web analytics so I decided to try reading it. It is dense, meaning…
Earlier this week, I read a blog by Paul Krugman on the inaugural of Nate Silver’s FiveThirtyEight website (or maybe the re-birthing of the site). The main point of the blog is that you can’t throw up the data and say “the data speaks for itself”. You need to do some analysis and indicate what the…
I’m still working on converting numbers from PDF files so I haven’t had a chance to write here or come up with decent accompanying pictures. I couldn’t convert from PDF straight to Excel; I had to do a roundabout method via converting first to Word and then copying and pasting from Word to Excel. This method…
You must be logged in to post a comment.