Transform Recent Reports into Power BI Dashboard

[rebekkabry]

• Test out transform most recent reports (2) into Power BI Dashboard.

• Link to Sharepoint

• Is it valuable?

• Should the report datasets be pushed to Open Data Portal or continue to manaully run/import in?

• SHould Maximo Start Center be considered. Meet with Rene.

[rebekkabry]

Updates 10/24/24

• We have successfully connected to the DBeaver DB and pulled in the needed tables to match most of the recent queries/reports built by Ganesh.
• We are currently testing the relationship between the tables
• Currently bi-weekly meetings with Rebekka and Ganesh to test and review.
• Pending ServiceNow response for Ganesh DB credientials.

Tables that have been successfully added and currrently testing.

TO DO

• Plan to map out column and table needs to share with Data Science to update the Datahub dataset to mirror more of the report needs data.

[rebekkabry]

10/30/24

• Pending updates from ServiceNow on download of PowerBI for Ganesh
• Completed importing additional tables into Power BI
• Imported Ops Data Mapping for CSR Requests

• Unable to Save after adding LKP PersonGroup and FailureCode
• Need to get help

[rebekkabry]

11/7/24

• able to get all tables needed for reporting (that we can find to date)
• testing building out Daves Monthly report
• Starting with 311 Consolidation