All resources

How OWOX Reports Helped Reformation Make Data-Backed Decisions

What if your team could go from data request to decision in minutes, not days? That’s exactly what Reformation, a fast-growing fashion brand, set out to achieve.

i-border i-radius

While many companies struggle with delayed reporting and fragmented data sources, Reformation built a system where nearly every department, from supply chain to finance, accesses up-to-date insights directly in the tools they already use.

This case study explores how the Reformation turned Google Sheets into a powerful decision-making platform using OWOX Reports. If your organization is looking for a faster, more flexible way to deliver trusted data to the people who need it, their story offers a roadmap. Let’s dive in.

THE CLIENT: Reformation — A Leader in Sustainable Fashion and Scalable Operations

Reformation is a globally recognized fashion retail brand with a strong emphasis on sustainability, style, and innovation. With products ranging from chic dresses to everyday essentials, the brand blends eco-conscious materials and manufacturing practices with tech-driven operations to deliver high-quality fashion at scale.

Company Snapshot

  • Industry: Fashion Retail
  • Markets: Global
  • Headquarters: United States
  • Sales Model: Omnichannel 

At the core of Reformation’s mission is a powerful promise: to bring sustainable fashion to everyone. With rapid growth, global operations, and deep investments in technology, their team relies heavily on data to ensure alignment, efficiency, and lasting impact.

“Google Sheets is a core tool at Reformation. Using OWOX to get clean, business-ready data into Sheets for quick analysis is really effective for us.” — Drish, Head of BI at Reformation

THE CHALLENGE: Empowering Teams to Work Faster with Trusted Data

At Reformation, tactics shift weekly. The pace of decision-making requires teams to act fast, adjust quickly, and work flexibly — especially when making cross-functional decisions in planning, supply chain, or inventory.

While internal dashboards delivered standardized reporting, teams needed a faster way to:

  • Get raw (and semi-structured) data into Google Sheets
  • Run their own ad hoc lookups and queries
  • Pivot quickly as business needs shift

“Looker is great for standardized reporting, where everyone aligns on the same numbers. But for quick decisions and pivots, it’s essential to have a direct link to raw data that we can manipulate as needed.”  — Angela, Head of Allocations at Reformation

This need for flexibility and self-service access to structured data led the team to adopt a tool like OWOX Reports, which empowers both analysts and business users to skip lengthy BI queues and work directly in Google Sheets.

Even for more technical roles like supply chain analysis, the speed and simplicity of spreadsheets made a difference.

As the company scaled and data sources multiplied, the team sought a more efficient solution to make trusted, up-to-date data accessible to everyone.

By bridging the gap between centralized BI and everyday workflows, OWOX Reports helped Reformation retain its agility while maintaining trust in the underlying data.

THE OWOX: Bringing Flexibility and Scale to Company-Wide Reporting

The BI team adopted OWOX in 2018 to solve a persistent challenge: moving raw, unsampled data from BigQuery into Google Sheets without technical or platform limitations.

“Google has its own BigQuery connector, but it doesn’t work the way we need – it only pulls the first thousand rows, and the queries don’t always execute properly. With OWOX, we get the full dataset as intended.” — Drish, Head of BI at Reformation

Unlike other tools that offer partial access, where the query gets disconnected from the source as soon as it runs, OWOX Reports Extension for Google Sheets became the go-to solution for analytics control, trust for everyone, and full freedom to explore data. Even as newer team members joined Reformation, OWOX remained a central part of the workflow.

“OWOX was already an existing product when I joined. I haven’t done a benefit analysis against other tools, but it’s clearly embedded in our reporting infrastructure.” — Brian, Data Analyst at Reformation

THE USE: Turning Data Into Decisions with Custom Reporting Workflows

At Reformation, data isn't just a resource – it's a driver for nearly every strategic and operational decision. While the company uses standardized dashboards through tools like Looker, its day-to-day agility relies heavily on dynamic spreadsheet reporting powered by OWOX Reports.

THE USE: Turning Data Into Decisions with Custom Reporting Workflows

From Requests to Insights: How Data Moves Across Teams

