The challenge

As Dremio’s user base grew, the platform struggled to keep up with the changing workflows and demands. The challenge was to redesign the platform to be more scalable, while also improving its usability and appeal to new users

‍

Deeper understanding of product

We started by understanding the product and understanding the whole user flow from E2E. As this was a new product for me, it was key for me learn the product and also understand the mental model of the user

Deeper visual dive

We Looked at product from visual standpoint and discovered has accessibility and readability issue and the cognitive load is very high. as we dive deeper we also noticed multiple styles and interactions

How we got there

Since it was huge project we recommend strategy to follow this order

1. Defined information architecture Will cover overview and details page for Phase 1.Group and add information.
2. Layout Explore new layouts to add more capabilities in  the future.Dashboard navigation exploration.
3. Visual theme and style Follows a component-based approach.Leverage design system to maintain consistency.

‍

Information architecture

Collaborating with a Product Manager, I developed the information architecture . We focused on organizing data efficiently, ensuring scalability, and meeting user needs. Together, we created a seamless, intuitive system that enhances data accessibility and usability, driving the platform’s success and aligning with business goals.

‍

layout

We chose to divide the information into two pages instead of one to reduce cognitive load and improve user focus. This approach allows users to navigate complex data more efficiently, enhancing readability and decision-making. By separating tasks, we ensured a cleaner interface that better supports Dremio's data lake functionality.

Design in detail

In the redesign, we focused on enhancing usability by reimagining the tables, Datasets graph, and SQL editor. We introduced a cleaner layout for tables, organized data visualization in the Datasets graph for better insights, and optimized the SQL editor with features like light/dark mode and tooltips, ensuring a seamless, user-friendly experience.

‍

Table redesign

We implemented a clean layout for tables to streamline data presentation and reduce visual clutter. By organizing information into clear, distinct columns and using consistent styling, we improved readability and user focus. This design choice enhances efficiency, making it easier for users to quickly find and analyze the data they need.

Dataset graph

The redesign features more organized connections, clear labeling, and improved hierarchy, making the data relationships easier to understand at a glance. This streamlined design aids in quicker data analysis and decision-making.

SQL editor

The SQL Editor redesign introduces a dark mode, color-coded syntax, and contextual tooltips. These improvements make complex queries easier to write and debug, reducing errors and improving user efficiency. The cleaner, more intuitive interface supports a smoother workflow, especially in data-intensive environments like Dremio’s data lake platform

‍

User Testing Key Findings

1. Users felt sticky columns were restrictive.
2. New icons need some explanation.
3. Users liked having all jobs on one page but felt like they were taking the extra step to go to a second page to see details.

The solution

We added the Columns filter feature to allow users to customize their view by selecting specific columns they want to see. This enhancement simplifies data analysis by enabling users to focus on relevant information, improving efficiency and ensuring that the interface adapts to individual needs and preferences.

Overcoming Challenges

One of the key challenges was working within the constraints of existing code, which limited some design possibilities. However, by collaborating closely with engineering, we found creative solutions that allowed us to meet our design goals within the timeline.

Impact

The redesign of Dremio's platform resulted in a significant impact, including a 35% increase in renewals and a 5% rise in new sales. The modernized UI and improved functionality not only attracted new users but also reduced support tickets, enhancing overall user satisfaction and driving business growth.

‍