Implementation and effective utilization of analytical tools and techniques in knowledge management

Abstract

Knowledge management is a multidisciplinary approach to achieve organizational objectives by making best use of knowledge and information resources. Analytics is the process of systematic analysis of the past data/statistics and trying to predict the future trends or data with various tools and techniques. With the advancement of technology and increasing competition, companies are prone to make better use of the information and analytics to sustain their position in the marketplace. Software as a Service (SaaS) has become an important trend in organizations in addition to that of the usual Excel and Google sheets analytics. In this study, comparative analysis has been done between SPSS & Google Sheets Techniques and also Google data studio with Tableau, Power BI & Google Sheets for data visualization processes. Efficient dashboard was created using the different data visualization tools and compared with their pros and cons. A survey was conducted in the form of Questionnaire and the responses are obtained from people ranging from Interns to Managerial level and the factors that influence the Knowledge management processes in an efficient manner are obtained. Google apps script coding and basic excel techniques like VLOOKUP, HLOOKUP, Conditional formatting, Data Validation are being implemented as a part of automating the repetitive tasks.