ブルーの六角形模様
Customer Story

IRS Uses Alteryx to Improve Data Accountability and Transparency in Government Procurement

IRS Key Stats

Industry: Public Sector
Department: Business Intelligence
Region: North America

language process developed to reduce thousands of labor hours spent finding and fixing contract description errors

transparency in the description and accuracy of procurement contracts

of concept in days

Improving data transparency in government through the DATA Act

The U.S. federal government spends more than $3.5 trillion and issues over 5.7 million procurement contracts annually. In order to improve transparency on where and how taxpayer money is spent, the Digital Accountability and Transparency Act of 2014, or DATA Act, requires the U.S. Federal Government to transform its spending information into open data. The DATA Act directs the Office of Management and Budget (OMB) and the Department of Treasury to establish government wide data standards, specifically the Data Act Information Model Schema (DAIMS). This must include common data standards for reporting and payment information.

Enabling greater data operations for the IRS through innovation

The Internal Revenue Service (IRS) is a sub-agency of the Treasury, whose primary functions are tax collection and tax code administration. In support of its mission, the IRS contracts with the private sector to buy services and products. In 2019, the IRS launched a program to identify innovative approaches to complying with the DATA Act. The program, known as Pilot IRS – DATA Act Improvements, has the following goals:

  1. Improving federal procurement data which resides in the Federal Procurement Data System – Next Generation (FPDS-NG)
  2. Limiting the amount of manual work required by government personnel
  3. Achieving incremental improvement in IRS data in the near term

The IRS faces increasing pressure to achieve more with less. Over the past five years, the U.S. government has seen a 23% compounded annual growth rate in contract volume. As the amount of work increases, the IRS has also seen a 40% decline in its workforce. In addition to maintaining its current workload, the IRS is faced with correcting contract errors to ensure compliance with the DATA Act and other policies. Finally, many of these procurement processes are performed manually across various IRS systems. Although this story is about the IRS, the Federal Government faces similar challenges across its more than four hundred agencies.

Like most large enterprises facing the challenges of legacy systems and processes, the IRS wanted to explore new and innovative ways to improve its data and operations. From extensive work in both public and private organizations dealing with similar procurement compliance issues, we know that the average organization loses approximately 7 hours per data worker in productivity due to manual legacy data processes.


Like most large enterprises facing the challenges of legacy systems and processes, the IRS wanted to explore new and innovative ways to improve its data and operations.

A daunting process for federal analysts

Federal procurement analysts are tasked with drafting contracts, which can be a grueling process. They must gather inputs from multiple systems and stakeholders while maintaining compliance with various federal acquisition regulations. As they dig through emails and folders for information to complete multiple pages and hundreds of data fields, they often find themselves trying to interpret vague, incorrect, and incomplete data. This can include whether an address is up to date, if an award description is meaningful or not, or if contract dates are accurate.

In some cases, analysts can perform reference checks with third-party websites, while in other cases, they send emails, make phone calls, and schedule meetings to confirm the data they need. In all cases, they try to make the best decision possible with the limited information they have.

As analysts validate the new information they have gathered, they can only hope that all the information they’ve received from upstream processes have been adequately validated. As their long day comes to an end, they notice the large backlog of new contracts that just arrived in their queue, ready for tomorrow. They can think of dozens of ways to improve this process, but they believe it will require software development and data engineering resources. It just feels like it will be too complicated and take too long before they can see any meaningful improvement.


An all-encompassing solution to accomplish multiple tasks

ResonantLogic, an Alteryx partner, developed a proof of concept (POC) to address this problem under the Pilot IRS program. ResonantLogic used Alteryx Designer and Alteryx Server to develop a working proof of concept for the IRS in less than 20 days. The solution used the following methods to:

Connect

  • Alteryx Designer was used for ETL processes for federal procurement data and Alteryx Server was used to schedule this activity to ensure the latest information was always available for users.

Verify and Validate

  • The system translates validation rules into an easy-to-use workflow. This lets users build and test algorithms without the need for complex code. And because Alteryx makes managing data workflows easy, users can simply update the workflows as conditions and validation rules change over time.
  • The system also uses natural language processing to interpret the meaningfulness of user-generated Award Descriptions.

Correct

  • The system identifies errors and exceptions and intelligently suggests corrected data.
  • The system automatically performs reference checks and provides corrected values using third-party sources such as Dun & Bradstreet and U.S. Postal Services.
  • The system uses a machine learning model that can be trained by users to determine whether a user-generated award description is meaningful. The system allows users to update a training library and view the results of analyzed award descriptions.

Notify

  • The system creates a report that lists the contract awards, the data fields with errant values, and the recommended values.
  • The system can provide custom reports to identify defect trends that can be used to support user training and other continuous improvement activities.


roi-calculator

Analytic Automation that adds up

With Alteryx Analytic Process Automation™, organizations can realize top-line growth, bottom-line savings, risk reduction, and efficiency gains.
マクラーレンのレーシングカー
お客様事例
5 分で読む

データ分析の高速化により、勝利を手中に収めるマクラーレン・レーシング

週末に開催される F1 レースは年間 20 戦以上にも及び、1 レースあたり 1.5TB ものデータが生成されるため、こうした膨大な量のデータの効率的な収集、処理、活用を可能にするソリューションは欠くことのできない存在です。
マクラーレン F1 チームでは、Alteryx Analytics Automation Platform を使用して、サーキット内外で戦略的な意思決定を加速させています。

サプライチェーン
アナリティクスリーダー
ビジネスインテリジェンス/分析/データサイエンス
今すぐ読む
Takenaka logo atop photo of modern building
お客様事例

300年にわたり蓄積されたデータを次世代建築の設計に

蔵に眠っていた古い情報を、『人の想い』を伝える「使えるデータ」へと変貌させた Alteryx 老舗のデータ利用を支える Alteryx は現代における大工道具箱

データ準備と分析
製造
Alteryx Designer
今すぐ読む
Roquette 社の動的コンテンツ
お客様事例
5 分で読む

Roquette 社におけるデータ文化の醸成

植物由来の原材料の世界的リーダー企業が Alteryx の導入により、戦略的な意思決定を大規模に実現。

アナリスト
データサイエンティスト
ビジネスリーダー
今すぐ読む

Put your data to work

86% of new Alteryx users deliver business value in their first week. Join thousands of practitioners who are breaking data barriers and dragging and dropping their way to insights.

デスクワークをする男性と女性

無料トライアル

Experience the power and ease of Alteryx