SBC Finance Data Warehouse - Dashboard

danaannab commented 10 months ago

Ability for SBC Finance to:

Widget/Dashboard to match data lifted from CAS (Total Paid $, invoice #)
Widget/Dashboard will display in red or green.
- red if data does not match between BCROS and CAS
- green if data matches between BCROS and CAS
Discrepancy can be status/amount paid
- Status (paid, pending, failure - 7 statuses available)
user guides that show how to pull reports for singular records and aggregate records
Enterprise system to pull report and Exports them into Google Sheets
Information from the day before fed into BCROS Reports.

thorwolpert commented 10 months ago

Can we give them online Google Sheets? We can put in some basic rollups, etc. more easily then They can export to desktop Excel if they want then.

danaannab commented 10 months ago

Great idea @thorwolpert I will bring it up in discussions with John L and client :)

bcgov / entity