A law firm's numbers looked healthy at 56.8% profit margin, until I dug into who was actually doing the work. Partners were carrying nearly 3x the workload of Associates, not because they worked harder, but because of how cases were assigned. I also found €773M sitting uncollected and seven of the firm's ten highest-revenue clients flying under the radar because they weren't flagged as strategic. Built in Power BI across 15,000 cases, 200 lawyers, and 800 clients.
Link