Ranvir’s Data Analysis Portfolio

Project 1: Stock Portfolio Dashboard

• Stock portfolio dashboard displaying unrealized profit/loss using real time data.
• The dashboard is designed so that information only has to be inputed into a single ledger.
• Macros are used to update the dashboard and to display portfolio information in real time for multiple users.

Project 2: Netflix Content Exploratory Data Analysis

• Performed Exploratory Data analysis on Netflix content
• Used PostgreSQL for data querying and Microsoft Excel for data visualization purposeses