Intermix.io

(now Integrate.io)

Problem Statement and Overview

The primary objective is to design a solution for managing cloud data through customized cloud reporting.

Intermix.io empowers data engineers to make Redshift the core of their data platform. Our performance analytics help remove bottlenecks from your cluster.

Company Size
10-500 Employees

Technical Considerations
Current cloud data management applications do not support the unique types of reporting our customers require. We need a solution that allows customers to build reports as they like, from the ground up, with the data that is more relevant to their business needs. Currently it can be difficult to parse data clusters to match diverse reporting per individual customer needs.

Request
Design a solution that allows data scientists and tech managers to access and manage details about their cloud data in a quick and easy manner.

Design Considerations

  • Must reflect technical considerations

Project

I was asked to completely redesign the current product offering and create a SaaS application for data cloud reporting.

  • Product design

  • Interaction design

Wireframes

  • #1 Reports

    Most likely this will be the landing page. A user would land on this page which would be a list of existing reports by name and a search bar. Choosing a report would. would then open the reports editor.

  • #2 Jobs workloads

    Jobs are saved workloads. The page is consistent with the other pages; the jobs workloads would appear on the right of the navigation, by name and with a search bar. The user can choose an existing job or create a new one by clicking the create button at the top. If no job has been selected, the main content box would prompt the user toward an action.

  • #3 Workload editor

    With a job selected or a new job created, workload definitions and additional filters would appear. This is where the user would define the workload.

  • #4 Workload viewer

    When a workload has been selected or a created workload defined, the user can view the report analytics. Graphs will show the count of queries matching the workload definition. The viewer will also show a list of the top 10 queries the user has run, with sortable columns.

  • #5 Analyze generator

    After selecting an existing report or creating a new report, the user lands on the Analyze page to find a menu of interactions to modify or adapt the report as needed. Below the generator menu is a list of affiliated queries.

  • #6 Cohorts

    List of related data sets.

  • #7 Cohorts editor

    Editor to modify or create new cohorts.

  • #8 Cohorts viewer

    View data per cohort.

Make it

the redesign

The app was reimagined as a powerful, custom reporting tool. Focusing on custom reporting in just three central areas, allowed us to focus in on creating the strongest working reports possible, for what our customers needed: ultimate customization.

  • Scrolling vertical libraries for jobs and cohorts

  • Expandable search filters, totally custom, complete with and /or contingencies and tags

  • Multiple chart types and reports viewing

  • Each job saved with custom tags

  • Exportable options to Excel or as raw data

Takeaways

Quality over quantity

It’s far too easy to over complicate solutions. This project took what I knew about designing data tables for enterprise clients further with an ask for responsive solutions. Designing for data is never simple and requires the designer to be an expert in funneling the correct data through a customized UI. The greater extent the user has to create a tailored experience, the better your solution becomes at serving their unique needs.