Getting the Most out of FPDS | Federal Compass

Getting the Most out of FPDS


As many others in this industry, I’ve worked with FPDS data for a long time. I suppose the good news is that the system has changed little over the years, so time invested in learning its quirks is worthwhile. Below, I’ve outlined a few methods for maximizing its value and pitfalls that you may encounter.

The Basics

For those of you who are new to federal market intelligence, the Federal Procurement Data System (FPDS) is the primary mode of transparency around government contracting. It’s best to think of this data as a running list of transactions, just like transactions in your bank account. Also just like your bank account, there are details like transaction amount and recipient, etc. However, unlike a transaction in your bank account, there is a vast amount of meta data surrounding each transaction in FPDS. For instance, contract details, socioeconomic indicators for the awardee and details on the procurement method, to name a few.

This is all well and good, but how do you make sense of all that information?

Sums and Aggregations

Viewing a single transaction in FPDS is great for a snapshot in history, but in order to derive value, we must look at the aggregate. After rolling up this spending along various dimensions, you begin to answer more meaningful questions:

  • What’s the total obligated amount on this contract?
  • How much did this awardee receive from a particular agency?
  • What’s the total set-aside spending for Navy?

Of course, that’s only of limited value. It’d be much better to know how these figures are changing over time.


The next level of understanding can come from watching sums and aggregations change over time. Viewing and understanding trends, especially at a granular level (like within an office or a for a specific contractor), can be incredibly valuable. Now, we can begin to see how contracting dollars are moving. How is the dominant contractor performing? Are they losing market share over time? Maybe this particular office is changing their buying patterns and moving dollars away from definitive contracts.

Data Normalization

Now that we can see where money is changing hands and how those hands are changing over time, it’s important to take a step back and consider data quality. What do we mean by data quality? Data quality is really just the consistency of categorization and classification of the data. In the case of FPDS, we need to look into each transaction and understand if things like vendors or programs are represented in a consistent fashion. The short answer is NO.

In order to paint a vivid and accurate picture of the world, these data quality issues must be addressed. For instance, let’s say a contractor, “ABC, Inc.”, is represented inconsistently in the data. Some transactions have names like, “ABC INC”, “ABC, INC”, “ABC Inc.”; we could on and on. Although the data that describes the awardee is different, this is in fact the same vendor, and we want to see all their transactions reported together.

Unfortunately, there’s no shortcut to good data quality. It must be cultivated by dedicated analysts, intent on seeking out every discrepancy.

At Federal Compass, we have expert and dedicated analysts doing this every day. We don’t outsource any data normalization because this is fundamental to quality market intelligence.

The Author

Chad Ganske Federal Compass
Chad Ganske
Changing the perspective of government contractors one market intelligence report at a time.

Federal Compass offers unique solutions for every member of your government contracting team.

Recent Posts

Top Challenges Faced By Small Business in GovCon

We meet with many small business owners and executives and listen to the unique challenges that they face with government contracting. Those discussions and that feedback works its way into every aspect of our products. That’s why, at Federal Compass, we aim to level the playing field by empowering small business contractors.

written by Chad Ganske, published 01/14/2020

FBO (FedBizOpps) / SAM (System for Award Management) Transition Guide

The official transition from FBO to SAM took place at the beginning of November, and now all federal contracting opportunities can be found on the new SAM website, including everything from solicitations to awards. This guide aims to answer the most pressing questions by contractors when making the transition from FBO to

published 12/19/2019

'Tis the Season to Rethink Market Intelligence

Make this the year that you demand more from your market intelligence provider.

written by Jim Sherwood, published 12/06/2019

Case Study: Reducing Market Intelligence Costs

We ask one of our customers to evaluate the quantifiable savings and qualitative improvements of switching to Federal Compass.

published 12/06/2019