Title: Interactive Tableau Dashboard for LC Raw Data
Post by: medico on March 23, 2016, 11:00:00 PM
Post by: medico 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?
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: dompazz on March 23, 2016, 11:00:00 PM
Post by: dompazz on March 23, 2016, 11:00:00 PM
Very nice.
Has anyone tried uploading the data to the IBM Watson free trial?
Has anyone tried uploading the data to the IBM Watson free trial?
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: lascott on March 23, 2016, 11:00:00 PM
Post by: lascott on March 23, 2016, 11:00:00 PM
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: jennrod12 on March 23, 2016, 11:00:00 PM
Post by: jennrod12 on March 23, 2016, 11:00:00 PM
Medico,
This is awesome, thank you!
Have you considered adding FICO score and Home Ownership? Those are two filters that immediately jumped to my mind. Either way, thanks!
Jenn
This is awesome, thank you!
Have you considered adding FICO score and Home Ownership? Those are two filters that immediately jumped to my mind. Either way, thanks!
Jenn
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
Definitely. I have been using home ownership as almost a first pass filter for everything.
For FICO score, i was planning on creating a linear regression and seeing what the R-squared is compared to ROI.
For FICO score, i was planning on creating a linear regression and seeing what the R-squared is compared to ROI.
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: rawraw on March 24, 2016, 11:00:00 PM
Post by: rawraw on March 24, 2016, 11:00:00 PM
Seems like loan type should be one of the variables you choose to get the stats
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
What do you mean type? The purpose variable is there on the left.
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
All, dashboard has been updated with FICO score, home ownership, and ROI color grading.
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
Post by: TravelingPennies on March 24, 2016, 11:00:00 PM
Outstanding! 
Thanks,
Jenn
Thanks,
Jenn
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: Fred on March 25, 2016, 11:00:00 PM
Post by: Fred on March 25, 2016, 11:00:00 PM
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: westonplatter on March 25, 2016, 11:00:00 PM
Post by: westonplatter on March 25, 2016, 11:00:00 PM
I really like this.
Does Tableau allow users to easily look at multi-variable returns? For example, E loans with DTI between 10 and 35%?
Does Tableau allow users to easily look at multi-variable returns? For example, E loans with DTI between 10 and 35%?
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: TravelingPennies on March 25, 2016, 11:00:00 PM
Post by: TravelingPennies on March 25, 2016, 11:00:00 PM
I don't know what it is called in tableu. But the variables you choose that then adjust the population for all the statistics shown. So when you click a specific loan type, all the boxes only show data for those selected loans. It'd be similiar to your "length variable"
Also, the # of loans with >10 years work experience seems a little high. I'd make sure something isn't accidentally mapped there besides the +10 years
Also, the # of loans with >10 years work experience seems a little high. I'd make sure something isn't accidentally mapped there besides the +10 years
Title: Interactive Tableau Dashboard for LC Raw Data
Post by: Perdun on April 09, 2016, 11:00:00 PM
Post by: Perdun on April 09, 2016, 11:00:00 PM
Excellent resource, thanks!