Your Privacy

This site uses cookies to enhance your browsing experience and deliver personalized content. By continuing to use this site, you consent to our use of cookies.
COOKIE POLICY

State Government

Centralized Approach to Data Quality Increases Visibility into Process Bottlenecks for State Agency 

Centralized Approach to Data Quality Increases Visibility into Process Bottlenecks for State Agency 

A modern data vault and enhanced reporting set the stage for a large state agency to increase visibility into data quality issues. This modernization effort created a centralized data repository enabling the organization to be hyper data–driven and establish a data governance program to raise the standard of data quality to improve internal business processes and provide better customer service.  

How We Went from Ideas to Impact

  • The Idea

    Ongoing data quality issues created bottlenecks in business processes and an overall lack of internal data trust. 

  • The Process

    Enable stronger data quality through identification and increased visibility into data quality issues to improve business processes. 

  • The Impact

    Build a centralized dashboard to monitor data quality issues to enable a proactive approach to resolve data issues negatively impacting the agency. 

The Idea

The agency‘s complex financial calculations are dependent upon accurate data figures. Without a comprehensive program to identify issue patterns, underlying problems went unnoticed for long periods of time until they affected crucial processes.  Many data quality issues were identified, but the records of these issues were divided between many systems, making it difficult to accurately scope the organization’s impact, decreasing confidence in the data for business users.  

The Impact

The new data vault created a centralized repository enabling our team to create a centralized data quality approach. UDig analyzed the agency‘s data fix logs and interviewed subject matter experts to identify data issues regularly encountered in their work. Working side-by-side with our client, the team conducted targeted data analysis, isolating all instances of these data quality issues into a series of discrete business rules. These rules were used as the basis for an interactive Tableau dashboard, allowing users to track data quality issues over time and target the largest data quality patterns. The visibility afforded by the dashboard enabled the agency to take a proactive approach towards the resolution of these issues and implement fixes before they affected the end–user. This proactive approach to data quality has allowed for increased visibility into process bottlenecks and improved data trust.

  • How We Did It
    Dashboard UX/UI DesignData Strategy & GovernanceExploratory Data Analysis
  • Tech Stack
    TableauMicrosoft SQL ServerSSISPython

Digging In

  • State Government

    UDig Welcomes David Allen as State Government Lead for Georgia

    UDig, a technology consulting company, is excited to announce the latest addition to our team, David Allen, who will take on the role of State Government Lead in Georgia. With two decades of technology experience in both the public and private sectors, David brings a wealth of experience and a deep understanding of the market […]

  • State Government

    NASCIO Midyear Conference | 4 Key Takeaways

    I attended the National Association of State CIO (NASCIO)’s Midyear Conference for the first time in National Harbor, Maryland. It was my first time at a NASCIO event, and what struck me most was how collaborative the NASCIO community is and how passionate these leaders are about serving their state’s constituents and employees.   Each […]

  • State Government

    AI in State Government | Observations from Tech Summit

    The Georgia Emerging Technology Summit: AI 2023 offered valuable insights into the current state and future of artificial intelligence in state government. While many states are still grappling with the policy and ethical considerations surrounding AI, the potential for transformative applications across various departments is undeniable. Key Takeaways | AI in State Government Policy & […]

  • State Government

    Predicting Student Performance Through Machine Learning

    With the level of data collection in modern education, there is a growing interest in using this data to identify students who are potentially falling behind and pinpoint areas in which they can improve. With the extensive data collected by educational institutions, we can leverage machine learning to help educators by flagging if a student […]

  • State Government

    Best Practices for Building an Engaging Digital Citizen Experience

    Whether renewing their car’s registration, paying a fine, or applying for social services, citizens expect to be able to interact with state agencies digitally to find the information they need and efficiently address their needs. Embracing your agency’s digital ecosystem will not only improve your constituents’ perception of your agency but can also enhance service […]

  • State Government

    VA Academic RPA CoP Releases Paper to Accelerate RPA in VA Higher Education

    The VA Academic Robotic Process Automation (RPA) Community of Practice (CoP) released its first primer designed to help universities on opening steps in the automation journey to bring greater effectiveness and efficiency to academic institutions. The CoP co-authored the paper with Jessa Barnes, Advisor of the CoP and Practice Lead, Intelligent Automation for UDig, a […]

  • State Government

    Streamlined Business Processes and Improved User Experience for Legislation Management

    Drafting and tracking bills through the state legislative process is multifaceted, requiring many steps of collaboration and review from government leaders, lawmakers, and drafters. Historically, this process has been cumbersome as it has relied on manual tasks and paper-driven reporting to meet each legislative element. Any software used to track the bills has typically become outdated, needing extensive upgrades. So, when a legislative technology company had a vision for helping a state government modernize its business processes and systems, they contacted UDig. As strategic partners, we worked together to design and build a flexible, collaborative tool that transforms how state governments manage the legislative process.