Joe from the Youtube channel Darwin's Hamster has posted a video he made for work on a database project he did for a court management and reporting system.
It's another good case study and is useful for both the new and seasoned business analyst. It gets quite technical as it goes on, but you need to know this stuff.
Set aside your lunch break (27 minutes) and take a look at the clip.
Business Intelligence Demonstration