A better tool than excel for reporting/charting?
Posted on 2011-02-25
I'm a reporting analyst that supports a call center. We collect and report on a wide range of data, like phone calls (volume, hold time, etc), cases (like trouble tickets, so, volume, aging, etc) and many more. Most of the data is imported to sql server and we typically create reports in excel via a connection to the sql server.
Tables, pivots and charts are frequently used and do a pretty good job, however, it seems to be more difficult that it should to create a meaninful graph in excel (2003). We've been looking at Tableau, but, I think will only get the desktop version first, so, not sure if that will really help our users (I think the reports would be in the form of a pdf, so, not dynamically updated).
I'm sure many of you have been in the same position and would like to hear your feedback; like you use excel and love it or just grin and bear it, you've done something to enhance excel, you've thrown out excel for something better, or ???