Archive for the ‘Business Analyst’ Category

Automatic Updating “Dynamic” Charts in Excel

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 [...]

Percentile – Finding the Percentrank() in Excel

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…

Images and Pictures in Charts – Excel Graphs

Posted on January 5th, 2009 by Joseph Harris

Quick an easy method of making your Excel graphs more appealing, by adding pictures.

Print Area and Print Preview – Analyst Best Practices

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 [...]

How to Create a Pareto Chart in Excel

Posted on November 20th, 2008 by Joseph Harris

Creating Pareto Charts

Dashboarding Best Practices

Posted on November 16th, 2008 by Joseph Harris

Best practices for creating dashboards