Greetings from the Dataplex! Welcome to my new site: data is Bae. Early in my career I have been able to identify business intelligence, data analytics and data visualization as core competencies. That said, I want to be able to showcase some of my work because storytelling through data visualizations is so much cooler and engaging. Keep an eye out for future posts, as I will present to you some awesome data visualizations using public datasets. Happy storytelling!
The fintech (Financial Technology) industry is in hyper-growth and there are many players entering the space. The biggest company in the industry right now is Lending Club, with over $13 Billion in loans issued as of 9/30/2015. Fortunately, Lending Club provides their data files to the public and after importing the 2015 loan data I was able to create a couple of data visualizations.
The following Tableau Public dashboards provides insight into the types of jobs Lending Club’s borrowers possess. I provided filters so you can look at the data based on different loan purposes, i.e. The loan will be used for a car, wedding or debt consolidation, just to name a few. (Note: I did not change any of the field names and used only the field names that Lending Club provides publicly). One insight that came from this data is that teachers are the highest rank for sum of loan amounts. Does this mean teachers don’t get paid enough? I’ll let you take a look at the following dashboards to gain some insight:
Tableau is an effective business intelligence application for data analytics, measuring customer/retailer engagement KPIs, dashboard creation, and developing key insights for the executive team, all while providing an intuitive user interface well-suited for a variety of data analysts. Looking at the bigger picture, however, are two features that really set Tableau apart: Real-time reporting and data blending.
At Bristlecone Holdings, Tableau can directly connect to our database and develop insight using data that is coming in on a day-to-day basis. This is key to driving executive decisions that are timely and relevant to current market conditions.Think about a geographic map, displayed in the company conference room, showing how many deals you’ve done so far, and being continuously updated showing new deals that are just coming in. This takes reporting to a whole new level.
Tableau has the ability to blend data from a variety of sources such as Excel, Google Analytics, and Salesforce. Customer engagement metrics can be formulated using data from a combined group of sources, such as Google analytics and excel.
DRIVING KEY EXECUTIVE DECISIONS
One example of a particular insight that is uncovered through Tableau, and is able to drive key executive decisions, is measuring engagement of our retail partners. Certain features have been recently added to our furniture product line to increase growth and overall market share. We recently put a new metric in place through Tableau to measure how many retailers are actively using our program, before and after the new features have been implemented. So far, the new features show that retailers are reacting positively and we have seen a growth in the number of retailers using our program. Looking at this metric over time will help executives decide what changes need to be implemented, across all product lines, in order to increase engagement of our product by our retail partners.