Posted in Business, Excel, Tools & methodologies on Feb 23rd, 2007 No Comments »
If you receive Excel files from external sources (analyst reports, etc.), chances are that you will start encountering the Excel 2007 format. Those files will end in .xlsx, .xlsb or .xlsm instead of the current .xls
Office 2007 has a significant number of advantages, but some of us will be for a while stuck with [...]
Posted in Apple, Software on Feb 15th, 2007 No Comments »
I’ve been recently working on some screencasts to demonstrate data analysis techniques.
Two common features I needed for my screencasts, which I’ve seen many screencasters also use/need, are:
Overlay of a small frame on top of the screencast. For instance, you may want people to see you while you are talking. With computers taking more [...]
Posted in Business, Data analysis, Excel, Tools & methodologies on Feb 12th, 2007 1 Comment »
One very common need in almost any industry is to show a given market, its size, the key participant and how all has evolved over the last few years. I have used since a few years a technique I like, and yesterday I read on Juice Analytics’ weblog an article describing basically the same [...]
Posted in Business, Data analysis, Excel, Tools & methodologies on Feb 12th, 2007 No Comments »
On my job I usually have to present data-rich slides that are the result of analysis on sets of data. One of my pet peeves on this types of slides is the omission of the data source. As I always point out to analysts in training, *please* do yourself a favor: put the footnote [...]
Posted in Rails, Ruby, Software on Feb 8th, 2007 No Comments »
I’m writing a portfolio management application in Rails where complex validations are required between fields of instances. The MVC paradigm of Rails is very good to encapsulate all the business logic of the application in a very readable way.
I found an article here describing how to add validations to a model through plugins, making [...]
Posted in Business, Data analysis, Excel, Tools & methodologies on Feb 1st, 2007 1 Comment »
Tornado diagrams are a classic tool of sensitivity analysis for decision analysis. They are not used as frequently as you would expect, given how clearly they help showing the impact of different variables on a geven outcome. As suggested by Ted Eschenbach on a recent article of Engineering Economist, (issue of 06/22/2006), perhaps [...]
Juan Carlos Méndez-García © 2008 Juan C. Mendez, All Rights Reserved. Contact: ![jcmendez [at] gmail [dot] com](http://jcandkimmita.info/jc/wp-content/themes/jc/img/jcaddr.gif)