Excel model transformation: Secure conversion, Easy operation & Robust auditability

This document outlines product requirements from my time at a FinTech organisation.

Objectives

In the financial and insurance sectors, actuaries construct intricate business models using Microsoft Excel. These models encompass vital logic and sensitive data necessary for processing input information and generating calculated results, such as financial planning and analysis models or insurance premium rate pricing models.

Imagine an Excel add-in that can extract the core formulas and logic from these models, transforming them into web services. Meanwhile, it transforms the input/output cells into a user interface in the Excel environment, enabling users like bank agents or insurance brokers to interact with the business model in Excel without exposure to the underlying logic and sensitive data. The new mechanics also monitors service usage, both from external and internal users, ensuring comprehensive auditing and the assessment of service performance and usability.

Product Discovery

Customer Identification

Identify the customers we have targeted to address their pain points and create a product that will be beneficial to them.

Value Proposition Canvas

The Value Proposition Canvas places the customer at the center of product development, which helps to create customer-centric solution by understanding customer needs, problems, and gains. It ensures a strong fit between the product and the market, and helps aligning the solution to the problem.

Competitors

Competitor research  was done and provided valuable insights into the market landscape, identifies gaps and unmet needs, and informs feature prioritisation. Analysing competitors provides valueable insights in benchmarking, setting pricing strategies, and understanding user preferences.

The 'Comparison' column facilitates the assessment of product features in the market and how this product distinguishes itself.

Product

Comparison

Other note

✔️ Author creates/maintain model in MS Excel

✔️ Distributes selected content from a model.

✔️ Tracks model usage (Accept submissions)

✔️ Control access to intellectual property.

❌ Operators work in the MS Excel environment.

 ❔  Select appropriate version of logic to operate.

❌ Preserves the VBA/plugins/macros 


✔️ Author creates/maintain model in MS Excel

  ❕   Distributes selected content from a model.

✔️ Tracks model usage (Accept submissions)

✔️ Control access to intellectual property.

❌ Operators work in the MS Excel environment.

❌ Select appropriate version of logic to operate.

❌ Preserves the VBA/plugins/macros 


❌ Author creates/maintain model in MS Excel

✔️ Distributes selected content from a model.

✔️ Tracks model usage (Accept submissions)

✔️ Control access to intellectual property.

❌ Operators work in the MS Excel environment.

✔️ Select appropriate version of logic to operate.

✔️ Preserves the VBA/plugins/macros 

Scope

Maintaining a well-defined product scope is essential in the product development process. It sets the project boundaries, offering a precise vision of the product's intended objectives. Moreover, the scope plays a crucial role in determining the project timeline and estimating the required resources.

MUST HAVE

NICE TO HAVE

NOT IN SCOPE

Deliverables

Defining deliverables in the discovery process establishes clear objectives and expectations. It ensures that the entire team understands the scope, goals, and outcomes of the project. This clarity helps in efficient resource allocation, streamlining tasks, and maintaining a shared focus on achieving the desired product.

Deliverables

Description

Cloud data platform (data storage)

Cloud platform portal

(User interface)

Excel add-in

Success Metrics

Helps to align product efforts with organisational goals, which provide data-driven insights for decision-making and facilitate accountability and prioritisation. They serve as a compass to ensure product managers' work directly contributes to the product's success and the organisation's mission. 

Goals

Metrics

Cloud platform portal

(User interface)

Excel add-in 

Milestones

Milestones provide clear, tangible markers of progress, helping teams track their journey from concept to delivery. These milestones serve as checkpoints for evaluating a product's development, enabling teams to identify and address challenges early, allocate resources effectively, and maintain alignment with project goals.

Important Note: Priority codes play a crucial role in organizing and prioritizing tasks, indicating the urgency level of a project. These codes, ranging from P0 to P4, help establish priorities, with P0 representing the highest urgency and P4 the lowest.

Deliverables

Description

Priority (P0 - P4)

1

Cloud data platform enhancement

Enhance the current Cloud  data platform to support new "shielded model" functionalities

P0

2

Excel add-in  (Create shielded model) via YAML 

A rapid prototype that doesn't involve the full development of an Excel add-in but delivers essential functionality, enabled by Script Lab.  The prototype supports shielded model creation.

P0

3

Excel add-in  (Model submission) via YAML 

A prototype which allows operatord to submit their finalized entries into the Cloud data platform.

P1

4

Front-end Cloud data platform access (Basic operations)

A simplified front-end interface for actuaries to export submission records, with data analytics capabilities in Power BI (manually conducted by actuaries)

P2

5

Excel add-in (Shield model submission) via Office JS

Development of a feature-rich Excel add-in that enhances user functionality and can be made available for download through the Microsoft Office store.

P2

6

Excel add-in (Create shielded model) via Office JS

Comprehensive  Excel add-in which supports both personas (Model creator and Model Operators)

P3

7

Front-end Cloud data platform access (Data analytics)

Comprehensive development of the front-end user interface for actuaries, integrating data analytics visualisations.

P4