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

Skip to main content

Revolutionizing Business Case Templates: A Deeper Look at UDig’s New Web App

By Patrick Kliebert

Revolutionizing Business Case Templates: A Deeper Look at UDig’s New Web App 
Back to insights

This summer, our software engineering interns undertook the challenge of reimagining UDig’s Business Case Template. The transformation of business case management at UDig is a story of collaborative effort and innovative thinking. Let’s delve into the key aspects that drove the creation of this new web app: the UI, the database structure, and the technology stack. 

UI: From Excel to an Intuitive Web App Experience

The genesis of this project revolved around converting a large Excel spreadsheet into a user-friendly interface. This undertaking began with breaking down the spreadsheet into various pages and it’s rows into forms. 

The original mockups centered around a fixed left navigation bar with a flexible space on the right for forms. However, the project took an exciting turn when Rob Phillips, VP, Software Engineering, challenged the team to think about mobile compatibility. This triggered a rapid refactoring of the app’s design to ensure responsiveness across various devices, from mobile to laptop or larger resolutions. Collaborating with Jacqueline Arce, UX/UI Design Consultant, proved invaluable in taking the team’s designs to an industry-standard level of polish. 

Through continuous feedback and iteration, the team was able to condense fields, add dropdown menus, and streamline navigation. The result is an intuitive user experience that transformed the Business Case Form’s user interaction completely. 

Database: Understanding Users with PostgreSQL

The shift from an Excel-based system to a web app opened up new avenues for enhancing our understanding of potential clients. Building the web app atop a PostgreSQL database allows UDig to compartmentalize the data into seven tables: users, objectives, costs, benefits, qualitative benefits, assumptions, and summaries. 

These tables, combined with Apollo GraphQL endpoints and Hasura for database management, enable UDig to gather valuable insights into industry trends. The rich data, including user experience metadata, will aid UDig in making more informed decisions, fostering relationships with clients, and navigating new markets. 

Tech Stack: Leveraging Modern Technology for Performance

The project’s success can also be attributed to the choice of a robust tech stack. Utilizing TypeScript and React for the front-end development ensured scalability and maintainability. Tailwind CSS played a pivotal role in crafting responsive and visually appealing designs. 

The combination of Hasura hosting a PostgreSQL database with GraphQL endpoints created a seamless data querying and manipulation experience. This integration significantly enhanced the overall performance and responsiveness of the application. 

Conclusion: A Collaborative Triumph

The development of UDig’s new web app marks a practical and meaningful transition from a conventional Excel-based approach to a more accessible and intuitive platform. With attention to user experience, data management, and technology integration, this project reflects a thoughtful and collaborative effort towards improvement. It’s a step forward that aligns with UDig’s commitment to understanding clients better and efficiently managing business cases. It’s not just about using new technologies, but using them wisely to create real value.

Check out our new web app: /business-case-form/

 

Digging In

  • Digital Products

    Energy 2025 – Expansion of Fossil Fuels or Carbon Reduction?

    Now that the election is behind us, we have an opportunity to anticipate the possible effects on the energy industry under this new administration. What strategies will be impacted? What will remain the same? What opportunities can we take advantage of in 2025? This blog is meant to dig into these questions and provide some […]

  • Digital Products

    The Growing Importance of Digital Accessibility

    Embracing Digital Accessibility: A Moral and Business Imperative In today’s digital landscape, accessibility has become crucial for businesses and organizations. With increasing awareness and legal requirements, ensuring that digital products are accessible to all users, including those with disabilities, is not just a compliance issue but a moral imperative. At UDig, we champion ADA compliance […]

  • Digital Products

    Unlocking Business Potential: The Power of Custom Application Development

    Like any savvy business leader, you’re likely always on the lookout for tools to give your company a competitive edge. And in doing so, you’ve undoubtedly considered investing in custom application development. But the question is, how do you ensure that such a major investment in a custom web application development provides a strong return on […]

  • Digital Products

    Mastering Legacy Application Modernization: Strategies for Success

    The ironic truth of the business world is that change is the only constant. But this means that failing to keep pace with the competition and its technologies will only end with you falling behind. That’s where legacy application modernization enters the fold. When you modernize legacy applications, your team gains access to new features […]

  • Digital Products

    CTO Confessions Podcast

    In this episode of CTO Confessions, Rob Phillips, the Vice President of Software Engineering at UDig, digs into his journey from a passionate technologist in his youth to a seasoned leader in the tech industry. He shares valuable lessons on transitioning to senior leadership, the importance of understanding and articulating company problems, and the art of empowering teams for high performance.

  • Digital Products

    Navigating the Challenges of On Premise to Cloud Migration

    In today’s rapidly evolving technological landscape, the shift from on premise solutions to cloud-based infrastructure has become a pivotal transformation for organizations seeking to modernize their IT operations. This transition holds the promise of increased agility, cost savings, and enhanced scalability. However, it is not without its set of formidable challenges that organizations must navigate. […]