Segmentation Portal

2023
Front-end
Design

LifeMD wanted to easily view reports of it’s captured data, and to make it metrics easily accessible to their stakeholders. So I was tasked with creating a Graphical web interface for viewing and generating reports (CSV downloadable), Based on the linked databases.

The query builder would adapt to whichever column types your database has, for each database column type there would be a corresponding Vue field component. Dynamically loaded based on your database schema, for constructing your SQL query. Generated queries can also be edited manually or even written from scratch.

Screenshot of the Segmentation Builder Edit List page