A Functional Framework for Evaluating Financial Visualization Products

Development and Application to the Design of a Custom Visual Analytics Solution for a Boutique Asset Management Firm
Chapter

Abstract

In this study, we aim to understand and bridge the gap between visual analytics (VA) research and deployment in imperfect conditions to solve multilayered, often vaguely defined, problems in the real world. We further narrow the scope to analysis problems in finance, with a focus on investment portfolio analysis. The goal of this project is to create a functional evaluation framework of VA techniques with regard to investment portfolio analysis problems, as well as a table of existing products that are capable of supporting problems. With a functional evaluation framework and a table of off-the-shelf solutions, more effective and theoretically grounded cost-benefit analysis can be performed to justify and plan applications of VA in financial organizations. We then apply this functional evaluation framework in a case study of a fixed-income investment management company. In this case study, we systematically identify the areas for improvement in the analytic process of the company and isolate the areas that could be improved with VA. We then map these detailed problem definitions to VA techniques in order to find the optimal visualizations of the data. Finally, we implement a solution for the company by building upon one of the free toolkits that we have evaluated in order to achieve all the analytic goals with the least amount of time and expenses.

Notes

Acknowledgments

The authors would like to acknowledge the financial support of the Boeing Company in making this research possible. The authors would also like to thank finance students QianQian Yu and Yao Shen for their assistance with this research. Research work carried out by Thomas Dang was in partial fulfillment of the requirements for a M.Sc. in Computer Science at the University of British Columbia under the supervision of Dr. Victoria Lemieux and Dr. Ronald Rensink, and a fuller account may be found in his thesis.