Most report creation begins with a request or an internal need identified by business users like Angela and Julie. The process often looks like this:

  • Power users like Angela start by exploring the data themselves or checking in with the BI team for guidance.
  • Julie, who focuses on supply chain analysis, builds her own SQL queries and, therefore, reports for the datasets she is familiar with, but turns to Brian for help with less familiar domains.
  • Brian, acting as a bridge between the BI & IT teams on one side and operations on the other, handles incoming requests via Slack or email and builds both one-off tools and ongoing reports using OWOX Reports.

“I don’t have a ticketing system. Most of my work is ad hoc—quick tools like Slack for covering never-ending ongoing requests. Every report ends up requiring some maintenance.” — Brian, Analyst at Reformation

Power users like Angela and Julie can write their own SQL queries and create their own Data Marts independently. But even when direct access isn’t available, OWOX makes it easy for business users to get the insights they need, without relying on SQL or asking analysts for every report.

Making Reporting More Powerful with OWOX and App Script

One standout use case demonstrates how OWOX Reports enables advanced workflows at scale. Brian built a reporting process to check price discrepancies between external wholesale purchase orders and current pricing data:

  1. A SQL query pulls purchase order and pricing data.
  2. OWOX pushes the result into Google Sheets.
  3. An App Script reads the sheet and automatically emails relevant teams if discrepancies are found.

“I wrote the query and then used OWOX to push it to a sheet. From there, App Script triggers an alert if prices don’t match – no manual work needed.” — Brian, Analyst at Reformation

This blend of SQL, OWOX Reports, Google Sheets, and App Script has become a core way Reformation delivers insights where and when they matter most.

THE BENEFITS: Reliable Numbers, Real-Time Decisions

At Reformation, the expansion of OWOX Reports brought clarity, speed, and consistency to their business workflows. Before, teams operated on fragmented data. Now, they're aligned – both in numbers and in strategy.

i-radius i-border

Top 5 Benefits OWOX Brought to Reformation

These are the standout capabilities that transformed how Reformation works with data:

  1. ✅ Automation: Reports run on a schedule and deliver fresh data daily, eliminating manual effort.

“Being able to set up scheduled reports and forget about them is huge.” — Angela

  1. 🔍 Ad Hoc Lookups: With OWOX-powered spreadsheets, non-technical users can input a list of SKUs, orders, or other values and instantly access all related data.

“It’s fast, self-service, and makes us more responsive.” — Brian

  1. 🕒 Data Freshness: Scheduled updates mean that decision-makers always rely on the latest numbers.

“We always have up-to-date data. That’s critical in a fast-moving business like ours.” — Drish

  1. 🔧 Flexibility: Users across departments can filter, pivot, and analyze raw data as needed, without being locked into static dashboards.

“We can explore and transform the data however we need.” — Julie

  1. 📤 Shareability: Once in Google Sheets, reports are easy to share, comment on, and collaborate across departments.

“OWOX makes it easy to get the right data in front of the right people.” — Brian

THE NEXT STEPS: Partnering on Product Improvements Together

As Reformation continues scaling its data-driven operations, the team remains highly engaged in refining the tools they rely on. Their hands-on approach and real-world feedback have already helped shape how OWOX Reports evolves to better serve growing teams.

“Angela pushes Google Sheets to the absolute limit. If there’s an issue with timeouts, she’s probably the first one to hit it.” — Brian, Analyst at Reformation

While OWOX Reports already meets their needs for flexibility, speed, and accuracy, the Reformation team shared a few thoughtful suggestions to make the tool even more powerful:

  • Query Editing Speed: Improving the performance of the query editor to reduce wait times.
  • Boolean Handling: Preserving Boolean data types during scheduled refreshes to avoid breaking formulas.
  • Formula Retention: Maintaining adjacent cell formulas after a refresh—something the team currently has to work around.
  • Staggered Scheduling: Allowing different queries in the same spreadsheet to refresh on separate schedules, minimizing timeouts.

“It’s a solid product. There’s not much to complain about.” — Brian, Analyst at Reformation

At OWOX, we deeply value this kind of detailed, constructive feedback. It’s how we continue to build a better experience – not just for Reformation, but for every data team looking to turn spreadsheets into scalable decision-making tools.

FAQ

No items found.

You might also like

2,000 companies rely on us

Oops! Something went wrong while submitting the form...