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

New Data Vault Architecture for Large State Agency Creates Central Repository and Enhanced Reporting

New Data Vault Architecture for Large State Agency Creates Central Repository and Enhanced Reporting

As part of a modernization effort, a large state agency sought to upgrade their infrastructure, streamline their business processes and enhance their reporting capabilities. While part of this effort entailed replacing their data architecture, they also sought a short-term solution to establish a BI platform and data model which would be scalable and adjust with their future needs. UDig’s Data Enablement team partnered with the agency over the course of several months to establish a data vault architecture and business intelligence reporting tool to meet their needs and position them for success as their requirements evolved.

How We Went from Ideas to Impact

  • The Idea

    Legacy systems facing deprecation in the near future are located in multiple locations which makes it difficult for the agency to easily pull critical reports.

  • The Process

    Create current data warehouse structure, improve usability for business users and improve flexibility and scalability as future data plans evolve.

  • The Impact

    Establish data vault architecture to function as central repository and enhance reporting capabilities through a simple BI platform to streamline information gathering process.

  • The engagement improves operational efficiency and reduces costs through eliminating previously manual reporting processes.

The Idea

The agency’s existing reporting structure pulled from multiple source systems and was mainframe focused. In addition to being decentralized, the five separate systems being utilized were slated for deprecation in the near future. Reports lacked one source of truth and integration, and were difficult to access. Users were required to submit requests to a team who would then manually build the reports with the information desired. This was both a time-consuming and cumbersome process and, in combination with the inflexible data warehouse in place, limited the agency’s ability to easily consume the information they sought in their reports. 

The Impact

Following an agile methodology, we articulated requirements of the architecture design through developing user and non-user stories. We then completed data profiling on the source tables to become familiar with the data itself and designed a flexible architecture to meet the immediate needs of the agency while also accommodating any future modifications associated with their overall modernization effort. 

We sought to consolidate the multiple systems being used and establish one source of truth for the agency’s reporting and as such, created a centralized data repository. We established a data vault architecture to replace the existing traditional reporting repository structure and in doing so, provided a more flexible and extensible system with improved ease of maintenance. The data vault was designed in a way that allows for easy modification to data as needs change over time. BI reporting capabilities through SQL became more efficient, as establishing one central repository for the data streamlined the overall reporting process. Users gained the ability to generate reports autonomously and without the need to request information from their support team.  

The engagement improves operational efficiency and reduces costs through eliminating previously manual reporting processes. The enhanced reporting also provides increased transparency within the organization and enables better decision making with improved outcomes. Creating a view of the new source systems within the centralized repository improves the quality and overall integrity of the data itself, and the new architecture provides extensibility for the agency.   

  • How We Did It
    Dashboard UX/UIData Sharing SolutionInteractive BI ApplicationWarehouse Acceleration
  • Tech Stack
    TableauSQL ServerSSIST-SQLApex SQL SearchVisual Studio (SSDT)

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