Case Study: United States Department of Commerce achieves modernized USPTO trademark analytics and rapid self-service reporting with Alteryx

Data Analytics, Federal Agency, and the Thirty-Year-Old Legacy System

The U.S. Patent and Trademark Office’s Trademark organization relied on decades-old, tightly coupled legacy systems (COBOL, Crystal Reports, SQL) that limited reporting, historical analysis and accessibility, forcing extensive manual data manipulation and delaying responses to executive and stakeholder requests. With critical documentation and institutional knowledge concentrated in a few people, the agency needed a modern, flexible way to support business planning, forecasting and ad hoc analysis as systems evolve.

Using Alteryx as an ETL and analytics engine, Trademark nightly extracts, cleanses and harmonizes transactional data into a Calgary-backed analytical model (building history where the source lacks it) and feeds dynamic reports and Tableau dashboards. The self-service interface, developed and maintained by Trademark staff, speeds data requests from days to seconds, enables new insights by joining disparate systems, supports forecasting and decision-making, and has produced cost savings versus traditional outsourced approaches.

United States Department of Commerce

James Nosal

Program Analyst