Background

What the inside of a typical GPC Distribution Center (or warehouse) looks like.

I designed enterprise data visualizations for Supply Chain leadership, who use these reports to analyze operational data on 53 Distribution Centers across the United States. These Distribution Centers supply auto parts nationwide to 6,000+ NAPA stores, other warehouses, and directly to commercial customers.

I also established report design standards and re-usable components that developers company-wide can use to build reports for other functions, such as Commercial Sales, HR, Pricing, Merchandising, Finance, and Store Operations.

These reports are displayed in the enterprise business intelligence tool, Power BI (by Microsoft) and are updated daily with data from a cloud data warehouse (Google Big Query), which is part of the modern data and analytics strategy of Genuine Parts Company

t

Notable Challenges: Lack of established design standards for reports, no streamlined workflow for gathering/validating report requirements and designs, navigating constraints within Power BI as a third party tool.

Research

t

Unique Highlights: Primary users of these reports are internal employees, ranging from General Managers to Supply Chain Directors and Executives. This made it easier to schedule time for user interviews, but also limited the number of actual users.
Since each report has varying users (usually a Sr. Director or VP of Supply Chain) I worked closely with Product and UX Researchers to identify requirements through Discovery Research. This process started from when the data was prepared and analyzed. I also involved Development early on to ideate, identify feasibility, and understand data limitations. Sometimes, there were existing reports in the legacy business intelligence application (Qlik) that we could reference for key filters and data frameworks.

Research focused on understanding what is important to see within each metric, and how to surface this data while allowing for deeper analysis. Discovery Research was mostly conducted through interviews, as users were responsible for different areas of warehouse operations such as Safety or Performance. Later in the project, we planned to implement surveys for NPS scores and additional feedback.

t

Sometimes, there were existing reports in the legacy BI application (Qlik) that we could reference.

Challenges & Workshopping

When I started working on this project early in 2024, there were no established report design standards or style guides, with each Power BI Developer designing reports as they saw fit. Besides lacking consistency, reports were not accessible and report creation was the "Wild West" with lots of back and forth on what "looked" right or not. This also led to a lot of repeat work, as each developer had their own way of creating reports.

Working with the data lead for Supply Chain, we established documentation for other developers to reference, along with style guides and examples based on learnings from Data Visualization books and courses.
For example, I drew heavy inspiration from the Okabe-Ito color palette to use for our enterprise reports, which is important for people with color vision deficiencies as color is often used to compare and differentiate data points.

t

A main point was Accessible Design, and making sure that all reports were readable and distinguishable. We also conducted a team workshop to identify the most common dashboard use cases, and started creating standardized JSON components within Power BI for all the available visualizations.

t

Examples

Below are several examples of the reports that I designed for various Supply Chain metrics. You can see what the reports looked like before and after the enterprise design standards were applied. The goal was to present the data in a clear, and easy to understand way while allowing for further exploration and analysis. Actual data has been redacted.

Screenshots and notes from the ad-hoc report to create quick concepts that could be validated directly with the Business users.

t

Sample page from the ad-hoc report, without enterprise design standards applied.

t

The same report page, with enterprise design standards applied.

t

Sample page from an ad-hoc report, without enterprise design standards applied.

t

The same report page, with enterprise design standards applied.

t

Re-usable template pages that could cover most standard Power BI reports.

I also conducted heuristic analyses of dashboard projects for other initiatives, and provided recommendations based on the enterprise standards that we established for all Power BI reports at the company. These combined practical changes in Power BI, as well as call outs based on Nielsen Norman Usability Heuristics.

Reflection

With a streamlined workflow and the team becoming accustomed to building reports with enterprise design standards, we noticed faster project completions with more visually consistent data visualizations that met Web Content Accessibility Guidelines.

Feedback from the Business was positive, stating that these reports helped reduce the manual work spent analyzing data in Excel spreadsheets, and sourcing data from various databases and email threads. Since this data comes directly from the source, there was increased confidence in data accuracy and validity - important in decision making.

Future work includes creating more standardized JSON files that developers can re-use while building Power BI reports, enhancing documentation and Power BI training resources, and eventually replacing all reports in the legacy business intelligence application (Qlik) as all the company functions adopt a modernized data platform.

t

I also had the opportunity to share my learnings about Data Visualization with the UX Design & Research Team, which helped solidify my own understanding and prompt further discussions and questions. Resources included the following books and courses.

Good Charts: The HBR Guide to Making Smarter, More Persuasive Data Visualizations
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Fundamentals of Data Visualization: A Primer on Making Informative and Compelling Figures
Information Visualization Course | IxDF (Interaction Design Foundation)
Analyzing/Presenting Data/Information: An online course taught by Edward Tufte

t

t

t