Abstract
Social media data is growing exponentially, to the point where it is already hard to analyze. Consequently, there is a need to increase the number of people analyzing this data, to make sense out of it and, if possible, react to it. However, accessing this data is not simple because it is behind a knowledge barrier, which can only be overcome either with learning or with money. To considerably lower this barrier, we implemented the Social Spreadsheet, which is a spreadsheet template that we extended with functions that make simple the retrieval of social media data. Moreover, the collected data is ready to be analyzed by end-users, who can use formulas, custom functions, charts, and other commonly known spreadsheet features to create visualizations similar to the ones offered by commercial applications. To validate our work, we demonstrate how end-users can easily implement the same dashboards as the ones offered by popular social media analysis tools.
Chapter PDF
Similar content being viewed by others
References
Social Media Analytics, From Data to Deliverables, http://simplymeasured.com/
Socialbakers: Social Media Marketing, Statistics & Monitoring Tools, http://www.socialbakers.com/
Sprout Social: Social Media Management, Social CRM for Business, http://sproutsocial.com/
NodeXL: Network Overview, Discovery and Exploration for Excel, http://nodexl.codeplex.com/
Mackay, H.: Information and the Transformation of Sociology: Interactivity and Social Media Monitoring. tripleC-Cognition, Communication, Co-operation 11(1), 117–126 (2012)
Hansen, D.L., Rotman, D., Bonsignore, E., Milić-frayling, N., Rodrigues, E.M., Smith, M., Shneiderman, B., Capone, T.: Do You Know the Way to SNA?: A Process Model for Analyzing and Visualizing Social Media Data. Group 56(3), 1–10 (2009)
Thackeray, R., Neiger, B.L., Hanson, C.L., McKenzie, J.F.: Enhancing promotional strategies within social marketing programs: use of Web 2.0 social media. Health Promotion Practice 9(4), 338–343 (2008)
Chi, E.H., Riedl, J., Barry, P., Konstan, J.A.: Principles for information visualization spreadsheets (1998)
Ballinger, D., Biddle, R., Noble, J.: Spreadsheet visualisation to improve end-user understanding. In: Proceedings of the Asia Pacific Symposium on Information Visualisatio, vol. 24, pp. 99–109. Australian Computer Society, Inc. (2003)
Hoang, D.D., Paik, H.Y., Benatallah, B.: An analysis of spreadsheet-based services mashup. In: Proceedings of the Twenty-First Australasian Conference on Database Technologies, ADC 2010, vol. 104, pp. 141–150. Australian Computer Society, Inc., Darlinghurst (2010)
Kongdenfha, W., Benatallah, B., Vayssière, J., Saint-Paul, R., Casati, F.: Rapid development of spreadsheet-based web mashups. In: Proceedings of the 18th International Conference on World Wide Web, WWW 2009, pp. 851–860 (2009)
Scaffidi, C., Shaw, M., Myers, B.: The 55M End-User Programmers Estimate Revisited. Technical Report February, Carnegie Mellon University (2005)
Saint-Paul, R., Benatallah, B., Vayssière, J.: Data services in your spreadsheet? In: Proceedings of the 11th International Conference on Extending Database Technology: Advances in Database Technology, pp. 690–694. ACM (2008)
Research and Analysis of the Facebook & Mobile App Ecosystems, http://research.insidenetwork.com
PageLever: Analytics & Social Marketing Tools for Facebook Pages, http://pagelever.com/
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Jara Laconich, J.J., Casati, F., Marchese, M. (2013). Social Spreadsheet. In: Daniel, F., Dolog, P., Li, Q. (eds) Web Engineering. ICWE 2013. Lecture Notes in Computer Science, vol 7977. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-39200-9_15
Download citation
DOI: https://doi.org/10.1007/978-3-642-39200-9_15
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-39199-6
Online ISBN: 978-3-642-39200-9
eBook Packages: Computer ScienceComputer Science (R0)