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

    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.