Requirements and Features

In my previous post I discussed the core concepts behind Digital Asset Management. In the context of that definition, in this article I document how these concepts translate to the requirements and features that myActivo will implement.

I will then build the implementation plan on GitHub projects so the roadmap is visible to anyone interested in tracking the progress of this project.

I will also use this post to maintain the most current documentation of all the business requirements and features that the platform will be implementing.

I will also borrow concepts from agile software development where I think it fits the needs of the project.

From the point of view of the user, the myActivo platform should meet the following requirements.


  1. Allow the user to define and store arbitrary asset data structures. These structures will serve as templates for the information that each instantiation of that kind of structure will contain.
  2. These structures should be capable of nesting inside each other in order to create more complex hierarchies.
  3. Provide the ability to create template structures and use them as starting point of new ones.
  4. These data structures will also be used to manage and check all data exchange activities throughout the platform. Any data acquired, analysed or visualised through this platform will be checked against the structures defined in this module.


  1. Enable the acquisition of data from any source, i.e. spreadsheets, databases, physical devices, etc.
  2. Allow the user to map this acquired data to the fields defined in the data structures.
  3. Allow the user to specify whether only the latest data or a historical log of data should be kept. Data records with a log can be used to trace back other aspects of the framework like visualisations or decisions.


  1. Present the user with all the defined data structures and the data contained in them.
  2. Allow the user to define calculations and algorithms of arbitrary complexity. The user should be able to input algorithms using various means, Excel-like formulas, visual coding languages or a general programming language like C#.


  1. Enable the creation of basic charts and graphs based on the raw data and calculations defined in the previous modules.
  2. Enable the creation of dashboards and report pages. These pages can be defined in a hierarchical structure (i.e. parent-child relationships).
  3. Allow developers to embed and integrate other visualisation libraries (i.e. PowerBI, Sisense, Qlik, Tableau, etc.)


  1. Enable the comparison of various options, including the contextual information of each options.
  2. Record the information of a particular decision, including what, why, who, when and where a decision was made.
  3. Enable the user to “play back” a particular scenario or context in which a decision was made. Using the point in time in which the decision was made, the system should allow the user to inspect the contextual data and outcome of the various algorithms at that time.


  1. Allow the user to connect to a range of data sources. As an initial set of options, the system should be able to connect to SQL data bases, REST API’s and Excel/CSV files.
  2. Keep a log of changes to each data structure over time. This will allow to keep track of the changes a d evolution in these data definitions.

I am aware that the requirements above are ambitious. I might not be able to implement them all in the end, but I believe that asking the question and going through the process of trying to implement something and fail would be worth the time.

At least you, the reader, will be able to learn from my mistakes and know how not to do something.

By Carlos Gamez

As an Mechanical and Electrical Engineer by profession and Computer Programmer by passion I’ve been building my own software tools for over 20 years. My career has taken me across multiple engineering areas including Design, Manufacturing, Field Operations, Maintenance, Refurbishment, Product Development, Asset Management, Customer Service, Process Improvement, Consulting and Software Development. Mainly driven by challenges that I’ve faced on my day-to-day work and my own laziness and refusal to do repetitive and menial tasks, I always find myself creating software applications to automate the boring parts of my job. I quite enjoy the process of facing a brand new challenge, thinking about the best way to solve it, designing the architecture of the application and then implementing it. It is very satisfying to then see peers and colleagues use and benefit from my tools to make their lives easier and ease their workload.

Leave a comment

Your email address will not be published.

%d bloggers like this: