Posts

Showing posts with the label spreadsheets

First Blog ever... Spreadsheets!

     One of my least favorite task while at work, is opening emails with large spreadsheets attached with the data representing last day's business performance or transactions. We can view this from many point of views, but for the sake of the discussion in my first internet blog ever, let's pick three. 1) Review yesterday's transactions/performance, which is the sole purpose of the email and the attachment. 2) Incredible inefficient way of transporting large data from one person/system to many users and 3) Time spent every day filtering, sorting, rearranging and formatting the raw data into a pivot table or something "user friendly". So let's begin, reviewing yesterday transactions/performance is not the right way to correctly have a good understanding of the direction of the operation or the business. The worst possible outcome for this is to start making decisions based on a very small set of data because the reality is just snapshot in time, a picture. it ...