As FISCal continues to work to increase the system’s transparency and reporting capabilities, we are pleased to announce the creation of a COVID-19 Transaction Dashboard in Power BI. This dashboard, released in early October, allows departments to review all COVID-19-related transactions in FI$Cal.
In conjunction with the release of this dashboard to all departments, FI$Cal is exploring the publication of COVID-19-related expenditure data on our public-facing transparency website, Open FI$Cal. This is consistent with direction from the Governor’s Office to publish all COVID-19-related information in a machine-readable format. Our hope is that departments use the dashboard to ensure that the COVID-19-related information in the system is as correct and complete as possible.
All departments should already be associating all COVID-19-related transactions with projects that have the COVID-19 attributes of stimulus programs, response, or testing and contact tracing. This is consistent with the guidance provided by the Department of Finance in Budget Letter 20-12, dated June 8, 2020. If your department is not yet following this process, please review the budget letter and begin following it as soon as possible. Our ability to report COVID-19-related information is dependent on data being entered consistent with the budget letter’s instructions. If you need assistance, please reach out to your FI$Cal relations coordinator or Finance FSCU analyst.
Please use Identity Self-Service to assign the “Power-BI COVID Viewer” role to the appropriate staff in your organization. People with this role will be able to view the data in the COVID-19 Transaction Dashboard.
If FI$Cal does publish detailed COVID-19-related expenditure information, the level of detail would be the same as the expenditure information already published on Open FI$Cal, with the addition of the COVID-19-related project attributes.
Department liaisons by now should have assigned the Power-BI COVID Viewer role to the appropriate staff and had them review your COVID-19-related transactional data, to ensure the data is as accurate as possible. If you have any questions or concerns about this process, please send an email to transparency@fiscal.ca.gov.