Cal State LA and LA County Public Defender's Office

The Los Angeles County Public Defender's Office (LACPD) is the largest public defender's office in the country, with over 1,200 employees that include attorneys, paralegals, investigators, administrators, and support staff. The office supports approximately 9.3 million residents of Los Angeles County in criminal defense, juvenile cases, mental health placement and treatment, and racial and social justice cases.

LACPD currently uses Microsoft's Power BI software to generate reports to help them keep track of workloads, case loads, and district information. Microsoft Power BI is a powerful business analysis tool that allows users to generate dynamic reports with live data, creating real-time data visualizations. However, the office faces challenges with report generation, as it can be cumbersome for the IT department due to the higher level of technical knowledge required. Our goal is to create a user-friendly dashboard that allows for the generating of reports using easy to use queries. We are working closely with the LACPD liaisons to gather information, schedule and conduct interviews, and to gather user feedback for the project.

Teams