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 datadriven 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

The agencys 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 approachUDig analyzed the agencys 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 enduser. 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

    State IT Leadership & Partners Converge in NOLA

    Takeaways from the NASCIO 2024 Annual Conference This premier event brings together state CIOs, industry experts, and vendors to discuss the latest trends, challenges, and innovations in the business of IT for state government. This event was the largest ever as this community continues to grow and innovate for its citizens. Key Takeaways Generative AI & […]

  • People

    Digging in with David Allen, State Government Lead

    Digging In is a regular series of blog posts profiling UDig employees. We hope this series helps you get to know our team and understand why we dig what we do! Today, we are sitting down with David Allen, State Government Lead. UDig: Tell us a little bit about your background and your role at […]

  • State Government

    Exploring the Future of State Technology: Takeaways from the NASTD 2024 Annual Conference

    Last week, I attended the National Association of State Technology Directors (NASTD) 2024 Annual Conference in Minneapolis, MN. This premier event brings together state technology directors, industry experts, and vendors to discuss the latest trends, challenges, and innovations in state technology. The conference fosters the exchange of ideas and best practices essential for addressing shared […]

  • 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

    Improving the Process and Accuracy of State Permits and Inspections

    A custom, user-centered application that supports existing business processes, allows for function-wide automation, and converts data from a legacy system while meeting state compliance requirements.

  • State Government

    Unlocking Data Insights for a State Education Agency

    A data-enabled agency that can leverage predictive analytics to provide its school districts, students, and parents with data-driven information that fosters informed decisions.

  • 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 […]