The challenge with embedding analytics is ensuring that it seamlessly blends in with the product you have already established, creating it in a cost effective way and deciding how often to refresh the data. We were able to extract and centralise a mixture of public data, spreadsheets and Connectd’s backend database into their warehouse. From here we modelled the data and created a dashboard in Metabase Pro. Using their advanced features, we could easily match the dashboard availability based on Connectd’s subscription levels. We batch processed the data so that every night it would update, reducing cost whilst still serving up timely insights.