Equity analysis was a take-home case I was given as part of an interview process for a fin-tech company I interviewed for.
Excel file is a time-series data for public companies with a few relevant attributes. Also, some not relevant attributes were added to test a candidate’s ability to recognize essential and functional data for the task from irrelevant data.

Detailed commentary and steps are in iPython notebook comments, please see file below.

For download:
Raw Excel file
iPython notebook on GitHub
Tableau visualization workbook