CANVAS - PowerPoint Plugin

Design a PowerPoint plugin for file search and reuse

Royalty Pharma is a company who focuses on drug investment. In many cases the analysts conduct research and analyses on similar drugs/targets. However, the current system doesn't support analysts to reuse past materials. This Powerpoint plugin aims to help analysts recycle past materials while working on presentations to reduce time on due diligence.

My Responsibilities

  • Conducted meetings with analysts to understand workflows.
  • Created user journey map and persona
  • Coordinated with the design lead and data engineers on data extraction and preliminary design solutions.
  • Led the user flow, mockups, and prototyping.
  • Conducted A/B testing.
  • Coordinated with the team on design iterations.

Timeline

February 2023 to March 2023

Team

1 UX designer
1 project manager
1 design lead
2 data engineers
1 front-end developer

There should be a way for analysts to recycle past due diligence efforts to save time on research and analysis.

1. Research

Why plug in?

Royalty Pharma is a company who focuses on drug investment How it usually works is that the analysis team receives applications and conducts due diligence (research&analysis) to determine if it's a good investment.

For the applications on the similar drugs/targets. The analysis team has not developed a good way to reuse past researches. This plug in is really to help the team to recycle materials on a similar research and save their time.

What is the process of the current due diligence?

The team conducted interviews with a few analysts and asked them to walk through their process of doing due diligence. A few key things we want to distill from the meetings are:

  • How do they structure their file organizations?
  • How often do they reuse their past due diligence efforts?
  • How do they reuse them? an image? a slide? a section?
  • What are the pain points of doing the due diligence process?
  • What do they hope this process to be improved?

User Journey and Opportunities

Based on the interviews, I mapped out their journey to better understand their workflow and pain points. While I was doing the journey map, I was also able to distill some insights in opportunities.

2. Define

Persona

The project requires the design team and data team to work closely to solve users problems. For a better understanding of stakeholders' needs and how to improve the due diligence process from the design perspective, I created a persona to better frame goals, needs, and pain points.

Design Constraints

Meeting stakeholders' goals and needs is definitely the key of this design. However, the design is also impacted by the data model and technical constraints. The team is comprised of data engineers, designers, and developers. We worked closely throughout the entire project and set up plans in the early.

Data Extraction and Ingestion

What can users search for?

The data team worked closely with the analysis team on identifying what to extract in the past materials. This is very important since it shapes what users can search for. in the long run, it also shapes the list of features in design.

The items determined that analysts would need when reusing materials are: slides, images, and publications.

Technical Constraints

Is there any constraints in development?

I worked with the front-end developer on reviewing MS powerpoint plugin documentations to identify the technical constraints. Gladly, there were some recommendations but not really something definitely we cannot do. The developer finally decided to go with typescript framework.

3. Design Concepts

We explored different options while figuring out technical constraints and compare their pros and cons.

Key design components

Search, Browse, Insert.

Search

Search is the most complicated part of the plug in because it determines what and how users can get in results. I worked on multiple schemes that can be summarized into three concepts.

Concept 1 - Real-time research updates (search and results on the same page)

Pros: users get real-time update when revising search criteria.
Cons: slow down the search and the space for results is limited.

Concept 2 - Query builder (search and results are separated)

Pros: can accommodate more search criteria without putting too much pressure on the APIs.
Cons: users have to go back every time updating the search.

Concept 3 - Search by following the prompts

Pros: provide clear instructions.
Cons: may hard to track search criteria in the search bar.

We decided to go with concept 2 because:

  • The plug-in space is limited. Having both on one would make result browsing and search update difficult - especially when user searches for multiple tags.
  • Real-time updates will put pressure on APIs.
  • Leave room for more search criteria in the future.

Browse

The key design consideration for the result browsing page are: 1. how can users scroll. 2. do we want to support multiple views.

Concept 1 - Unlimited scrolling

Concept 2 - Pagination

We decided to go with unlimited scrolling because:

  • Users can stay on one page and get to results faster.
  • It doesn't put pressure on users to remember the place of the results (on which page).

Multiple views?

We discussed providing multiple views to allow users to choose their ways to browse results (large, small, extra small etc). However, the developer declined due to the technical difficulty.

Insert

The design consideration around insert is whether we want to support multiple inserts of the search results and how the flow is when multi-selecting.

Concept 1 - Multiple inserts

Concept 2 - Single insert

We decided to go with single insert because:

  • It causes messes for slide insert.
  • save efforts in development.

Final Design

Base Search

Search by file type, project, and key tags.

The users will follow prompts to set up search criteria step by step.

Advanced Search

Refine the search

Mentions
Users are allowed to get to desired results faster by selecting files that contains any type of tags including target, indication, drug, company, clinical trial, and keywords.

Date range
Users are allowed to get desired results faster by selecting files that contains any type of tags.

Other elements
Users can refine the search containing other elements such as images for slides.

Browse results and insert

Infinite scrolling

Users can infinitely scroll and insert a slide/image/publication.

Static search summary

The search summary will display on top statically for users to go back to search and visit search criteria anytime.

Revise results

Users can go back to the home page to revise results and clear by one click.

WHAT I LEARNED FROM THIS PROJECT?

Collaboration on understanding the data model and limitations of Microsoft plugin is very important for this one. We as a team spent a lot of time on figuring out the constraints and how we balance that with what client asked for before we dive into design.