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 one of our Design Consultants 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

    Inside Config 2025: What’s New in Figma

    Config 2025 kicked off with a bang on Day 1. Figma’s annual conference brings together designers, developers, and all those involved in the making of a product. The 2-day event has a stacked lineup of accomplished speakers ready to share their insights on the world of product building. At today’s opening keynote, the Figma team, […]

  • Digital Products

    Choosing the Right Modernization Approach

    When organizations decide it’s time to modernize their technology infrastructure, choosing the right approach is crucial. Modernization isn’t merely a technical upgrade; it’s a strategic business move that significantly impacts growth, agility, and long-term success. Here’s how your company can effectively begin to select the best modernization strategy tailored to your goals and challenges. In […]

  • Digital Products

    TAG Panel: Differentiate Your Customer Experience

    Join the CX and Product Management Societies to hear from our panel of Human-Centered Design experts on the business value of Agentic AI.

  • Digital Products

    The Bloated SaaS Era: Paying More for Less While Businesses Wait

    SaaS was supposed to make business faster, smarter, and more efficient. Instead, it’s become bloated, expensive, and painfully slow to change. The platforms we rely on—Salesforce, Workday, SAP, and others—haven’t truly innovated in years. Yet, they demand massive investments in re-implementation, process re-engineering, and data migration just to keep up. It’s time to ask: Are […]

  • Digital Products

    Reid Braswell Joins UDig as Vice President, Software Engineering

    UDig is proud to welcome Reid Braswell as our new Vice President of Software Engineering. With over 13 years of experience in technology consulting, Reid brings deep expertise in digital transformation, modern software engineering, and client-focused solutions. His leadership and passion for solving complex challenges make him an exceptional addition to the UDig team. Reid’s […]

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