References

  1. Alsakran J, Zha Y, Zhao X (2010) Tile-based parallel coordinates and its application in financial visualization. In: Park J, Hao MC, Wong PC, Chen C (eds) Proceedings of visualization and data analysis 2010 (VDA 2010), 18–19 January 2010. SPIE, San JoseGoogle Scholar
  2. Amar R, Stasko J (2004) A knowledge task-based framework for de-sign and evaluation of information visualizations. In: Ward M, Munzner T (eds) Proceedings of the 10th IEEE symposium on information visualization 2004 (INFOVIS ‘04), 10–12 Oct 2004. IEEE Computer Society Press, AustinGoogle Scholar
  3. Amar R, Eagan J, Stasko J (2005) Low-level components of analytic activity in information visualization. In: Stasko J (ed) Proceedings of the 11th IEEE symposium on information visualization 2005 (INFOVIS ‘05), 23–25 Oct 2005. IEEE Computer Society Press, MinneapolisGoogle Scholar
  4. Arias-Hernández R, Kaastra LT, Green TM, Fisher B (2011) Pair analytics: capturing reasoning processes in collaborative visual analytics. In: Sprague R (ed) Proceedings of the 44th annual Hawaii international conference on system sciences, 4–7 January 2011. IEEE Computer Society Press, KoloaGoogle Scholar
  5. Becker RA, Cleveland WS, Wilks AR (1987) Dynamic graphics for data analysis. Statis Sci 2:355–383CrossRefGoogle Scholar
  6. Bostock M (2010) Protovis APIGoogle Scholar
  7. Bostock M (2011) D3.js APIGoogle Scholar
  8. Brodbeck D, Chalmers M, Lunzer A, Cotture P (1997) Domesticat-ing bead: adapting an information visualization system to a financial institution. In: Dill J (ed) Proceedings of the 3rd IEEE symposium on information visualization 1997 (INFOVIS ‘97), 20–15 Oct 1997. IEEE Computer Society Press, PhoenixGoogle Scholar
  9. Card SK, Mackinlay J (1997) The structure of the information visualization design space. IEEE symposium on information visualization, Phoeniz, Arizona, pp 92–99Google Scholar
  10. Card SK, Mackinlay JD, Schneiderman B (eds) (1999) Readings in in-formation visualization: using vision to think. Morgan Kaufmann Publishers Inc., WalthamGoogle Scholar
  11. Chang R, Lee A, Ghoniem M, Kosara R, Ribarsky W, Yang J, Suma E, Ziemkiewicz C, Kern D, Sudjianto A (2008) Scalable and interactive visual analysis of financial wire transactions for fraud detection. Inf Vis 7:63–76. doi:10.1057/palgrave.ivs.9500172 CrossRefGoogle Scholar
  12. Chaudhuri S, Dayal U (1997) An overview of data warehousing and OLAP technology. ACM SIGMOD Record 26:65–74. doi:10.1145/248603.248616 CrossRefGoogle Scholar
  13. Chen V, Alimadadi S, Guenther J, Kadivar N, Lee E, Dill J, Woodbury R (2009) CZSaw: capturing and supporting the analysis process. http://www.sfu.ca/~shaw/papers/CzSaw-VAST09.pdf
  14. Chi EH, Riedl JT (1998) An operator interaction framework for visualization systems. IEEE symposium on information visualization (InfoVis), pp 63–70Google Scholar
  15. Codd EF, Codd SB, Salley CT (1993) Providing OLAP to user-analysts: an IT mandate. Codd and Date, San JoseGoogle Scholar
  16. Dos Santos S, Brodlie K (2004) Gaining understanding of multivariate and multidimensional data through visualization. Comput Graphics 28:311–325CrossRefGoogle Scholar
  17. Dow Jones (2010) Dow Jones financial services taxonomy. Dow Jones & company, New YorkGoogle Scholar
  18. Dwyer T, Eades P (2002) Visualizing a fund manager flow graph with columns and worms. In: Proceedings of the 6th international conference on information visualization (IV’02), 10–12 July 2002. IEEE Computer Society Press, LondonGoogle Scholar
  19. Few S (2006) Bullet graph design specification. Accessed from www.perceptualedge.com/articles/misc/Bullet_Graph_Spec.pdf
  20. FinViz (2010) Financial visualizations. Accessed from http://finviz.com/
  21. Gebhardt M, Jarke M, Jacobs S (1997) A toolkit for negotiation support interfaces to multi-dimensional data. ACM SIGMOD international conference on management of data, Tucson, ArizonaGoogle Scholar
  22. Girardin L, Brodbeck D (2001) Interactive visualization of prices and earnings around the globe. In: Andrews K (ed) Proceedings of the 7th IEEE symposium on information visualization 2001 (INFOVIS ‘11), 22–23 Oct 2001. IEEE Comput Soc Press, San DiegoGoogle Scholar
  23. Gray J, Chaudhuri S, Bosworth A, Layman A, Reichart D, Venka-trao M (1997) Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub-totals. Data Min Knowl Disc 1:29–53CrossRefGoogle Scholar
  24. Gunn J (2007) XBRL: opportunities and challenges in enhancing financial reporting and assurance processes. Curr Issues in Auditing 1:A36–A43CrossRefGoogle Scholar
  25. Heuer RJJ (1999) Psychology of inteligence analysis. Central intelligence agency: center for the study of intelligence. https://www.cia.gov/library/center-for-the-study-of-intelligence/csi-publications/books-and-monographs/psychology-of-intelligence-analysis/index.html
  26. Jungmeister WA, Truro D (1992) Adapting treemaps to stock portfolio visualization. Center for Automation Research, University of Mary-land, BaltimoreGoogle Scholar
  27. Khan A (2009) JExcel APIGoogle Scholar
  28. Klein P, Muller F, Reiterer H, Eibl M (2002) Visual information retrieval with SuperTable + Scatterplot. In: Proceedings of the 6th international conference on information visualization (IV’02), 10–12 July 2002. IEEE Computer Society Press, LondonGoogle Scholar
  29. Kosslyn SM (1980) Image and mind. Harvard University Press, CambridgeGoogle Scholar
  30. Kosslyn SM, Jacobs R (1994) Visual mental images in the brain. In: Farah MJ, Ratcliff G (eds) The neuropsychology of high-level vision: collected tutorial essays. Lawrence Erlbaum, HillsdaleGoogle Scholar
  31. Kubelec C, Sa F (2010) The geographical composition of national external balance sheets: 1980–2005: Bank of England working paper no. 384. Bank of EnglandGoogle Scholar
  32. Leca D (2010) The impossible Bloomberg makeover. UX Magazine. http://www.uxmag.com/articles/the-impossible-bloomberg-makeover
  33. Lei ST, Zhang K (2010) A visual analytics system for financial time-series data. In: Proceedings of the 3rd international symposium on visual information communication (VINCE’10), 28–29 Sept 2010. Association for Computing Machinery, BeijingGoogle Scholar
  34. Lemieux V, Fisher B, Dang T (2012) The visual analysis of financial data. In: Mark Flood et al. (eds) Handbook of financial risk data. Cambridge University Press, CambridgeGoogle Scholar
  35. Leronutti L, Pighin M (2009) A novel visualisation and interaction technique for exploring multidimensional data. Int J Business Intell Data Mining 4:350–374. doi:10.1504/IJBIDM.2009.029084 CrossRefGoogle Scholar
  36. Lurie NH, Mason C (2007) Visual representation: implications for decision making. J Mark 71:160–177CrossRefGoogle Scholar
  37. Maniatis AS, Vassiliadis P, Skiadopoulos S, Vassiliou Y (2003) Advanced visualization for OLAP. The 6th ACM international workshop on data warehousing and OLAP. http://www.dbnet.ece.ntua.gr/pubs/uploads/TR-2003-13.pdf
  38. Mansmann S, Mansmann F, Scholl MH, Keim D (2007) Hierarchy-driven visual exploration of multidimensional data cubes. BTW P-103:96–111Google Scholar
  39. Microsoft Corporation (1997) Multidimensional expressions (MDX)Google Scholar
  40. Microsoft Corporation (1998) OLAP services, part of SQL server 7Google Scholar
  41. Microsoft Corporation, & Hyperion (2001) XML for analysis (XMLA)Google Scholar
  42. Munzner T (2009) A nested model for visualization design and validation. Paper presented at the information visualization, Atlantic City, vol 15(6)Google Scholar
  43. Munzner T (2009b) Visualization. In: Shirley P, Ashikhminand M, Marshner S (eds) Fundamentals of graphics, 3rd edn. AK Peters/CRC Press, MassachusettsGoogle Scholar
  44. Neumann P, Tang A, Carpendale S (2007) A framework for visual information analysis. http://www.lri.fr/~isenberg/publications/papers/Neumann_2007_AFF.pdf
  45. Nison S (2001) Japanese candlestick charting techniques, 2nd edn. Prentice Hall Press, Upper Saddle RiverGoogle Scholar
  46. Panopticon Software I (2010) Panopticon—build visual analysis dashboards with interactive, real-time data visualizations. http://www.panopticon.com. Accessed 23 March 2011
  47. Qin C, Zhou C, Pei T (2003) Taxonomy of visualization techniques and systems: concerns between users and developers are different. Asia GIS Conference, pp 1–14Google Scholar
  48. Ramnath S, Rock S, Shane BP (2008) The financial analyst forecasting literature: a taxonomy with suggestions for further research. Int J Forecast 24:34–75CrossRefGoogle Scholar
  49. Roberts P (2003) Information visualization for stock market ticks: toward a new trading interface. Massachusetts Institute of Technology. Accessed from http://dspace.mit.edu/bitstream/handle/1721.1/16668/56675083.pdf
  50. Russell DM, Stefik MJ, Pirolli P, Card SK (1993) The cost structure of sensemaking. INTERCHI ‘93 conference on human factors, AmsterdamGoogle Scholar
  51. SAP crystal dashboard design, formerly xcelsiusGoogle Scholar
  52. Savikhin A, Maciejewski R, Ebert DS (2008) Applied visual analytics for economic decision-making. In: Ebert DS, Ertl T (eds) Proceedings of the IEEE symposium on visual analytics science and technology 2008 (VAST 08), 21–23 Oct 2008. IEEE Computer Society Press, ColumbusGoogle Scholar
  53. Savikhin A, Lam HC, Fisher B, Ebert DS (2011) An experimental study of financial portfolio selection with visual analytics for decision support. In: Sprague R (ed) Proceedings of the 44th annual Hawaii international conference on system sciences (HICSS-44), 4–7 January 2011. IEEE Computer Society Press, KoloaGoogle Scholar
  54. Sawant A (2009) StockViz: analyzing the trend of stocks in major auto, oil, consumer, and technology companies. In: Arabnia H, Deligiannidis L (eds) Proceedings of the 2009 international conference on modeling, simulation & visualization methods (MSV 2009), 13–16 July 2009. CSREA Press, Las VegasGoogle Scholar
  55. Securities and Exchange Commission (SEC) (2008) SEC approves interactive data for financial reporting by public companies, mutual funds. Accessed from http://www.sec.gov/news/press/2008/2008-300.htm
  56. Shneiderman B (1992) Tree visualization with tree-maps: a 2D space-filling approach. ACM Trans Graphics 11:92–99CrossRefGoogle Scholar
  57. Shneiderman B (1996) The eyes have it: a task by data type taxonomy for information visualization. In: Proceedings of the IEEE symposium on visual languages 1996, 3–6 Sept 1996. IEEE Computer Society Press, BoulderGoogle Scholar
  58. Techapichetvanich K, Datta A (2005) Interactive visualization for OLAP. International conference on computational science, pp 206–214Google Scholar
  59. Tegarden DP (1999) Business information visualization. Commun Assoc Inf Syst 1:2–38Google Scholar
  60. Thomas JJ, Cook KA (eds) (2005) Illuminating the path: the re-search and development agenda for visual analytics. IEEE Computer Society Press, Los AlamitosGoogle Scholar
  61. Ward M, Grinstein G, Keim D (2010) Interactive data visualization: foundations, techniques, and applications. AK Peters/CRC Press, MassachusettsGoogle Scholar
  62. TD Waterhouse (2011) ThinkorswimGoogle Scholar
  63. Wattenberg M (1999) Visualizing the stock market. In: William M (ed) Proceedings of the ACM SIGCHI conference on human factors in computing systems (CHI ‘99), 15–20 May 1999. Association for Computing Machinery, PittsburghGoogle Scholar
  64. Wehrend S, Lewis C (1990) A problem-oriented classification of visualization techniques. In: Kaufman A (ed) Proceedings of the 1st IEEE conference on visualization (Visualization’90), 23–26 Oct 1990. IEEE Computer Society Press, San FranciscoGoogle Scholar
  65. Wright W (1995) Information animation applications in the capital markets. In: Eick S, Gershon N (eds) Proceedings of the 1st IEEE symposium on information visualization 1995 (INFOVIS ‘95), 30–31 Oct 1995. IEEE Computer Society Press, AtlantaGoogle Scholar
  66. Zhou M, Feiner S (1998) Visual task characterization for automated visual discourse synthesis. In: Karat C, Lund A (eds) Proceedings of the ACM SIGCHI conference on human factors in computing systems (CHI ‘98), 18–23 April 1998. Association for Computing Machinery, Los AngelesGoogle Scholar
  67. Ziegler H, Nietzschmann T, Keim DA (2008) Visual analytics on the financial market: pixel-based analysis and comparison of long-term investments. In: Banissi E et al. (eds) Proceedings of the 12th international conference on information visualization 2009 (IV’08), 9–11 July 2008. IEEE Computer Society Press, LondonGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  1. 1.University of British ColumbiaVancouverCanada

Personalised recommendations