Bits and Bytes Blog
ODGA and the Department of Motor Vehicle Dashboards
Thursday, July 27, 2023
About the Office of Data Governance and Analytics (ODGA)
The ODGA partners with Commonwealth agencies and public institutions to maximize the value of Commonwealth data through strategic governance, secure and appropriate data sharing, and enterprise analytics services informing actionable intelligence. The office is led by the Chief Data Officer for the Commonwealth of Virginia and is made up of a team full of talented professionals.
Brief Description of Dashboard Project
The ODGA partnered with The Chief Transformation Office (CTO) to automate an Excel Dashboard that recorded wait times and other metrics at Department of Motor Vehicle (DMV) locations.
Scope of Work
Prior to collaborating with the ODGA, DMV monitored their Executive Performance data through an Excel dashboard, which measured metrics such as average wait time, number of customers served, and service time for DMV locations. The data was updated manually in a process that took on average one hour daily.
The ODGA created an automated Power BI dashboard that captured all the Executive Performance data. This dashboard could be instantly updated in the Power BI platform. This dashboard was visually effective, efficient, and easy to use.
ODGA’s automated Power BI dashboard provides instant updates, saving the Transformation Office an hour a day and removing the need for manual uploading. This in turn helps minimize opportunities for human error.
The Power BI Executive Performance Metric Dashboard has saved time and created more efficiency for the Transformation team. The time savings has been reallocated towards making the DMV more efficient and effective. The dashboard helps drive decision making that improves performance.