LAPD Project 3 (Power BI)

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 users to generate 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. 

Note: This is the first semester for this project with LACPD                                                                                                                                      

CAL STATE LA Team
Mark Baldwin (Advisor)
Name Contact Info
Daniel Herrera dherre119@calstatela.edu
Lynn Lee llee61@calstatela.edu
Ratul Uddin ruddin@calstatela.edu
Joseph Sandoval jsando183@calstatela.edu
Alec Bennardo abennar@calstatela.edu
Cesar Gomez cgomez156@calstatela.edu
Alex Pena apena74@calstatela.edu
Elijah De Vera edevera@calstatela.edu
George Melendrez gmelen19@calstatela.edu
LACDP Liaison
Mohammed Al Rawi
Gratia Dsouza
Mario Bonifacio

 

Meetings
Group With LACPD Liaison Wednesday 0900-1000
Team Meeting with Advisor Friday 0800-0900

 

 

 

Student Team
  • Alec Bennardo
  • Elijah De Vera
  • Cesar Gomez
  • Daniel Herrera
  • Lynn Lee
  • George Melendrez
  • Alex Pena
  • Joseph Sandoval
  • Ratul Uddin
Project Liaisons
Faculty Advisors