reset password
Power BI Data Analytics Dashboard
Sponsored by Office of the Public Defender, Santa Barbara County
Yara Ajjawi, Markniel Cruz, Jevon Fan, Suresh Ghimire, Jiajun Gu, DeQing Liang, Elton Lin, Edwin Lugo Bautista, Tommy Ly, Winston Pham, Alvin Truong
Advisor: Chengyu Sun

Power BI is a business analytics service provided by Microsoft that lets you visualize your data and share insights. It converts data from different sources to build interactive dashboards and Business Intelligence reports. The Power BI software is part of the Microsoft Power Platform. Power BI provides cloud-based business intelligence services, known as "Power BI Services", along with a desktop-based interface, called "Power BI Desktop" It offers data warehouse capabilities including data preparation, data discovery, and interactive dashboards. Power BI’s interactive dashboards allow users to manipulate the data in real-time using filters to allow certain data to show while hiding others. More detail can be found on Microsoft's Power BI website.

 

Our project revolves around closely collaborating with the Santa Barbara County Public Defender team. We hold weekly meetings and communicate via email to determine what visualizations will fit the SBCPD team’s needs. After discussions during meetings, the student team will create the dashboards with their requested features and data. If the SBCPD team is unsatisfied with the dashboard or wants something modified, the student team accommodates.

 

Team meets with Advisors and Liasons every Friday from 8:00 AM - 9:00 AM

Student Team meets every Tuesday and Thursday starting from 5:00 PM

Team/Contact Information
PROJECT LEAD
Winston Pham wpham4@calstatela.edu
BACKEND DEVELOPERS
Suresh Ghimire sghimir@calstatela.edu
Jevon Fan jfan19@calstatela.edu
Jiajun Gu jgu4@calstatela.edu
DATA VISUALIZATION DESIGNERS
Yara Ajjawi yajjawi@calstatela.edu
Markniel Cruz mcruz74@calstatela.edu
DeQing Liang dliang@calstatela.edu
Elton Lin elin13@calstatela.edu
Edwin Lugo Bautista elugo5@calstatela.edu
Tommy Ly tly2@calstatela.edu
Alvin Truong atruong7@calstatela.edu
LIASONS
Deepak Budwani dbudwani@countyofsb.org
Sarah Rothschild srothschild@countyofsb.org
Bryan Burzon bburzon@countyofsb.org
Angella Stokke astokke@countyofsb.org
Aidan Bassett abassett@countyofsb.org

 

Resources
[Private Resource] Microsoft Power BI Presentation Fall 2021
SRS
SDD
Power BI Data Analytics Dashboard Poster
Video Presentation
PowerPoint Presentation
PowerPoint Presentation PPTX File
Project Report