Skip to main content

Real-Time Data Visualization Using Business Intelligence Techniques in Small and Medium Enterprises for Making a Faster Decision on Sales Data

  • Chapter
  • First Online:
Decision Intelligence Analytics and the Implementation of Strategic Business Management

Abstract

In the recent world, making the proper decisions in business is challenging and complicated, especially on sales data. Sales are the most valuable part of a business. Only the sales report of a business is not enough for today’s business development. The activity needs to get an insight into sales using data because data-driven decision is more impactful. The purpose of the research is to develop an affordable and approachable model to deliver a business insight that helps you to understand your business and support to make business decisions faster. In this piece of research work, a model is proposed to develop an affordable simple sales data insight, helping with business intelligence technique and cloud database. This model uses a set of data, with ad hoc query, statistical analysis, some mathematical equations, and data visualization is a key component to gain a proactive and data-driven solution. Using such methodologies and approaches, our model generated certain key performance indicators and a quick snapshot of the sales situation, allowing company owners to see trends and predict sales process weaknesses. Not only that proposed model also provides geolocations sales state and cross ponding sales preview on a visualization mode.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 89.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 119.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 119.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. S. Chaudhuri, An overview of business intelligence technology. Commun. ACM 54(8), 88 (2011)

    Article  Google Scholar 

  2. OLAP.com, What is Business Intelligence? BI Definition, OLAP.com, 2019. https://olap.com/learn-bi-olap/olap-bi-definitions/business-intelligence/. Accessed 18 November 2019

  3. J. Ranjan, Business intelligence: concepts, components, techniques and benefits. J. Theor. Appl. Inf. Technol. 2009, 60 (2009)

    Google Scholar 

  4. B.K. Mishra, D. Hazra, K. Tarannum, M. Kumar, Business intelligence using data mining techniques and business analytics, in 5th International Conference on System Modeling & Advancement in Research Trends, SMART-2016, Moradabad, India, 2016

    Google Scholar 

  5. H. Singh, Implementation benefit to business intelligence using data mining techniques. Int. J. Comput. Business Res. 2012, 2229–6166 (2012)

    Google Scholar 

  6. Executive summary, data growth, business opportunities, and the IT imperatives, EMC Dell, April, 2014. https://www.emc.com/leadership/digital-universe/2014iview/executive-summary.htm. Accessed 18 Nov 2019

  7. Hiba Alsghaier, et al., The impact of big data analytics on business competitiveness, in Proceedings of the New Trends in Information Technology (NTIT-2017), The University of Jordan, Amman, Jordan, 2017

    Google Scholar 

  8. M. Al Hasan, An economic and modern business intelligence solution for textile. Glob. J. Comp. Sci Technol. 18(2), 12 (2018)

    Article  Google Scholar 

  9. P.S. Chunnu Khawas, Application of firebase in android app development. Int. J. Comput. Appl. 179(46), 49–53 (2018)

    Google Scholar 

  10. H. Cheng, Y.C. Lu, C. Sheu, An ontology-based business intelligence application in a financial knowledge management system. Expert Syst. Appl. 36, 3614 (2009)

    Article  Google Scholar 

  11. A. Amin, I.u. Haq, M. Nazir, Two factor authentication. Int. J. Comput. Sci. Mob. Comput. 6(7), 5–8 (2017)

    Google Scholar 

  12. J. Freeman, What is JSON? A better format for data exchange, InfoWorld, 25 October 2019. https://www.infoworld.com/article/3222851/what-is-json-a-better-format-for-data-exchange.html. Accessed 18 Nov 2019

  13. Vijay Krishnan, S Bharanidharan, G Krishnamoorthy, Research data analysis with power BI, in 11th International CALIBER-2017, Anna University, Chennai, Tamil Nadu, 2017

    Google Scholar 

  14. Wikipedia, Power Pivot, Wikipedia, 30 May 2019. https://en.wikipedia.org/wiki/Power_Pivot. Accessed 18 Nov 2019

  15. K. Gowthami, M.R.P. Kumar, Study on business intelligence tools for enterprise dashboard development. Int. Res. J. Eng. Technol. 4(4), 2395–0072 (2017)

    Google Scholar 

  16. Zhong, Power BI: What is DAX? And why you should (or should not) learn it, 2018. https://towardsdatascience.com/power-bi-what-is-dax-and-why-you-should-or-should-not-learn-it-1581aadbb038. Accessed 18 Nov 2019

  17. J. Acampora, Power query overview: an introduction to Excel’s most powerful data tool, Excelcampus, 20 March 2015. https://www.excelcampus.com/power-tools/power-query-overview/. Accessed 18 Nov 2019

  18. M. Rouse, Business intelligence dashboard, Search Business Analytics, 2018. https://searchbusinessanalytics.techtarget.com/definition/business-intelligence-dashboard. Accessed 18 Nov 2019

  19. I. Bhatti et al., The key performance indicators (KPIs) and their impacton overall organizational performance (Springer, Dordrecht, 2013). https://doi.org/10.1007/s11135-013-9945-y

    Book  Google Scholar 

  20. D.A. Keima, M.C. Haob, et al., Generalized scatter plots. Inform. Visualiz. 9(4), 301–311 (2010)

    Article  Google Scholar 

  21. H. Paul, What a webview is and how to test it, DZone, 9 October 2018. https://dzone.com/articles/what-is-a-webview-and-how-to-test-it. Accessed 18 Nov 2019

  22. M. Rouse, IFrame (Inline Frame), https://whatis.techtarget.com/, 2015. https://whatis.techtarget.com/definition/IFrame-Inline-Frame. Accessed 18 Nov 2019

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Owes Quruny Shubho .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Shubho, O.Q., Tumpa, Z.N., Dipto, W.I.R., Alam, M.R. (2022). Real-Time Data Visualization Using Business Intelligence Techniques in Small and Medium Enterprises for Making a Faster Decision on Sales Data. In: Jeyanthi, P.M., Choudhury, T., Hack-Polay, D., Singh, T.P., Abujar, S. (eds) Decision Intelligence Analytics and the Implementation of Strategic Business Management. EAI/Springer Innovations in Communication and Computing. Springer, Cham. https://doi.org/10.1007/978-3-030-82763-2_17

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-82763-2_17

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-82762-5

  • Online ISBN: 978-3-030-82763-2

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics