Visualization of Data in Tableau to Perform Fundamental Analysis of S&P 500 Stocks using Financial Ratios that measure Valuation, Profitability, Liquidity and Dividend Yield
• Extracted, cleaned, and preprocessed the fundamental data of stocks in S&P 500 and segregated them according to their sectors of operation using python.
• Performed calculations of top finance ratios to evaluate stocks and exported the data in CSV format.
• Designed an Interactive Dashboard in Tableau to visualize the data imported.
• Performed data analysis to understand the stock performance and created a portfolio of stocks that would yield a maximum return based on their past performance.