Business Intelligence Solution for an SME: A Case Study

Raghavendra Raj, Shun Ha Sylvia Wong, Anthony J. Beaumont

2016

Abstract

Business Intelligence (BI) leverages the usefulness of existing information. It equips business users with relevant information to perform various analyses to make key business decisions. Over the last two decades, BI has become a core strategy for the growth of many companies, in particular large corporations. However, studies show that small and medium-sized enterprises (SMEs) lag behind in implementation and exploitation of BI solutions. To stay ahead of the competition, SMEs must be able to monitor and effectively use all of their resources, in particular information resources, to assist them in making important business decisions. In this paper, we examine the challenges such as lack of technical expertise and limited budget when implementing a BI solution within an SME in the UK. In light of our experiences in tackling these issues, we discuss how these challenges can be overcome through applying various tools and strategies and the potential benefits.

References

  1. AGGORA Group. (2016). AGGORA, http://aggora.co.uk/ [accessed 15 August 2016].
  2. Burstein, F. and Holsapple, C. (2008). Handbook on decision support systems. Berlin: Springer.
  3. Chugh, R and Grandhi, S. (2013). Why Business Intelligence? Significance of Business Intelligence tools and integrating BI governance with corporate governance', International Journal of E-Entrepreneurship and Innovation, vol. 4, no.2, pp. 1-14. http://www.igi-global.com/article/why-businessintelligence/89282
  4. European Commission (2016). What is an SME?, http://ec.europa.eu/growth/smes/business-friendlyenvironment/sme-definition/index_en.htm [accessed 1 June 2016].
  5. Fink, K. and Ploder, C. (2009). Knowledge Management Toolkit for SMEs. International Journal of Knowledge Management, 5(1), pp.46-60.
  6. Gartner Inc. (2012). Gartner Executive Programs' Worldwide Survey of More Than 2,300 CIOs Shows Flat IT Budgets in 2012, but IT Organizations Must Deliver on Multiple Priorities, http://www.gartner. com/newsroom/id/1897514 [accessed 25 May 2016].
  7. Gartner Inc. (2015). Magic Quadrant for Operational Database Management Systems, https://www.gartner. com/doc/reprints?id=1-2PMFPEN&ct=151013 [accessed 15 August 2016].
  8. Gartner Inc. (2016). Magic Quadrant for Business Intelligence and Analytics Platforms, https://www. gartner.com/doc/reprints?id=1-2XXET8P&ct=160204 [accessed 15 August 2016].
  9. Google (2016). Google Charts, https://developers.google. com/chart/ [accessed 2 June 2016].
  10. Horakova, M. and Skalska, H. (2013). Business Intelligence and Implementation in a Small Enterprise. Journal of Systems Integration, 4.2, pp.50-61.
  11. Howson, C. (2008). Successful business intelligence. New York: McGraw-Hill.
  12. InnovateUK (2016), Knowledge Transfer Partnerships, https://connect.innovateuk.org/web/ktp [accessed 10 June 2016].
  13. Kimball, R. and Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edition. Indianapolis, IN: Wiley.
  14. Lacko, L. (2009). Business Intelligence v SQL Serveru 2008. Brno: Computer Press.
  15. Luhn, H.P. (1958). A Business Intelligence System, IBM Journal of Research and Development, 2(4), 314-319.
  16. McCabe, L. (2012). Closing the Business Intelligence Gap for Small Businesses, https://lauriemccabe.com/2012/ 01/27/closing-the-business-intelligence-gap-for-smallbusinesses/ [accessed 14 June 2016].
  17. McGonagle, J. (2007). An Examination of the ' Classic ' CI Model. Journal of Competitive Intelligence and Management, 4(2), pp.71-86.
  18. Microsoft. (2015). Frequently asked questions about Power BI Microsoft Power BI, https://powerbi. microsoft.com/en-us/documentation/powerbifrequently-asked-questions/?CorrelationId=a0b3a797- a620-4e09-b346-1141a5f1d03d&ui=en-US&rs=enUS&ad=US [accessed 27 May 2016].
  19. Microsoft. (2016a). DAX Queries, https://msdn.microsoft. com/en-us/library/gg492201.aspx [accessed 13 June 2016].
  20. Microsoft. (2016b). Editions and Components of SQL Server 2012, https://technet.microsoft.com/en-us/libra ry/ms144275%28v=sql.110%29.aspx [accessed 25 May 2016].
  21. Microsoft. (2016c). Microsoft Developer Network (MSDN), https://msdn.microsoft.com/ [accessed 15 August 2016].
  22. Microsoft. (2016d). Office 365, https://products.office. com/en-gb/business/explore-office-365-for-business [accessed 15 August 2016].
  23. Microsoft. (2016e). Reporting Services (SSRS), https://msdn.microsoft.com/enus/library/ms159106.aspx [accessed 27 May 2016].
  24. Negash, S. and Gray, P. (2003) Business intelligence, Proceedings of the Ninth Americas Conference on Information Systems (AMCIS 2003), Tama, Florida, pp. 3190-3199.
  25. Papazoglou, M. P. (2003). Service-oriented computing: concepts, characteristics and directions, Proceedings of the Fourth International Conference on Web Information Systems Engineering, 2003 (WISE 2003), Rome, pp. 3-12. doi: 10.1109/WISE.2003.1254461.
  26. Scholz, P., Schieder, C., Kurze, C., Gluchowski, P. and Böhringer, M. (2010). Benefits and challenges of business intelligence adoption in small and mediumsized enterprises. 18th European Conference on Information Systems.
  27. Tutunea, M.F. and Rus, R.V. (2012). Business intelligence solutions for SME's. Procedia Economics and Finance, 3, pp.865-870.
  28. Watson, H. and Wixom, B. (2007). The Current State of Business Intelligence, Computer, 40(9), pp.96-99.
Download


Paper Citation


in Harvard Style

Raj R., Wong S. and Beaumont A. (2016). Business Intelligence Solution for an SME: A Case Study . In Proceedings of the 8th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management - Volume 3: KMIS, (IC3K 2016) ISBN 978-989-758-203-5, pages 41-50. DOI: 10.5220/0006049500410050


in Bibtex Style

@conference{kmis16,
author={Raghavendra Raj and Shun Ha Sylvia Wong and Anthony J. Beaumont},
title={Business Intelligence Solution for an SME: A Case Study},
booktitle={Proceedings of the 8th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management - Volume 3: KMIS, (IC3K 2016)},
year={2016},
pages={41-50},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0006049500410050},
isbn={978-989-758-203-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 8th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management - Volume 3: KMIS, (IC3K 2016)
TI - Business Intelligence Solution for an SME: A Case Study
SN - 978-989-758-203-5
AU - Raj R.
AU - Wong S.
AU - Beaumont A.
PY - 2016
SP - 41
EP - 50
DO - 10.5220/0006049500410050