A fast-growing mid-sized company with inconsistent operations, delayed delivery, manual reporting, hidden vendor risk, and a leaking growth funnel. Each project is one chapter of diagnosing and fixing that and the output of each chapter feeds directly into the next. Standalone, each project showcases a distinct tool. Together, they tell a coherent business transformation story.

Meridian operates across 4 regions but every team runs the same core process differently. No one knows which version is right. Before anything can be fixed  delivery, reporting, risk. The current state has to be mapped and standardised. This is Chapter 1: diagnosis.

The automated reporting in Ch.3 surfaces something concerning: 60% of Meridian's operational spend flows through just 3 vendors. Leadership hasn't reviewed vendor contracts in 18 months. This chapter builds the risk scoring model that turns that raw data into a structured governance framework  and a Tableau dashboard that makes the risk visible.

With operations standardised, delivery structured, reporting automated, and vendor risk governed.  Meridian is now stable enough to focus on growth. But marketing spend has doubled while conversions have stayed flat. This final chapter analyses the full funnel to find where leads are dropping off and where budget is being wasted. The Plotly Dash app lets anyone on the team explore the data interactively.