Project: ParentPowered Analytics Dashboard

Goal

Craft a customer analytics dashboard to replace keen.io, a third party service.

Challenges

Performance: Quickly extract, analyze, and present raw data scattered across millions of records and multiple tables. To meet this challenge, I architected a reusable time series query engine that utilizes table joins and aggregations to fetch multidimensional performance data in a single query. This allows fetching an entire chart’s worth of data in one transaction, thus minimizing database access and network transit times. The page you see to the right takes roughly a quarter of a second to load.

Presentation: Provide the user a high density of information in a way that is uncluttered, easy to navigate, and looks good. To meet this challenge, I organized content into logical sections using contrasts in size, value, and placement, typography, a consistent color scheme, and careful use of white space.

Results

Fast-loading and informative data analysis that saves the company significant monthly charges of a third party service.