Let me tell you about the time we built a data warehouse and dashboards to discover our red-yellow-green dot system could be reduced to just red and green.

Seriously though, the best analytics project I ever worked on was designing a data model to understand and improve the efficiency of a state court system.

Questions like 'with case types of X, are certain judges consistently more efficient than others?' and 'how fast on average does each judicial district clear cases?'

Lots more I can't remember, but it was fascinating stuff and no one had done anything like it at the time. The guy in the state court system spearheading it was a pioneer. Designing that data model was a blast.