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

Are you ready for 8(a) graduation?

The clock is ticking, that 8(a) exit date is fast approaching, and soon, you'll be cast into an unfamiliar and challenging environment. Once outside of your protected status you’ll be facing competitors with mature processes, experienced in operating in the wilds of unrestricted competition. Are you ready for graduation?

published 05/26/2020

What Federal Contractors Need to Know About COVID-19

There’s a lot of news going around about the coronavirus COVID-19. We’d like to add some clarity, rooted in the numbers (see data appendix), on what the government is doing during this acute phase of the pandemic and its impact on the Federal contracting community.

published 04/03/2020

CIO-SP3 Trends and Observations

There's reason to be excited for CIO-SP4. With new tracks and more initial awards than CIO-SP3, spending on CIO-SP4 is anticipated to surpass to CIO-SP3 trends. We've put together an eBook focused entirely on understanding CIO-SP3 trends ahead of CIO-SP4. Lessons learned from CIO-SP3? You are more likely to fail than to succeed. If you’re determined to pursue CIO-SP4, preparation is necessary to position yourself for success.

published 03/23/2020

Who Uses Federal Compass?

Federal Compass launched its Opportunity & Market Intelligence platform for government contractors back in 2019. Since then, we've attracted a diverse user-base, focused on a range of industries within the government contracting space. We get a lot of questions about who uses Federal Compass and what features they find most compelling. Here are some quick numbers to show just how diverse our community has become.

published 03/18/2020