Data Visualization of impact of Demonetization on Indian Stock Exchange using Tableau Software

Amarkishan Ponmalithazham, B.Tech.

Master's thesis

Abstract:

Data visualisation is the process of representing information and data graphically. Data styles, outliers and trends can be easily observed and analysed with data visualisation tools which include visual aids like charts, graphs, and maps. Data visualization is a useful tool for transforming unprocessed data into compelling visual representations of any business or project and it facilitates the decision-making process for upcoming business actions. The purpose of this thesis is to identify various visualization methods, comprehend various tools, compare Tableau, and Excel tools. It also aims to explain data using visualisation tools that can present the information in a better way efficiently as well as effectively, instead of explaining the return values of the chosen Bombay Stock Exchange sectoral indices to an individual or managers of a company. The data used for the purpose of analysis includes daily historical stock prices of selected BSE sectoral indices. The data is collected from the year 2016 to 2021. The returns are calculated for each chosen indices in Excel using the historical stock prices. Further, the results of calculated returns have been presented through different visualisation methods in Tableau. The results suggests that demonetization has impacted the Indian stock exchange, the returns for few indices were in negative and other indices were able to give minimal returns. It can be also seen that; stock exchange is slowly getting out of the sudden impact due to the trust by their investors.

Keywords

Data Visualization, Tableau Software, Demonetization, Indian Stock Exchange, Bombay Stock Exchange

Jazyk práce: English

Datum vytvoření / odevzdání či podání práce: 7. 4. 2023

Obhajoba závěrečné práce

• Obhajoba proběhla 23. 5. 2023
• Vedúci: Ing. Tomáš Hlavsa, Ph.D.
• Oponent: Michal Kadlec, externi

Czech University of Life Sciences Prague

Faculty of Economics and Management

Master programme:
Informatics