SBA just published the PPP loan dataset. There are so many ways to dice and slide data for PPP. Our team spent some time to take this data into SAC and create a few visualizations to see what sectors took the most money and which months.
THIS PUBLICATION ONLY DISPLAYS THE DATA FOR LOANS GREATER THAN 150k. If you need complete analysis, contact us.
SAP Analytics Cloud is a Analytics tool provided by SAP and is a very powerful tool for analyzing the data and creating an intelligent enterprise.
SAP Analytics CloudOur team has been using SAP Analytics cloud for a few different applications its been developing. We find the Planning feature extremely powerful and useful to an enterprise. SAP like other products build them with an Enterprise mindset and make sure they are ready for the enterprise customers with the right security model and other integration features.
My team tool the datasets from SBA site and imported the datasets into SAC and merged it with other data like the NAICS code descriptions and also the location attributes.
The PPP program started on 4/3/2020 and is still going on. It was really interesting how some of the distribution changes over the 3 months the plan has been on.
If you look at the distribution of money in April, you can see Chase was clearly the largest distributor of loans and Bank of America was like 5th.
| April | May | June | Overall | |
| Loan Disbursement Bank | JPM/Chase, followed by Truist, PNC, KeyBank | Bank of America, JPM, Well fargo, US Bank | Kabbage Inc, Celtic, Cross River, BOA | JPM/Chase, Bank of America, PNC, Truist, KeyBank |
| Sector Paid Most | Construction, Health Care, Professional, Manufacturing | Health Care, Professional, Construction, Manufacturing | Health Care, Accommodation/Food Service, Professional, Construction | Construction, Health Care, Professional, Manufacturing |
| Sector with Highest Per Job Payment | Mining/O&G, Professional, Information, Construction | Information, Finance, Professional, Wholesale Trade | Management of Companies, Finance, Mining, Real Estate | Mining/O&G, Professional, Information, Finance |
Its interesting to see how different banks and industries joined this and how they benefited them. We also have analysis of the complete data available.
Data Provides so many insights and there are a lot more insights into the exact companies who took the money and what they do etc that we plan to run on this data. If you are interested contact us: info@digitalglyde.com
