Posted on February 16th, 2009 by Joseph Harris
One of the most time consuming parts of producing a scheduled report is updating all of the charts in the report. Many times, an analyst only wants to show the last 7 days or the last 6 months of data and not the entire data set. To achieve this, the analyst changes the the Y [...]
Posted on January 6th, 2009 by Joseph Harris
Finding and displaying the percentile of specific results can be valuable to your audience. Sometimes stand alone numbers do not tell the story, but, if I know that 80% of the other results are lower than me, that tells a more complete story…
Posted on January 5th, 2009 by Joseph Harris
Quick an easy method of making your Excel graphs more appealing, by adding pictures.
Posted on December 15th, 2008 by Joseph Harris
Even Though we are progressing towards a paperless society, the majority of executives still print the documents you send them. They may print them to bring them into meetings or to share with someone else. I have seen many a corporate manager print a new spreadsheet they received from their staff analyst only to become angered [...]
Posted on November 20th, 2008 by Joseph Harris
Creating Pareto Charts
Posted on November 16th, 2008 by Joseph Harris
Best practices for creating dashboards
