Sales Dashboard for Midwest Industrial Lumber, Inc.

This summer I’ve had the privilege of being an intern at an industrial lumber distributor. Being their first-ever intern, it wasn’t a defined role, but that also gave me the opportunity to look for places in the business where I could provide real value.

I quickly realized the sales team didn’t have access to the data they wanted, so I exported our sales data from QuickBooks and used Plotly to build a dashboard showing customer trends over time, broken down by product type, specific customer, and specific sales rep. I also trained an XGBoost decision tree to predict the probability that a customer will still be buying from us in 6 and/or 12 months.