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 |
- Alec Bennardo
- Elijah De Vera
- Cesar Gomez
- Daniel Herrera
- Lynn Lee
- George Melendrez
- Alex Pena
- Joseph Sandoval
- Ratul Uddin