Empowering SMEs to Make Better Decisions with Business Intelligence: A Case Study

  • Raghavendra RajEmail author
  • Shun Ha Sylvia Wong
  • Anthony J. Beaumont
Conference paper
Part of the Communications in Computer and Information Science book series (CCIS, volume 914)


With the advance of Business Information Systems (BIS), irrespective of the size, companies have adopted an approach to electronic data collection and management for two decades. The advancement in technology means they have in their possessions large volumes of historical data. Large organizations have cached on this and use a range of tools and techniques to leverage the usefulness of this information to make more informed business decisions. For most small and medium-sized enterprises (SMEs), however, such data typically sits in an archive without being utilized. While SMEs appreciate the need for utilizing historical data to make more informed business decisions, they often lack the technical knowhow and funding to embrace an effective BI solution. In this paper, drawing from our experience in implementing a BI solution for a UK SME we discuss some potential tools and strategies that could help SMEs overcome these challenges so as to reap the benefits of adopting an effective BI solution.


Business Intelligence Data warehouse Microsoft BI SME 



The project reported in this case study is funded by Innovate UK via the Knowledge Transfer Partnership Scheme (KTP009714). We acknowledge the financial support by Innovate UK. We also acknowledge the advice provided by our KTP Adviser Ms Jose Freeman throughout the project development. We thank the team at AGGORA who made this project possible through their participation.


  1. 1.
    AGGORA Group: AGGORA. (2016). Accessed 8 Mar 2017
  2. 2.
    Burstein, F., Holsapple, C.: Handbook on Decision Support Systems. Springer, Berlin (2008). Scholar
  3. 3.
    Chugh, R., Grandhi, S.: Why business intelligence? Significance of business intelligence tools and integrating BI governance with corporate governance. Int. J. e-Entrep. Innov. 4(2), 1–14 (2013). Scholar
  4. 4.
    European Commission: What is an SME? (2016). Accessed 8 Mar 2017
  5. 5.
    Fink, K., Ploder, C.: Knowledge management toolkit for SMEs. Int. J. Knowl. Manag. 5(1), 46–60 (2009)CrossRefGoogle Scholar
  6. 6.
    Gartner Inc.: 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 (2012). Accessed 07 Mar 2017
  7. 7.
    Gartner Inc.: Magic quadrant for operational database management systems (2015). Accessed 15 Aug 2016
  8. 8.
    Gartner Inc.: Magic quadrant for business intelligence and analytics platforms (2016). Accessed 15 Aug 2016
  9. 9.
    Google: Google Charts (2016). Accessed 8 Mar 2017
  10. 10.
    Horakova, M., Skalska, H.: Business intelligence and implementation in a small enterprise. J. Syst. Integr. 4(2), 50–61 (2013)Google Scholar
  11. 11.
    Howson, C.: Successful Business Intelligence. McGraw-Hill, New York (2008)Google Scholar
  12. 12.
    InnovateUK: Knowledge transfer partnerships (2016). Accessed 7 Mar 2017
  13. 13.
    Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd edn. Wiley, Indianapolis (2013)Google Scholar
  14. 14.
    Lacko, L.: Business Intelligence v SQL Serveru 2008. Computer Press, Brno (2009)Google Scholar
  15. 15.
    Luhn, H.P.: A business intelligence system. IBM J. Res. Dev. 2(4), 314–319 (1958)MathSciNetCrossRefGoogle Scholar
  16. 16.
    McCabe, L.: Closing the business intelligence gap for small businesses (2012). Accessed 8 Mar 2017
  17. 17.
    McGonagle, J.: An examination of the ‘classic’ CI model. J. Compet. Intell. Manag. 4(2), 71–86 (2007)Google Scholar
  18. 18.
  19. 19.
    Microsoft: DAX queries (2016). Accessed 7 Mar 2017
  20. 20.
    Microsoft: Editions and components of SQL Server 2012 (2016). Accessed 8 Mar 2017
  21. 21.
    Microsoft: Microsoft Developer Network (MSDN) (2016). Accessed 8 Mar 2017
  22. 22.
    Microsoft: Office 365 (2016). Accessed 8 Mar 2017
  23. 23.
    Microsoft: Reporting Services (SSRS) (2016). Accessed 8 Mar 2017
  24. 24.
    Negash, S., Gray, P.: Business intelligence. In: Proceedings of the Ninth Americas Conference on Information Systems (AMCIS 2003), Tama, FL, pp. 3190–3199 (2003)Google Scholar
  25. 25.
    Papazoglou, M.P.: Service-oriented computing: concepts, characteristics and directions. In: Proceedings of the Fourth International Conference on Web Information Systems Engineering, (WISE 2003), Rome, pp. 3–12 (2003).
  26. 26.
    Raj, R., Wong, S.H.S., Beaumont, A.J.: 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 (IC3K 2016), KMIS, vol. 3, pp. 41–50. SCITEPRESS – Science and Technology Publications, Lda (2016). ISBN 978-989-758-203-5Google Scholar
  27. 27.
    Scholz, P., Schieder, C., Kurze, C., Gluchowski, P., Böhringer, M.: Benefits and challenges of business intelligence adoption in small and medium-sized enterprises. In: 18th European Conference on Information Systems (2010)Google Scholar
  28. 28.
    Tutunea, M.F., Rus, R.V.: Business intelligence solutions for SME’s. Proc. Econ. Finance 3, 865–870 (2012)CrossRefGoogle Scholar
  29. 29.
    Watson, H., Wixom, B.: The current state of business intelligence. Computer 40(9), 96–99 (2007)CrossRefGoogle Scholar

Copyright information

© Springer Nature Switzerland AG 2019

Authors and Affiliations

  • Raghavendra Raj
    • 1
    Email author
  • Shun Ha Sylvia Wong
    • 2
  • Anthony J. Beaumont
    • 2
  1. 1.AGGORA GroupRedditchUK
  2. 2.School of Engineering and Applied ScienceAston UniversityBirminghamUK

Personalised recommendations