Solution

Catalog

Solution

Catalog

CONTEXT

From spreadsheet to a user-friendly dashboard

From spreadsheet to a user-friendly dashboard

Motriz hired me as a freelance product designer to transform its solution catalog into a more efficient and strategic tool. The organization supports education departments in various Brazilian municipalities and offers training programs on racial equity, gender, literacy, and inclusion.

Previously, these training programs were selected manually through a static spreadsheet, which contained only basic information such as the solution's name, responsible organization, covered topic, and a proposal document.  My challenge was to create a more intuitive and functional experience, not only organizing the solutions but also enhancing decision-making and process management.

Motriz hired me as a freelance product designer to transform its solution catalog into a more efficient and strategic tool. The organization supports education departments in various Brazilian municipalities and offers training programs on racial equity, gender, literacy, and inclusion.

Previously, these training programs were selected manually through a static spreadsheet, which contained only basic information such as the solution's name, responsible organization, covered topic, and a proposal document.  My challenge was to create a more intuitive and functional experience, not only organizing the solutions but also enhancing decision-making and process management.

YEAR

2025

ROLE

PRODUCT DESIGNER

TEAM

BI ANALYST

TOOLS

FIGMA
LOOKER STUDIO
GOOGLE SHEETS
FIGJAM
HTML
CSS

PROBLEM

How can we create a catalog that not only organizes the solutions but also enhances the user experience?

How can we create a catalog that not only organizes the solutions but also enhances the user experience?

The management needed to turn the solution spreadsheet into a more interactive catalog, making searches easier and encouraging greater use. In its current form, finding information was difficult, and the layout was unclear, complicating the selection of training programs.

The main challenge? A short 15-day deadline to develop the solution, requiring careful decisions to balance practicality, ease of use, and performance.

The management needed to turn the solution spreadsheet into a more interactive catalog, making searches easier and encouraging greater use. In its current form, finding information was difficult, and the layout was unclear, complicating the selection of training programs.

The main challenge? A short 15-day deadline to develop the solution, requiring careful decisions to balance practicality, ease of use, and performance.

After

Original search spreadsheet with blurred information to protect the client's confidential data.

After

Before

Before

Solution Catalog and Dashboard in Looker Studio

Original search spreadsheet with blurred information to protect the client's confidential data.

Original search spreadsheet with blurred information to protect the client's confidential data.

After

Solution Catalog and Dashboard in Looker Studio

Solution Catalog and Dashboard in Looker Studio

SOLUTION

Optimized Solution Catalog and Management Dashboard

Optimized Solution Catalog and Management Dashboard

Solution Catalog

Solution Catalog

  • Search for registered solutions and consulting services.

  • Suport section with guidelines on procurement and evaluation procedures.

  • Access to the evaluation form for implemented proposals.

  • Search for registered solutions and consulting services.

  • Suport section with guidelines on procurement and evaluation procedures.

  • Access to the evaluation form for implemented proposals.

Proposal

Summary

and Evaluation

Proposal Summary

and Evaluation

Proposal Summary and Evaluation

  • Solutions with ratings to assist in implementation decisions.

  • Cards displaying key solution details without needing to access the full proposal.

  • Solutions with ratings to assist in implementation decisions.

  • Cards displaying key solution details without needing to access the full proposal.

Management

Dashboard

Management

Dashboard

  • Login with restricted access for managers.

  • Access to a dashboard for tracking registered solutions and consulting services.

  • Solution and consulting service registration.

  • Access to essential documents for registering new solutions.

  • Login with restricted access for managers.

  • Access to a dashboard for tracking registered solutions and consulting services.

  • Solution and consulting service registration.

  • Access to essential documents for registering new solutions.

PROCESS

Collaborative Process

To develop a user-centered solution, we followed a structured process. We started with interviews and process analysis to understand needs. Then, we conducted journey mapping to identify key steps and pain points for managers and implementers. In the co-creation phase, we defined functionalities through ideation and feature prioritization.

The solution took shape in the prototyping stage, with wireframes and Looker Studio implementation. Finally, we refined the product through testing and validation, gathering user feedback to make necessary adjustments.

To develop a user-centered solution, we followed a structured process. We started with interviews and process analysis to understand needs. Then, we conducted journey mapping to identify key steps and pain points for managers and implementers. In the co-creation phase, we defined functionalities through ideation and feature prioritization.

The solution took shape in the prototyping stage, with wireframes and Looker Studio implementation. Finally, we refined the product through testing and validation, gathering user feedback to make necessary adjustments.

Research

Research

Journey

Mapping

Journey

Mapping

Co-creation

of Solutions

Co-creation

of Solutions

Prototyping

Prototyping

Testing and
validation

Testing and
validation

Managers' journey map: From registering new solutions to monitoring implementations.

Managers' journey map: From registering new solutions to monitoring implementations.

Implementers' journey map: From searching for a solution to contracting and implementation.

Implementers' journey map: From searching for a solution to contracting and implementation.

OUTCOMES

Evaluation for Better Decision-Making

Solutions can now be evaluated with structured criteria, providing insights for future selection and improvement.

Real-Time Monitoring of Implemented Solutions

dashboard allows managers to track solutions in execution, improving transparency and strategic follow-up.

Solutions can now be evaluated with structured criteria, providing insights for future selection and improvement.

Real-Time Monitoring of Implemented Solutions

dashboard allows managers to track solutions in execution, improving transparency and strategic follow-up.

Obrigada for visiting!

Obrigada for visiting!