Walmart Foundation

Design a digital product to help the foundation manager manage her responsibilities efficiently.

The TEam

Solo research project

Responsibilities

User experience, visual design, data visualization

TimelinE 

June 2021

Team

Design challenge

My Role

Product Designer

Responsibilities

UX design, UI design, Data visualization, Product building

Year

2021

Introduction

About the project

Walmart and the Walmart Foundation generally provide more than $1 billion in cash and in-kind to support programs that align with our philanthropic priorities. They strive to systematically address some of the biggest economic, environmental, and social challenges faced in the world today. But they can’t do it alone. They work closely with our grantees to address large-scale environmental and social challenges.

Walmart has enabled Grantees (NGOs, Volunteers, Social Workers, etc.) to submit their donation requests with their purpose and needs. They get their grants reviewed and approved by our business team.

The problem

Sarah is a manager at the Walmart business team, responsible for:
1. Review and approve the donation requests
2. Manage and allocate the donation budget
3. Generate reports

Design a digital product to help Sarah manage her responsibilities efficiently.

Breaking down the problem

Understanding user and identifying opportunities

The user - Sarah is a manager at Walmart business team. The main need we’re addressing with this product is to enable how effectively Sarah can manage her work. To do that, I believe these are the solutions the product should be addressing following needs:

  • How should Sarah manage the donation requests?
  • How would Sarah understand more about the grantees requests and their background?
  • What can Sarah do to make sure grants (money, goods and storage spaces) are distributed effectively within the budget?
  • How can she easily generate donation reports?
  • How can she see overview of allocations geographically, if needed?


Determining design solution & assumptions

Since Sarah is a business professional, most of her working time would be spent at the computer, hence I believe the core digital product should be a web app. It would help her provide the best experience to manage her work and responsibilities more effectively.

This app should also provide a mobile experience, in case she has any field work like meetings, and might need to be updated on the grantees profiles and requests on the go, owing to business needs.

Assumption: Since there is no unit measurement for goods and storage, the total budget includes money, goods, and storage spaces cumulatively.

Measuring success and business outcomes

Running a user test on the app design and understanding how Sarah performs the main actions would help us measure the success critically. Since the application will affect the key metrics of the product as a whole, so business KPIs and Sarah’s performance would be useful for measuring its success. Some critical success factors could be measured by -

01

Effort and satisfaction - Sarah should be able satisfied can be measured for approving grants and accessing their profiles

02

Time on task - Average time taken for Sarah to approve the eligible grants

Brainstorming

Storyboarding ideas & user journey

This approach helped me breakdown the possible user journey, user flows and requirement gathering for all use cases. With the help of storyboards, I started thinking about what content I could provide to assist the Sarah during her work management and identify possible edge cases.

The dashboard would the main entry point to the app and I believe it has 2 main goals:

  • Informational - providing an overview of requests
  • Navigational - providing quick access to the app’s main areas and actions

Identifying key use cases

The informational goal could be achieved by fulfilling Sarah’s needs we discovered earlier:

01

How should Sarah manage the donation requests? - Providing an overall view of requests

02

How would Sarah understand more about the grantees requests and their background? - Providing a overall review of applicants profiles

03

What can Sarah do to make sure grants (money, goods and storage spaces) are distributed effectively within the budget? - Providing a budget distribution system

04

How can she easily generate donation reports? - Providing a quick tool to export reports

05

How can she see overview of allocations geographically? - Showing map allocations view

Information architecture

Identification the structure of all the content/information. Once I was clear about the ideas and what direction I wanted to take, I could structure the information of the platform simply.

Initial wireframes

I created digital wireframes before creating final design solutions.

This helped me to gauge how much space will need to be allocated for each feature, connect the site’s information architecture to its visual design, and clarify the page’s functionality.

The solution

Design deep-dive

Visual design components for the dashboard solution -

Link to Figma prototype

Dashboard overview

The home dashboard design provides -

  • Overview of requests - approved, pending and rejected.
  • Donation summary based on various grants allocation.
  • Tabular overview of recent requests - id, title, org type, sorted submission date-wise, grant-wise and their current status.
  • Demographic overview of the US based on the kind of organisations the donations have been made to.
  • Viewing filters via day, sorting options and quick csv generation.

Hypothesis: A more structured content display would help Sarah view the information more easily.
Metric: This would help in activation of quick access to requests and required actions.

All requests overview

The requests overview focuses on sharing requests. To structure the content more simply, I chose a tabular view to run through the requests. Additionally, there is sorting on rows and filter views by location and time-span.

Hypothesis: Sarah can run through the requests more easily, click on any request to view more details on individual request to be able to approve or reject them.
Metric: This would help Sarah in efficiently reviewing the donation requests and generate quick report.

Request details overview

The requests details page displays the breakdown details that the an applicant inputs while creating a request in a form format.

  • It supports a breadcrumb navigation structure from Requests screen.
  • The footer on this page is sticky & consists of CTAs - Approve or Deny request.
  • Sarah can also download the request copy for reference.

Hypothesis & Metrics: This view would let Sarah to approve or deny the requests very easily while letting her view the overall request details, enabling overall satisfaction & reduced effort.

Reporting solution overview


The reporting details page displays options for different reporting data. For visibility I have put them in different visualisation data models, they can also be seen in list view via filters.

  • Including data on - Requests, Budget info, Demographics and grants distribution, overview, organisation, etc.
  • Generate Reports CTA - would show more options on report formats like .pdf, .csv, .excel reports, etc.

Hypothesis & Metrics: This helps in generating reports on various data, and also gives an overview of data analytics.

Conclusion

Key learning & challenges

  • Since the project span was short, it was very challenging and a great learning experience.
  • Understanding data points and budget allocation was very complex and to solutionize for allocation model was a big challenge given it relied highly on assumptions.
  • With this solution, I believe a fraudulent check on requests would be a good add-on to the solution to ensure the donation are authenticated.
  • The mobile experience would be a key add-on, if it aligns with the business needs.