Show Posts
1
Investors - LC / Interactive Tableau Dashboard for LC Raw Data
« on: March 23, 2016, 11:00:00 PM »
So after downloading raw LC data and putting it in Tableau, I have begun creating interesting tables that help find relationships between many of the variables. In addition, this should help create better filters for finding better loans to invest in.
The dashboard is posted on Tableau Public for everyone to use.
https://public.tableau.com/views/LendingClubROI/Dashboard1
**bold**I appreciate feedback on improvements!!!!**bold**
If you haven't used a Tableau dashboard before, everything is interactive. If you click on a grade in the grade table, all other tables will automatically filter for what you're looking for. It's a little slow after clicking, but it works.
Compared to NSR, I am using a more complete formula for ROI:
([Interest received to date]+[Post charge off gross recovery]-[Service Fee]-[Collection Recovery Fee]-[Loss Estimate]) / ([Interest received to date]/[Interest Rate])
This takes into account recoveries after charge off and detrimental collection fees.
I haven't pulled in the pre-2012 data, but will do so soon. One idea I have for the dashboard is to remove all other information except ROI. It will allow many other variables to be populated on one dashboard. Thoughts?
The dashboard is posted on Tableau Public for everyone to use.
https://public.tableau.com/views/LendingClubROI/Dashboard1
**bold**I appreciate feedback on improvements!!!!**bold**
If you haven't used a Tableau dashboard before, everything is interactive. If you click on a grade in the grade table, all other tables will automatically filter for what you're looking for. It's a little slow after clicking, but it works.
Compared to NSR, I am using a more complete formula for ROI:
([Interest received to date]+[Post charge off gross recovery]-[Service Fee]-[Collection Recovery Fee]-[Loss Estimate]) / ([Interest received to date]/[Interest Rate])
This takes into account recoveries after charge off and detrimental collection fees.
I haven't pulled in the pre-2012 data, but will do so soon. One idea I have for the dashboard is to remove all other information except ROI. It will allow many other variables to be populated on one dashboard. Thoughts?